Mybatis中的复合条件查询

1.Map中根据字段名存儲:

　　定义接口:List<Student> selectByCondition1(Map<String,Object> map);

　　映射文件:

<select id="selectByCondition1" resultType="com.framework.entity.Student">
     select * from stu
            where name like '%' #{name} '%' and age &lt; #{age}
</select>

　　测试类:

public void test(){
    Map<String,Object> map = new HashMap<String,Object>();
    map.put("name", "Yang");
    map.put("age", "17");
    List<Student> students = dao.selectByCondition(map);
    for (Student student : students){
        System.out.println(student);
    }
}

2.Map中存儲对象

　　定义接口:List<Student> selectByCondition2(Map<String,Object> map);

　　映射文件:

<select id="selectByCondition2" resultType="com.framework.entity.Student">
     select * from stu
            where name like '%' #{stu1.name} '%' and age &lt; #{stu2age}
</select>

　　测试类:

public void test(){
    Map<String,Object> map = new HashMap<String,Object>();
    Student stu1 = new Student();
    Student stu2 = new Student();
    map.put("stu1", stu1);
    map.put("stu2", stu2);
    List<Student> students = dao.selectByCondition(map);
    for (Student student : students){
        System.out.println(student);
    }
}

 

转载于:https://www.cnblogs.com/Joey44/p/9993110.html