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