Question

ibatis多条件查询

我想分页，怎么查出 查询结果 的记录数，怎么补充，求高手指导，谢谢
多条件查询语句，该怎么补充
<select id="queryOrgans" resultClass="organ" parameterClass="organ">
select * from (select a.*, rownum row_num from (
select * from organ
<dynamic prepend=" where ">
<isNotEmpty prepend=" and " property="orgName">orgName Like '%$orgName$%'</isNotEmpty>
<isNotEmpty prepend=" and " property="orgLevel">orgLevel=#orgLevel#</isNotEmpty>
<isNotEmpty prepend=" and " property="orgType">orgType=#orgType#</isNotEmpty>
<isNotEmpty prepend=" and " property="orgState">orgState=#orgState#</isNotEmpty>
</dynamic>
order by orgId asc) a
where #end#>rownum) b where b.row_num>=#start#
</select>

Answer 1

ibatis 有自带分页功能方法：getSqlMapClientTemplate().queryForList(statementName, skipResults, maxResults);
和
getSqlMapClientTemplate().queryForList(statementName, parameterObject, skipResults, maxResults);
只需要传入相关参数即可。SQL和查询全部一样，ibatis会自动根据你所传参数过滤并返回结果。
这样避免写嵌套SQL，XML文件完整如下：
<select id="queryOrgans" resultClass="organ" parameterClass="organ">
select * from organ
<dynamic prepend=" where ">
<isNotEmpty prepend=" and " property="orgName">orgName Like '%$orgName$%'</isNotEmpty>
<isNotEmpty prepend=" and " property="orgLevel">orgLevel=#orgLevel#</isNotEmpty>
<isNotEmpty prepend=" and " property="orgType">orgType=#orgType#</isNotEmpty>
<isNotEmpty prepend=" and " property="orgState">orgState=#orgState#</isNotEmpty>
</dynamic>
order by orgId asc
</select>

Answer 2

查询语句中查出sum，用group by 进行分组