与吴聪聪老师的tk.mybatis类似,insert时,不需要手写返回主键id,controller层insert的商品就有了数据库对应的id
// 添加商品@PostMapping("/upload")public String upload(Product product, @RequestParam("imgs") CommonsMultipartFile img, HttpServletRequest req)throws IllegalStateException, IOException {String uuid = UUID.randomUUID().toString();String uploadDire = PropertiesUtil.getkey("upload.dir");// 文件存放的路径// System.out.println("uploadDire=" + uploadDire);String productimg = uuid + "-" + img.getOriginalFilename();// System.out.println("productimg=" + productimg);String imgdest = uploadDire + productimg;// System.out.println("imgdesrt=" + imgdest);img.transferTo(new File(imgdest));product.setImg(productimg);product.setCreatetime(new Date());String token = super.getCookieVal(req, "token");System.out.println("token=" + token);// 根据request拿到当前useridSysUser sysUser = JwtUtils.getObject(token, SysUser.class);System.out.println("sysUser.id=" + sysUser.getId());product.setUserid(sysUser.getId());int i = productService.insertProduct(product);// 添加商品System.out.println("商品添加返回的id" + product.getId());//为每一个insert的商品开辟一个roomRoom room = new Room();room.setCreatetime(product.getCreatetime());room.setEndtime(product.getEndtime());room.setProductid(product.getId());room.setState(1);roomService.insertRoom(room);System.out.println("room添加返回的id" + room.getId());return "redirect:/moon/Product/selectProductByid?id=" + product.getId();}
public int insertRoom(Room room) {return roomMapper.insert(room);}// 修改public int updateProduct(Product product) {return productMapper.updateByPrimaryKey(product);}
