按照視頻教程,運行測試類報錯
@Data
public?class?User
{
????private?Long?id;
????private?String?name;
????private?Integer?age;
????private?String?email;
????private?Long?managerid;
????private?LocalDateTime?createTime;
}
###?Cause:?java.sql.SQLSyntaxErrorException:?Unknown?column?'managerid'?in?'field?list';?bad?SQL?grammar?[];?nested?exception?is?java.sql.SQLSyntaxErrorException:?Unknown?column?'managerid'?in?'field?list'
managerid字段不存在。
修改user類的可以成功運行但manager_id全部為null
@Data
public?class?User
{
????private?Long?id;
????private?String?name;
????private?Integer?age;
????private?String?email;
????private?Long?manager_id;
????private?LocalDateTime?createTime;
}
User(id=1087982257332887553,?name=大boss,?age=40,?email=boss@baomidou.com,?manager_id=null,?createTime=2019-01-11T14:20:20)User(id=1088248166370832385,?name=王天風(fēng),?age=25,?email=wtf@baomidou.com,?manager_id=null,?createTime=2019-02-05T11:12:22)User(id=1088250446457389058,?name=李藝偉,?age=28,?email=lyw@baomidou.com,?manager_id=null,?createTime=2019-02-14T08:31:16)User(id=1094590409767661570,?name=張雨琪,?age=31,?email=zjq@baomidou.com,?manager_id=null,?createTime=2019-01-14T09:15:15)User(id=1094592041087729666,?name=劉紅雨,?age=32,?email=lhm@baomidou.com,?manager_id=null,?createTime=2019-01-14T09:48:16)
2021-10-07
2021-08-13
MyBatis遵循的是駝峰命名法,把i改成大寫就可以了