阅读背景:

Mybatis一个搜索框对多个字段进行模糊查询搜索

来源:互联网 

Mapper.xml文件:

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "https://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.it.master.dao.impl.MeasureDaoImpl">
    <resultMap id="AllResult"                 type="com.it.entity.master.measure.Measure">
        <result column="id"                   property="id" />
        <result column="name"                 property="name" />
        <result column="py"                   property="py" />
        <result column="memo"                 property="memo" />
        <result column="create_time"          property="createTime" />
        <result column="edit_time"            property="editTime" />
    </resultMap>
    <parameterMap id="Measure" type="com.it.entity.master.measure.Measure"/>
    <sql id="table">`measure`</sql>
    <select id="measureList" parameterType="java.util.Map" resultMap="AllResult" >
        SELECT
        *
        FROM
        <include refid="table" />
        WHERE
        1
        AND `is_del` = "N"
        <if test="keywords != null and keywords != """>
            AND CONCAT(`name`,`py`) LIKE CONCAT ("%", #{keywords},"%")
        </if>
        ORDER BY `id` ASC
    </select><?xml version="1.0" encoding="UTF-



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: