MyBatis之动态updata语句

最新推荐文章于 2024-11-23 13:41:05 发布

qq305933616

最新推荐文章于 2024-11-23 13:41:05 发布

阅读量666

点赞数

分类专栏： MyBatis 文章标签： mybatis

本文链接：https://blog.youkuaiyun.com/qq_28039297/article/details/76057097

版权

MyBatis 专栏收录该内容

1 篇文章

订阅专栏

本文主要探讨MyBatis中动态update语句的使用，通过实例解析其工作原理和优势，帮助开发者更好地掌握MyBatis的动态SQL操作。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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>