resources/mapper/ShangpinqiugouDao.xml

微信扫码关注公众号，代码整理好后第一时间通知你。

<?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.ShangpinqiugouDao">


    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        a.id as id
        ,a.name as name
        ,a.qgrid as qgrid
        ,a.phoen as phoen
        ,a.money as money
        ,a.create_time as createTime
    </sql>

    <select id="selectListView" parameterType="map" resultType="com.entity.view.ShangpinqiugouView" >
        SELECT
        <include refid="Base_Column_List" />
        FROM Shangpinqiugou  a
        <where>
            <if test=" params.name != '' and params.name != null and params.name != 'null' ">
                and a.name like CONCAT('%',#{params.name},'%')
            </if>
            <if test=" params.phoen != '' and params.phoen != null and params.phoen != 'null' ">
                and a.phoen like CONCAT('%',#{params.phoen},'%')
            </if>
            <if test=" params.moneyStart != '' and params.moneyStart != null and params.moneyStart != 'null' ">
                and a.money &gt;= #{params.moneyStartSearch}
            </if>
            <if test=" params.moneyEnd != '' and params.moneyEnd != null and params.moneyEnd != 'null' ">
                and a.money &lt;= #{params.moneyEndSearch}
            </if>
        </where>
        order by a.id desc
    </select>

</mapper>