JFinal

登录 注册

Db+record无法获取数据

我使用DB+record执行List<Record> list = Db.find(url,date,openId);语句,后台打印了sql语句:

SELECT a.*,b.result FROM sjb_main a
LEFT JOIN sjb_mortgage b on a.id = b.sjbId
LEFT JOIN (SELECT * FROM sjb_user WHERE openid =?) as c on b.userId = c.id  WHERE a.date = ? and a.state <2  ORDER BY time


但是list获取不到结果 
,我用这个sql在数据库执行时有两条数据,请问是什么原因呢?

评论