mybatis配置文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "mybatis-3-mapper.dtd" >
<mapper namespace="com.maigao.xiaowei.server.dao.AdverDao">

<resultMap id="BaseResultMap" type="com.maigao.xiaowei.server.entity.Adver">
<id column="id" property="id" jdbcType="INTEGER" />
<result column="adver_name" property="adverName" jdbcType="VARCHAR" />
<result column="adver_create_user" property="adverCreateUser"
jdbcType="VARCHAR" />
<result column="adver_update_user" property="adverUpdateUser"
jdbcType="VARCHAR" />
<result column="adver_create_time" property="adverCreateTime"
jdbcType="TIMESTAMP" />
<result column="adver_update_time" property="adverUpdateTime"
jdbcType="TIMESTAMP" />
<result column="adver_start_time" property="adverStartTime"
jdbcType="TIMESTAMP" />
<result column="adver_end_time" property="adverEndTime"
jdbcType="TIMESTAMP" />
</resultMap>

<sql id="Base_Column_List">
id, adver_name, adver_create_user, adver_update_user, adver_create_time,
adver_update_time,
adver_start_time, adver_end_time
</sql>

<insert id="insert" parameterType="com.maigao.xiaowei.server.entity.Adver"
useGeneratedKeys="true" keyProperty="id">
insert into tb_adver
<trim prefix="(" suffix=")" suffixOverrides=",">
adver_name,
adver_create_user,
adver_update_user,
adver_create_time,
adver_update_time,
adver_start_time,
adver_end_time,
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
#{adverName,jdbcType=VARCHAR},
#{adverCreateUser,jdbcType=VARCHAR},
#{adverUpdateUser,jdbcType=VARCHAR},
#{adverCreateTime,jdbcType=TIMESTAMP},
#{adverUpdateTime,jdbcType=TIMESTAMP},
#{adverStartTime,jdbcType=TIMESTAMP},
#{adverEndTime,jdbcType=TIMESTAMP},
</trim>
</insert>

<update id="update" parameterType="com.maigao.xiaowei.server.entity.Adver">
update tb_adver
<set>
<if test="adverName != null !=‘‘">
adver_name = #{adverName,jdbcType=VARCHAR},
</if>
<if test="adverCreateUser != null">
adver_create_user = #{adverCreateUser,jdbcType=VARCHAR},
</if>
<if test="adverUpdateUser != null">
adver_update_user = #{adverUpdateUser,jdbcType=VARCHAR},
</if>
<if test="adverCreateTime != null">
adver_create_time = #{adverCreateTime,jdbcType=TIMESTAMP},
</if>
<if test="adverUpdateTime != null">
adver_update_time = #{adverUpdateTime,jdbcType=TIMESTAMP},
</if>
<if test="adverStartTime != null">
adver_start_time = #{adverStartTime,jdbcType=TIMESTAMP},
</if>
<if test="adverEndTime != null">
adver_end_time = #{adverEndTime,jdbcType=TIMESTAMP},
</if>
</set>
where id = #{id,jdbcType=INTEGER}
</update>

<select id="get" resultMap="BaseResultMap" parameterType="java.lang.Integer">
select
<include refid="Base_Column_List" />
from tb_adver
where id = #{id,jdbcType=INTEGER}
</select>

<delete id="delete" parameterType="java.lang.Integer">
delete from tb_adver
where id = #{id,jdbcType=INTEGER}
</delete>
<sql id="sql_where">
<where>
1 = 1
<if test="id != null">
and id = #{id,jdbcType=INTEGER}
</if>
<if test="adverName != null and adverName !=‘‘">
and adver_name like ‘%${adverName}%‘
</if>
<if test="adverCreateUser != null and adverCreateUser !=‘‘">
and adver_create_user like ‘%${adverCreateUser}%‘
</if>
<if test="adverUpdateUser != null and adverUpdateUser !=‘‘">
and adver_update_user like ‘%${adverUpdateUser}%‘
</if>
<if test="adverCreateTimeFrom != null">
and <![CDATA[ adver_create_time >= #{adverCreateTimeFrom,jdbcType=TIMESTAMP} ]]>
</if>
<if test="adverCreateTimeTo != null">
and <![CDATA[ adver_create_time <= #{adverCreateTimeTo,jdbcType=TIMESTAMP} ]]>
</if>
<if test="adverUpdateTimeFrom != null">
and <![CDATA[ adver_update_time >= #{adverUpdateTimeFrom,jdbcType=TIMESTAMP} ]]>
</if>
<if test="adverUpdateTimeTo != null">
and <![CDATA[ adver_update_time <= #{adverUpdateTimeTo,jdbcType=TIMESTAMP} ]]>
</if>
<if test="adverStartTimeFrom != null">
and <![CDATA[ adver_start_time >= #{adverStartTimeFrom,jdbcType=TIMESTAMP} ]]>
</if>
<if test="adverStartTimeTo != null">
and <![CDATA[ adver_start_time <= #{adverStartTimeTo,jdbcType=TIMESTAMP} ]]>
</if>
<if test="adverEndTimeFrom != null">
and <![CDATA[ adver_end_time >= #{adverEndTimeFrom,jdbcType=TIMESTAMP} ]]>
</if>
<if test="adverEndTimeTo != null">
and <![CDATA[ adver_end_time <= #{adverEndTimeTo,jdbcType=TIMESTAMP} ]]>
</if>
</where>
</sql>
<select id="getList" resultMap="BaseResultMap"
parameterType="com.maigao.xiaowei.server.entity.Adver">
select
<include refid="Base_Column_List" />
from tb_adver
<include refid="sql_where" />
order by id,adver_name
</select>

<select id="getTotal" parameterType="com.maigao.xiaowei.server.entity.Adver"
resultType="int">
select count(1) from tb_adver
<include refid="sql_where" />
</select>

<select id="getPage" resultMap="BaseResultMap"
parameterType="com.maigao.xiaowei.server.entity.Adver">
select
<include refid="Base_Column_List" />
from tb_adver
<include refid="sql_where" />
order by id,adver_name limit #{pageNo},#{pageCount}
</select>

<select id="search" resultMap="BaseResultMap"
parameterType="com.maigao.xiaowei.server.entity.Adver">
select
<include refid="Base_Column_List" />
from tb_adver

order by id,adver_name limit #{pageNo},#{pageCount}
</select>
</mapper>

mybatis配置文件

原文：http://www.cnblogs.com/jxlyc050616/p/4989629.html