mybatis mapper.xml常用写法

resultMap写法

<resultMap id="BaseResultVoMap" type="*.*.*.Entity" >
    <id column="id" property="id" jdbcType="VARCHAR" />
    <result column="value" property="value" jdbcType="VARCHAR" />
    <result column="date" property="date" jdbcType="DATE" />
    <result column="time" property="time" jdbcType="TIMESTAMP" />
    <result column="status" property="status" jdbcType="INTEGER" />
    <result column="bool" property="bool" jdbcType="BOOLEAN" />
</resultMap>

if 书写

<if test=' value != null and value!= ""'>
     value = #{value}
</if>

foreach 书写

<foreach collection="ids" item="item" open="(" separator=" , " close=")" index="index">
     #{item}
</foreach>

批量插入 

<insert id="insert" parameterType="java.util.Map">
    insert into table(id, value, date, time, status)
    values
    <foreach collection="list" item="entity" separator=",">
        (
        #{entity.id}, 
        #{entity.value},
        #{entity.date},
        #{entity.time},
        #{entity.status}
        )
    </foreach>
</insert>

批量更新 

<update id="batchUpdate" parameterType="java.util.List">
	<foreach collection="lists" item="item" index="index" open="" close="" separator=";">
		UPDATE table_name
		<set>
			create_time = #{item.createTime}
		</set>
		WHERE id = #{item.id}
	</foreach>
</update>

 

choose 书写

<choose>
    <when test=' time != null and time == "1" '>
         table_${time}
    </when>
    <otherwise>
         table_${date}
    </otherwise>
</choose>

大于小于

&lt;=	<=
&gt;=	>=

sql 书写

<sql id="BaseColumn">
    id, value, date, time, status
</sql>

<select id="selectByPidsAndQids" parameterType="java.util.Map" resultMap="BaseResultVoMap">
    SELECT <include refid="BaseColumn"/>
    FROM table
</select>

resultType中接受Date数据类型

<select id="queryMaxDate" resultType="java.util.Date">
  	SELECT MAX(date)  as maxDate from dual
</select>