基于ssm+mysql的软件bug管理系统源码数据库.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.Tichu; import com.server.TichuServer; import com.util.PageBean; import net.sf.json.JSONObject; import com.util.db; import java.sql.SQLException; import java.sql.*; @Controller public class TichuController { @Resource private TichuServer tichuService; @RequestMapping("addTichu.do") public String addTichu(HttpServletRequest request,Tichu tichu,HttpSession session) throws SQLException{ Timestamp time=new Timestamp(System.currentTimeMillis()); tichu.setAddtime(time.toString().substring(0, 19)); tichuService.add(tichu); db dbo = new db(); dbo.hsgexecute("update chakan set issh='是'where xiangmubianhao='"+tichu.getXiangmubianhao()+"'"); //kuabiaogaizhi session.setAttribute("backxx", "添加成功"); session.setAttribute("backurl", request.getHeader("Referer")); //session.setAttribute("backurl", "tichuList.do"); return "redirect:postback.jsp"; //return "redirect:tichuList.do"; } // 处理编辑 @RequestMapping("doUpdateTichu.do") public String doUpdateTichu(int id,ModelMap map,Tichu tichu){ tichu=tichuService.getById(id); map.put("tichu", tichu); return "tichu_updt"; } // 后台详细 @RequestMapping("tichuDetail.do") public String tichuDetail(int id,ModelMap map,Tichu tichu){ tichu=tichuService.getById(id); map.put("tichu", tichu); return "tichu_detail"; } // 前台详细 @RequestMapping("tcDetail.do") public String tcDetail(int id,ModelMap map,Tichu tichu){ tichu=tichuService.getById(id); map.put("tichu", tichu); return "tichudetail"; } // @RequestMapping("updateTichu.do") public String updateTichu(int id,ModelMap map,Tichu tichu,HttpServletRequest request,HttpSession session){ tichuService.update(tichu); session.setAttribute("backxx", "修改成功"); session.setAttribute("backurl", request.getHeader("Referer")); return "redirect:postback.jsp"; //String url = request.getHeader("Referer"); //return "redirect:"+url; //return "redirect:tichuList.do"; } // 分页查询 @RequestMapping("tichuList.do") public String tichuList(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Tichu tichu, String xiangmubianhao, String xiangmumingcheng, String xiangmuleibie, String diaoshiyuan, String xiangmuriqi, String xiangmujingli, String fanganrenyuan, String jiejuefangan, 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); pmap.put("issh", "否"); if(xiangmubianhao==null||xiangmubianhao.equals("")){pmap.put("xiangmubianhao", null);}else{pmap.put("xiangmubianhao", xiangmubianhao);} if(xiangmumingcheng==null||xiangmumingcheng.equals("")){pmap.put("xiangmumingcheng", null);}else{pmap.put("xiangmumingcheng", xiangmumingcheng);} if(xiangmuleibie==null||xiangmuleibie.equals("")){pmap.put("xiangmuleibie", null);}else{pmap.put("xiangmuleibie", xiangmuleibie);} if(diaoshiyuan==null||diaoshiyuan.equals("")){pmap.put("diaoshiyuan", null);}else{pmap.put("diaoshiyuan", diaoshiyuan);} if(xiangmuriqi==null||xiangmuriqi.equals("")){pmap.put("xiangmuriqi", null);}else{pmap.put("xiangmuriqi", xiangmuriqi);} if(xiangmujingli==null||xiangmujingli.equals("")){pmap.put("xiangmujingli", null);}else{pmap.put("xiangmujingli", xiangmujingli);} if(fanganrenyuan==null||fanganrenyuan.equals("")){pmap.put("fanganrenyuan", null);}else{pmap.put("fanganrenyuan", fanganrenyuan);} if(jiejuefangan==null||jiejuefangan.equals("")){pmap.put("jiejuefangan", null);}else{pmap.put("jiejuefangan", jiejuefangan);} int total=tichuService.getCount(pmap); pageBean.setTotal(total); List<Tichu> list=tichuService.getByPage(pmap); map.put("page", pageBean); map.put("list", list); session.setAttribute("p", 1); return "tichu_list"; } @RequestMapping("tichu_yanben1.do") public String tichu_yanben1(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Tichu tichu, String xiangmubianhao, String xiangmumingcheng, String xiangmuleibie, String diaoshiyuan, String xiangmuriqi, String xiangmujingli, String fanganrenyuan, String jiejuefangan, 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(xiangmubianhao==null||xiangmubianhao.equals("")){pmap.put("xiangmubianhao", null);}else{pmap.put("xiangmubianhao", xiangmubianhao);} if(xiangmumingcheng==null||xiangmumingcheng.equals("")){pmap.put("xiangmumingcheng", null);}else{pmap.put("xiangmumingcheng", xiangmumingcheng);} if(xiangmuleibie==null||xiangmuleibie.equals("")){pmap.put("xiangmuleibie", null);}else{pmap.put("xiangmuleibie", xiangmuleibie);} if(diaoshiyuan==null||diaoshiyuan.equals("")){pmap.put("diaoshiyuan", null);}else{pmap.put("diaoshiyuan", diaoshiyuan);} if(xiangmuriqi==null||xiangmuriqi.equals("")){pmap.put("xiangmuriqi", null);}else{pmap.put("xiangmuriqi", xiangmuriqi);} if(xiangmujingli==null||xiangmujingli.equals("")){pmap.put("xiangmujingli", null);}else{pmap.put("xiangmujingli", xiangmujingli);} if(fanganrenyuan==null||fanganrenyuan.equals("")){pmap.put("fanganrenyuan", null);}else{pmap.put("fanganrenyuan", fanganrenyuan);} if(jiejuefangan==null||jiejuefangan.equals("")){pmap.put("jiejuefangan", null);}else{pmap.put("jiejuefangan", jiejuefangan);} int total=tichuService.getCount(pmap); pageBean.setTotal(total); List<Tichu> list=tichuService.getByPage(pmap); map.put("page", pageBean); map.put("list", list); session.setAttribute("p", 1); return "tichu_yanben1"; } @RequestMapping("tichu_yanben2.do") public String tichu_yanben2(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Tichu tichu, String xiangmubianhao, String xiangmumingcheng, String xiangmuleibie, String diaoshiyuan, String xiangmuriqi, String xiangmujingli, String fanganrenyuan, String jiejuefangan, 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(xiangmubianhao==null||xiangmubianhao.equals("")){pmap.put("xiangmubianhao", null);}else{pmap.put("xiangmubianhao", xiangmubianhao);} if(xiangmumingcheng==null||xiangmumingcheng.equals("")){pmap.put("xiangmumingcheng", null);}else{pmap.put("xiangmumingcheng", xiangmumingcheng);} if(xiangmuleibie==null||xiangmuleibie.equals("")){pmap.put("xiangmuleibie", null);}else{pmap.put("xiangmuleibie", xiangmuleibie);} if(diaoshiyuan==null||diaoshiyuan.equals("")){pmap.put("diaoshiyuan", null);}else{pmap.put("diaoshiyuan", diaoshiyuan);} if(xiangmuriqi==null||xiangmuriqi.equals("")){pmap.put("xiangmuriqi", null);}else{pmap.put("xiangmuriqi", xiangmuriqi);} if(xiangmujingli==null||xiangmujingli.equals("")){pmap.put("xia