看了一下这个查询语句,发现写的代码还真不少!
有时候我需要做联合查询写这么多虽然是COPY,但也耗费神经
Sql.create("SELECT m.* FROM master m JOIN detail d ON m.d_id=d.d_id WHERE
d.name='aa'");
sql.setCallback(Sqls.callback.entities());
sql.setEntity(dao.getEntity(Master.class));
dao.execute(sql);
List<Master> list = sql.getList(Master.class);
------------------------------------------------------------------
这样应该也能查出来的是LIST吧
Sql.create("SELECT m.* FROM master m JOIN detail d ON m.d_id=d.d_id WHERE
d.name='aa'");
sql.setCallback(Sqls.callback.entities());
sql.setEntity(dao.getEntity(List.class));
dao.execute(sql);
List<String,String> list = sql.getList(List.class);
我觉得这个需要进一步封装
1:支持只传入SQL语句,可以返回record,map,list,array等类型数��
�集
2:支持传入map类型或list类型自动解析匹配变成sql.params().set("
name", "A%");
3:保留分页功能。
4:建议该方法名定义为manuQuery
Original issue reported on code.google.com by ssht968@gmail.com on 27 Oct 2011 at 2:16
Original issue reported on code.google.com by
ssht968@gmail.com
on 27 Oct 2011 at 2:16