Mybatis级联查询对象为null

最新推荐文章于 2024-01-08 02:18:59 发布

乱舞小心情

最新推荐文章于 2024-01-08 02:18:59 发布

阅读量1.9k

点赞数

本文链接：https://blog.csdn.net/qq358716059/article/details/71650933

版权

记录自己一次二13的过程

SELECT
a.reader AS "Reader",
a.ispay AS "ispay",
location.name AS "Name",
location.position AS "position"
FROM
reading a
LEFT JOIN location location ON location.number = a.number

在级联查询时这样在数据库能查到数据。

但是写到 xml文件中时就会在查询时。location始终都是null

后来在谦虚求教的情况下知道。

SELECT
a.reader AS "Reader",
a.ispay AS "ispay",
location.name AS "location.Name",
location.position AS "location.position"
FROM
reading a
LEFT JOIN location location ON location.number = a.number

需要把需要级联的对象一起匹配进去。。

小程序猿。。犯的错都很傻。。。