nutz使用sql查询 Daos.queryCount(dao, sql)异常Every derived table must have its own alias

最新推荐文章于 2022-09-23 14:58:12 发布

seven酱

最新推荐文章于 2022-09-23 14:58:12 发布

阅读量659

点赞数

本文链接：https://blog.youkuaiyun.com/qq_41809490/article/details/89513461

版权

代码专栏收录该内容

0 篇文章

订阅专栏

nutz 源码：传入查询sql，执行queryCount产生Every derived table must have its own alias异常

public static int queryCount(Dao dao, String sql) {
       Sql sql2 = Sqls.fetchLong("select count(1) FROM (" + sql + ")");
       dao.execute(new Sql[] { sql2 });
       return sql2.getInt();
}

解决方案：直接使用代码，并为sql起别名
       Sql sql2 = Sqls.fetchLong("select count(1) FROM (" + sql + ") as temptable");
       dao.execute(new Sql[] { sql2 });
       return sql2.getInt();