src/main/resources/mybatis/system/OaSyscarinfoMapper.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.syscarinfo.mapper.OaSyscarinfoMapper">
    
    <resultMap type="OaSyscarinfo" id="OaSyscarinfoResult">
        <result property="id"    column="id"    />
        <result property="carNumber"    column="carNumber"    />
        <result property="carXingHao"    column="carXingHao"    />
        <result property="carBrand"    column="carBrand"    />
        <result property="carColors"    column="carColors"    />
        <result property="carValue"    column="carValue"    />
        <result property="carChuChangRiQi"    column="carChuChangRiQi"    />
        <result property="carLiCheng"    column="carLiCheng"    />
        <result property="carXingShiZheng"    column="carXingShiZheng"    />
        <result property="carFaDongJiNomber"    column="carFaDongJiNomber"    />
        <result property="carShenYanRiQi"    column="carShenYanRiQi"    />
        <result property="carBaoXianRiQi"    column="carBaoXianRiQi"    />
        <result property="carRizuFei"    column="carRizuFei"    />
        <result property="carYueZuFei"    column="carYueZuFei"    />
        <result property="carNianZuFei"    column="carNianZuFei"    />
        <result property="carImages"    column="carImages"    />
        <result property="carStatus"    column="carStatus"    />
        <result property="oilProductInfo"    column="oilProductInfo"    />
        <result property="gpsCode"    column="gpsCode"    />
    </resultMap>

    <sql id="selectOaSyscarinfoVo">
        select id, carNumber, carXingHao, carBrand, carColors, carValue, carChuChangRiQi, carLiCheng, carXingShiZheng, carFaDongJiNomber, carShenYanRiQi, carBaoXianRiQi, carRizuFei, carYueZuFei, carNianZuFei, carImages, carStatus,oilProductInfo ,gpsCode  from oa_syscarinfo
    </sql>

    <select id="selectOaSyscarinfoList" parameterType="OaSyscarinfo" resultMap="OaSyscarinfoResult">
        <include refid="selectOaSyscarinfoVo"/>
        <where>  
            <if test="carNumber != null  and carNumber != ''"> and carNumber like concat('%', #{carNumber}, '%')</if>
            <if test="carXingHao != null  and carXingHao != ''"> and carXingHao like concat('%', #{carXingHao}, '%')</if>
            <if test="carBrand != null  and carBrand != ''"> and carBrand like concat('%', #{carBrand}, '%')</if>
            <if test="carStatus != null  and carStatus != ''"> and carStatus = #{carStatus}</if>
            <if test="gpsCode != null  and gpsCode != ''"> and gpsCode = #{gpsCode}</if>
        </where>
    </select>
    
    <select id="selectOaSyscarinfoById" parameterType="Long" resultMap="OaSyscarinfoResult">
        <include refid="selectOaSyscarinfoVo"/>
        where id = #{id}
    </select>
        
    <insert id="insertOaSyscarinfo" parameterType="OaSyscarinfo" useGeneratedKeys="true" keyProperty="id">
        insert into oa_syscarinfo
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="carNumber != null">carNumber,</if>
            <if test="carXingHao != null">carXingHao,</if>
            <if test="carBrand != null">carBrand,</if>
            <if test="carColors != null">carColors,</if>
            <if test="carValue != null">carValue,</if>
            <if test="carChuChangRiQi != null">carChuChangRiQi,</if>
            <if test="carLiCheng != null">carLiCheng,</if>
            <if test="carXingShiZheng != null">carXingShiZheng,</if>
            <if test="carFaDongJiNomber != null">carFaDongJiNomber,</if>