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

 Mapper.xml文件：

 1 <?xml version="1.0" encoding="UTF-8" ?>
 2 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 3 <mapper namespace="com.it.master.dao.impl.MeasureDaoImpl">
 4     <resultMap id="AllResult"                 type="com.it.entity.master.measure.Measure">
 5         <result column="id"                   property="id" />
 6         <result column="name"                 property="name" />
 7         <result column="py"                   property="py" />
 8         <result column="memo"                 property="memo" />
 9         <result column="create_time"          property="createTime" />
10         <result column="edit_time"            property="editTime" />
11     </resultMap>
12     <parameterMap id="Measure" type="com.it.entity.master.measure.Measure"/>
13     <sql id="table">`measure`</sql>
14     <select id="measureList" parameterType="java.util.Map" resultMap="AllResult" >
15         SELECT
16         *
17         FROM
18         <include refid="table" />
19         WHERE
20         1
21         AND `is_del` = 'N'
22         <if test="keywords != null and keywords != ''">
23             AND CONCAT(`name`,`py`) LIKE CONCAT ('%', #{keywords},'%')
24         </if>
25         ORDER BY `id` ASC
26     </select>

 

接口：

 

1 public interface MeasureDao { 
2     List<Measure> measureList(String keywords); 
3 }

 

 

实现类：

1 @Repository
2 public class MeasureDaoImpl extends BaseDao implements MeasureDao {
3     @Override
4     public List<Measure> measureList(final String keywords) {
5         final Map m = new HashMap<>(1);
6         m.put("keywords", keywords);
7         return super.getSqlSession().selectList(super.getStatement("measureList"), m);
8     }

 

posted @ 2019-10-08 16:54  Chery-Qi  阅读(1802)  评论(0)    收藏  举报