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

小程序：扫一扫查出行
【扫一扫了解最新限行尾号】
复制小程序

1、配置文件sqlMap.xml中需要注意的点

比如：

<?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>