ssm高校综合素质测评系统毕业设计程序

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.Huojiangxinxi; import com.server.HuojiangxinxiServer; import com.util.PageBean; import net.sf.json.JSONObject; import com.util.db; import java.sql.SQLException; import java.sql.*; @Controller public class HuojiangxinxiController { @Resource private HuojiangxinxiServer huojiangxinxiService; @RequestMapping("addHuojiangxinxi.do") public String addHuojiangxinxi(HttpServletRequest request,Huojiangxinxi huojiangxinxi,HttpSession session) throws SQLException{ Timestamp time=new Timestamp(System.currentTimeMillis()); huojiangxinxi.setAddtime(time.toString().substring(0, 19)); huojiangxinxiService.add(huojiangxinxi); session.setAttribute("backxx", "添加成功"); session.setAttribute("backurl", request.getHeader("Referer")); //session.setAttribute("backurl", "huojiangxinxiList.do"); return "redirect:postback.jsp"; //return "redirect:huojiangxinxiList.do"; } // 处理编辑 @RequestMapping("doUpdateHuojiangxinxi.do") public String doUpdateHuojiangxinxi(int id,ModelMap map,Huojiangxinxi huojiangxinxi){ huojiangxinxi=huojiangxinxiService.getById(id); map.put("huojiangxinxi", huojiangxinxi); return "huojiangxinxi_updt"; } @RequestMapping("doUpdateHuojiangxinxilb.do") public String doUpdateHuojiangxinxilb(int id,ModelMap map,Huojiangxinxi huojiangxinxi){ huojiangxinxi=huojiangxinxiService.getById(id); map.put("huojiangxinxi", huojiangxinxi); return "huojiangxinxi_updtlb"; } @RequestMapping("updateHuojiangxinxilb.do") public String updateHuojiangxinxilb(int id,ModelMap map,Huojiangxinxi huojiangxinxi){ huojiangxinxiService.updatelb(huojiangxinxi); return "redirect:huojiangxinxiList.do"; } // 后台详细 @RequestMapping("huojiangxinxiDetail.do") public String huojiangxinxiDetail(int id,ModelMap map,Huojiangxinxi huojiangxinxi){ huojiangxinxi=huojiangxinxiService.getById(id); map.put("huojiangxinxi", huojiangxinxi); return "huojiangxinxi_detail"; } // 前台详细 @RequestMapping("hjxxDetail.do") public String hjxxDetail(int id,ModelMap map,Huojiangxinxi huojiangxinxi){ huojiangxinxi=huojiangxinxiService.getById(id); map.put("huojiangxinxi", huojiangxinxi); return "huojiangxinxidetail"; } // @RequestMapping("updateHuojiangxinxi.do") public String updateHuojiangxinxi(int id,ModelMap map,Huojiangxinxi huojiangxinxi,HttpServletRequest request,HttpSession session){ huojiangxinxiService.update(huojiangxinxi); session.setAttribute("backxx", "修改成功"); session.setAttribute("backurl", request.getHeader("Referer")); return "redirect:postback.jsp"; //String url = request.getHeader("Referer"); //return "redirect:"+url; //return "redirect:huojiangxinxiList.do"; } // 分页查询 @RequestMapping("huojiangxinxiList.do") public String huojiangxinxiList(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Huojiangxinxi huojiangxinxi, String xuehao, String xingming, String yuanximingcheng, String banjimingcheng, String zhuanyemingcheng, String jiangxiangbianhao, String jiangxiangmingcheng, String huojiangriqi1,String huojiangriqi2, String huojiangwenjian, String yuanxishenhejieguo, String dengjiren, String issh){ 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(xuehao==null||xuehao.equals("")){pmap.put("xuehao", null);}else{pmap.put("xuehao", xuehao);} if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);} if(yuanximingcheng==null||yuanximingcheng.equals("")){pmap.put("yuanximingcheng", null);}else{pmap.put("yuanximingcheng", yuanximingcheng);} if(banjimingcheng==null||banjimingcheng.equals("")){pmap.put("banjimingcheng", null);}else{pmap.put("banjimingcheng", banjimingcheng);} if(zhuanyemingcheng==null||zhuanyemingcheng.equals("")){pmap.put("zhuanyemingcheng", null);}else{pmap.put("zhuanyemingcheng", zhuanyemingcheng);} if(jiangxiangbianhao==null||jiangxiangbianhao.equals("")){pmap.put("jiangxiangbianhao", null);}else{pmap.put("jiangxiangbianhao", jiangxiangbianhao);} if(jiangxiangmingcheng==null||jiangxiangmingcheng.equals("")){pmap.put("jiangxiangmingcheng", null);}else{pmap.put("jiangxiangmingcheng", jiangxiangmingcheng);} if(huojiangriqi1==null||huojiangriqi1.equals("")){pmap.put("huojiangriqi1", null);}else{pmap.put("huojiangriqi1", huojiangriqi1);} if(huojiangriqi2==null||huojiangriqi2.equals("")){pmap.put("huojiangriqi2", null);}else{pmap.put("huojiangriqi2", huojiangriqi2);} if(huojiangwenjian==null||huojiangwenjian.equals("")){pmap.put("huojiangwenjian", null);}else{pmap.put("huojiangwenjian", huojiangwenjian);} if(yuanxishenhejieguo==null||yuanxishenhejieguo.equals("")){pmap.put("yuanxishenhejieguo", null);}else{pmap.put("yuanxishenhejieguo", yuanxishenhejieguo);} if(dengjiren==null||dengjiren.equals("")){pmap.put("dengjiren", null);}else{pmap.put("dengjiren", dengjiren);} int total=huojiangxinxiService.getCount(pmap); pageBean.setTotal(total); List<Huojiangxinxi> list=huojiangxinxiService.getByPage(pmap); map.put("page", pageBean); map.put("list", list); session.setAttribute("p", 1); return "huojiangxinxi_list"; } @RequestMapping("huojiangxinxi_yanben1.do") public String huojiangxinxi_yanben1(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Huojiangxinxi huojiangxinxi, String xuehao, String xingming, String yuanximingcheng, String banjimingcheng, String zhuanyemingcheng, String jiangxiangbianhao, String jiangxiangmingcheng, String huojiangriqi1,String huojiangriqi2, String huojiangwenjian, String yuanxishenhejieguo, String dengjiren, String issh){ 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(xuehao==null||xuehao.equals("")){pmap.put("xuehao", null);}else{pmap.put("xuehao", xuehao);} if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);} if(yuanximingcheng==null||yuanximingcheng.equals("")){pmap.put("yuanximingcheng", null);}else{pmap.put("yuanximingcheng", yuanximingcheng);} if(banjimingcheng==null||banjimingcheng.equals("")){pmap.put("banjimingcheng", null);}else{pmap.put("banjimingcheng", banjimingcheng);} if(zhuanyemingcheng==null||zhuanyemingcheng.equals("")){pmap.put("zhuanyemingcheng", null);}else{pmap.put("zhuanyemingcheng", zhuanyemingcheng);} if(jiangxiangbianhao==null||jiangxiangbianhao.equals("")){pmap.put("jiangxiangbianhao", null);}else{pmap.put("jiangxiangbianhao", jiangxiangbianhao);} if(jiangxiangmingcheng==null||jiangxiangmingcheng.equals("")){pmap.put("jiangxiangmingcheng", null);}else{pmap.put("jiangxiangmingcheng", jiangxiangmingcheng);} if(huojiangriqi1==null||huojiangriqi1.equals("")){pmap.put("huojiangriqi1", null);}else{pmap.put("huojiangriqi1", huojiangriqi1);} i