2021.8.31
从25号开始练习复杂的mybatis多对多,从设计数据库思路到实现需求功能转移到实体项目中
1.之前很少看过字符转换的详细内容从今往后会注意字符串转换此项目为转数组(date)实体项目会有UUID生成的字符串
2.在添加时如果原表设计的首个id是自动增长的,在xml中要设置是否使用jdbc的getGenerateKeys方法获取主键并赋值到keyProperty设置的主键字段中将要插入字段对应的生成的id抽出来
3.@service中如果中间表角色id不想用逗号的形式要做循环插入数据
4.修改多表连接的中间表 因为是1-2 2-3的形式不能做修改只能删除干净后重新插入新数据
表结构
实体类Entity—user
package com.example.unicom.entity;
import lombok.Data;
@Data
public class User {
private Integer id;
private String name;
private String phone;
private Integer age;
private String sex;
private String date;
private String name1;
private String js_id;
}
Entity—js(死表)
package com.example.unicom.entity;
import lombok.Data;
@Data
public class Js {
private Integer id;
private String name;
private String date;
}
Entity—user_role
package com.example.unicom.entity;
import lombok.Data;
@Data
public class UserJs {
private Integer id;
private Integer id1;
private Integer user_id;
private String js_id;
}
UsrtController
package com.example.unicom.controller;
import com.example.unicom.entity.User;
import com.example.unicom.entity.base.GeneralResponse;
import com.example.unicom.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestBody;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
/**
* @author 孙翊轩
* @since 2021-08-25
*/
@RestController
@RequestMapping("/isp/unicom/user")
public class UserController {
@Autowired
private UserService userService;
// @Autowired
// private UserJsService userJsService;
@RequestMapping(value = "selectUser",method = RequestMethod.GET)
public GeneralResponse selectUser(){
try{
List<User>userList=userService.selectUser();
return new GeneralResponse("SUCCESS","查询成功",userList);
}catch (