target/classes/mybatis/system/OaCustomerinfoMapper.xml

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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="com.ruoyi.project.system.customerinfo.mapper.OaCustomerinfoMapper">
    
    <resultMap type="OaCustomerinfo" id="OaCustomerinfoResult">
        <result property="customerId"    column="customerId"    />
        <result property="customerName"    column="customerName"    />
        <result property="customerCard"    column="customerCard"    />
        <result property="customerPhone"    column="customerPhone"    />
        <result property="customerSex"    column="customerSex"    />
        <result property="customerAge"    column="customerAge"    />
        <result property="customerDateofBirth"    column="customerDateofBirth"    />
        <result property="customerAdress"    column="customerAdress"    />
        <result property="customerNewAdress"    column="customerNewAdress"    />
        <result property="createDate"    column="createDate"    />
        <result property="customerImages"    column="customerImages"    />
        <result property="customerStatus"    column="customerStatus"    />
    </resultMap>

    <sql id="selectOaCustomerinfoVo">
        select customerId, customerName, customerCard, customerPhone, customerSex, customerAge, customerDateofBirth, customerAdress, customerNewAdress, createDate, customerImages, customerStatus from oa_customerinfo
    </sql>

    <select id="selectOaCustomerinfoList" parameterType="OaCustomerinfo" resultMap="OaCustomerinfoResult">
        <include refid="selectOaCustomerinfoVo"/>
        <where>  
            <if test="customerName != null  and customerName != ''"> and customerName like concat('%', #{customerName}, '%')</if>
            <if test="customerCard != null  and customerCard != ''"> and customerCard like concat('%', #{customerCard}, '%')</if>
            <if test="params.beginCustomerPhone != null and params.beginCustomerPhone != '' and params.endCustomerPhone != null and params.endCustomerPhone != ''"> and customerPhone between #{params.beginCustomerPhone} and #{params.endCustomerPhone}</if>
            <if test="customerStatus != null "> and customerStatus = #{customerStatus}</if>
        </where>
    </select>
    
    <select id="selectOaCustomerinfoByCustomerId" parameterType="Long" resultMap="OaCustomerinfoResult">
        <include refid="selectOaCustomerinfoVo"/>
        where customerId = #{customerId}
    </select>
        
    <insert id="insertOaCustomerinfo" parameterType="OaCustomerinfo" useGeneratedKeys="true" keyProperty="customerId">
        insert into oa_customerinfo
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="customerName != null and customerName != ''">customerName,</if>
            <if test="customerCard != null and customerCard != ''">customerCard,</if>
            <if test="customerPhone != null">customerPhone,</if>
            <if test="customerSex != null">customerSex,</if>
            <if test="customerAge != null">customerAge,</if>
            <if test="customerDateofBirth != null">customerDateofBirth,</if>
            <if test="customerAdress != null">customerAdress,</if>
            <if test="customerNewAdress != null">customerNewAdress,</if>
            <if test="createDate != null">createDate,</if>
            <if test="customerImages != null">customerImages,</if>
            <if test="customerStatus != null">customerStatus,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="customerName != null and customerName != ''">#{customerName},</if>
            <if test="customerCard != null and customerCard != ''">#{customerCard},</if>
            <if test="customerPhone != null">#{customerPhone},</if>
            <if test="customerSex != null">#{customerSex},</if>