ibatis

来源:互联网 发布:网络信息化领导小组 编辑:程序博客网 时间:2024/06/16 02:33
<?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="qbt_category">  <resultMap class="cn.flystone.quubox.foundation.model.QCategory" id="ibatorgenerated_BaseResultMap">    <!--  [generated on 2012-11-13 13:47:48.530] -->    <result column="UUID" jdbcType="VARCHAR" property="uuid" />    <result column="PARENT_UUID" jdbcType="VARCHAR" property="parentUuid" />    <result column="NAME" jdbcType="VARCHAR" property="name" />    <result column="COMMENT" jdbcType="VARCHAR" property="comment" />    <result column="RECOMMEND" jdbcType="INTEGER" property="recommend" />    <result column="ORD" jdbcType="INTEGER" property="ord" />    <result column="CREATE_TIME" jdbcType="TIMESTAMP" property="createTime" />    <result column="UPDATE_TIME" jdbcType="TIMESTAMP" property="updateTime" />  </resultMap>  <sql id="ibatorgenerated_Example_Where_Clause">    <!--  [generated on 2012-11-13 13:47:48.530] -->    <iterate conjunction="or" prepend="where" property="oredCriteria" removeFirstPrepend="iterate">      <isEqual compareValue="true" property="oredCriteria[].valid">        (        <iterate conjunction="and" prepend="and" property="oredCriteria[].criteriaWithoutValue">          $oredCriteria[].criteriaWithoutValue[]$        </iterate>        <iterate conjunction="and" prepend="and" property="oredCriteria[].criteriaWithSingleValue">          $oredCriteria[].criteriaWithSingleValue[].condition$            #oredCriteria[].criteriaWithSingleValue[].value#        </iterate>        <iterate conjunction="and" prepend="and" property="oredCriteria[].criteriaWithListValue">          $oredCriteria[].criteriaWithListValue[].condition$          <iterate close=")" conjunction="," open="(" property="oredCriteria[].criteriaWithListValue[].values">            #oredCriteria[].criteriaWithListValue[].values[]#          </iterate>        </iterate>        <iterate conjunction="and" prepend="and" property="oredCriteria[].criteriaWithBetweenValue">          $oredCriteria[].criteriaWithBetweenValue[].condition$          #oredCriteria[].criteriaWithBetweenValue[].values[0]# and          #oredCriteria[].criteriaWithBetweenValue[].values[1]#        </iterate>        )      </isEqual>    </iterate>  </sql>  <sql id="ibatorgenerated_Example_Page_Clause">    <dynamic prepend="LIMIT">      <isNotNull property="_startNum">        #_startNum#      </isNotNull>      <isNotNull property="_offsetNum">        ,#_offsetNum#      </isNotNull>    </dynamic>  </sql>  <select id="ibatorgenerated_selectByExample" parameterClass="cn.flystone.quubox.foundation.model.QCategoryExample" resultMap="ibatorgenerated_BaseResultMap">    <!--  [generated on 2012-11-13 13:47:48.530] -->    select UUID, PARENT_UUID, NAME, COMMENT, RECOMMEND, ORD, CREATE_TIME, UPDATE_TIME    from qbt_category    <isParameterPresent>      <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />      <isNotNull property="orderByClause">        order by $orderByClause$      </isNotNull>      <include refid="qbt_category.ibatorgenerated_Example_Page_Clause" />    </isParameterPresent>  </select>  <select id="ibatorgenerated_selectByPrimaryKey" parameterClass="cn.flystone.quubox.foundation.model.QCategory" resultMap="ibatorgenerated_BaseResultMap">    <!--  [generated on 2012-11-13 13:47:48.531] -->    select UUID, PARENT_UUID, NAME, COMMENT, RECOMMEND, ORD, CREATE_TIME, UPDATE_TIME    from qbt_category    where UUID = #uuid:VARCHAR#  </select>  <delete id="ibatorgenerated_deleteByPrimaryKey" parameterClass="cn.flystone.quubox.foundation.model.QCategory">    <!--  [generated on 2012-11-13 13:47:48.531] -->    delete from qbt_category    where UUID = #uuid:VARCHAR#  </delete>  <delete id="ibatorgenerated_deleteByExample" parameterClass="cn.flystone.quubox.foundation.model.QCategoryExample">    <!--  [generated on 2012-11-13 13:47:48.531] -->    delete from qbt_category    <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />  </delete>  <insert id="ibatorgenerated_insert" parameterClass="cn.flystone.quubox.foundation.model.QCategory">    <!--  [generated on 2012-11-13 13:47:48.531] -->    insert into qbt_category (UUID, PARENT_UUID, NAME, COMMENT, RECOMMEND, ORD, CREATE_TIME,      UPDATE_TIME)    values (#uuid:VARCHAR#, #parentUuid:VARCHAR#, #name:VARCHAR#, #comment:VARCHAR#,      #recommend:INTEGER#, #ord:INTEGER#, #createTime:TIMESTAMP#, #updateTime:TIMESTAMP#)  </insert>  <insert id="ibatorgenerated_insertSelective" parameterClass="cn.flystone.quubox.foundation.model.QCategory">    <!--  [generated on 2012-11-13 13:47:48.532] -->    insert into qbt_category    <dynamic prepend="(">      <isNotNull prepend="," property="uuid">        UUID      </isNotNull>      <isNotNull prepend="," property="parentUuid">        PARENT_UUID      </isNotNull>      <isNotNull prepend="," property="name">        NAME      </isNotNull>      <isNotNull prepend="," property="comment">        COMMENT      </isNotNull>      <isNotNull prepend="," property="recommend">        RECOMMEND      </isNotNull>      <isNotNull prepend="," property="ord">        ORD      </isNotNull>      <isNotNull prepend="," property="createTime">        CREATE_TIME      </isNotNull>      <isNotNull prepend="," property="updateTime">        UPDATE_TIME      </isNotNull>      )    </dynamic>    values    <dynamic prepend="(">      <isNotNull prepend="," property="uuid">        #uuid:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="parentUuid">        #parentUuid:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="name">        #name:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="comment">        #comment:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="recommend">        #recommend:INTEGER#      </isNotNull>      <isNotNull prepend="," property="ord">        #ord:INTEGER#      </isNotNull>      <isNotNull prepend="," property="createTime">        #createTime:TIMESTAMP#      </isNotNull>      <isNotNull prepend="," property="updateTime">        #updateTime:TIMESTAMP#      </isNotNull>      )    </dynamic>  </insert>  <select id="ibatorgenerated_countByExample" parameterClass="cn.flystone.quubox.foundation.model.QCategoryExample" resultClass="java.lang.Integer">    <!--  [generated on 2012-11-13 13:47:48.532] -->    select count(*) from qbt_category    <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />  </select>  <update id="ibatorgenerated_updateByExampleSelective">    <!--  [generated on 2012-11-13 13:47:48.532] -->    update qbt_category    <dynamic prepend="set">      <isNotNull prepend="," property="record.uuid">        UUID = #record.uuid:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="record.parentUuid">        PARENT_UUID = #record.parentUuid:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="record.name">        NAME = #record.name:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="record.comment">        COMMENT = #record.comment:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="record.recommend">        RECOMMEND = #record.recommend:INTEGER#      </isNotNull>      <isNotNull prepend="," property="record.ord">        ORD = #record.ord:INTEGER#      </isNotNull>      <isNotNull prepend="," property="record.createTime">        CREATE_TIME = #record.createTime:TIMESTAMP#      </isNotNull>      <isNotNull prepend="," property="record.updateTime">        UPDATE_TIME = #record.updateTime:TIMESTAMP#      </isNotNull>    </dynamic>    <isParameterPresent>      <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />    </isParameterPresent>  </update>  <update id="ibatorgenerated_updateByExample">    <!--  [generated on 2012-11-13 13:47:48.532] -->    update qbt_category    set UUID = #record.uuid:VARCHAR#,      PARENT_UUID = #record.parentUuid:VARCHAR#,      NAME = #record.name:VARCHAR#,      COMMENT = #record.comment:VARCHAR#,      RECOMMEND = #record.recommend:INTEGER#,      ORD = #record.ord:INTEGER#,      CREATE_TIME = #record.createTime:TIMESTAMP#,      UPDATE_TIME = #record.updateTime:TIMESTAMP#    <isParameterPresent>      <include refid="qbt_category.ibatorgenerated_Example_Where_Clause" />    </isParameterPresent>  </update>  <update id="ibatorgenerated_updateByPrimaryKeySelective" parameterClass="cn.flystone.quubox.foundation.model.QCategory">    <!--  [generated on 2012-11-13 13:47:48.532] -->    update qbt_category    <dynamic prepend="set">      <isNotNull prepend="," property="parentUuid">        PARENT_UUID = #parentUuid:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="name">        NAME = #name:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="comment">        COMMENT = #comment:VARCHAR#      </isNotNull>      <isNotNull prepend="," property="recommend">        RECOMMEND = #recommend:INTEGER#      </isNotNull>      <isNotNull prepend="," property="ord">        ORD = #ord:INTEGER#      </isNotNull>      <isNotNull prepend="," property="createTime">        CREATE_TIME = #createTime:TIMESTAMP#      </isNotNull>      <isNotNull prepend="," property="updateTime">        UPDATE_TIME = #updateTime:TIMESTAMP#      </isNotNull>    </dynamic>    where UUID = #uuid:VARCHAR#  </update>  <update id="ibatorgenerated_updateByPrimaryKey" parameterClass="cn.flystone.quubox.foundation.model.QCategory">    <!--  [generated on 2012-11-13 13:47:48.532] -->    update qbt_category    set PARENT_UUID = #parentUuid:VARCHAR#,      NAME = #name:VARCHAR#,      COMMENT = #comment:VARCHAR#,      RECOMMEND = #recommend:INTEGER#,      ORD = #ord:INTEGER#,      CREATE_TIME = #createTime:TIMESTAMP#,      UPDATE_TIME = #updateTime:TIMESTAMP#    where UUID = #uuid:VARCHAR#  </update></sqlMap>

原创粉丝点击