Ibatis知道（一）

常用标签： 

<isNotEmpty prepend="AND" property="DEPT_NO">

<isEmpty prepend="" property="sortname">

<isNotEqual property="LOGINNAME" compareValue="IT">

 <isEqual property="LOGINNAME" compareValue="IT">

sql部分：

                DEPTNO IN
            <iterate property="DEPTNO" open="(" close=")" conjunction=",">
                #DEPTNO[]#
            </iterate>

JAVA部分

   String[] strArray = null;   // 部门值为：C1432,C1441,C1415
    strArray = dbdeptNo.split(",");
    paramMap.put("DEPTNO", Arrays.asList(strArray));

 

 

   <![CDATA[
    ]]>