SpringBoot 通用mapper selectByPrimaryKey Bug记录

 

https://github.com/abel533/Mapper/wiki/3.config   通用mapper config配置

 

1.不加@Id

找不到查询的主键

SELECT id,user_name,password,name,age,sex,birthday,created,updated,note FROM tb_user WHERE id = ? AND user_name = ? AND password = ? AND name = ? AND age = ? AND sex = ? AND birthday = ? AND created = ? AND updated = ? AND note = ?

2.@加上主键栏位名字确定查询的参数栏位(在实体类pojo包中)

SELECT id,user_name,password,name,age,sex,birthday,created,updated,note FROM tb_user WHERE id = ?