MyBatis接口式编程

MyBatis接口式编程

1.创建数据库

2.创建Java项目，生成实体类：Info

package bean;

public class Info {
	private Integer id;
	private String sex;
	private String name;
	private Integer age;

	public Integer getId() {
		return id;
	}

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

	public String getSex() {
		return sex;
	}

	public void setSex(String sex) {
		this.sex = sex;
	}

	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 "Info [id=" + id + ", sex=" + sex + ", name=" + name + ", age=" + age + "]";
	}

}

3.创建文件夹，导入jar

4.创建接口：InfoDao

package dao;

import bean.Info;

public interface Infodao {
	public Info getInfo(Integer id);

}

5.创建sql映射文件：InfoMapper.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="dao.Infodao">
	<!-- 编写sql语句 -->
	<select id="getInfo" resultType="bean.Info">
		select * from info where id = #{id}
			</select>
</mapper>

namespace命名空间:接口的全类名
id唯一标识：接口中的方法名
resultType返回值类型：实体类的全类名

6.编写全局配置文件：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">
			<!-- 数据库连接池  JDBC -->
			<transactionManager type="JDBC" />
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver" />
				<property name="url" value="jdbc:mysql://localhost:3306/my_test" />
				<property name="username" value="root" />
				<property name="password" value="123" />
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<!-- 引用内部文件，即sql映射文件 -->
		<mapper resource="InfoMapper.xml" />
	</mappers>
</configuration>

7.编写测试类:InfoTest

package Test;

import java.io.IOException;
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 bean.Info;
import dao.Infodao;

public class InfoTest {
@Test
	public void test1() throws IOException {
		// 引用全局配置文件
		String resource = "mybatis_config.xml";
		InputStream inputStream = Resources.getResourceAsStream(resource);
		// 2.获取SqlSessionFactory对象
		SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
		// 3.获取sqlSession对象，开启事务
		SqlSession session = sqlSessionFactory.openSession();
		try {
			// 4.获取接口的实现类对象
			Infodao infodao = session.getMapper(Infodao.class);
			Info info = infodao.getInfo(1);
			System.out.println(info);
		} finally {
			// 关闭事务
			session.close();
		}
	}

}

8.JUnit Test 运行

总结

1.接口式编程 原生：dao ==> daoimpl mybatis: mapper ==> xxMapper.xml

2.SqlSession代表和数据库会话：sqlSessionFactory.openSession();用完关闭

3.SqlSession和connection一样都是非线程安全，每次使用都要获取新的对象，不可以共用

4.mapper没有实现类，但是mybatis会为我们生成一个代理对象。（接口与xml通过id="getEmpById"和namespace="dao.EmployeeMapper"绑定）

eg:EmployeeMapper mapper =sqlSession.getMapper(EmployeeMapper.class);

5.两个配置文件：

mybatis的全局配置文件MyBatis-config.xml：包含数据库连接池、jdbc等信息

sql映射文件EmployeeMapper.xml：保存了每一个sql语句的映射文件