classes/production/taotaoshop/com/mapper/GoodsMapper.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.dao.GoodsMapper" >
  <resultMap id="BaseResultMap" type="com.entity.Goods" >
    <id column="id" property="id" jdbcType="INTEGER" />
    <result column="fid" property="fid" jdbcType="VARCHAR" />
    <result column="mark" property="mark" jdbcType="VARCHAR" />
    <result column="img" property="img" jdbcType="VARCHAR" />
    <result column="name" property="name" jdbcType="VARCHAR" />
    <result column="price" property="price" jdbcType="DOUBLE" />
    <result column="pubtime" property="pubtime" jdbcType="VARCHAR" />
    <result column="isdel" property="isdel" jdbcType="VARCHAR" />
    <result column="uid" property="uid" jdbcType="VARCHAR" />
    <result column="kcnum" property="kcnum" jdbcType="INTEGER" />
    <result column="xnum" property="xnum" jdbcType="INTEGER" />
    <result column="tpstatus" property="tpstatus" jdbcType="VARCHAR" />
    <result column="shuoming" property="shuoming" jdbcType="VARCHAR" />
    <result column="ftype" property="ftype" jdbcType="VARCHAR" />
    <result column="ftime" property="ftime" jdbcType="VARCHAR" />
    <result column="fprice" property="fprice" jdbcType="VARCHAR" />
    <result column="isshow" property="isshow" jdbcType="VARCHAR" />
  </resultMap>
  <resultMap id="ResultMapWithBLOBs" type="com.entity.Goods" extends="BaseResultMap" >
    <result column="miaoshu" property="miaoshu" jdbcType="LONGVARCHAR" />
  </resultMap>
  <sql id="Base_Column_List" >
    id, fid, mark, img, name, price, pubtime, isdel, uid, kcnum, xnum, tpstatus, shuoming, 
    ftype, ftime, fprice, isshow
  </sql>
  <sql id="Blob_Column_List" >
    miaoshu
  </sql>
  <select id="selectByPrimaryKey" resultMap="ResultMapWithBLOBs" parameterType="java.lang.Integer" >
    select 
    <include refid="Base_Column_List" />
    ,
    <include refid="Blob_Column_List" />
    from goods
    where id = #{id,jdbcType=INTEGER}
  </select>
  <select id="getCount"  resultType="int" parameterType="java.util.Map" >
    select  count(*) from goods  where isdel="1" 
   <if test="name!=null ">
     and name like concat('%',#{name,jdbcType=VARCHAR},'%')
     </if>
      <if test="tpstatus!=null ">
     and tpstatus =#{tpstatus,jdbcType=VARCHAR}
     </if>
      <if test="fid != null" >
      and  fid = #{fid,jdbcType=VARCHAR}
      </if>
      <if test="mark != null" >
      and  mark  like concat('%',#{mark,jdbcType=VARCHAR},'%')
      </if>
      <if test="price != null" >
        and price = #{price,jdbcType=DOUBLE}
      </if>
      <if test="uid != null" >
       and uid = #{uid,jdbcType=VARCHAR}
      </if>