mybatis动态sql实现高级查询-mybatis学习笔记03

深藏阁楼爱情的钟 2022-04-08 12:19 457阅读 0赞

mybatis动态sql实现高级查询:  
定义个查询对象：  
![在这里插入图片描述][20181213221836506.png]  
定义一个接口写高级查询的方法：用UserQuery对象接收多个查询条件：  
![在这里插入图片描述][20181213221932434.png]接下来配置：UserMapper.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="cn.itsource.mybatis.mapper_query.UserMapper">
        
        <select id="query" parameterType="cn.itsource.mybatis.mapper_query.UserQuery"
                resultType="cn.itsource.mybatis.mapper_query.User">
    
            select * from user
    
            <where>
    
                <if test="keyWord!=null and keyWord!=''">
                    and username like concat('%',#{keyWord},'%')
                </if>
    
                <if test="minAge!=null">
                    and <![CDATA[ age>=#{minAge}]]>
                </if>
    
                <if test="maxAge!=null">
                    and <![CDATA[ age<=#{maxAge}]]>
                </if>
    
            </where>
    
        </select>
    
    </mapper>

注意：数据库的配置，和自定义Mybatis工具类和mybatis-config.xml的配置省略，  
详细配置请看 mybatis学习笔记01

![在这里插入图片描述][20181213222115914.png]![在这里插入图片描述][20181213222224799.png]测试：  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70]测试结果：  
![在这里插入图片描述][20181213222356178.png]

[20181213221836506.png]: /images/20220405/d5c5793ae4ae4a1b8612e96d3ae57f01.png
[20181213221932434.png]: /images/20220405/6cfbae9ac8c8483e86be7d7585ff1451.png
[20181213222115914.png]: https://img-blog.csdnimg.cn/20181213222115914.png
[20181213222224799.png]: /images/20220405/7788f4759b0a41d6a165102284b549d4.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70]: /images/20220405/d79703b533024aee9ba8310559349a55.png
[20181213222356178.png]: /images/20220405/fef59594321a40868bdd6bcff2a390ad.png