resources/mapper/YaopinDao.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.YaopinDao">

    <!-- 通用查询结果列 -->
    <sql id="Base_Column_List">
        a.id as id
        ,a.yaopin_name as yaopinName
        ,a.yaopin_types as yaopinTypes
        ,a.yaopin_money as yaopinMoney
        ,a.yaopin_photo as yaopinPhoto
        ,a.create_time as createTime
    </sql>
    <select id="selectListView" parameterType="map" resultType="com.entity.view.YaopinView" >
        SELECT
        <include refid="Base_Column_List" />

--         级联表的字段

        FROM yaopin  a

        <where>
            <if test=" params.yaopinName != '' and params.yaopinName != null and params.yaopinName != 'null' ">
                and a.yaopin_name like CONCAT('%',#{params.yaopinName},'%')
            </if>
            <if test="params.yaopinTypes != null">
                and a.yaopin_types = #{params.yaopinTypes}
            </if>
            <if test="params.yaopinMoneyStart != null">
                <![CDATA[  and a.yaopin_money >= #{params.yaopinMoneyStart}   ]]>
            </if>
            <if test="params.yaopinMoneyEnd != null">
                <![CDATA[  and a.yaopin_money <= #{params.yaopinMoneyEnd}   ]]>
            </if>

        </where>
        order by a.${params.orderBy} desc
    </select>

</mapper>