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

最新推荐文章于 2024-02-27 19:46:59 发布

原创最新推荐文章于 2024-02-27 19:46:59 发布 · 置顶 · 1.6k 阅读

8 ·

CC 4.0 BY-SA版权

文章标签：

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

Mybatis 专栏收录该内容

4 篇文章

订阅专栏

本文详细解析了MyBatis框架中Mapper.xml文件的配置细节，包括命名空间、ResultMap、ParameterMap、SQL片段和Select语句的具体用法。通过一个具体的例子，展示了如何在Mapper.xml中定义映射关系、参数类型、SQL查询语句以及如何在Java接口中调用这些SQL查询，实现了根据关键字搜索并返回Measure实体列表的功能。

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);
    }