iBatis框架之配置文件之注意点之总结

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd" >
<sqlMap namespace="dbo_Hishop_Oren" >
  <resultMap id="OrderRetuenResult" class="com.temp.model.OrderRetuenModel" >
    <result column="RetuId" property="retuid" jdbcType="VARCHAR" />
    <result column="OrderId" property="orderid" jdbcType="VARCHAR" />
    <result column="UserId" property="userid" jdbcType="INTEGER" />
    <result column="LinkMan" property="linkman" jdbcType="VARCHAR" />
 </resultMap>
  <sql id="Where_Clause" >
    <isNotEmpty prepend="and" property="retuid" >
      RetuId = #retuid:VARCHAR#
    </isNotEmpty>
    <isNotEmpty prepend="and" property="orderid" >
      OrderId = #orderid:VARCHAR#
    </isNotEmpty>
    <isNotEmpty prepend="and" property="userid" >
      UserId = #userid:INTEGER#
    </isNotEmpty>
    <isNotEmpty prepend="and" property="linkman" >
      LinkMan = #linkman:VARCHAR#
    </isNotEmpty>
  <isNotEmpty property="criteria" >
      <iterate property="criteria" conjunction="and" prepend="and" open="(" close=")" >
        $criteria[].paramName$ $criteria[].arithmeticType$ #criteria[].paramValue#
      </iterate>
    </isNotEmpty>
  </sql>