src/com/mapper/OrdersMapper.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.OrdersMapper">
  <resultMap id="BaseResultMap" type="com.entity.Orders">
    <id column="id" jdbcType="INTEGER" property="id" />
    <result column="ordercode" jdbcType="VARCHAR" property="ordercode" />
    <result column="uid" jdbcType="INTEGER" property="uid" />
    <result column="bid" jdbcType="INTEGER" property="bid" />
    <result column="price" jdbcType="VARCHAR" property="price" />
    <result column="start" jdbcType="VARCHAR" property="start" />
    <result column="end" jdbcType="VARCHAR" property="end" />
    <result column="status" jdbcType="VARCHAR" property="status" />
    <result column="cateid" jdbcType="VARCHAR" property="cateid" />
    <result column="baoxian" jdbcType="VARCHAR" property="baoxian" />
  </resultMap>
  <sql id="Base_Column_List">
    id, ordercode, uid, bid, price, start, end, status, cateid,baoxian
  </sql>
  <select id="checkUname"  parameterType="java.util.Map" resultMap="BaseResultMap" >
    select 
    <include refid="Base_Column_List" />
    from orders
    where username = #{username,jdbcType=VARCHAR} 
  </select>
   <select id="getTongJi"   resultType="com.entity.TongJi" parameterType="java.util.Map" >
    select  sum(price) as zprice, count(*) as amount from orders  where 1=1
    <if test="stime != null and etime !=null">
      and start between #{stime} and #{etime}
    </if>
  </select> 
 <select id="getCount"   resultType="int" parameterType="java.util.Map" >
    select  count(*) from orders  where 1=1
    <if test="ordercode != null">
      and  ordercode= #{ordercode,jdbcType=VARCHAR}
      </if>
      <if test="uid != null">
     and  uid= #{uid,jdbcType=INTEGER}
      </if>
      <if test="bid != null">
      and bid= #{bid,jdbcType=INTEGER}
      </if>
      <if test="price != null">
      and price=  #{price,jdbcType=VARCHAR}
      </if>
      <if test="start != null">
      and start= #{start,jdbcType=VARCHAR}
      </if>
      <if test="end != null">
      and end= #{end,jdbcType=VARCHAR}
      </if>
      <if test="status != null">
      and status= #{status,jdbcType=VARCHAR}
      </if>
      <if test="cateid != null">
      and cateid= #{cateid,jdbcType=VARCHAR}
      </if>
  </select> 
  <select id="getAll"   resultMap="BaseResultMap" parameterType="java.util.Map" >
    select   <include refid="Base_Column_List" /> from orders  where 1=1
     <if test="ordercode != null">