技巧速记SSM上传照片至数据库存储#mysql存照片#ssm上传照片

package com.photo.controller; import com.photo.dao.UserMapper; import com.photo.pojo.User; import com.photo.service.UserService; import org.apache.xmlbeans.impl.xb.xsdschema.Public; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.beans.factory.annotation.Qualifier; 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.IOException; import java.util.Base64; @Controller public class UserController { @Autowired UserService userService; @Qualifier("userMapper") @Autowired private UserMapper userMapper; //1登录界面---登录功能----------------------------------------------------------------------------------------------- // box的作用是防止初次访问页面时直接提示"请填写用户名和密码" @RequestMapping("/login") public String login( @RequestParam(name = "id", required = false) Integer id, @RequestParam(name = "password", required = false) String password, @RequestParam(name ="box",required = false) String box, Model model) { String errorMessage = null; if (id != null && password != null ) { User user = userService.findUser(id, password); if (user == null) { errorMessage = "用户名或密码不合法"; }else { userService.updateLoginUser(id); return "redirect:main"; } }else if(box != null){ errorMessage = "请填写用户名和密码"; } model.addAttribute("errorMessage", errorMessage); return "login"; } @GetMapping("/main") public String loginSuccess(Model model) { User user0 = userMapper.findById(888888); User userXXX = userMapper.findById(Integer.parseInt(user0.getName())); //照片获取 if (userXXX != null && userXXX.getAvatar() != null) { // 将头像数据以字节数组的形式传递给 JSP 页面 // 注意：在 JSP 页面中显示图片时，您可能需要将字节数组转换为 Base64 编码的字符串 String avatarBase64 = Base64.getEncoder().encodeToString(userXXX.getAvatar()); model.addAttribute("avatarBase64", avatarBase64); } else { // 处理用户不存在或头像为空的情况 model.addAttribute("avatar", null); } model.addAttribute("userXXX", userXXX); return "main"; // Return the success page view name } //2注册界面---注册功能----------------------------------------------------------------------------------------------- @GetMapping("/register") public String showRegistrationForm(Model model) { model.addAttribute("user", new User()); return "register"; } @PostMapping("/register") public String registerUser(@ModelAttribute("user") User user, Model model) { if (user.getId() == null || user.getPassword() == null || user.getName() == null || user.getId().toString().isEmpty() || user.getPassword().isEmpty() || user.getName().isEmpty()) { // 信息校验不为空 model.addAttribute("error", "请将信息补充完整"); return "register"; } boolean registrationSuccess = userService.register(user); if (registrationSuccess) { model.addAttribute("error", "注册已成功"); return "register"; } else { model.addAttribute("error", "用户已存在"); return "register"; } } //密码修改界面---修改功能------------------------------------------------------------------------------------------- @GetMapping("/updatePassword") public String showRegistrationForm2(Model model) { model.addAttribute("user", new User()); return "forgotPassword"; } @PostMapping("/updatePassword") public String registerUser2(@ModelAttribute("user") User user, Model model) { if (user.getId() == null || user.getPassword() == null || user.getName() == null || user.getId().toString().isEmpty() || user.getPassword().isEmpty() || user.getName().isEmpty()) { // 信息校验不为空 model.addAttribute("error", "请将信息补充完整"); return "forgotPassword"; } boolean registrationSuccess = userService.updateUser(user); if (registrationSuccess) { model.addAttribute("error", "修改成功"); return "forgotPassword"; } else { model.addAttribute("error", "信息错误"); return "forgotPassword"; } } //主界面---获取用户信息--- // 测试照片显示与上传------------------------------------------------------------------------------------------------------------------------------ @RequestMapping(value = "/user/avatar/{id}", method = RequestMethod.GET) public String getUserAvatar(@PathVariable int id, Model model) { User user = userService.getUserById(id); // 或者直接调用 userMapper.getUserById(id) if (user != null && user.getAvatar() != null) { // 将头像数据以字节数组的形式传递给 JSP 页面 // 注意：在 JSP 页面中显示图片时，您可能需要将字节数组转换为 Base64 编码的字符串 String avatarBase64 = Base64.getEncoder().encodeToString(user.getAvatar()); model.addAttribute("avatarBase64", avatarBase64); } else { // 处理用户不存在或头像为空的情况 model.addAttribute("avatar", null); } // 返回 JSP 页面的名称 return "userAvatar"; } //上传头像 @PostMapping("/uploadAvatar") public String uploadAvatar(@RequestParam("avatarFile") MultipartFile avatarFile, @RequestParam("id") Integer id, Model model) { try { // 验证文件类型和大小（可选） if (!avatarFile.isEmpty() && avatarFile.getContentType().startsWith("image/")) { byte[] avatarBytes = avatarFile.getBytes(); userService.updateAvatar(id, avatarBytes); model.addAttribute("message", "头像上传成功！"); } else { model.addAttribute("message", "请上传一个有效的图片文件！"); } } catch (IOException e) { e.printStackTrace(); model.addAttribute("message", "头像上传失败，请重试！"); } return "uploadResult"; // 跳转到结果页面 } }