WebRoot/WEB-INF/classes/com/javapandeng/mapper/ItemMapper.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.javapandeng.mapper.ItemMapper">
    <!--实体类与数据库映射字段部分-->
    <resultMap id="ResultMapItem" type="com.javapandeng.po.Item">
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="name" column="name" jdbcType="VARCHAR"/>
        <result property="price" column="price" jdbcType="VARCHAR"/>
        <result property="zk" column="zk" jdbcType="INTEGER"/>
        <result property="scNum" column="scNum" jdbcType="INTEGER"/>
        <result property="gmNum" column="gmNum" jdbcType="INTEGER"/>
        <result property="url1" column="url1" jdbcType="VARCHAR"/>
        <result property="url2" column="url2" jdbcType="VARCHAR"/>
        <result property="url3" column="url3" jdbcType="VARCHAR"/>
        <result property="url4" column="url4" jdbcType="VARCHAR"/>
        <result property="url5" column="url5" jdbcType="VARCHAR"/>
        <result property="ms" column="ms" jdbcType="VARCHAR"/>
        <result property="pam1" column="pam1" jdbcType="VARCHAR"/>
        <result property="pam2" column="pam2" jdbcType="VARCHAR"/>
        <result property="pam3" column="pam3" jdbcType="VARCHAR"/>
        <result property="val1" column="val1" jdbcType="VARCHAR"/>
        <result property="val2" column="val2" jdbcType="VARCHAR"/>
        <result property="val3" column="val3" jdbcType="VARCHAR"/>
        <result property="type" column="type" jdbcType="INTEGER"/>
        <result property="categoryIdOne" column="category_id_one" jdbcType="INTEGER"/>
        <result property="categoryIdTwo" column="category_id_two" jdbcType="INTEGER"/>
        <result property="isDelete" column="isDelete" jdbcType="INTEGER"/>
        <association property="yiji" column="category_id_one" select="com.javapandeng.mapper.ItemCategoryMapper.load"/>
        <association property="erji" column="category_id_two" select="com.javapandeng.mapper.ItemCategoryMapper.load"/>
        <collection property="pls" column="id" ofType="com.javapandeng.po.Comment" select="com.javapandeng.mapper.CommentMapper.listByItemId"/>
    </resultMap>

    <!-- 声明数据库字段 -->
    <sql id="Item_field">
        id,name,price,zk,scNum,gmNum,url1,url2,url3,url4,url5,ms,pam1,pam2,pam3,val1,val2,val3,type,category_id_one,category_id_two,isDelete
    </sql>

    <!-- 实体类属性-->
    <sql id="Item_insert">
        #{id},#{name},#{price},#{zk},#{scNum},#{gmNum},#{url1},#{url2},#{url3},#{url4},#{url5},#{ms},#{pam1},#{pam2},#{pam3},
        #{val1},#{val2},#{val3},#{type},#{categoryIdOne},#{categoryIdTwo},#{isDelete}
    </sql>

    <!-- 更新结果  -->
    <sql id="Item_update">
        <if test="name != null">
            name = #{name},
        </if>
        <if test="price != null">
            price = #{price},
        </if>
        <if test="zk != null">
            zk = #{zk},
        </if>
        <if test="scNum != null">
            scNum = #{scNum},
        </if>
        <if test="gmNum != null">
            gmNum = #{gmNum},
        </if>