MyBatis映射文件<mapper>

1.概述

< select>元素

1.概述

3.< insert>元素

1.简介

4. update和delete

5.< sql>元素

1.简介

resultMap元素

1.简介

举例说明

新建User实体类

package com.lin.po;

public class User {

	private Integer id;
	private String name;
	private Integer age;

	public Integer getId() {
		return id;
	}

	public void setId(Integer id) {
		this.id = id;
	}

	public String getName() {
		return name;
	}

	public void setName(String name) {
		this.name = name;
	}

	public Integer getAge() {
		return age;
	}

	public void setAge(Integer age) {
		this.age = age;
	}

	@Override
	public String toString() {
		return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
	}

}

建立Mapper.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">
<!-- namespace表示命名空间 -->
<mapper namespace="com.lin.po.User">
	<resultMap type="com.lin.po.User" id="resultMap">
		<id property="id" column="t_id"></id>
		<result property="name" column="t_name"></result>
		<result property="age" column="t_age"></result>
	</resultMap>

	<select id="findAllUser" resultMap="resultMap">
		select * from t_user
	</select>
</mapper>

在mybatis-config.xml中添加mapper依赖

<mappers>
		<mapper resource="com/lin/po/CustomerMapper.xml" />
		<mapper resource="com/lin/po/UserMapper.xml" />
	</mappers>

下面是测试类
工具类在上篇写了，这里不做过多讲师

//测试ResultMap
	@Test
	public void findAllUserTest() {
		//通过工具类获取SqlSession
		SqlSession sqlSession=	MybatisUtils.getSqlSession();
		//执行SqlSeesion执行文件中定义的SQL，并返回结果集
		List<User> list=sqlSession.selectList("com.lin.po.User.findAllUser");
		for (User user : list) {
			System.out.println(user);
		}
		
		//关闭sqlSession
		sqlSession.close();
	}