ibatis多條件查詢

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>