MyBatis之动态updata语句

MyBatis之动态updata语句

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "./mybatis-3-mapper.dtd" ><mapper namespace="net.bunnytouch.bs.dao.widget.LoopProgramDAO">     <resultMap type="LoopProgramEntity" id="loopProgramEntity">        <result column="CSTM_ID" property="cstmId"/>        <result column="TASK_ID" property="taskId"/>        <result column="PRGM_ID" property="prgmId"/>        <result column="DESCP" property="descp"/>        <result column="NAME" property="name"/>        <result column="SEQ" property="seq"/>        <result column="WIDTH" property="width"/>        <result column="HEIGHT" property="height"/>        <result column="MAIN_RECT" property="mainRect"/>        <result column="STATE" property="state"/>        <result column="CREATE_TIME" property="creatTime"/>        <result column="CREATE_USER" property="creatUser"/>     </resultMap>     <sql id="loopProgramTableName">        tb_loop_program     </sql>     <update id="updateLoopProgram" parameterMap="loopProgramEntity">        update <include refid="loopProgramTableName"/>        <trim prefix="set" suffixOverrides=",">            <if test="descp!=null">DESCP=#{descp}</if>            <if test="name!=null">NAME=#{name}</if>            <if test="seq!=null">SEQ=#{seq}</if>            <if test="width!=null">WIDTH=#{width}</if>            <if test="height!=null">HEIGHT=#{height}</if>            <if test="mainRect!=null">MAIN_RECT=#{mainRect}</if>            <if test="state!=null">STATE=#{state}</if>            <if test="creatTime!=null">CREATE_TIME=#{creatTime}</if>            <if test="creatUser!=null">CREATE_USER=#{creatUser}</if>        </trim>        where         CSTM_ID = #{cstmId} and TASK_ID=#{taskId} and PRGM_ID=#{prgmId}     </update></mapper>