spring+springmvc+mybatis搭建的一个典当系统附带mysql数据库

package com.gcl.controller; import java.io.IOException; import java.math.BigDecimal; import java.text.ParseException; import java.text.SimpleDateFormat; import java.util.ArrayList; import java.util.Date; import java.util.List; import javax.persistence.metamodel.SetAttribute; import net.sf.json.JSONArray; import net.sf.json.JSONObject; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import com.gcl.po.Auctioncompany; import com.gcl.po.Auctioneer; import com.gcl.po.Businessda; import com.gcl.po.Client; import com.gcl.po.Deadpawnagedispose; import com.gcl.po.Deadpawnagedisposedetail; import com.gcl.po.Deadpawnagedisposesaledetail; import com.gcl.po.Deadpawnagedisposeselldetail; import com.gcl.po.Pawn; import com.gcl.po.Pawndetail; import com.gcl.po.Pawntype; import com.gcl.po.Redeemdetail; import com.gcl.po.Renewalofpawn; import com.gcl.po.Renewalofpawndetai; import com.gcl.service.AuctioncompanyService; import com.gcl.service.AuctioneerService; import com.gcl.service.BusinessdaService; import com.gcl.service.ClientService; import com.gcl.service.DeadpawnageService; import com.gcl.service.PawnService; import com.gcl.service.PawndetailService; import com.gcl.service.PawntypeService; import com.gcl.service.PawntypedetailService; import com.gcl.service.RedeemdetailService; import com.gcl.service.RenewalofpawnService; import com.gcl.util.DateUtil; import com.gcl.util.enums.CertificateType; import com.gcl.util.enums.ClientType; import com.gcl.util.enums.Pawnstate; import com.gcl.util.query.Page; import com.gcl.vo.Deadpawnagegoodsvo; import com.gcl.vo.Deadpawndetailvo; import com.gcl.vo.Deadpawnselectvo; import com.gcl.vo.Deadpawnvo; /** * 绝当处置 * * @author 崇良 * */ @Controller @RequestMapping("deadpawnage") public class DeadpawnageController extends baseController { @Autowired private DeadpawnageService deadpawnageService; @Autowired private PawndetailService pawndetailService; @Autowired private PawnService pawnService; @Autowired private RenewalofpawnService renewalofpawnService; @Autowired private BusinessdaService businessdaService; @Autowired private ClientService clientService; @Autowired private AuctioncompanyService auctioncompanyService; @Autowired private AuctioneerService auctioneerService; @Autowired private PawntypedetailService pawntypedetailService; // =============绝当处置开始================= // 绝当处置 @RequestMapping("deadpawnagehandle") public String deadpawnagehandle(String pawnnumber, String pawnname, String papersnumber, String clientname, String beginDate, String endDate, String pawnmoneygtstr, String pawnmoneyltstr, String selectidgather, String deadpawnid, String operatetype, String updateing) throws ParseException { DateUtil dateUtil = new DateUtil(); if ("".equals(pawnnumber)) { pawnnumber = null; } if ("".equals(pawnname)) { pawnname = null; } if ("".equals(papersnumber)) { papersnumber = null; } if ("".equals(clientname)) { clientname = null; } if ("".equals(beginDate)) { beginDate = null; } if ("".equals(endDate)) { endDate = null; } if (pawnmoneygtstr == null || "".equals(pawnmoneygtstr)) { pawnmoneygtstr = "0"; } if (pawnmoneyltstr == null || "".equals(pawnmoneyltstr)) { pawnmoneyltstr = "0"; } if ("".equals(deadpawnid)) { deadpawnid = null; } if ("".equals(operatetype)) { operatetype = null; } // deadpawnid不为空证明是修改操作 =========开始 if (deadpawnid != null && !"".equals(deadpawnid)) { if (operatetype != null && !"".equals(operatetype)) { request.setAttribute("deadpawnid", deadpawnid); request.setAttribute("operatetype", operatetype); // 执行修改操作 Deadpawnagedisposedetail deadpawnagedisposedetail = this.deadpawnageService .selectdeadpawnagedisposedetaiByPrimaryKey(Integer .parseInt(deadpawnid)); Deadpawnagedispose deadpawnagedispose = this.deadpawnageService .selectDeadpawnagedisposeByPrimaryKey(deadpawnagedisposedetail .getDeadpawnagedisposeid()); request.setAttribute("deadpawnagedispose", deadpawnagedispose); if ("1".equals(deadpawnagedispose.getDisposeway())) { Deadpawnagedisposeselldetail deadpawnagedisposeselldetail = this.deadpawnageService .selectDeadpawnagedisposeselldetailByPrimaryKey(deadpawnagedispose .getId()); Client client = this.clientService .findbyid(deadpawnagedisposeselldetail .getClientid()); client.setPapersnameid(CertificateType.valueOf( client.getPapersnameid()).getLabel()); request.setAttribute("deadpawnagedisposeselldetail", deadpawnagedisposeselldetail); request.setAttribute("client", client); } else if ("2".equals(deadpawnagedispose.getDisposeway())) { Deadpawnagedisposesaledetail deadpawnagedisposesaledetail = this.deadpawnageService .findalldeadpawnagedisposesaledetailbydeadpawnagedisposesaleid(deadpawnagedispose .getId()); Auctioncompany auctioncompany = this.auctioncompanyService .findbyid(deadpawnagedisposesaledetail .getAuctioncompanyid()); Auctioneer auctioneer = this.auctioneerService .findbyid(deadpawnagedisposesaledetail .getAuctioneerid()); request.setAttribute("deadpawnagedisposesaledetail", deadpawnagedisposesaledetail); request.setAttribute("auctioncompany", auctioncompany); request.setAttribute("auctioneer", auctioneer); } if ("updateing".equals(updateing)) { List<Deadpawnagedisposedetail> deadpawnagedisposedetails = this.deadpawnageService .findallbydeadpawnagedisposeid(deadpawnagedispose .getId()); for (Deadpawnagedisposedetail deadpawnagedisposedetail2 : deadpawnagedisposedetails) { if (selectidgather == null || "".equals(selectidgather)) { selectidgather = ""; selectidgather = deadpawnagedisposedetail2 .getPawndetailid().toString(); } else { selectidgather = selectidgather + "," + deadpawnagedisposedetail2 .getPawndetailid(); } } } } } // deadpawnid不为空证明是修改操作 =========结束 String currentpageString = request.getParameter("currentPage"); if (currentpageString == null || "".equals(currentpageString)) { currentpageString = "1"; } Page<Deadpawnvo> query = new Page<Deadpawnvo>(); query.setCurrentPage(Integer.parseInt(currentpageString)); query.setPageSize(8); BigDecimal pawnmoneygt = new BigDecimal(pawnmoneygtstr); BigDecimal pawnmoneylt = new BigDecimal(pawnmoneyltstr); Page<Deadpawnvo> page = this.deadpawnageService.queryPage(query, pawnnumber, pawnname, papersnumber, clientname, beginDate, endDate, pawnmoneygt, pawnmoneylt); for (Deadpawnvo deadpawnvo : page.result) { deadpawnvo.setPapersnameid(CertificateType.valueOf( deadpawnvo.getPapersnameid()).getLabel()); deadpawnvo.setRemark(dateUtil.daysBetween(deadpawnvo.getEnddate(), new Date()) + "天"); } if (selectidgather != null && !"".equals(selectidgather)) { List<Deadpawndetailvo> deadpawndetailvos = new ArrayList<Deadpawndetailvo>(); String[] ids = selectidgather.split(","); for (String id : ids) { List<Deadpawndetailvo> deadpawndetailvostwo = data(id); for (Deadpawndetailvo deadpawndetailvo : deadpawndetailvostwo) { deadpawndetailvos.add(deadpawndetailvo); } } request.setAttribute("deadpawndetailvos", deadpawndetailvos); request.setAttribute("selectidgather", selectidgather); } request.setAttribute("page", page); returnparameter(pawnnumber, pawnname, pa