文章目录
一、对学生表进行条件查询,涉及姓名、性别和年龄。
1、创建学生表
2、创建学生实体类
二、创建学生映射文件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.cw.mybatis.mapper.StudentMapper">
<select id="findByCondition" parameterType="java.util.Map" resultMap="studentResultMap">
SELECT * FROM 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 class WHERE c_id = #{id};
</select>
</mapper>
三、在mybatis-config.xml文件里配置实体类别名和映射文件
四、 定义学生映射接口StudentMapper
package net.cw.mybatis.mapper;
import net.cw.mybatis.bean.Student;
import java.util.List;
import java.util.Map;
public interface StudentMapper {
List<Student> findByCondition(Map<String, Object> condition);
}
五、 创建测试程序TestStudentMapper
package net.cw.mybatis.mapper;
import net.cw.mybatis.bean.Student;
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.After;
import org.junit.Before;
import org.junit.Test;
import java.io.IOException;
import java.io.Reader;
import java.util.HashMap;
import java.util.List;
public class TestStudentMapper {
private SqlSession session;
private StudentMapper studentMapper;
@Before
public void init() {
try {
Reader reader = Resources.getResourceAsReader("mybatis-config.xml");
SqlSessionFactory factory = new SqlSessionFactoryBuilder().build(reader);
session = factory.openSession();
studentMapper = session.getMapper(StudentMapper.class);
} catch (IOException e) {
e.printStackTrace();
}
}
@Test
public void testFindByCondition() {
HashMap<String, Object> condition = new HashMap<String, Object>();
condition.put("gender", "女");
List<Student> students = studentMapper.findByCondition(condition);
for (Student student : students) {
System.out.println(student);
}
}
@After
public void destroy() {
session.close();
}
}
1、 运行testFindByCondition()方法,查看结果
2、修改查询条件,查询19岁的女生,并运行testFindByCondition()