Mybatis多条件直接查询Param注解版

阳光穿透心脏的1/2处 2021-12-12 15:27 422阅读 0赞

## 1.UserMapper接口 ##

package com.william.dao;
    
    import com.william.domain.QueryValueObject;
    import com.william.domain.User;
    
    import java.util.List;
    
    public interface UserMapper {
     /**
         * 多条件直接查询Param注解版
         * @param username
         * @param sex
         * @param startIndex
         * @param pageSize
         * @return
         */
        public List<User> findByManyConditionByParam(@Param("username") String username, @Param("sex") String sex, @Param("startIndex")Integer startIndex,@Param("pageSize") Integer pageSize);
    }

## 2.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="com.william.dao.UserMapper">
        
        <select id="findByManyConditionByParam"  resultType="user">
            select * from user where username like "%"#{username}"%" and sex=#{sex}
           limit #{startIndex},#{pageSize}
        </select>
    </mapper>

## 3.TestCrud测试类 ##

package com.william;
    
    import com.william.dao.UserMapper;
    import com.william.domain.QueryValueObject;
    import com.william.domain.User;
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    import org.junit.Test;
    
    import javax.annotation.Resource;
    import java.io.IOException;
    import java.io.InputStream;
    import java.util.List;
    
    /**
     * @author ：lijunxuan
     * @date ：Created in 2019/7/12  10:16
     * @description ：
     * @version: 1.0
     */
    public class TestCrud {
     
      /**
         * Mybatis多条件直接查询Param注解版
         * @throws IOException
         */
        @Test
        public void findByManyConditionByParam() throws IOException {
            InputStream inputStream = Resources.getResourceAsStream("Mybatis-configuration.xml");
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
            SqlSession sqlSession = sqlSessionFactory.openSession();
            //获取某接口的动态代理对象（获取某接口的一个实现类）
            UserMapper userMapper = sqlSession.getMapper(UserMapper.class);
            QueryValueObject queryValueObject = new QueryValueObject();
            List<User> userMapperByConditionByMap = userMapper.findByManyConditionByParam("a","男",0,7);
            for (User user1 : userMapperByConditionByMap) {
                System.out.println(user1);
            }
            sqlSession.close();
        }
    }

## 4.测试结果 ##

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3NpbmF0XzM5MTc5OTkz_size_16_color_FFFFFF_t_70]: /images/20211210/5030ff8aa5cc446c98f4e2c05aa064d2.png