<?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="in_userterminating">
<resultMap class="com.stu.mail.model.InUserterminating" id="ibatorgenerated_BaseResultMap">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
<result column="in_termin_id" jdbcType="BIGINT" property="inTerminId" />
<result column="in_termin_title" jdbcType="VARCHAR" property="inTerminTitle" />
<result column="in_terminsettime" jdbcType="TIMESTAMP" property="inTerminsettime" />
<result column="in_terminsts" jdbcType="INTEGER" property="inTerminsts" />
<result column="in_user_id" jdbcType="BIGINT" property="inUserId" />
<result column="in_sentuser_id" jdbcType="BIGINT" property="inSentuserId" />
<result column="in_termindeltime" jdbcType="TIMESTAMP" property="inTermindeltime" />
</resultMap>
<resultMap class="com.stu.mail.model.InUserterminating" extends="in_userterminating.ibatorgenerated_BaseResultMap" id="ibatorgenerated_ResultMapWithBLOBs">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
<result column="in_termin_text" jdbcType="LONGVARCHAR" property="inTerminText" />
</resultMap>
<sql id="ibatorgenerated_Example_Where_Clause">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
<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>
<select id="ibatorgenerated_selectByExampleWithBLOBs" parameterClass="com.stu.mail.model.example.InUserterminatingExample" resultMap="ibatorgenerated_ResultMapWithBLOBs">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
select in_termin_id, in_termin_title, in_terminsettime, in_terminsts, in_user_id,
in_sentuser_id, in_termindeltime, in_termin_text
from in_userterminating
<isParameterPresent>
<include refid="in_userterminating.ibatorgenerated_Example_Where_Clause" />
<isNotNull property="orderByClause">
order by $orderByClause$
</isNotNull>
</isParameterPresent>
</select>
<select id="ibatorgenerated_selectByExample" parameterClass="com.stu.mail.model.example.InUserterminatingExample" resultMap="ibatorgenerated_BaseResultMap">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
select in_termin_id, in_termin_title, in_terminsettime, in_terminsts, in_user_id,
in_sentuser_id, in_termindeltime
from in_userterminating
<isParameterPresent>
<include refid="in_userterminating.ibatorgenerated_Example_Where_Clause" />
<isNotNull property="orderByClause">
order by $orderByClause$
</isNotNull>
</isParameterPresent>
</select>
<select id="ibatorgenerated_selectByPrimaryKey" parameterClass="com.stu.mail.model.InUserterminating" resultMap="ibatorgenerated_ResultMapWithBLOBs">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
select in_termin_id, in_termin_title, in_terminsettime, in_terminsts, in_user_id,
in_sentuser_id, in_termindeltime, in_termin_text
from in_userterminating
where in_termin_id = #inTerminId:BIGINT#
</select>
<delete id="ibatorgenerated_deleteByPrimaryKey" parameterClass="com.stu.mail.model.InUserterminating">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
delete from in_userterminating
where in_termin_id = #inTerminId:BIGINT#
</delete>
<delete id="ibatorgenerated_deleteByExample" parameterClass="com.stu.mail.model.example.InUserterminatingExample">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
delete from in_userterminating
<include refid="in_userterminating.ibatorgenerated_Example_Where_Clause" />
</delete>
<insert id="ibatorgenerated_insert" parameterClass="com.stu.mail.model.InUserterminating">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
insert into in_userterminating (in_termin_title, in_terminsettime, in_terminsts, in_user_id,
in_sentuser_id, in_termindeltime, in_termin_text)
values (#inTerminTitle:VARCHAR#, #inTerminsettime:TIMESTAMP#, #inTerminsts:INTEGER#,
#inUserId:BIGINT#, #inSentuserId:BIGINT#, #inTermindeltime:TIMESTAMP#,
#inTerminText:LONGVARCHAR#)
<selectKey keyProperty="inTerminId" resultClass="java.lang.Long">
SELECT SCOPE_IDENTITY()
</selectKey>
</insert>
<insert id="ibatorgenerated_insertSelective" parameterClass="com.stu.mail.model.InUserterminating">
<!--
WARNING - This element is automatically generated by Apache iBATIS ibator, do not modify.
This element was generated on Mon Jan 18 11:26:16 CST 2010.
-->
insert into in_userterminating
<dynamic prepend="(">
<isNotNull prepend="," property="inTerminTitle">
in_termin_title
</isNotNull>
<isNotNull prepend="," property="inTerminsettime">
in_terminsettime
</isNotNull>
<isNotNull prepend="," property="inTerminsts">
in_terminsts
</isNotNull>
<isNotNull prepend="," property="inUserId">
in_user_id
</isNotNull>
<isNotNull prepend="," property="inSentuserId">
in_sentuser_id
</isNotNull>
<isNotNull prepend="," property="inTermindeltime">
in_termindeltime
</isNotNull>
<isNotNull prepend="," property="inTerminText">
in_termin_text
</isNotNull>
)
</dynamic>
values
<dynamic prepend="(">
<isNotNull prepend="," property="inTerminTitle">
#inTerminTitle:VARCHAR#
</isNotNull>
<isNotN