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

关注

原创最新推荐文章于 2026-04-25 09:19:06 发布 1.6k 阅读 AI 写同款· GEO 优化 ›

MyBatis-plus 模糊查询的使用主要介绍了MyBatis-plus 模糊查询的使用，文中通过示例代码介绍的非常详细，对大家的学习或者工作具有一定的参考学习价值，需要的朋友们下面随着小编来一起学习学习吧立即下载

Mapper.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.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>

接口：

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

实现类：

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