Day5——MyBatis helloworld Mapper接口开发

一. 回顾

前面Day3——MyBatis的helloworld(不使用Mapper接口实现MyBatis查询数据库）是不适用Mapper接口实现MyBatis，今天讲解使用Mapper接口开发实现MyBatis

前往免费下载源码

二. 知识储备

2.1 使用Mapper接口实现MyBatis的步骤

1. 提供Mapper接口（其实就是以往自己创建的DAO接口，比如EmployDao.java，现在讲解MyBatis内容，使用Mapper称之，而不是叫DAO）
2. 完成两个绑定

绑定	说明
Mapper接口与映射文件的绑定	SQL映射文件的namespace指定成接口的全类名
Mapper接口的方法与SQL语句的绑定	SQL语句的id值指定成接口的方法名

3. 获取MyBatis为Mapper接口生成的代理实现类的对象，如下:

EmployeeMapper mapper = session.getMapper(EmployeeMapper.class);

三. 例子

• 创建工程，导入jar 包，如下：
  

• 创建测试表，如下：

CREATE TABLE tbl_employee(
  id INT(11) PRIMARY KEY AUTO_INCREMENT,
	last_name VARCHAR(50),
	email VARCHAR(50),
	gender CHAR(1)
);

INSERT INTO tbl_employee VALUES (1001, '刚哥', 'gg@sina.com', '1');

SELECT * FROM tbl_employee;

• 创建JavaBean，如下：

Employee.java

package com.atguigu.mybatis.beans;

public class Employee {
     private Integer id;
     private String lastName;
     private String email;
     private String gender;
     
	public Integer getId() {
		return id;
	}
	
	public void setId(Integer id) {
		this.id = id;
	}
	
	public String getLastName() {
		return lastName;
	}
	
	public void setLastName(String lastName) {
		this.lastName = lastName;
	}
	
	public String getEmail() {
		return email;
	}
	
	public void setEmail(String email) {
		this.email = email;
	}
	
	public String getGender() {
		return gender;
	}
	
	public void setGender(String gender) {
		this.gender = gender;
	}
	
	@Override
	public String toString() {
		return "Employee [id=" + id + ", lastName=" + lastName + ", email=" + email + ", gender=" + gender + "]";
	}
     
     
}

• 创建全局配置文件，如下:
  mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?> 
<!DOCTYPE configuration  PUBLIC "-//mybatis.org//DTD Config 3.0//EN"  
"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
    <!-- 数据连接环境 -->
	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/bookstore_0416" />
				<property name="username" value="root" />
				<property name="password" value="123456" />
			</dataSource>
		</environment>
	</environments>
	
	<!-- 引入SQL映射文件 ：即xxxMapper.xml文件
	     resource： 资源所在的位置，因为EmployeeMapper.xml在类路径下（源文件夹conf下），
	                             所以只写EmployeeMapper.xml即可
	
	-->
	
	<mappers>
		<mapper resource="EmployeeMapper.xml" />
	</mappers> 
</configuration>

• 创建映射文件，如下：
  EmployeeMapper.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">


<!-- SQL映射文件/apper映射文件
     namespace: 命名空间
         1. 随便写。不使用mapper接口开发，随便写
         2. 不随便写。 使用mapper接口开发，不能随便写。必须写成接口的全类名

 -->
<mapper namespace="com.atguigu.mybatis.dao.EmployeeMapper">
	<!-- 
	  <select>:  定义查询的SQL语句
	     id:  唯一标识，namespace+id
	     resultType:  结果集的封装类型
	     #{}:  获取参数值
	 -->
	<!-- public Employee selectEmployeeById(Integer id); -->
	<select id="selectEmployeeById" resultType="com.atguigu.mybatis.beans.Employee">
	    select id, last_name lastName, email, gender from tbl_employee where id = #{id}
	</select>
	
</mapper>

• 创建Mapper接口，如下：
  EmployeeMapper.java

package com.atguigu.mybatis.dao;

import com.atguigu.mybatis.beans.Employee;

public interface EmployeeMapper {

	public Employee selectEmployeeById(Integer id);
	
}

• 创建测试方法，如下：

package com.atguigu.mybatis.test;

import java.io.InputStream;

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.Test;

import com.atguigu.mybatis.beans.Employee;
import com.atguigu.mybatis.dao.EmployeeMapper;

public class TestMyBatis {
	@Test
	public void helloWorldMapper() throws Exception {
		String resource = "mybatis-config.xml"; 
		InputStream inputStream = 
				Resources.getResourceAsStream(resource); 
		SqlSessionFactory sqlSessionFactory = 
				new SqlSessionFactoryBuilder().build(inputStream);
		
		SqlSession session = sqlSessionFactory.openSession(); 
		
		try {
			EmployeeMapper mapper = session.getMapper(EmployeeMapper.class);
			Employee employee = mapper.selectEmployeeById(1001);
			System.out.println(employee);
		} finally {
			// TODO: handle finally clause
			session.close();
		}

	}

• 测试结果，如下：