SSM框架項(xiàng)目實(shí)例源代碼從注冊(cè)開始結(jié)合數(shù)據(jù)庫

1、/ssm/webroot/index.jsp base href= 入口頁面 !- 登錄 注冊(cè) /ssm/src/config/applicationcontext.xml/ssmexam/src/com/action/empaction.java/ssmexam/src/com/action/empaction.javapackage com.action;import java.util.hashmap;import java.util.list;import java.util.map;import .empservice;import mon.action.

2、baseaction;import mon.dto.comm;import mon.dto.dept;import mon.dto.empinfo;import mon.dto.pagedto;/* * 控制層 * author administrator * */public class empaction extends baseactionprivate empservice empservice;private empinfo empinfo;private pagedto pg;public string toregist()m

3、ap result=empservice.queryforregist();requestmap.put(result, result);return super.success;/注冊(cè)的actionpublic string register()int counts=empservice.queryempbyname(empinfo.getename();if(counts0)/說明該注冊(cè)名是存在的 return registerfail;elseint count=empservice.addemp(empinfo);system.out.println(新增了+count+條數(shù)據(jù));if

4、(count!=0)return registersuccess;elsereturn registerfail;/登錄public string login()system.out.println(進(jìn)入登錄);empinfo=empservice.queryempbyempidandp(empinfo);system.out.println(進(jìn)入登錄+empinfo.getempno();if(empinfo!=null)/將用戶保存在session里面sessionmap.put(empinfo, empinfo);return super.success;elsereturn login

5、fail;private string exists;public string getexists() return exists;public void setexists(string exists) this.exists = exists;public string checkname()int count=empservice.queryempbyename(empinfo.getename();if(count0)/說明存在exists=y;else/說明不存在exists=n;return super.success;/篩選加模糊查詢所有員工的表public string qu

6、eryallemp()int rowcount=empservice.findtotalemp();/system.out.println(=+rowcount);pg=new pagedto();/new一個(gè)page對(duì)象 不然會(huì)報(bào)空pg.setrowcount(rowcount);/-設(shè)置總記錄數(shù)pg.setpagesize(3);/設(shè)置每頁顯示的記錄數(shù)/總頁數(shù)int pagecount=pg.getallpagecount(pg.getrowcount(), pg.getpagesize();/system.out.println(=+pagecount);pg.setpagecount(

7、pagecount);int pageindex=1;if(request.getparameter(pageindex)!=null&.equals(request.getparameter(pageindex)pageindex=1;else if(request.getparameter(pageindex)!=null&!.equals(request.getparameter(pageindex)pageindex=integer.parseint(request.getparameter(pageindex);pg.setpageindex(pageindex);/獲取上一頁int

8、 upindex=pg.getupindex();/獲取下一頁int nextpage=pg.getnextindex();/放入對(duì)象和頁碼requestmap.put(pg, pg);requestmap.put(upindex, upindex);requestmap.put(nextpage, nextpage);map pagemap=new hashmap();pagemap.put(start, pg.getstartindex();pagemap.put(end, pg.getendindex();/傳入分頁參數(shù)/list empmaplist=empservice.findpa

9、geemp(pagemap);/分頁先留著/string deptname=;/*for (empinfo empinfos : empmaplist) empinfo.getdept().setdeptname(empinfos.getdept().getdeptname();/部門empinfo.getcomm().setsalary(empinfos.getcomm().getsalary();/薪資empinfo.setempno(empinfos.getempno();/編號(hào)empinfo.setename(empinfos.getename();/姓名empinfo.setempa

10、ge(empinfos.getempage();/年齡empinfo.setempsex(empinfos.getempsex();/性別empinfo.setempid(empinfos.getempid();/賬號(hào)用戶名empinfo.setempidno(empinfos.getempidno();/身份證empinfo.setempphone(empinfos.getempphone();/電話empinfo.setemppassword(empinfos.getemppassword();/密碼requestmap.put(empmaplist, empinfo);system.ou

11、t.println(empinfo.getdept().getdeptname();*/system.out.println(deptname);/將條件放入map sql將根據(jù)鍵值的條件查詢/list empmaplist=empservice.querylikeemp(empmap); /不分頁list empmaplist=empservice.findallemp();requestmap.put(empmaplist, empmaplist);/requestmap.putall(empmap); return super.success;/模糊查詢public string que

12、rylikeemp()map empmap=new hashmap();/獲取用戶輸入的條件string ename=request.getparameter(ename);string deptname=request.getparameter(deptname);string empagestart=request.getparameter(empagestart);string empageend=request.getparameter(empageend);string empsex=request.getparameter(empsex);/根據(jù)條件查詢放入到empmapempma

13、p.put(ename, ename);empmap.put(deptname, deptname);empmap.put(empagestart, empagestart);empmap.put(empageend, empageend);empmap.put(empsex, empsex);list emplikelist=empservice.querylikeemp(empmap);requestmap.put(emplikelist, emplikelist);if(emplikelist=null)return queryfail;for (map map : emplikelis

14、t) system.out.println(*+map.get(ename);system.out.println(map.get(empage);return super.success;/刪除員工public string deleteemp()system.out.println(進(jìn)入刪除);int count=empservice.deleteempbyid(empinfo.getempno();if(count0)/成功return super.success;elsereturn fail;public string deleteallemp()/復(fù)選框參數(shù)集合string det

15、eles=request.getparametervalues(deletes);empservice.deleteallemp(deteles);return super.success;/刪除部門public string deletedeptbyid()/從部門中刪除部門信息要先判斷員工是不是在這個(gè)要?jiǎng)h除的部門int count=empservice.selectdeptcommon(empinfo.getdept().getdeptno();if(count0)/說明無法刪除啊string message=刪除部門信息請(qǐng)先刪除該員工!;session.setattribute(mess

16、age, message);system.out.println(=count+count);return deletefail;elsesystem.out.println(=count+count);empservice.deletedeptbyid(empinfo.getdept().getdeptno();return super.success;/刪除薪資福利public string deletecommbyid()empservice.deletecommbyid(empinfo.getcomm().getcommid();return super.success;/查詢所有部門

17、public string queryalldept()int rowcount=empservice.findtotaldept();/system.out.println(=+rowcount);pg=new pagedto();/new一個(gè)page對(duì)象 不然會(huì)報(bào)空pg.setrowcount(rowcount);/-設(shè)置總記錄數(shù)pg.setpagesize(4);/設(shè)置每頁顯示的記錄數(shù)/總頁數(shù)int pagecount=pg.getallpagecount(pg.getrowcount(), pg.getpagesize();system.out.println(=+pagecount)

18、;pg.setpagecount(pagecount);int pageindex=1;if(request.getparameter(pageindex)=null&.equals(request.getparameter(pageindex)pageindex=1;else if(request.getparameter(pageindex)!=null&!.equals(request.getparameter(pageindex)pageindex=integer.parseint(request.getparameter(pageindex);pg.setpageindex(page

19、index);/獲取上一頁int upindex=pg.getupindex();/獲取下一頁int nextpage=pg.getnextindex();/放入對(duì)象和頁碼requestmap.put(pg, pg);requestmap.put(upindex, upindex);requestmap.put(nextpage, nextpage);map pagemap=new hashmap();pagemap.put(start, pg.getstartindex();pagemap.put(end, pg.getendindex();list deptlist=empservice.

20、findpagedept(pagemap);/list deptlist=empservice.queryalldept();無分頁requestmap.put(deptlist, deptlist);return super.success;/所有薪資福利 要分頁public string queryallcomm()int rowcount=empservice.findtotalcomm();pg=new pagedto();/new一個(gè)page對(duì)象 不然會(huì)報(bào)空pg.setrowcount(rowcount);/-設(shè)置總記錄數(shù)pg.setpagesize(4);/設(shè)置每頁顯示的記錄數(shù)/總

21、頁數(shù)int pagecount=pg.getallpagecount(pg.getrowcount(), pg.getpagesize();pg.setpagecount(pagecount);int pageindex=1;if(request.getparameter(pageindex)=null&.equals(request.getparameter(pageindex)pageindex=1;else if(request.getparameter(pageindex)!=null&!.equals(request.getparameter(pageindex)pageindex=

22、integer.parseint(request.getparameter(pageindex);pg.setpageindex(pageindex);/獲取上一頁int upindex=pg.getupindex();/獲取下一頁int nextpage=pg.getnextindex();/放入對(duì)象和頁碼requestmap.put(pg, pg);requestmap.put(upindex, upindex);requestmap.put(nextpage, nextpage);map pagemap=new hashmap();pagemap.put(start, pg.getsta

23、rtindex();pagemap.put(end, pg.getendindex();list commlist=empservice.findpagecomm(pagemap);/list commlist=empservice.queryallcomm();不帶分頁requestmap.put(commlist, commlist);return super.success;/修改員工 先進(jìn)入頁面updateemplastpublic string updateempfirst()map result=empservice.queryforregist();/system.out.pri

24、ntln(result.size();requestmap.put(result, result);/查詢到該名員工的編號(hào)empinfo=empservice.getempbyid(empinfo.getempno();system.out.println(xinxi-+empinfo.getename();requestmap.put(empinfo, empinfo);return super.success;public string updateemplast()int count=empservice.updateemp(empinfo);/system.out.println(=1

25、成功?=+count);return super.success;/修改部門先進(jìn)入頁面public string updatedeptfirst()/獲取部門編號(hào)int deptno=empinfo.getdept().getdeptno();dept dept=empservice.getdeptbydeptno(deptno);empinfo.setdept(dept);requestmap.put(dept, empinfo.getdept();return super.success;public string updatedeptlast()int count=empservice.

26、updatedept(empinfo.getdept();return super.success;public string updatecommfirst()/獲取idint commid=empinfo.getcomm().getcommid();comm comm=empservice.getcommbycommid(commid);empinfo.setcomm(comm);requestmap.put(comm, empinfo.getcomm();return super.success;public string updatecommlast()/傳入部門對(duì)象修改int cou

27、nt=empservice.updatecomm(empinfo.getcomm();return super.success;/-詳情-public string showempdetails()/empinfo=empservice.getempbyid(empinfo.getempno();list emplist= empservice.getempsbyid(empinfo.getempno();/requestmap.put(empinfo, empinfo);requestmap.put(emplist, emplist);return super.success;public

28、string showcommdetails()comm comm=empservice.getcommbycommid(empinfo.getcomm().getcommid();requestmap.put(comm, comm);return super.success;public stringshowdeptdetails()dept dept=empservice.getdeptbydeptno(empinfo.getdept().getdeptno();requestmap.put(dept, dept);return super.success;private string d

29、eptname;public string getdeptname() return deptname;public void setdeptname(string deptname) this.deptname = deptname;/新增部門public string adddept()empservice.adddept(deptname);return super.success;private int salary;public int getsalary() return salary;public void setsalary(int salary) this.salary =

30、salary;/新增薪資福利public string addcomm()int count=empservice.addcomm(salary);if(count0)string message2=alert(新增1條數(shù)據(jù));string message=新增+count+條數(shù)據(jù);session.setattribute(y, 新增+count+條數(shù)據(jù));session.setattribute(message2, message2);session.setattribute(messagealert, message);return super.success;public string

31、addempfirst()map result=empservice.queryforregist();system.out.println(result.size();requestmap.put(result, result);return super.success;public string addemplast()int count=empservice.addemp(empinfo);if(count0)/成功return super.success;elsereturn addfail;/進(jìn)入管理中心的action public string gotocenter()return

32、 super.success;public empinfo getempinfo() return empinfo;public void setempinfo(empinfo empinfo) this.empinfo = empinfo;public empservice getempservice() return empservice;public void setempservice(empservice empservice) this.empservice = empservice;/ssm/src/com/common/action/baseaction.java繼承的acti

33、on類package mon.action;import java.util.map;import javax.servlet.servletcontext;import javax.servlet.http.httpservletrequest;import javax.servlet.http.httpservletresponse;import javax.servlet.http.httpsession;import org.apache.struts2.servletactioncontext;import com.opensymphony.xwork2.actionc

34、ontext;import com.opensymphony.xwork2.actionsupport;public class baseaction extends actionsupportprotected map sessionmap;/session map集合的對(duì)象protected map applicationmap;protected map requestmap;protected httpservletrequest request;/原生request的對(duì)象protected httpservletresponse response;protected httpsess

35、ion session;protected servletcontext application;protected map paramsmap;/參數(shù)map的集合suppresswarnings(unchecked)public baseaction()/構(gòu)造方法/* * 通過actioncontext獲得上下文 然后直接點(diǎn)獲得session的方法 */sessionmap=actioncontext.getcontext().getsession();applicationmap=actioncontext.getcontext().getapplication();requestmap=

36、(map)actioncontext.getcontext().get(request);request=(httpservletrequest)actioncontext.getcontext().get(servletactioncontext.http_request);response=(httpservletresponse)actioncontext.getcontext().get(servletactioncontext.http_response);application=(servletcontext)actioncontext.getcontext().get(servletactioncontext.servlet_context);session=request.getsession();paramsmap=actioncontext.getcontext().getparameters();/ssm/src/config/emp.xml select count(*) from emp_info where empid=#empid insert into