mybatis 若查询中带有“_’命名的变量要使用 results

最新推荐文章于 2022-11-24 20:14:04 发布

ChunKitAu

最新推荐文章于 2022-11-24 20:14:04 发布

阅读量412

点赞数

本文链接：https://blog.csdn.net/ChunKitAu/article/details/101157110

版权

使用：

@Select("SELECT * FROM path where mac = #{mac}")
public List<Path> getPathByMac(String mac);

在这里插入图片描述
部分带 _ 的变量取值为空

使用：

@Select("SELECT * FROM path where mac = #{mac}")
//不使用的话部分返回值会为null
@Results({
    @Result(column = "id",property = "id"),
    @Result(column = "mac",property = "mac"),
    @Result(column = "start_x",property = "start_x"),
    @Result(column = "start_y",property = "start_y"),
    @Result(column = "end_x",property = "end_x"),
    @Result(column = "end_y",property = "end_y"),
    @Result(column = "start_time",property = "start_time"),
    @Result(column = "end_time",property = "end_time"),
})
public List<Path> getPathByMac(String mac);

数据获取成功
在这里插入图片描述