Mybatis多条件直接查询

╰半夏微凉° 2021-12-12 15:25 459阅读 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 username
         * @param sex
         * @param startIndex
         * @param pageSize
         * @return
         */
        public List<User> findByManyCondition(String username,String sex,Integer startIndex,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="findByManyCondition"  resultType="user">
            select * from user where username like "%"#{param1}"%" and sex=#{param2}
           limit #{param3},#{param4}
        </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 {
     
     /**
         * 多条件直接查询
         * @throws IOException
         */
        @Test
        public void findByManyCondition() 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.findByManyCondition("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/7d2b9997bc1d48efb1fc4dfdb27550be.png