1.查询需求
对学生表进行条件查询,涉及姓名、性别和年龄三个字段。
2.创建学生映射器配置文件
在resources 下的mapper中创建StudentMapper.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="net.zl.mybatis.mapper.StudentMapper">
<select id="findByCondition" parameterType="java.util.Map" resultMap="studentResultMap">
SELECT * FROM t_student
<trim prefix="WHERE" prefixOverrides="AND|OR">
<if test="name != null">
s_name Like CONCAT(#{name},'%')
</if>
<if test="gender != null">
AND s_gender = #{gender}
</if>
<if test="age != null">
AND s_age = #{age}
</if>
</trim>
</select>
<resultMap id="studentResultMap" type="Student">
<result column="s_id" property="id"/>
<result column="s_name" property="name"/>
<result column="s_gender" property="gender"/>
<result column="s_age" property="age"/>
<association property="clazz" column="class_id" javaType="Clazz" select="getClazz"/>
</resultMap>
<select id="getClazz" resultType="Clazz">
SELECT c_id id, c_name name FROM t_class WHERE c_id = #{id};
</select>
</mapper>
3.在mybatis配置文件中注册配置映射器文件
4.创建映射器接口
5.创建测试类TestStudentMapper
public class TestStudentMapper {
private SqlSession sqlSession; // SQL会话
private StudentMapper studentMapper; // 学生映射器
@Before
public void init() {
try {
// 读取MyBatis配置文件作为字符输入流
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
// 基于MyBatis配置文件构建SQL会话工厂
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
// 利用SQL会话工厂获取SQL会话
sqlSession = factory.openSession();
// 利用SQL会话获取学生映射器对象
studentMapper = sqlSession.getMapper(StudentMapper.class);
} catch (IOException e) {
e.printStackTrace();
}
}
@Test
public void testFindByCondition(){
HashMap<String,Object> condition = new HashMap<>();
condition.put("gender","女");
List<Student> byCondition = studentMapper.findByCondition(condition);
byCondition.forEach(student -> System.out.println(student));
}
@Test
public void testFindByCondition1(){
HashMap<String,Object> condition = new HashMap<>();
condition.put("gender","女");
condition.put("age",19);
List<Student> byCondition = studentMapper.findByCondition(condition);
byCondition.forEach(student -> System.out.println(student));
}
@Test
public void testFindByCondition2(){
HashMap<String,Object> condition = new HashMap<>();
condition.put("gender","女");
condition.put("age",19);
condition.put("name","吴");
List<Student> byCondition = studentMapper.findByCondition(condition);
if (byCondition.size() > 0){
byCondition.forEach(student -> System.out.println(student));
}else {
System.out.println("找不到此人");
}
}
@After
public void destroy() {
// 关闭SQL会话
sqlSession.close();
}
}
测试结果如下