target/classes/mybatis/system/OaSysnianjianinfotabelMapper.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.sysnianjianinfotabel.mapper.OaSysnianjianinfotabelMapper">
    
    <resultMap type="OaSysnianjianinfotabel" id="OaSysnianjianinfotabelResult">
        <result property="id"    column="id"    />
        <result property="carNumber"    column="carNumber"    />
        <result property="carJianYanJigou"    column="carJianYanJigou"    />
        <result property="carJianYanFei"    column="carJianYanFei"    />
        <result property="carJianYanRiqi"    column="carJianYanRiqi"    />
        <result property="carTargetJianYanRiqi"    column="carTargetJianYanRiqi"    />
        <result property="carJianYanTixingDay"    column="carJianYanTixingDay"    />
        <result property="carJianYanDanPicture"    column="carJianYanDanPicture"    />
        <result property="carOperatorName"    column="carOperatorName"    />
        <result property="carNianJianRemark"    column="carNianJianRemark"    />
        <result property="carNianJianstatus"    column="carNianJianstatus"    />
    </resultMap>

    <sql id="selectOaSysnianjianinfotabelVo">
        select id, carNumber, carJianYanJigou, carJianYanFei, carJianYanRiqi, carTargetJianYanRiqi, carJianYanTixingDay, carJianYanDanPicture, carOperatorName, carNianJianRemark, carNianJianstatus from oa_sysnianjianinfotabel
    </sql>

    <select id="selectOaSysnianjianinfotabelList" parameterType="OaSysnianjianinfotabel" resultMap="OaSysnianjianinfotabelResult">
        <include refid="selectOaSysnianjianinfotabelVo"/>
        <where>  
            <if test="carNumber != null  and carNumber != ''"> and carNumber like concat('%', #{carNumber}, '%')</if>
        </where>
    </select>
    
    <select id="selectOaSysnianjianinfotabelById" parameterType="Long" resultMap="OaSysnianjianinfotabelResult">
        <include refid="selectOaSysnianjianinfotabelVo"/>
        where id = #{id}
    </select>
        
    <insert id="insertOaSysnianjianinfotabel" parameterType="OaSysnianjianinfotabel" useGeneratedKeys="true" keyProperty="id">
        insert into oa_sysnianjianinfotabel
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="carNumber != null and carNumber != ''">carNumber,</if>
            <if test="carJianYanJigou != null">carJianYanJigou,</if>
            <if test="carJianYanFei != null">carJianYanFei,</if>
            <if test="carJianYanRiqi != null">carJianYanRiqi,</if>
            <if test="carTargetJianYanRiqi != null">carTargetJianYanRiqi,</if>
            <if test="carJianYanTixingDay != null">carJianYanTixingDay,</if>
            <if test="carJianYanDanPicture != null">carJianYanDanPicture,</if>
            <if test="carOperatorName != null">carOperatorName,</if>
            <if test="carNianJianRemark != null">carNianJianRemark,</if>
            <if test="carNianJianstatus != null">carNianJianstatus,</if>
         </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="carNumber != null and carNumber != ''">#{carNumber},</if>
            <if test="carJianYanJigou != null">#{carJianYanJigou},</if>
            <if test="carJianYanFei != null">#{carJianYanFei},</if>
            <if test="carJianYanRiqi != null">#{carJianYanRiqi},</if>
            <if test="carTargetJianYanRiqi != null">#{carTargetJianYanRiqi},</if>
            <if test="carJianYanTixingDay != null">#{carJianYanTixingDay},</if>
            <if test="carJianYanDanPicture != null">#{carJianYanDanPicture},</if>
            <if test="carOperatorName != null">#{carOperatorName},</if>
            <if test="carNianJianRemark != null">#{carNianJianRemark},</if>