基于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.Zulinxinxi; import com.server.ZulinxinxiServer; import com.util.PageBean; import net.sf.json.JSONObject; import com.util.db; import java.sql.SQLException; import java.sql.*; @Controller public class ZulinxinxiController { @Resource private ZulinxinxiServer zulinxinxiService; @RequestMapping("addZulinxinxi.do") public String addZulinxinxi(HttpServletRequest request,Zulinxinxi zulinxinxi,HttpSession session) throws SQLException{ Timestamp time=new Timestamp(System.currentTimeMillis()); zulinxinxi.setAddtime(time.toString().substring(0, 19)); String sql=""; sql="update wupinxinxi set zhuangtai='出租' where wupinbianhao='"+zulinxinxi.getWupinbianhao()+"'"; db dbo = new db(); dbo.hsgexecute(sql); zulinxinxiService.add(zulinxinxi); session.setAttribute("backxx", "添加成功"); session.setAttribute("backurl", request.getHeader("Referer")); //session.setAttribute("backurl", "zulinxinxiList.do"); return "redirect:postback.jsp"; //return "redirect:zulinxinxiList.do"; } // 处理编辑 @RequestMapping("doUpdateZulinxinxi.do") public String doUpdateZulinxinxi(int id,ModelMap map,Zulinxinxi zulinxinxi){ zulinxinxi=zulinxinxiService.getById(id); map.put("zulinxinxi", zulinxinxi); return "zulinxinxi_updt"; } // 后台详细 @RequestMapping("zulinxinxiDetail.do") public String zulinxinxiDetail(int id,ModelMap map,Zulinxinxi zulinxinxi){ zulinxinxi=zulinxinxiService.getById(id); map.put("zulinxinxi", zulinxinxi); return "zulinxinxi_detail"; } // 前台详细 @RequestMapping("zlxxDetail.do") public String zlxxDetail(int id,ModelMap map,Zulinxinxi zulinxinxi){ zulinxinxi=zulinxinxiService.getById(id); map.put("zulinxinxi", zulinxinxi); return "zulinxinxidetail"; } // @RequestMapping("updateZulinxinxi.do") public String updateZulinxinxi(int id,ModelMap map,Zulinxinxi zulinxinxi,HttpServletRequest request,HttpSession session){ zulinxinxiService.update(zulinxinxi); session.setAttribute("backxx", "修改成功"); session.setAttribute("backurl", request.getHeader("Referer")); return "redirect:postback.jsp"; //String url = request.getHeader("Referer"); //return "redirect:"+url; //return "redirect:zulinxinxiList.do"; } // 分页查询 @RequestMapping("zulinxinxiList.do") public String zulinxinxiList(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Zulinxinxi zulinxinxi, String wupinbianhao, String wupinmingcheng, String leibie, String zujin, String zhuangtai, String chuzushijian1,String chuzushijian2, String chuzutianshu1,String chuzutianshu2, String chuzujine, String yonghuming, String xingming, String shenfenzheng, String shouji){ 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(wupinbianhao==null||wupinbianhao.equals("")){pmap.put("wupinbianhao", null);}else{pmap.put("wupinbianhao", wupinbianhao);} if(wupinmingcheng==null||wupinmingcheng.equals("")){pmap.put("wupinmingcheng", null);}else{pmap.put("wupinmingcheng", wupinmingcheng);} if(leibie==null||leibie.equals("")){pmap.put("leibie", null);}else{pmap.put("leibie", leibie);} if(zujin==null||zujin.equals("")){pmap.put("zujin", null);}else{pmap.put("zujin", zujin);} if(zhuangtai==null||zhuangtai.equals("")){pmap.put("zhuangtai", null);}else{pmap.put("zhuangtai", zhuangtai);} if(chuzushijian1==null||chuzushijian1.equals("")){pmap.put("chuzushijian1", null);}else{pmap.put("chuzushijian1", chuzushijian1);} if(chuzushijian2==null||chuzushijian2.equals("")){pmap.put("chuzushijian2", null);}else{pmap.put("chuzushijian2", chuzushijian2);} if(chuzutianshu1==null||chuzutianshu1.equals("")){pmap.put("chuzutianshu1", null);}else{pmap.put("chuzutianshu1", chuzutianshu1);} if(chuzutianshu2==null||chuzutianshu2.equals("")){pmap.put("chuzutianshu2", null);}else{pmap.put("chuzutianshu2", chuzutianshu2);} if(chuzujine==null||chuzujine.equals("")){pmap.put("chuzujine", null);}else{pmap.put("chuzujine", chuzujine);} if(yonghuming==null||yonghuming.equals("")){pmap.put("yonghuming", null);}else{pmap.put("yonghuming", yonghuming);} if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);} if(shenfenzheng==null||shenfenzheng.equals("")){pmap.put("shenfenzheng", null);}else{pmap.put("shenfenzheng", shenfenzheng);} if(shouji==null||shouji.equals("")){pmap.put("shouji", null);}else{pmap.put("shouji", shouji);} int total=zulinxinxiService.getCount(pmap); pageBean.setTotal(total); List<Zulinxinxi> list=zulinxinxiService.getByPage(pmap); map.put("page", pageBean); map.put("list", list); session.setAttribute("p", 1); return "zulinxinxi_list"; } @RequestMapping("zulinxinxi_yanben1.do") public String zulinxinxi_yanben1(@RequestParam(value="page",required=false)String page, ModelMap map,HttpSession session,Zulinxinxi zulinxinxi, String wupinbianhao, String wupinmingcheng, String leibie, String zujin, String zhuangtai, String chuzushijian1,String chuzushijian2, String chuzutianshu1,String chuzutianshu2, String chuzujine, String yonghuming, String xingming, String shenfenzheng, String shouji){ 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(wupinbianhao==null||wupinbianhao.equals("")){pmap.put("wupinbianhao", null);}else{pmap.put("wupinbianhao", wupinbianhao);} if(wupinmingcheng==null||wupinmingcheng.equals("")){pmap.put("wupinmingcheng", null);}else{pmap.put("wupinmingcheng", wupinmingcheng);} if(leibie==null||leibie.equals("")){pmap.put("leibie", null);}else{pmap.put("leibie", leibie);} if(zujin==null||zujin.equals("")){pmap.put("zujin", null);}else{pmap.put("zujin", zujin);} if(zhuangtai==null||zhuangtai.equals("")){pmap.put("zhuangtai", null);}else{pmap.put("zhuangtai", zhuangtai);} if(chuzushijian1==null||chuzushijian1.equals("")){pmap.put("chuzushijian1", null);}else{pmap.put("chuzushijian1", chuzushijian1);} if(chuzushijian2==null||chuzushijian2.equals("")){pmap.put("chuzushijian2", null);}else{pmap.put("chuzushijian2", chuzushijian2);} if(chuzutianshu1==null||chuzutianshu1.equals("")){pmap.put("chuzutianshu1", null);}else{pmap.put("chuzutianshu1", chuzutianshu1);} if(chuzutianshu2==null||chuzutianshu2.equals("")){pmap.put("chuzutianshu2", null);}else{pmap.put("chuzutianshu2", chuzutianshu2);} if(chuzujine==null||chuzujine.equals("")){pmap.put("chuzujine", null);}else{pmap.put("chuzujine", chuzujine);} if(yonghuming==null||yonghuming.equals("")){pmap.put("yonghuming", null);}else{pmap.put("yonghuming", yonghuming);} if(xingming==null||xingming.equals("")){pmap.put("xingming", null);}else{pmap.put("xingming", xingming);} if(shenfenzheng==null||shenfenzheng.equals("")){pmap.put("shenfenzheng", nul