前两天遇到的 ,最后发现是数据库中属性名和idea中实体属性名不一致导致的
解决方案:
//查询所有
@Select("select * from users")
@Results(id = "users_data", value = {
//前面数据库的属性名称 后面实体类属性名称
@Result(column = "id", property = "id"),
@Result(column = "username",property ="username" ),
@Result(column = "password",property ="password" ),
@Result(column ="face_image" ,property ="faceImage" ),
@Result(column ="nick_name" ,property ="nickName" ),
@Result(column ="fans_counts" ,property ="fansCounts" ),
@Result(column ="follow_counts" ,property ="followCounts" ),
@Result(column ="receive_like_counts" ,property = "receiveLikeCounts"),
})
List<Users> selectAll();
实体中属性名字和数据库属性名字中在mapper中用result一一对应,申明了id="user_data",在其他查询中可以直接@ResultMap("users_data")
//根据用户的id查询所有信息
@Select("select * from users where id=#{id}")
@ResultMap("users_data")
Users QueryAllByUserId(String id);