自定义sql多表查询，获取列表问题

@At
@Ok("jsp:/user/list.jsp")
public Object demoSql() {
Sql sql = Sqls.create(
"select a.*,b.officeName as b_name,c.dutyName as c_name,d.roleName as d_name from t_user a LEFT JOIN t_office b on a.officeId=b.officeId LEFT JOIN t_duty c ON a.dutyId=c.dutyId LEFT JOIN t_role d on a.roleId =d.roleId ");

    dao.execute(sql);
    List<Record> list = sql.getList(Record.class);
    Map<String, Object> map = new HashMap<String, Object>();
    map.put("list", list);
    return map;

}

jsp页面，应该怎么调用呢？求教~

wendal

1楼•2571天前

obj.list

wendal

2楼•2571天前

但你没设置回调呢，list会是null

Yunisoo(yunisoo)

3楼•2571天前

sql.setCallback(new SqlCallback() {
public Object invoke(Connection conn, ResultSet rs, Sql sql) throws SQLException {
while (rs.next()) {
User m = dao.getEntity(User.class).getObject(rs, null, "a.");

         }

       }
    });
    dao.execute(sql);

类似这样么？

wendal

4楼•2571天前

Sqls.callback.XXX 有很多现成的

PS: 贴代码用 "插入代码" 按钮啊....

请先登陆