MyBatis学习笔记(三) 使用XML配置SQL映射器

Mybatis学习笔记（一）简介及初步操作

Mybatis学习笔记（二）MyBatis项目配置

工程结构

INSERT、UPDATE、DELETE、SELECT 映射语句

StudentMappers.xml

<resultMap type="Student" id="StudentResult">
    <id property="id" column="id"/><!-- 实体里的id属性对应数据库中id字段 -->
    <result property="name" column="name"/>
    <result property="age" column="age"/>
</resultMap>

<insert id="add" parameterType="Student"  >
    insert into t_student values(null,#{name},#{age})
</insert>

<update id="update" parameterType="Student">
    update t_student set name=#{name},age=#{age} where id=#{id}
</update>

<delete id="delete" parameterType="Integer">
    delete from t_student where id=#{id}
</delete>

<select id="findById" parameterType="Integer" resultType="Student">
    select * from t_student where id=#{id}
</select>

<select id="find" resultMap="StudentResult">
    select * from t_student
</select>

StudentTest类

导入Junit的jar包、

public class StudentTest2 {

	private static Logger logger=Logger.getLogger(StudentTest.class);
	private SqlSession sqlSession=null;
	private StudentMapper studentMapper=null;
	
	//测试方法前调用
	@Before
	public void setUp() throws Exception {
		sqlSession=SqlSessionFactoryUtil.openSession();
		studentMapper=sqlSession.getMapper(StudentMapper.class);
	}

        //测试方法后调用
	@After
	public void tearDown() throws Exception {
		sqlSession.close();
	}

	@Test
	public void testAdd() {
		logger.info("添加学生");
		Student student=new Student("王五",12);
		studentMapper.add(student);
		sqlSession.commit();
	}
	
	@Test
	public void testUpdate(){
		logger.info("修改学生");
		Student student=new Student(8,"王五2",13);
		studentMapper.update(student);
		sqlSession.commit();
	}
	
	@Test
	public void testDelete(){
		logger.info("删除学生");
		studentMapper.delete(8);
		sqlSession.commit();
	}
	
	@Test
	public void testFindById(){
		logger.info("通过ID查找学生");
		Student student=studentMapper.findById(1);
		System.out.println(student);
	}

	@Test
	public void testFind(){
		logger.info("查找所有学生");
		List<Student> studentList=studentMapper.find();
		for(Student s:studentList){
			System.out.println(s);
		}
	}
}