select ，update更新xml语法

最新推荐文章于 2023-12-21 12:35:07 发布

一枝独秀儿

最新推荐文章于 2023-12-21 12:35:07 发布

阅读量2.5k

点赞数

文章标签： xml sql

本文链接：https://blog.youkuaiyun.com/weixin_52311326/article/details/120973983

版权

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="xx.xx.mapper.UserMapper">
<update id="updateByIdAndRevision" parameterType="xx.xx.model.pojos.User" >
        update user
        set
        # 注意不是String类型的字段不能写  xx != ''  
        <if test="auditStatus != null and auditStatus != ''">
            audit_status = #{auditStatus}, # 这里记得加逗号
        </if>
        <if test="createdTime!= null ">
            created_time = #{createdTime},
        </if>
        <if test="revision != null and revision != '' ">
            revision = #{revision} + 1
        </if>
         where id = #{id} and revision = #{revision} 
    </update>

   <select id="findOrderListCount" parameterType="xx.xx.req.OrderListRequest" resultType="java.lang.Long">
        select count(DISTINCT id) from user
        where 
        <if test="id != null and id != ''">
            and id=#{id}
        </if>
        <if test="custId != null and custId != ''">
            and cust_id=#{custId}
        </if>
        <if test="productName !=null and  productName!='' ">
             AND product_name like CONCAT('%',#{productName},'%')
        </if>
        <if test="orderState != null ">
            <choose>
                <when test="orderStates !=null ">
                    and o.order_state in
                    <foreach close=")" collection="orderStates" index="index" item="state" open="(" separator=",">
                        #{state}
                    </foreach>
                </when>
                <otherwise>
                     and o.order_state = #{orderState}
                </otherwise>
            </choose>
        </if>
    </select>
</mapper>