SSH教务系统源码(含数据库脚本).zip

package com.kzfire.portal.action.user; import java.util.ArrayList; import java.util.List; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import com.kzfire.portal.dao.AllusersDao; import com.kzfire.portal.entiy.Allusers; import com.kzfire.portal.entiy.Kefangxinxi; import com.kzfire.portal.entiy.Kehuxinxi; import com.kzfire.portal.entiy.Liuyanban; import com.kzfire.portal.entiy.Ruzhujilu; import com.kzfire.portal.entiy.Xiaofeijilu; import com.kzfire.portal.service.AllusersService; import com.kzfire.portal.service.KefangxinxiService; import com.kzfire.portal.service.KehuxinxiService; import com.kzfire.portal.service.LiuyanbanService; import com.kzfire.portal.service.RuzhujiluService; import com.kzfire.portal.service.XiaofeijiluService; @Controller @RequestMapping("/user/user") public class UserAction { @Autowired private AllusersService allusersservice; @Autowired private KefangxinxiService kefangxinxiService; @Autowired private KehuxinxiService kehuxinxiservice; @Autowired private RuzhujiluService ruzhujiluservice; @Autowired private XiaofeijiluService xiaofeijiluservice; @Autowired private LiuyanbanService liuyanbanservice; protected final static String VIEW = "WEB-INF/page/"; @RequestMapping("/Iteminfo_add") public String Iteminfo_add() throws Exception { return "Iteminfo_add"; } @RequestMapping("/Iteminfo_add_post") public String Iteminfo_add_post(Model model, HttpServletRequest request, HttpServletResponse response) throws Exception { String bianhao=request.getParameter("bianhao"); String leixing=request.getParameter("leixing"); String daxiao= ""; String jiage=request.getParameter("jiage"); String tupian=request.getParameter("tupian"); String zhuangtai=request.getParameter("zhuangtai"); Kefangxinxi kefangxinxi=new Kefangxinxi(); kefangxinxi.setBianhao(bianhao); kefangxinxi.setLeixing(leixing); kefangxinxi.setDaxiao(daxiao); kefangxinxi.setJiage(jiage); kefangxinxi.setTupian(tupian); kefangxinxi.setZhuangtai(zhuangtai); kefangxinxiService.insert(kefangxinxi); request.setAttribute("message_login", "添加成功!!"); return "Iteminfo_add"; } @RequestMapping("/Iteminfo_list") public String Iteminfo_list(Model model, HttpServletRequest request, HttpServletResponse response) throws Exception { int curpage = 1;//当前页 int page_record = 10;//每页显示的记录数 int zgs = 0; int zys = 0; //用下面的方法（sql查询完成，速度快） String hsgnpage = request.getParameter("page"); Kefangxinxi Kefangxinxi=new Kefangxinxi(); List<Kefangxinxi> kefangxinxilist=new ArrayList<Kefangxinxi>(); kefangxinxilist=kefangxinxiService.findAll(Kefangxinxi); for (int i=0;i<kefangxinxilist.size();i++) { zgs = kefangxinxilist.size(); if ((zgs % page_record) == 0) { zys = zgs / page_record; } else { zys = zgs / page_record + 1; } } if (hsgnpage != null) { curpage = Integer.parseInt(request.getParameter("page"));//获取传递的值，需要显示的页 } else { curpage = 1; } if (curpage == 0) { curpage = 1; } if (curpage > zys) { curpage = zys; } if (request.getParameter("bianhao") == "" || request.getParameter("bianhao") == null) { } else { Kefangxinxi.setBianhao(request.getParameter("bianhao")); } if (request.getParameter("leixing") == "所有" || request.getParameter("leixing") == null) { } else { Kefangxinxi.setLeixing(request.getParameter("leixing")); } if (request.getParameter("zhuangtai") == "所有" || request.getParameter("zhuangtai") == null) { } else { Kefangxinxi.setZhuangtai(request.getParameter("zhuangtai")); } kefangxinxilist=kefangxinxiService.findAll(Kefangxinxi); model.addAttribute("kefangxinxis",kefangxinxilist); model.addAttribute("page_record",page_record); model.addAttribute("zgs",zgs); model.addAttribute("size",kefangxinxilist.size()); model.addAttribute("curpage",curpage); return "Iteminfo_list"; } @RequestMapping("/Iteminfo_updt") public String Iteminfo_updt(Model model,HttpServletRequest request,HttpServletResponse response) { String id=request.getParameter("id"); Kefangxinxi Kefangxinxi=new Kefangxinxi(); Kefangxinxi.setId(Integer.parseInt(id)); List<Kefangxinxi> kefangxinxilist=new ArrayList<Kefangxinxi>(); kefangxinxilist=kefangxinxiService.findAll(Kefangxinxi); if(kefangxinxilist !=null && kefangxinxilist.size() >0){ model.addAttribute("size", kefangxinxilist.size()); model.addAttribute("kefangxinxi",kefangxinxilist.get(0)); }else{ return "Iteminfo_list"; } return "Iteminfo_updt"; } @RequestMapping("/Iteminfo_updt_post") public String Iteminfo_updt_post(Model model,HttpServletRequest request,HttpServletResponse response) { System.out.println("<<<<<<<<<<<<<Iteminfo_updt_post>>>>>>>>>>>>>"); String bianhao=request.getParameter("bianhao"); String leixing=request.getParameter("leixing"); String daxiao=""; String jiage=request.getParameter("jiage"); String tupian=request.getParameter("tupian"); String zhuangtai=request.getParameter("zhuangtai"); String id=request.getParameter("id"); Kefangxinxi Kefangxinxi=new Kefangxinxi(); Kefangxinxi.setId(Integer.parseInt(id)); Kefangxinxi.setBianhao(bianhao); Kefangxinxi.setLeixing(leixing); Kefangxinxi.setDaxiao(daxiao); Kefangxinxi.setJiage(jiage); Kefangxinxi.setTupian(tupian); Kefangxinxi.setZhuangtai(zhuangtai); kefangxinxiService.update(Kefangxinxi); Kefangxinxi=new Kefangxinxi(); List<Kefangxinxi> kefangxinxilist=new ArrayList<Kefangxinxi>(); kefangxinxilist=kefangxinxiService.findAll(Kefangxinxi); model.addAttribute("size", kefangxinxilist.size()); model.addAttribute("kefangxinxis",kefangxinxilist); return "Iteminfo_list"; } @RequestMapping("/Iteminfo_list2") public String Iteminfo_list2(Model model,HttpServletRequest request,HttpServletResponse response) { Kefangxinxi Kefangxinxi=new Kefangxinxi(); if (request.getParameter("bianhao") == "" || request.getParameter("bianhao") == null) { } else { Kefangxinxi.setBianhao(request.getParameter("bianhao")); } if (request.getParameter("leixing") == "所有" || request.getParameter("leixing") == null) { } else { Kefangxinxi.setLeixing(request.getParameter("leixing")); } if (request.getParameter("zhuangtai") == "所有" || request.getParameter("zhuangtai") == null) { } else { Kefangxinxi.setZhuangtai(request.getParameter("zhuangtai")); } List<Kefangxinxi> kefangxinxilist=new ArrayList<Kefangxinxi>(); kefangxinxilist=kefangxinxiService.findAll(Kefangxinxi); model.addAttribute("size", kefangxinxilist.size()); model.addAttribute("kefangxinxis",kefangxinxilist); return "Iteminfo_list2"; } @RequestMapping("/del") public String del(Model model,HttpServletRequest request,HttpServletResponse response) { int id=Integer.parseInt(request.getParameter("id")); String tablename=request.getParameter("tablename"); if("kefangxinxi".equals(tablename)){ Kefangxinxi Kefangxinxi=new Kefangxinxi(); Kefangxinxi.setId(id); kefangxinxiService.delete(Kefangxinxi); Kefangxinxi=new Kefangxinxi(); List<Kefangxinxi> kefangxinxilist=new ArrayList<Kefangxinxi>(); kefangxinxilist=kefangxinxiService.findAll(Kefangxinxi); model.addAttribute("size", kefangxinxilist.size()); model.addAttribute("kefangxinxis",kefangxinxilist); return "Itemin