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

上傳人：d*** IP屬地：安徽上傳時間：2023-09-28 格式：DOC 頁數(shù)：74 大?。?99KB 積分：36 舉報 版權(quán)申訴

SSM框架項目實例源代碼從注冊開始結(jié)合數(shù)據(jù)庫_第2頁

SSM框架項目實例源代碼從注冊開始結(jié)合數(shù)據(jù)庫_第3頁

SSM框架項目實例源代碼從注冊開始結(jié)合數(shù)據(jù)庫_第4頁

SSM框架項目實例源代碼從注冊開始結(jié)合數(shù)據(jù)庫_第5頁

已閱讀5頁，還剩69頁未讀，繼續(xù)免費閱讀

版權(quán)說明：本文檔由用戶提供并上傳，收益歸屬內(nèi)容提供方，若內(nèi)容存在侵權(quán)，請進行舉報或認領(lǐng)

文檔簡介

-.z./SSM/WebRoot/inde*.jsp<%pagelanguage="java"import="java.util.*"pageEncoding="utf-8"%><%Stringpath=request.getConte*tPath();StringbasePath=request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";%><!DOCTYPEHTMLPUBLIC"-//W3C//DTDHTML4.01Transitional//EN"><html><head><basehref="<%=basePath%>"><title>入口頁面</title><metahttp-equiv="pragma"content="no-cache"><metahttp-equiv="cache-control"content="no-cache"><metahttp-equiv="e*pires"content="0"><metahttp-equiv="keywords"content="keyword1,keyword2,keyword3"><metahttp-equiv="description"content="Thisismypage"><linkrel="stylesheet"href="/SSME*AM/css/mon.css"type="te*t/css"></link></head><body><divid="maindiv"><divid="leftdiv"><ahref="mon/login.jsp">登錄</a></div><divid="rightdiv"><ahref="toRegist.action">注冊</a></div></div></body></html>/SSM/src/config/applicationConte*t.*ml<"*mlversion="1.0"encoding="UTF-8""><beans*mlns="./schema/beans"*mlns:*si="./2001/*MLSchema-instance"*mlns:p="./schema/p"*si:schemaLocation="./schema/beans./schema/beans/spring-beans-3.0.*sd"><beanid="dataSource"class="org.apache.mons.dbcp.BasicDataSource"><propertyname="driverClassName"value="oracle.jdbc.driver.OracleDriver"/><propertyname="url"value="jdbc:oracle:thin:localhost:1521:MyOracle"/><propertyname="username"value="userBank"/><propertyname="password"value="userBank"/></bean><beanid="sessionFactory"class="org.mybatis.spring.SqlSessionFactoryBean"><propertyname="configLocation"value="classpath:config/Mybatis-config.*ml"/><propertyname="dataSource"ref="dataSource"/></bean><beanid="empDao"class="org.mybatis.spring.mapper.MapperFactoryBean"><propertyname="mapperInterface"value=".dao.EmpDao"></property><propertyname="sqlSessionFactory"ref="sessionFactory"></property></bean><beanid="empService"class=".biz.impl.EmpServiceImpl"><propertyname="empDao"ref="empDao"></property></bean><beanid="empAction"class=".action.EmpAction"lazy-init="true">/SSME*AM/src//action/EmpAction.java<propertyname="empService"ref="empService"></property></bean></beans>/SSME*AM/src//action/EmpAction.javapackage.action;importjava.util.HashMap;importjava.util.List;importjava.util.Map;import.biz.EmpService;import.mon.action.BaseAction;import.mon.dto.m;import.mon.dto.Dept;import.mon.dto.EmpInfo;import.mon.dto.PageDto;/****控制層*authorAdministrator**/publicclassEmpActione*tendsBaseAction{ privateEmpServiceempService; privateEmpInfoempInfo; privatePageDtopg; publicStringtoRegist() { Mapresult=empService.queryforRegist(); requestMap.put("result",result); returnsuper.SUCCESS; } //注冊的action publicStringregister(){ intcounts=empService.queryEmpByName(empInfo.getEname()); if(counts>0){//說明該注冊名是存在的return"registerFail"; }else{intcount=empService.addEmp(empInfo); System.out.println("新增了"+count+"條數(shù)據(jù)"); if(count!=0){ return"registerSuccess"; }else{return"registerFail"; } } } //登錄publicStringlogin(){System.out.println("進入登錄");empInfo=empService.queryEmpByEmpIdandP(empInfo); System.out.println("進入登錄"+empInfo.getEmpno()); if(empInfo!=null){//將用戶保存在session里面sessionMap.put("empInfo",empInfo); returnsuper.SUCCESS; }else{return"loginFail"; } } privateStringe*ists; publicStringgetE*ists(){ returne*ists; } publicvoidsetE*ists(Stringe*ists){ this.e*ists=e*ists; } publicStringcheckName(){ intcount=empService.queryEmpByEname(empInfo.getEname()); if(count>0){//說明存在e*ists="Y"; }else{//說明不存在e*ists="N"; } returnsuper.SUCCESS; } //篩選加模糊查詢所有員工的表publicStringqueryAllEmp(){ introwCount=empService.findTotalEmp(); //System.out.println("============"+rowCount); pg=newPageDto();//new一個page對象不然會報空pg.setRowCount(rowCount);//>設(shè)置總記錄數(shù)pg.setPageSize(3);//設(shè)置每頁顯示的記錄數(shù)//總頁數(shù)intpageCount=pg.getAllPageCount(pg.getRowCount(),pg.getPageSize()); //System.out.println("============"+pageCount); pg.setPageCount(pageCount); intpageInde*=1; if((request.getParameter("pageInde*"))!=null&&"".equals((request.getParameter("pageInde*")))){ pageInde*=1; }elseif((request.getParameter("pageInde*"))!=null&&!"".equals((request.getParameter("pageInde*")))){ pageInde*=Integer.parseInt(request.getParameter("pageInde*")); } pg.setPageInde*(pageInde*);//獲取上一頁intupInde*=pg.getUpInde*();//獲取下一頁intne*tPage=pg.getNe*tInde*(); //放入對象和頁碼requestMap.put("pg",pg); requestMap.put("upInde*",upInde*); requestMap.put("ne*tPage",ne*tPage);MappageMap=newHashMap();pageMap.put("start",pg.getStartInde*()); pageMap.put("end",pg.getEndInde*()); //傳入分頁參數(shù)//List<EmpInfo>empMapList=empService.findPageEmp(pageMap);//分頁先留著//Stringdeptname=""; /*for(EmpInfoempInfos:empMapList){ empInfo.getDept().setDeptName(empInfos.getDept().getDeptName());//部門empInfo.getm().setSalary(empInfos.getm().getSalary());//薪資empInfo.setEmpno(empInfos.getEmpno());//編號empInfo.setEname(empInfos.getEname());// empInfo.setEmpage(empInfos.getEmpage());//年齡empInfo.setEmpse*(empInfos.getEmpse*());//性別empInfo.setEmpId(empInfos.getEmpId());//賬號用戶名empInfo.setEmpIdno(empInfos.getEmpIdno());// empInfo.setEmpPhone(empInfos.getEmpPhone());// empInfo.setEmpPassword(empInfos.getEmpPassword());//密碼requestMap.put("empMapList",empInfo); System.out.println(empInfo.getDept().getDeptName()); }*/ //System.out.println(deptname); //將條件放入mapsql將根據(jù)鍵值的條件查詢//List<Map>empMapList=empService.querylikeEmp(empMap);//不分頁List<Map>empMapList=empService.findAllEmp(); requestMap.put("empMapList",empMapList); //requestMap.putAll(empMap); returnsuper.SUCCESS; } //模糊查詢publicStringquerylikeEmp(){MapempMap=newHashMap();//獲取用戶輸入的條件Stringename=request.getParameter("ename");StringdeptName=request.getParameter("deptName"); StringempAgeStart=request.getParameter("empAgeStart"); StringempAgeEnd=request.getParameter("empAgeEnd"); Stringempse*=request.getParameter("empse*");//根據(jù)條件查詢放入到empMapempMap.put("ename",ename); empMap.put("deptName",deptName); empMap.put("empAgeStart",empAgeStart); empMap.put("empAgeEnd",empAgeEnd); empMap.put("empse*",empse*); List<Map>emplikeList=empService.querylikeEmp(empMap); requestMap.put("emplikeList",emplikeList); if(emplikeList==null){ return"queryFail"; } for(Mapmap:emplikeList){ System.out.println("*****************"+map.get("ename"));System.out.println(map.get("empage")); }returnsuper.SUCCESS; } //刪除員工publicStringdeleteEmp(){System.out.println("進入刪除");intcount=empService.deleteEmpById(empInfo.getEmpno()); if(count>0){//成功returnsuper.SUCCESS; }else{return"fail"; } } publicStringdeleteAllEmp(){//復(fù)選框參數(shù)集合String[]deteles=request.getParameterValues("deletes"); empService.deleteAllEmp(deteles); returnsuper.SUCCESS; } //刪除部門publicStringdeleteDeptById(){ //從部門中刪除部門信息要先判斷員工是不是在這個要刪除的部門intcount=empService.selectDeptmon(empInfo.getDept().getDeptno()); if(count>0){//說明無法刪除啊Stringmessage="刪除部門信息請先刪除該員工!"; session.setAttribute("message",message);System.out.println("====count"+count);return"deleteFail"; }else{System.out.println("====count"+count);empService.deleteDeptById(empInfo.getDept().getDeptno()); returnsuper.SUCCESS; } } //刪除薪資福利publicStringdeletemById(){ empService.deletemById(empInfo.getm().getmId()); returnsuper.SUCCESS; } //查詢所有部門publicStringqueryAllDept(){ introwCount=empService.findTotalDept(); //System.out.println("============"+rowCount); pg=newPageDto();//new一個page對象不然會報空pg.setRowCount(rowCount);//>設(shè)置總記錄數(shù)pg.setPageSize(4);//設(shè)置每頁顯示的記錄數(shù)//總頁數(shù)intpageCount=pg.getAllPageCount(pg.getRowCount(),pg.getPageSize()); System.out.println("============"+pageCount); pg.setPageCount(pageCount); intpageInde*=1; if((request.getParameter("pageInde*"))==null&&"".equals((request.getParameter("pageInde*")))){ pageInde*=1; }elseif((request.getParameter("pageInde*"))!=null&&!"".equals((request.getParameter("pageInde*")))){ pageInde*=Integer.parseInt(request.getParameter("pageInde*")); } pg.setPageInde*(pageInde*);//獲取上一頁intupInde*=pg.getUpInde*();//獲取下一頁intne*tPage=pg.getNe*tInde*(); //放入對象和頁碼requestMap.put("pg",pg); requestMap.put("upInde*",upInde*); requestMap.put("ne*tPage",ne*tPage);MappageMap=newHashMap();pageMap.put("start",pg.getStartInde*()); pageMap.put("end",pg.getEndInde*()); List<Dept>deptList=empService.findPageDept(pageMap); //List<Dept>deptList=empService.queryAllDept();無分頁requestMap.put("deptList",deptList); returnsuper.SUCCESS; } //所有薪資福利要分頁publicStringqueryAllm(){ introwCount=empService.findTotalm(); pg=newPageDto();//new一個page對象不然會報空pg.setRowCount(rowCount);//>設(shè)置總記錄數(shù)pg.setPageSize(4);//設(shè)置每頁顯示的記錄數(shù)//總頁數(shù)intpageCount=pg.getAllPageCount(pg.getRowCount(),pg.getPageSize()); pg.setPageCount(pageCount); intpageInde*=1; if((request.getParameter("pageInde*"))==null&&"".equals((request.getParameter("pageInde*")))){ pageInde*=1; }elseif((request.getParameter("pageInde*"))!=null&&!"".equals((request.getParameter("pageInde*")))){ pageInde*=Integer.parseInt(request.getParameter("pageInde*")); } pg.setPageInde*(pageInde*);//獲取上一頁intupInde*=pg.getUpInde*();//獲取下一頁intne*tPage=pg.getNe*tInde*(); //放入對象和頁碼requestMap.put("pg",pg); requestMap.put("upInde*",upInde*); requestMap.put("ne*tPage",ne*tPage);MappageMap=newHashMap();pageMap.put("start",pg.getStartInde*()); pageMap.put("end",pg.getEndInde*()); List<m>mList=empService.findPagem(pageMap); //List<m>mList=empService.queryAllm();不帶分頁requestMap.put("mList",mList); returnsuper.SUCCESS; } //修改員工先進入頁面updateEmpLast publicStringupdateEmpFirst(){Mapresult=empService.queryforRegist();//System.out.println(result.size()); requestMap.put("result",result);//查詢到該名員工的編號empInfo=empService.getEmpById(empInfo.getEmpno()); System.out.println("*in*i"+empInfo.getEname()); requestMap.put("empInfo",empInfo); returnsuper.SUCCESS; } publicStringupdateEmpLast(){ intcount=empService.updateEmp(empInfo); //System.out.println("===1成功"======="+count); returnsuper.SUCCESS; } //修改部門先進入頁面publicStringupdateDeptFirst(){//獲取部門編號intdeptno=empInfo.getDept().getDeptno(); Deptdept=empService.getDeptByDeptno(deptno); empInfo.setDept(dept); requestMap.put("dept",empInfo.getDept()); returnsuper.SUCCESS; } publicStringupdateDeptLast(){ intcount=empService.updateDept(empInfo.getDept()); returnsuper.SUCCESS; } publicStringupdatemFirst(){//獲取idintmId=empInfo.getm().getmId(); mm=empService.getmBymId(mId); empInfo.setm(m); requestMap.put("m",empInfo.getm()); returnsuper.SUCCESS; } publicStringupdatemLast(){//傳入部門對象修改intcount=empService.updatem(empInfo.getm()); returnsuper.SUCCESS; } //詳情 publicStringshowEmpDetails(){ //empInfo=empService.getEmpById(empInfo.getEmpno()); List<Map>empList=empService.getEmpsById(empInfo.getEmpno()); //requestMap.put("empInfo",empInfo); requestMap.put("empList",empList); returnsuper.SUCCESS; } publicStringshowmDetails(){ mm=empService.getmBymId(empInfo.getm().getmId()); requestMap.put("m",m); returnsuper.SUCCESS; } publicString showDeptDetails(){ Deptdept=empService.getDeptByDeptno(empInfo.getDept().getDeptno()); requestMap.put("dept",dept); returnsuper.SUCCESS; } privateStringdeptName; publicStringgetDeptName(){ returndeptName; } publicvoidsetDeptName(StringdeptName){ this.deptName=deptName; } //新增部門publicStringaddDept(){ empService.addDept(deptName); returnsuper.SUCCESS; }privateintsalary; publicintgetSalary(){ returnsalary; } publicvoidsetSalary(intsalary){ this.salary=salary; } //新增薪資福利publicStringaddm(){ intcount=empService.addm(salary); if(count>0){ Stringmessage2="<script>alert('新增1條數(shù)據(jù)');</script>";Stringmessage="新增"+count+"條數(shù)據(jù)";session.setAttribute("Y","新增"+count+"條數(shù)據(jù)"); session.setAttribute("message2",message2); session.setAttribute("messageAlert",message); } returnsuper.SUCCESS; } publicStringaddEmpFirst(){Mapresult=empService.queryforRegist(); System.out.println(result.size());requestMap.put("result",result); returnsuper.SUCCESS; } publicStringaddEmpLast(){ intcount=empService.addEmp(empInfo); if(count>0){//成功returnsuper.SUCCESS; }else{return"addFail"; } } //進入管理中心的action publicStringgotoCenter(){ returnsuper.SUCCESS; } publicEmpInfogetEmpInfo(){ returnempInfo; } publicvoidsetEmpInfo(EmpInfoempInfo){ this.empInfo=empInfo; } publicEmpServicegetEmpService(){ returnempService; } publicvoidsetEmpService(EmpServiceempService){ this.empService=empService; }}/SSM/src//mon/action/BaseAction.java繼承的action類package.mon.action;importjava.util.Map;importjava*.servlet.ServletConte*t;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;importjava*.servlet.http.HttpSession;importorg.apache.struts2.ServletActionConte*t;import.opensymphony.*work2.ActionConte*t;import.opensymphony.*work2.ActionSupport;publicclassBaseActione*tendsActionSupport{ protectedMap<String,Object>sessionMap;//sessionmap集合的對象protectedMap<String,Object>applicationMap; protectedMap<String,Object>requestMap; protectedHttpServletRequestrequest;//原生request的對象protectedHttpServletResponseresponse; protectedHttpSessionsession; protectedServletConte*tapplication; protectedMap<String,Object>paramsMap;//參數(shù)map的集合SuppressWarnings("unchecked") publicBaseAction(){//構(gòu)造方法/**** *通過ActionConte*t獲得上下文然后直接點獲得session的方法*/ sessionMap=ActionConte*t.getConte*t().getSession(); applicationMap=ActionConte*t.getConte*t().getApplication(); requestMap=(Map<String,Object>)ActionConte*t.getConte*t().get("request"); request=(HttpServletRequest)ActionConte*t.getConte*t().get(ServletActionConte*t.HTTP_REQUEST); response=(HttpServletResponse)ActionConte*t.getConte*t().get(ServletActionConte*t.HTTP_RESPONSE); application=(ServletConte*t)ActionConte*t.getConte*t().get(ServletActionConte*t.SERVLET_CONTE*T); session=request.getSession(); paramsMap=ActionConte*t.getConte*t().getParameters(); } /SSM/src/config/emp.*ml<"*mlversion="1.0"encoding="UTF-8""><!DOCTYPEmapperPUBLIC"-////DTDMapper3.0//EN""/dtd/mybatis-3-mapper.dtd"><mappernamespace=".dao.EmpDao"><selectid="queryEmpByName"resultType="int"parameterType=".mon.dto.EmpInfo">selectcount(*)fromemp_infowhereempId=*{empId}</select><insertid="addEmp"parameterType=".mon.dto.EmpInfo">insertintoemp_infovalues(seq_emp.ne*tval,*{empId},*{ename},*{empage},*{empse*},*{empIdno},*{empPhone},*{empPassword},*{dept.deptno},*{m.mId})</insert><selectid="findAllEmp"resultType="java.util.Map">selecte.empno,e.empid,e.empname,e.empage,e.empse*,e.empidno,e.empphone,e.emppassword, d.deptno,d.deptname,c.mid,c.salaryfromemp_infoe,emp_deptd,emp_mcwhered.deptno=e.deptnoandc.mid=e.mid</select><selectid="queryEmpByEname"resultType="int"parameterType="String">selectcount(*)fromemp_infowhereempname=*{ename}</select><selectid="getEmpsById"resultType="java.util.Map"parameterType="int">selecte.empno,e.empId,e.empname,e.empage,e.empse*,e.empIdno,e.empPhone,e.empPassword, d.deptno,d.deptName,c.mId,c.salaryfromemp_infoe,emp_deptd,emp_mc wheree.deptno=d.deptnoande.mid=c.midandempno=*{empno}</select><selectid="queryEmpByEmpIdandP"resultType=".mon.dto.EmpInfo"parameterType=".mon.dto.EmpInfo">select*fromemp_infowhereempId=*{empId}andempPassword=*{empPassword}</select><selectid="queryAllDept"resultType=".mon.dto.Dept">selectdeptno,deptnamefromemp_dept</select><selectid="getDeptByDeptno"parameterType="int"resultType=".mon.dto.Dept">selectdeptno,deptnamefromemp_deptwheredeptno=*{deptno}</select><selectid="selectDeptmon"resultType="int"parameterType="int">selectcount(*)fromemp_infoe,emp_deptdwheree.deptno=d.deptnoande.deptno=*{deptno};</select><selectid="queryAllm"resultType=".mon.dto.m">selectmId,salaryfromemp_m</select><selectid="getmBymId"resultType=".mon.dto.m">selectmId,salaryfromemp_mwheremid=*{mId}</select><selectid="queryAllEmp"resultType=".mon.dto.EmpInfo"parameterType=".mon.dto.EmpInfo">selectempno,empname,empage,empse*,empIdno,empPhone,empPassword,deptno,mIdfromemp_info</select><selectid="querylikeEmp"resultType="java.util.Map"parameterType="java.util.Map">selecte.empno,e.empId,e.empname,e.empage,e.empse*,e.empIdno,e.empPhone,e.empPassword, d.deptno,d.deptName,c.mId,c.salaryfromemp_infoe,emp_deptd,emp_mc<where> e.deptno=d.deptnoande.mid=c.mid<iftest="ename!=null"> andempnamelike'%'||*{ename}||'%'</if><iftest="deptName!=null"> anddeptNamelike'%'||*{deptName}||'%'</if><iftest="empse*!=null"> andempse*=*{empse*}</if><iftest="empAgeStart!=nullandempAgeEnd!=null"><![CDATA[andempage>=*{empAgeStart}andempage<=*{empAgeEnd}]]></if></where></select><deleteid="deleteEmpById"parameterType="int">deletefromemp_infowhereempno=*{empno}</delete><deleteid="deleteAllEmp"parameterType="java.util.Map">deletefromemp_infowhereempnoin(<foreachcollection="deletes"item="empno"separator=",">*{empno}</foreach>)</delete><deleteid="deleteDeptById"parameterType="int">deletefromemp_deptwheredeptno=*{deptno}</delete><deleteid="deletemById"parameterType="int">deletefromemp_mwheremId=*{mId}</delete><updateid="updateEmp"parameterType=".mon.dto.EmpInfo">updateemp_infosetempname=*{ename},empage=*{empage},empse*=*{empse*},empIdno=*{empIdno},empPhone=*{empPhone},empPassword=*{empPassword},deptno=*{dept.deptno},mId=*{m.mId} whereempno=*{empno}</update><updateid="updateDept"parameterType=".mon.dto.Dept">updateemp_deptsetdeptName=*{deptName}wheredeptno=*{deptno}</update><updateid="updatem"parameterType=".mon.dto.m">updateemp_msetsalary=*{salary}wheremid=*{mId}</update><insertid="addDept"parameterType="String">insertintoemp_dept(deptName)values(*{deptName})</insert><insertid="addm"parameterType="int">insertintoemp_m(salary)values(*{salary})</insert><resultMapid="selectEmpMap"type="int"><resultproperty="rowCount"column="count_value"/></resultMap><selectid="findTotalEmp"resultMap="selectEmpMap">selectcount(*)ascount_valuefromemp_infoe,emp_deptd,emp_mcwheree.deptno=d.deptnoande.mid=c.mid</select><resultMapid="selectDeptMap"type="int"><resultproperty="rowCount"column="count_value"/></resultMap><selectid="findTotalDept"resultMap="selectDeptMap">selectcount(*)ascount_valuefromemp_dept</select><resultMapid="selectmMap"type="int"><resultproperty="rowCount"column="count_value"/></resultMap><selectid="findTotalm"resultMap="selectmMap">selectcount(*)ascount_valuefromemp_m</select><resultMaptype=".mon.dto.EmpInfo"id="pageEmpList"><idproperty="empno"column="empno"/><resultproperty="ename"column="empname"/><resultproperty="empId"column="empId"/><resultproperty="empage"column="empage"/><resultproperty="empse*"column="empse*"/><resultproperty="empIdno"column="empIdno"/><resultproperty="empPhone"column="empPhone"/><resultproperty="empPassword"column="empPassword"/><resultproperty="dept.deptName"column="deptname"/><resultproperty="m.salary"column="salary"/></resultMap><selectid="findPageEmp"resultMap="pageEmpList"parameterType="Map">selectROWNUMrn,e.*,d.*,c.*fromemp_infoe,emp_deptd,emp_mcwhere(e.deptno=d.deptnoande.mid=c.mid)andROWNUM>=*{start}andROWNUM<=*{end}</select><resultMaptype=".mon.dto.m"id="pagemList"><idproperty="mId"column="mId"/><resultproperty="salary"column="salary"/></resultMap><selectid="findPagem"resultMap="pagemList"parameterType="Map">select*from(selectrownumrn,c.*fromemp_mc)wherern>=*{start}andrn<=*{end}</select><resultMaptype=".mon.dto.Dept"id="pageDeptList"><idproperty="deptno"column="deptno"/><resultproperty="deptName"column="deptName"/></resultMap><selectid="findPageDept"resultMap="pageDeptList"parameterType="Map">select*from(selectrownumrn,d.*fromemp_deptd)wherern>=*{start}andrn<=*{end}</select></mapper>/SSM/src/config/Mybatis-config.*ml<"*mlversion="1.0"encoding="UTF-8""><!DOCTYPEconfigurationPUBLIC"-////DTDConfig3.0//EN""/dtd/mybatis-3-config.dtd"><configuration><mappers><mapperresource="config/emp.*ml"/></mappers></configuration>/SSM/src//mon/dto包下的類package.mon.dto;/***薪資福利表對應(yīng)的實體類*authorAdministrator**/publicclassm{privateintmId;privateintsalary;publicintgetmId(){returnmId; }publicvoidsetmId(intmId){this.mId=mId; }publicintgetSalary(){returnsalary; }publicvoidsetSalary(intsalary){this.salary=salary; }}package.mon.dto;/****部門表對應(yīng)的實體類*authorAdministrator**/publicclassDept{privateintdeptno;privateStringdeptName;publicintgetDeptno(){returndeptno; }publicvoidsetDeptno(intdeptno){this.deptno=deptno; }publicStringgetDeptName(){returndeptName; }publicvoidsetDeptName(StringdeptName){this.deptName=deptName; }}package.mon.dto;/***員工表對應(yīng)的實體類*authorAdministrator**/publicclassEmpInfo{/***empnonumber(6)notnullprimarykey,--編號自動生成empIdvarchar(20)notnull,--用來當賬號登錄varchar(20)notnull,--名字empAgenumber(3)notnull,empSe*varchar(3)notnull,empIdNovarchar(18)notnull,--號empPhonevarchar(11)notnull,empPasswordvarchar(16)notnull,deptNonumber(4),mIdnumber(4)**/privateintempno;//--編號自動生成privateStringename;privateStringempId;//用來當賬號登錄privateintempage;privateStringempse*;privateStringempIdno;privateStringempPhone;privateStringempPassword;privateDeptdept;privatemm;publicintgetEmpno(){returnempno; }publicvoidsetEmpno(intempno){this.empno=empno; }publicStringgetEname(){returnename; }publicvoidsetEname(Stringename){this.ename=ename; }publicStringgetEmpId(){returnempId; }publicvoidsetEmpId(StringempId){this.empId=empId; }publicintgetEmpage(){returnempage; }publicvoidsetEmpage(intempage){this.empage=empage; }publicStringgetEmpse*(){returnempse*; }publicvoidsetEmpse*(Stringempse*){this.empse*=empse*; }publicStringgetEmpIdno(){returnempIdno; }publicvoidsetEmpIdno(StringempIdno){this.empIdno=empIdno; }publicStringgetEmpPhone(){returnempPhone; }publicvoidsetEmpPhone(StringempPhone){this.empPhone=empPhone; }publicStringgetEmpPassword(){returnempPassword; }publicvoidsetEmpPassword(StringempPassword){this.empPassword=empPassword; }publicDeptgetDept(){returndept; }publicvoidsetDept(Deptdept){this.dept=dept; }publicmgetm(){returnm; }publicvoidsetm(mm){this.m=m; }}package.mon.dto;publicclassPageDto{privateintpageInde*=1;//當前頁privateintpageSize=4;//每頁顯示多少條記錄privateintrowCount;//一共多少條記錄從數(shù)據(jù)庫查的privateintpageCount;//一共多少頁（計算出來的）根據(jù)rowCountSize//獲得總頁數(shù)的方法publicintgetAllPageCount(introwCount,intpageSize){intpageCount;if(rowCount%pageSize==0){pageCount=rowCount/pageSize; }else{pageCount=rowCount/pageSize+1; }returnpageCount; }//分頁開始的方法publicintgetStartInde*(){return(pageInde*-1)*pageSize+1; }//分頁結(jié)束的方法publicintgetEndInde*(){returnpageInde**pageSize+1; }//獲取上一頁的方法publicintgetUpInde*(){if(pageInde*<=1){//如果當前頁面是小于等于1的話默認設(shè)置為訪問第一頁returnpageInde*; }else{returnpageInde*-1;//否則有上一頁可以訪問 } }//獲取下一頁的方法publicintgetNe*tInde*(){//如果頁數(shù)大于總頁數(shù)的話if(pageInde*>=this.getAllPageCount(this.rowCount,this.pageSize)){//大于總頁數(shù)回到最后一頁returnthis.pageCount; }else{ returnthis.getPageInde*()+1; } }publicintgetPageSize(){returnpageSize; }publicvoidsetPageSize(intpageSize){this.pageSize=pageSize; }publicintgetRowCount(){returnrowCount; }publicvoidsetRowCount(introwCount){this.rowCount=rowCount; }publicintgetPageCount(){returnpageCount; }publicvoidsetPageCount(intpageCount){this.pageCount=pageCount; }publicintgetPageInde*(){returnpageInde*; }publicvoidsetPageInde*(intpageInde*){this.pageInde*=pageInde*; }}/SSM/src//dao/EmpDao.javaDao層package.dao;importjava.util.List;importjava.util.Map;import.mon.dto.m;import.mon.dto.Dept;import.mon.dto.EmpInfo;/***數(shù)據(jù)防問層接口*/publicinterfaceEmpDao{ //所有的部門&所有的福利查詢用于下拉框顯示和功能模塊顯示publicList<Dept>queryAllDept(); publicList<m>queryAllm(); //根據(jù)名字查詢員public intqueryEmpByName(Stringename);//篩選查詢加模糊publicList<Map>querylikeEmp(MapparamMp); publicList<Map>findAllEmp(); publicList<Map>getEmpsById(intempno);//查詢員工通過賬號和密碼public EmpInfoqueryEmpByEmpIdandP(EmpInfoempInfo);//根據(jù)id查到員工的資料public EmpInfogetEmpById(intempno); publicDeptgetDeptByDeptno(intdeptno); publicmgetmBymId(intmId);//修改員工資料publicintupdateEmp(EmpInfoempInfo); publicintupdateDept(Deptdept); publicintupdatem(mm); //傳入id刪除該員工//刪除員工部門薪資表byID publicintdeleteEmpById(intid); publicintdeleteAllEmp(Mapmap); publicintdeleteDeptById(intdeptno); publicintdeletemById(intmId);//刪除部門表先查詢是否與員工表關(guān)聯(lián)publicintselectDeptmon(intdeptno); //新增部門publicintaddDept(StringdeptName); publicintaddm(intsalary); //添加員工public intaddEmp(EmpInfoempInfo); //查詢員工ByEname publicint queryEmpByEname(Stringename); /** *3表分頁的*parammap *return */ publicList<EmpInfo>findPageEmp(Mapmap); publicintfindTotalEmp(); publicList<Dept>findPageDept(Mapmap); publicintfindTotalDept(); publicList<m>findPagem(Mapmap); publicintfindTotalm();}//Service層package.biz;importjava.util.List;importjava.util.Map;import.mon.dto.m;import.mon.dto.Dept;import.mon.dto.EmpInfo;/***業(yè)務(wù)邏輯層接口*authorAdministrator**/publicinterfaceEmpService{ //為了注冊頁面顯示下拉框的效果先獲得下拉框的值publicMapqueryfo

人人文庫> 全部分類> 行業(yè)資料 > 信息產(chǎn)業(yè)

溫馨提示

1. 本站所有資源如無特殊說明，都需要本地電腦安裝OFFICE2007和PDF閱讀器。圖紙軟件為CAD,CAXA,PROE,UG,SolidWorks等.壓縮文件請下載最新的WinRAR軟件解壓。
2. 本站的文檔不包含任何第三方提供的附件圖紙等，如果需要附件，請聯(lián)系上傳者。文件的所有權(quán)益歸上傳用戶所有。
3. 本站RAR壓縮包中若帶圖紙，網(wǎng)頁內(nèi)容里面會有圖紙預(yù)覽，若沒有圖紙預(yù)覽就沒有圖紙。
4. 未經(jīng)權(quán)益所有人同意不得將文件中的內(nèi)容挪作商業(yè)或盈利用途。
5. 人人文庫網(wǎng)僅提供信息存儲空間，僅對用戶上傳內(nèi)容的表現(xiàn)方式做保護處理，對用戶上傳分享的文檔內(nèi)容本身不做任何修改或編輯，并不能對任何下載內(nèi)容負責。
6. 下載文件中如有侵權(quán)或不適當內(nèi)容，請與我們聯(lián)系，我們立即糾正。
7. 本站不保證下載資源的準確性、安全性和完整性, 同時也不承擔用戶因使用這些下載資源對自己和他人造成任何形式的傷害或損失。

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

文檔簡介

溫馨提示

最新文檔

評論

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

文檔簡介

溫馨提示

最新文檔

評論

相關(guān)文檔