<!-- XML映射 --><selectid="queryStudentByMap"parameterType="map"resultType="com.sunleaf.entity.Student">
select * from student where name like concat('%',#{name},'%') and age > #{age}
</select>
<!-- XML映射 --><selectid="queryStudentByMultiParam"resultType="com.sunleaf.entity.Student">
select * from student where name like concat('%',#{name},'%') and age > #{age}
</select>
// 测试publicvoidtestQueryStudentByMultiParam(){
List<Student> students = mapper.queryStudentByMultiParam("test",20);
students.forEach(System.out::println);}
<!-- XML映射 --><selectid="queryStudentByJavaBean"parameterType="com.sunleaf.entity.Student"resultType="com.sunleaf.entity.Student">
select * from student where name like concat('%',#{name},'%') and age > #{age}
</select>
// 测试publicvoidtestQueryStudentByJavaBean(){
Student st =newStudent();
st.setName("test");
st.setAge(20);
List<Student> students = mapper.queryStudentByJavaBean(st);
students.forEach(System.out::println);}