问题
当前表想使用左连接关联另外一个表的一个字段,实体类里面需要加这个字段的属性定义么? 还有就是log发现执行查出来了数据,但是页面显示不出来,可能是我前端不熟导致的,想请教一下。
我的做法
左连接:
类属性:
list页面:
查询结果:
01-10 23:50:47.760 DEBUG [com.jeesite.modules.users.dao.UsersDao.findList] - ==> Preparing: SELECT a.id AS "id", a.type AS "type", a.affiliation AS "affiliation", a.attributes AS "attributes", a.state AS "state", a.max_enrollments AS "maxEnrollments", a.token AS "token", a.level AS "level", c.pem AS "certificates.pem" FROM users a LEFT JOIN certificates c ON a.id=c.id ORDER BY a.id DESC LIMIT 20
01-10 23:50:47.760 DEBUG [com.jeesite.modules.users.dao.UsersDao.findList] - ==> Parameters:
01-10 23:50:47.780 DEBUG [com.jeesite.modules.users.dao.UsersDao.findList] - <== Total: 2
结果显示不出来: