ibatis SQLmap 查询方法整理

in 语句

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

  INFO_KIND in ($infoKind$)

</isNotEmpty>

注意($infoKind$)中 使用$而不是#否则得不到想要的查询结果，因为 #1,2# 会被解析成‘1,2’

like 语句

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

  INFO_NUM LIKE '%$infoNum$%'

</isNotEmpty>

多表查询

<select id="query" parameterClass="java.util.HashMap"

      resultClass="java.util.HashMap" >

  SELECT

IPLAT.TDMCM07.STUDENT_CODE as "studentCode",

IPLAT.TDMCM07.STUDENT_NAME as "studentName",

IPLAT.TDMCM08.BOOKE_CODE as "bookeCode",

IPLAT.TDMCM08.STUDENT_CODE as "student",

IPLAT.TDMCM08.BOOKE_NAME as "bookeName",

IPLAT.TDMCM08.BOOKE_AUTHOR as "bookeAuthor",

IPLAT.TDMCM08.BOOKE_BRIEF  as "bookeBrief"

FROM IPLAT.TDMCM07 , IPLAT.TDMCM08  WHERE IPLAT.TDMCM07.STUDENT_CODE = IPLAT.TDMCM08.BOOKE_CODE

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

      IPLAT.TDMCM08.STUDENT_CODE = #stuCode#

      <dynamic prepend="ORDER BY">

        <isNotEmpty property="orderBy">

            $orderBy$

      <isEmpty property="orderBy">

      IPLAT.TDMCM08.STUDENT_CODE asc

      </dynamic>

注意： 多个表中存在相同名称字段时应明确指出操作的字段属于哪张表格否则数据库无法准确找得到相应的字段