Java SSM实现公司薪资管理系统【优质毕业设计、课程设计项目】.zip

package com.controller; import java.io.File; import java.io.IOException; import java.sql.Timestamp; import java.util.ArrayList; import java.util.HashMap; import java.util.List; import java.util.Map; import java.io.PrintWriter; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.multipart.MultipartFile; import com.entity.Xinzixinxi; import com.server.XinzixinxiServer; import com.util.PageBean; import net.sf.json.JSONObject; import com.util.db; import java.sql.SQLException; import java.sql.*; @Controller public class XinzixinxiController { @Resource private XinzixinxiServer xinzixinxiService; @RequestMapping("addXinzixinxi.do") public String addXinzixinxi(HttpServletRequest request,Xinzixinxi xinzixinxi,HttpSession session) throws SQLException{ Timestamp time=new Timestamp(System.currentTimeMillis()); xinzixinxi.setAddtime(time.toString().substring(0, 19)); xinzixinxiService.add(xinzixinxi); session.setAttribute("backxx", "添加成功"); session.setAttribute("backurl", request.getHeader("Referer")); //session.setAttribute("backurl", "xinzixinxiList.do"); return "redirect:postback.jsp"; //return "redirect:xinzixinxiList.do"; } // 处理编辑 @RequestMapping("doUpdateXinzixinxi.do") public String doUpdateXinzixinxi(int id,ModelMap map,Xinzixinxi xinzixinxi){ xinzixinxi=xinzixinxiService.getById(id); map.put("xinzixinxi", xinzixinxi); return "xinzixinxi_updt"; } // 后台详细 @RequestMapping("xinzixinxiDetail.do") public String xinzixinxiDetail(int id,ModelMap map,Xinzixinxi xinzixinxi){ xinzixinxi=xinzixinxiService.getById(id); map.put("xinzixinxi", xinzixinxi); return "xinzixinxi_detail"; } // 前台详细 @RequestMapping("xzxxDetail.do") public String xzxxDetail(int id,ModelMap map,Xinzixinxi xinzixinxi){ xinzixinxi=xinzixinxiService.getById(id); map.put("xinzixinxi", xinzixinxi); return "xinzixinxidetail"; } // @RequestMapping("updateXinzixinxi.do") public String updateXinzixinxi(int id,ModelMap map,Xinzixinxi xinzixinxi,HttpServletRequest request,HttpSession session){ xinzixinxiService.update(xinzixinxi); session.setAttribute("backxx", "修改成功"); session.setAttribute("backurl", request.getHeader("Referer")); return "redirect:postback.jsp"; //String url = request.getHeader("Referer"); //return "redirect:"+url; //return "redirect:xinzixinxiList.do"; } // 分页查询 @RequestMapping("xinzixinxiList.do") public String xinzixinxiList(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Xinzixinxi xinzixinxi, String gonghao, String yuangongxingming, String bumen, String faxinyuefen, String jibengongzi1,String jibengongzi2, String fulijintie1,String fulijintie2, String gonglingjintie1,String gonglingjintie2, String gangweijintie1,String gangweijintie2, String manqinjiang1,String manqinjiang2, String jixiaojiangjin1,String jixiaojiangjin2, String buzhu1,String buzhu2, String jijiangongzi1,String jijiangongzi2, String jiaban1,String jiaban2, String queqinkoukuan1,String queqinkoukuan2, String qitakoukuan1,String qitakoukuan2, String zhufang1,String zhufang2, String yanglaoxianji1,String yanglaoxianji2, String yiliaoxianji1,String yiliaoxianji2, String shiyexianji1,String shiyexianji2, String shifagongzi){ if(page==null||page.equals("")){ page="1"; } PageBean pageBean=new PageBean(Integer.parseInt(page), 15); Map<String, Object> pmap=new HashMap<String,Object>(); pmap.put("pageno", pageBean.getStart()); pmap.put("pageSize", 15); if(gonghao==null||gonghao.equals("")){pmap.put("gonghao", null);}else{pmap.put("gonghao", gonghao);} if(yuangongxingming==null||yuangongxingming.equals("")){pmap.put("yuangongxingming", null);}else{pmap.put("yuangongxingming", yuangongxingming);} if(bumen==null||bumen.equals("")){pmap.put("bumen", null);}else{pmap.put("bumen", bumen);} if(faxinyuefen==null||faxinyuefen.equals("")){pmap.put("faxinyuefen", null);}else{pmap.put("faxinyuefen", faxinyuefen);} if(jibengongzi1==null||jibengongzi1.equals("")){pmap.put("jibengongzi1", null);}else{pmap.put("jibengongzi1", jibengongzi1);} if(jibengongzi2==null||jibengongzi2.equals("")){pmap.put("jibengongzi2", null);}else{pmap.put("jibengongzi2", jibengongzi2);} if(fulijintie1==null||fulijintie1.equals("")){pmap.put("fulijintie1", null);}else{pmap.put("fulijintie1", fulijintie1);} if(fulijintie2==null||fulijintie2.equals("")){pmap.put("fulijintie2", null);}else{pmap.put("fulijintie2", fulijintie2);} if(gonglingjintie1==null||gonglingjintie1.equals("")){pmap.put("gonglingjintie1", null);}else{pmap.put("gonglingjintie1", gonglingjintie1);} if(gonglingjintie2==null||gonglingjintie2.equals("")){pmap.put("gonglingjintie2", null);}else{pmap.put("gonglingjintie2", gonglingjintie2);} if(gangweijintie1==null||gangweijintie1.equals("")){pmap.put("gangweijintie1", null);}else{pmap.put("gangweijintie1", gangweijintie1);} if(gangweijintie2==null||gangweijintie2.equals("")){pmap.put("gangweijintie2", null);}else{pmap.put("gangweijintie2", gangweijintie2);} if(manqinjiang1==null||manqinjiang1.equals("")){pmap.put("manqinjiang1", null);}else{pmap.put("manqinjiang1", manqinjiang1);} if(manqinjiang2==null||manqinjiang2.equals("")){pmap.put("manqinjiang2", null);}else{pmap.put("manqinjiang2", manqinjiang2);} if(jixiaojiangjin1==null||jixiaojiangjin1.equals("")){pmap.put("jixiaojiangjin1", null);}else{pmap.put("jixiaojiangjin1", jixiaojiangjin1);} if(jixiaojiangjin2==null||jixiaojiangjin2.equals("")){pmap.put("jixiaojiangjin2", null);}else{pmap.put("jixiaojiangjin2", jixiaojiangjin2);} if(buzhu1==null||buzhu1.equals("")){pmap.put("buzhu1", null);}else{pmap.put("buzhu1", buzhu1);} if(buzhu2==null||buzhu2.equals("")){pmap.put("buzhu2", null);}else{pmap.put("buzhu2", buzhu2);} if(jijiangongzi1==null||jijiangongzi1.equals("")){pmap.put("jijiangongzi1", null);}else{pmap.put("jijiangongzi1", jijiangongzi1);} if(jijiangongzi2==null||jijiangongzi2.equals("")){pmap.put("jijiangongzi2", null);}else{pmap.put("jijiangongzi2", jijiangongzi2);} if(jiaban1==null||jiaban1.equals("")){pmap.put("jiaban1", null);}else{pmap.put("jiaban1", jiaban1);} if(jiaban2==null||jiaban2.equals("")){pmap.put("jiaban2", null);}else{pmap.put("jiaban2", jiaban2);} if(queqinkoukuan1==null||queqinkoukuan1.equals("")){pmap.put("queqinkoukuan1", null);}else{pmap.put("queqinkoukuan1", queqinkoukuan1);} if(queqinkoukuan2==null||queqinkoukuan2.equals("")){pmap.put("queqinkoukuan2", null);}else{pmap.put("queqinkoukuan2", queqinkoukuan2);} if(qitakoukuan1==null||qitakoukuan1.equals("")){pmap.put("qitakoukuan1", null);}else{pmap.put("qitakoukuan1", qitakoukuan1);} if(qitakoukuan2==null||qitakoukuan2.equals("")){pmap.put("qitakoukuan2", null);}else{pmap.put("qitakoukuan2", qitakoukuan2);} if(zhufang1==null||zhufang1.equals("")){pmap.put("zhufang1", null);}else{pmap.put("zhufang1", zhufang1);} if(zhufang2==null||zhufang2.equals("")){pmap.put("zhufang2", null);}else{pmap.put("zhufang2", zhufang2);} if(yanglaoxianji1==null||yanglaoxianji1.equals("")){pmap.put("yanglaoxianji1", null);}else{pmap.put("yanglaoxianji1", yanglaoxianji1);} if(yanglaoxianji2==null||yanglaoxianji2.equals("")){pmap.put("yanglaoxianji2", null);}else{pmap.put("yanglaoxianji2", yanglaoxianji2);} if(yiliaoxianji1==null||yiliaoxianji1.equals("")){pmap.put("yiliaoxianji1", null);}else{pmap.put("yiliaoxianji1", yiliaoxianji1);} if(yiliaoxianji2==null||yiliaoxianji2.equals("")){pmap.put("yiliaoxi