基于ssm+mysql的书籍借阅系统源码数据库.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.Guihuantushu; import com.server.GuihuantushuServer; import com.util.PageBean; import net.sf.json.JSONObject; import com.util.db; import java.sql.SQLException; import java.sql.*; @Controller public class GuihuantushuController { @Resource private GuihuantushuServer guihuantushuService; @RequestMapping("addGuihuantushu.do") public String addGuihuantushu(HttpServletRequest request,Guihuantushu guihuantushu,HttpSession session) throws SQLException{ Timestamp time=new Timestamp(System.currentTimeMillis()); guihuantushu.setAddtime(time.toString().substring(0, 19)); guihuantushuService.add(guihuantushu); db dbo = new db(); dbo.hsgexecute("update jieyuetushu set kucun=kucun+"+guihuantushu.getGuihuanshuliang()+" where tushubianhao='"+guihuantushu.getTushubianhao()+"'"); db dbo1 = new db(); dbo1.hsgexecute("update jieyuetushu set issh='是'where tushubianhao='"+guihuantushu.getTushubianhao()+"'"); //kuabiaogaizhi session.setAttribute("backxx", "添加成功"); session.setAttribute("backurl", request.getHeader("Referer")); //session.setAttribute("backurl", "guihuantushuList.do"); return "redirect:postback.jsp"; //return "redirect:guihuantushuList.do"; } // 处理编辑 @RequestMapping("doUpdateGuihuantushu.do") public String doUpdateGuihuantushu(int id,ModelMap map,Guihuantushu guihuantushu){ guihuantushu=guihuantushuService.getById(id); map.put("guihuantushu", guihuantushu); return "guihuantushu_updt"; } @RequestMapping("doUpdateGuihuantushulb.do") public String doUpdateGuihuantushulb(int id,ModelMap map,Guihuantushu guihuantushu){ guihuantushu=guihuantushuService.getById(id); map.put("guihuantushu", guihuantushu); return "guihuantushu_updtlb"; } @RequestMapping("updateGuihuantushulb.do") public String updateGuihuantushulb(int id,ModelMap map,Guihuantushu guihuantushu){ guihuantushuService.updatelb(guihuantushu); return "redirect:guihuantushuList.do"; } // 后台详细 @RequestMapping("guihuantushuDetail.do") public String guihuantushuDetail(int id,ModelMap map,Guihuantushu guihuantushu){ guihuantushu=guihuantushuService.getById(id); map.put("guihuantushu", guihuantushu); return "guihuantushu_detail"; } // 前台详细 @RequestMapping("ghtsDetail.do") public String ghtsDetail(int id,ModelMap map,Guihuantushu guihuantushu){ guihuantushu=guihuantushuService.getById(id); map.put("guihuantushu", guihuantushu); return "guihuantushudetail"; } // @RequestMapping("updateGuihuantushu.do") public String updateGuihuantushu(int id,ModelMap map,Guihuantushu guihuantushu,HttpServletRequest request,HttpSession session){ guihuantushuService.update(guihuantushu); session.setAttribute("backxx", "修改成功"); session.setAttribute("backurl", request.getHeader("Referer")); return "redirect:postback.jsp"; //String url = request.getHeader("Referer"); //return "redirect:"+url; //return "redirect:guihuantushuList.do"; } // 分页查询 @RequestMapping("guihuantushuList.do") public String guihuantushuList(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Guihuantushu guihuantushu, String tushubianhao, String tushumingcheng, String tushuleibie, String kucun, String jieyueshuliang, String jieyueriqi, String guihuanshuliang1,String guihuanshuliang2, String duzhe, String shifouguihuan, 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(tushubianhao==null||tushubianhao.equals("")){pmap.put("tushubianhao", null);}else{pmap.put("tushubianhao", tushubianhao);} if(tushumingcheng==null||tushumingcheng.equals("")){pmap.put("tushumingcheng", null);}else{pmap.put("tushumingcheng", tushumingcheng);} if(tushuleibie==null||tushuleibie.equals("")){pmap.put("tushuleibie", null);}else{pmap.put("tushuleibie", tushuleibie);} if(kucun==null||kucun.equals("")){pmap.put("kucun", null);}else{pmap.put("kucun", kucun);} if(jieyueshuliang==null||jieyueshuliang.equals("")){pmap.put("jieyueshuliang", null);}else{pmap.put("jieyueshuliang", jieyueshuliang);} if(jieyueriqi==null||jieyueriqi.equals("")){pmap.put("jieyueriqi", null);}else{pmap.put("jieyueriqi", jieyueriqi);} if(guihuanshuliang1==null||guihuanshuliang1.equals("")){pmap.put("guihuanshuliang1", null);}else{pmap.put("guihuanshuliang1", guihuanshuliang1);} if(guihuanshuliang2==null||guihuanshuliang2.equals("")){pmap.put("guihuanshuliang2", null);}else{pmap.put("guihuanshuliang2", guihuanshuliang2);} if(duzhe==null||duzhe.equals("")){pmap.put("duzhe", null);}else{pmap.put("duzhe", duzhe);} if(shifouguihuan==null||shifouguihuan.equals("")){pmap.put("shifouguihuan", null);}else{pmap.put("shifouguihuan", shifouguihuan);} int total=guihuantushuService.getCount(pmap); pageBean.setTotal(total); List<Guihuantushu> list=guihuantushuService.getByPage(pmap); map.put("page", pageBean); map.put("list", list); session.setAttribute("p", 1); return "guihuantushu_list"; } @RequestMapping("guihuantushu_yanben1.do") public String guihuantushu_yanben1(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Guihuantushu guihuantushu, String tushubianhao, String tushumingcheng, String tushuleibie, String kucun, String jieyueshuliang, String jieyueriqi, String guihuanshuliang1,String guihuanshuliang2, String duzhe, String shifouguihuan, 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(tushubianhao==null||tushubianhao.equals("")){pmap.put("tushubianhao", null);}else{pmap.put("tushubianhao", tushubianhao);} if(tushumingcheng==null||tushumingcheng.equals("")){pmap.put("tushumingcheng", null);}else{pmap.put("tushumingcheng", tushumingcheng);} if(tushuleibie==null||tushuleibie.equals("")){pmap.put("tushuleibie", null);}else{pmap.put("tushuleibie", tushuleibie);} if(kucun==null||kucun.equals("")){pmap.put("kucun", null);}else{pmap.put("kucun", kucun);} if(jieyueshuliang==null||jieyueshuliang.equals("")){pmap.put("jieyueshuliang", null);}else{pmap.put("jieyueshuliang", jieyueshuliang);} if(jieyueriqi==null||jieyueriqi.equals("")){pmap.put("jieyueriqi", null);}else{pmap.put("jieyueriqi", jieyueriqi);} if(guihuanshuliang1==null||guihuanshuliang1.equals("")){pmap.put("guihuanshuliang1", null);}else{pmap.put("guihuanshuliang1", guihuanshuliang1);} if(guihuanshuliang2==null||guihuanshuliang2.equals("")){pmap.put("guihuanshuliang2", null);}else{pmap.put("guihuanshuliang2", guihuanshuliang2);} if(duzhe==null||duzhe.equals("")){pmap.put("duzhe", null);}else{pmap.put("duzhe", duzhe);} if(shifouguihuan==null||shifouguihuan.equals("")){pmap.put("shifouguihuan", null);}else{pmap.put("shifouguihuan", shifouguihuan);} int total=guihuantushuService.getCount(pmap); pageBean.setTotal(total)