Java实战项目-基于springboot和jsp的超市管理系统 （源码+数据库）

package cn.smbms.controller.user; import javax.annotation.Resource; import javax.servlet.http.HttpServlet; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpSession; import cn.smbms.pojo.Role; import cn.smbms.pojo.User; import cn.smbms.service.role.RoleService1; import cn.smbms.service.user.UserService1; import com.github.pagehelper.PageHelper; import com.github.pagehelper.PageInfo; import com.mysql.jdbc.StringUtils; import org.apache.commons.io.FilenameUtils; import org.apache.commons.lang.math.RandomUtils; import org.apache.log4j.Logger; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.*; import org.springframework.web.multipart.MultipartFile; import java.io.File; import java.lang.annotation.ElementType; import java.lang.annotation.Retention; import java.lang.annotation.RetentionPolicy; import java.lang.annotation.Target; import java.util.Date; import java.util.HashMap; import java.util.List; import static cn.smbms.tools.Constants.USER_SESSION; @Controller @RequestMapping("/user") /*@Target({ElementType.METHOD})// 可用在方法名上 @Retention(RetentionPolicy.RUNTIME)// 运行时有效*/ public class UserController extends HttpServlet { private Logger logger=Logger.getLogger(UserController.class); @Resource private UserService1 userService; @Resource private RoleService1 roleSerivece; /** * 跳转到登录页面 */ @RequestMapping(value = "/login.html") public String login(){ return "login"; } /** * 实现登录 */ @RequestMapping(value = "/dologin.html",method = RequestMethod.POST) public String doLogin(@RequestParam String userCode , @RequestParam String userPassword , HttpSession session, HttpServletRequest request) throws Exception { //调用service方法，进行用户匹配 User user= userService.login(userCode,userPassword);//匹配账号 if(null != user){ //匹配密码 if(!user.getUserPassword().equals(userPassword)) { request.setAttribute("error","密码不正确!"); return "login"; } //页面跳转（frame.jsp） session.setAttribute(USER_SESSION,user);//放入session第二种方式 return "redirect:/user/main.html";//重定向 }else{ //页面跳转带出提示信息 request.setAttribute("error","用户名不正确!"); return "login"; /*throw new RuntimeException("用户名或密码不正确!");*/ } } //判断session是否为空 @RequestMapping(value = "/main.html") public String main(HttpSession session){ if(null == session.getAttribute("userSession")){ return "redirect:/user/login.html"; } return "frame"; } /** * 注销 */ @RequestMapping("/closelogin") public String closeLogin(HttpSession session){ session.removeAttribute("userSession"); return "redirect:/user/login.html"; } /** * 查询用户列表 */ @RequestMapping("/userlist.html") public String getUserList(Model model, @RequestParam (value = "queryname",required = false) String queryUserName, @RequestParam (value = "queryUserRole",required = false) String queryUserRole, @RequestParam (value = "pageIndex",required = false,defaultValue = "1")String pageIndex) throws Exception { int _queryUserRole = 0; List<User> userList=null; if(queryUserName == null){ queryUserName=""; } if(queryUserRole !=null && !queryUserRole.equals("")){ _queryUserRole = Integer.parseInt(queryUserRole); } //获得分页对象 参数：页数+每页的大小 PageHelper.startPage(Integer.parseInt(pageIndex),5); //获得查询的所有供应商数据 userList = userService.getUserList(queryUserName,_queryUserRole); //获得PageInfo对象 PageInfo<User> pageInfo = new PageInfo<User>(userList); //总共多少页 model.addAttribute("totalCount",pageInfo.getPages()); //获得总记录数 model.addAttribute("totalPageCount",pageInfo.getTotal()); //第几页 model.addAttribute("pageIndex",pageInfo.getPageNum()); model.addAttribute("userList", userList); List<Role> roleList=null; roleList=roleSerivece.getRoleList(); model.addAttribute("roleList", roleList); model.addAttribute("queryUserName", queryUserName); model.addAttribute("queryUserRole", queryUserRole); return "userlist"; } //处理sysError方法 @RequestMapping("syserror.html") public String sysError(){ return "syserror"; } /** *跳转增加用户页面 */ @RequestMapping(value = "/useradd.html",method = RequestMethod.GET) public String addUser(){ return "useradd"; } /** * 新增保存用户 */ @RequestMapping(value = "/addsave.html",method = RequestMethod.POST) public String addUserSave(User user, HttpSession session, HttpServletRequest request, @RequestParam (value = "a_idPicPath",required = false)MultipartFile attach) throws Exception { String idPicPath=null; //判断文件是否是空 if(!attach.isEmpty()){ String path=request.getSession().getServletContext().getRealPath("statics"+ File.separator+"uploadfiles"); String odlFileName=attach.getOriginalFilename();//原文件名 String prefix= FilenameUtils.getExtension(odlFileName);//原文件后缀 int filesize=500000; if(attach.getSize()>filesize){//上传大小不得超过500k request.setAttribute("uploadFileError"," * 上传文件大小不得超过500KB"); return "useradd"; }else if(prefix.equalsIgnoreCase("jpg") ||prefix.equalsIgnoreCase("png") ||prefix.equalsIgnoreCase("jpeg") ||prefix.equalsIgnoreCase("pneg")){//判断上传图片格式正确 String fileName=System.currentTimeMillis()+ RandomUtils.nextInt(1000000)+"_Personal.jpg"; File targetFile=new File(path,fileName); if(!targetFile.exists()){ targetFile.mkdirs(); } //保存 try { attach.transferTo(targetFile); }catch (Exception e){ e.printStackTrace(); request.setAttribute("uploadFileError"," * 上传失败！"); return "useradd"; } idPicPath=path+File.separator+fileName; }else{ request.setAttribute("uploadFileError"," * 上传图片格式不正确"); return "useradd"; } } user.setCreatedBy(((User)session.getAttribute(USER_SESSION)).getId()); user.setCreationDate(new Date()); user.setIdPicPath(idPicPath); if(userService.add(user)){ return "redirect:/user/userlist.html"; } return "useradd"; } /** * 用户验证 */ @RequestMapping(value = "/ucexist.html",method = RequestMethod.GET) @ResponseBody public Object userCodeIsExit(@RequestParam String userCode) throws Exception { HashMap<String, String> resultMap = new HashMap<String, String>(); if(StringUtils.isNullOrEmpty(userCode)){ resultMap.put("userCode","exist"); }else{ User user =userService.selectUserCodeExist(userCode); if(null!=user) { resultMap.put("userCode","exist"); } else { resultMap.put("userCode","noexist"); } } return resultMap; } /** * 加载绑定用户角色 */ @RequestMapping(value = "userrole",method = RequestMethod.GET,produces="application/json;charset=UTF-8") @ResponseBody public Object getUserRole() throws Exception { List<Role> roleList= roleSerivece.getRoleList(); return roleList; } /** * 跳转修改用户页面 */ @RequestMapping(value = "/usermodify.html",method = RequestMethod.GET) public String getUserById(@RequestParam String uid,Model model) throws Exception { int uid1=Integer.parseInt(uid); User user = userService.getUserById(uid1); model.addAttribute(user); return "usermodify"; } /** * 保存修改用户信息 */ @RequestMapping(value = "/usermodifysave.html",method = RequestMethod.POST) public String modifyUserSave(User user,HttpSession session) throws Exception { user.setModifyBy(((User)session.getAttribute(USER_SESSION)).getId()); user.setModifyDate(new Date()); if(userServic