SSM(Spring+SpringMvc+Mybatis)图片上传保存到数据库与回显+sql

package cn.cet.controller; import java.io.File; import java.io.IOException; import java.util.List; import java.util.UUID; import org.apache.commons.lang3.StringUtils; import org.springframework.stereotype.Controller; import org.springframework.ui.ModelMap; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.multipart.MultipartFile; import cn.cet.doman.PasswordUtils; import cn.cet.entity.User; @Controller("UserController") @RequestMapping(UserController.LOCATION) public class UserController extends BaseController { public static final String LOCATION ="/UserController"; public static final String USER_LIST="/user/user_list"; public static final String ADD_PAGE="/user/add"; public static final String UPDATE_USER="/user/update"; /** * 获得所有用户 * @param map * @return */ @RequestMapping(value="allUser") public String getAllUser(ModelMap map){ List<User> item=userService.getAllUser(); map.put("user_list",item ); return USER_LIST; } /** * 查询所有 * 跳往列表展示页 * @param map * @param user * @return */ @RequestMapping(value="allUsers") public String getUsers(ModelMap map,User user,String page){ //参数验证：user,page 备注：StringUtils.isNotBlank()是非空吗？/StringUtils.isBlank()是空吗？ //判断判断是否为null 或"" 去空格比较 if(StringUtils.isBlank(user.getUsername())){ //给出提示 user.setUsername(null); } User user1 =new User(); //增加分页： if(page!=null &&!"".equals(page)){ user.setPage(Integer.parseInt(page)); }else{ user.setPage(1); } //分页参数设置 int totalCount=userService.getCount(user);// user1.setTotalCount(totalCount); user1.setPageList(user.getPageList()); user1.setRows(3); //将条件u1参数 传递给user if(user!=null){ user.setId(user.getId()); user.setUsername(user.getUsername()); } //查询 List<User> userList=userService.getUsers(user1); //传入map map.put("userList", userList); map.put("user", user1); return USER_LIST; } /** * 跳往新增页面 * @return */ @RequestMapping(value="addPage") public String addUserPage(){ return ADD_PAGE; } /** * 新增用户 * @return * @throws IOException * @throws IllegalStateException */ @RequestMapping(value="addUser") public String addUser(User user,ModelMap map,MultipartFile file) throws IllegalStateException, IOException{ //controller中编写：上传处理的关键代码 //原始文件名称 String filename =file.getOriginalFilename(); //性名称 String newFileName=UUID.randomUUID().toString() +filename.substring(filename.lastIndexOf(".")); //上传图片 File uploadPic=new File("d:/upload/"+newFileName); if(!uploadPic.exists()){ uploadPic.mkdirs(); } //向磁盘写入文件 file.transferTo(uploadPic); //将图片的路径保存到user对象中 user.setImageUrl("/file/"+newFileName); //密码加密 user.setPassword(PasswordUtils.encryptPassword(user.getPassword(), user.getUsername())); int count=userService.addUser(user); if(count>0){ map.put("success","新增成功！"); return "redirect:/UserController/allUser"; }else{ map.put("error", "新增失败！"); return "redirect:/UserController/allUser"; } } /** * 删除用户 * @param id * @param map * @return */ @RequestMapping(value="deleteUser") public String deleteUser(Long id,ModelMap map){ int count=0; count=userService.deleteUser(id); if(count>0){ map.put("success","删除成功！"); return "redirect:/UserController/allUser"; }else{ map.put("error", "新增失败！"); return "redirect:/UserController/allUser"; } } /** * 根据id查询用户跳往修改界面 * @param id * @param map * @return */ @RequestMapping(value="updatePage") public String updatePage(Long id,ModelMap map){ User user=userService.getUserById(id); if(user!=null){ map.put("user",user); return UPDATE_USER; }else{ return "error"; } } /** * 修改用户 * @param user * @param map * @return */ @RequestMapping(value="updateUser") public String updateUser(User user ,ModelMap map){ int count=0; count=userService.updateUser(user); if(count>0){ map.put("success","修改成功！"); return "redirect:/UserController/allUser"; }else{ map.put("error","修改失败！"); return "redirect:/UserController/allUser"; } } }