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

    }

}

巴特西

Mybatis中的复合条件查询

最新文章

热门文章