环境快速搭建测试——MyBatis（正常搭建测试）

Mybatis快速搭建环境并测试有两种方法： 

一种是 常见流程（导包，配置文件，建表，写po类，写mapper接口及xml，测试代码运行）；

另一种是通过 mybatis逆向工程 直接通过 数据库表单 生成  pojo类和Mapper，适合已有数据库（项目迁移）的情况。更快速。

法一： （oracle数据库）

①数据库建表

dob = Date of Birth

drop table students;
create table students ( 
	stud_id number PRIMARY KEY, 
	name varchar2(50) , 
	email varchar2(50) , 
	dob date 
); 

②创建项目，创建好对应的pojo类

package com.briup.pojo;
import java.util.Date;
public class Student {
	private Integer studId; 
	private String name; 
	private String email; 
	private Date dob;
	get/set...
}

③项目中引入mybatis的核心包以及可选的依赖包

    必须的包  mybatis-3.3.0.jar    ojdbc14.jar

    可选的包  junit-4.7.jar        log4j-1.2.17.jar

④mybatis中的配置文件和映射文件分别引入到项目中

src下面的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>
	<typeAliases>
		<typeAlias type="com.briup.pojo.Student" alias="Student" />
	</typeAliases>


	<environments default="development">
		<environment id="development">
			<transactionManager type="JDBC"></transactionManager>
			<dataSource type="POOLED">
				<property name="driver" value="oracle.jdbc.driver.OracleDriver" /> 
				<property name="url" value="jdbc:oracle:thin:@127.0.0.1:1521:XE" /> 
				<property name="username" value="test" />
				<property name="password" value="test" />
			</dataSource>
		</environment>
	</environments>
	
	<mappers>
		<mapper resource="com/briup/mappers/StudentMapper.xml"/>
	</mappers>
	
</configuration>

com.briup.mappers包下面的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">
<!-- com.briup.mappers.StudentMapper是我们定义接口的全限定名字 这样就可以使用接口调用映射的SQL语句了 这个名字一定要和接口对应上-->
<mapper namespace="com.briup.mappers.StudentMapper">

<resultMap type="Student" id="StudentResult">
	<id property="studId" column="stud_id" />
	<result property="name" column="name" />
	<result property="email" column="email" />
	<result property="dob" column="dob" />
</resultMap>

<select id="findAllStudents" resultMap="StudentResult">
	SELECT * FROM STUDENTS
</select>

<!-- 列名和属性名字不一致可以给查询的列起一个别名 -->
<select id="findStudentById" parameterType="int" resultType="Student">
	SELECT STUD_ID AS STUDID,NAME,EMAIL,DOB
	FROM STUDENTS
	WHERE
	STUD_ID=#{id}
</select>
<insert id="insertStudent" parameterType="Student"> 
	INSERT INTO
	STUDENTS(STUD_ID,NAME,EMAIL,DOB) 
	VALUES(#{studId},#{name},#{email},#{dob}) 
</insert>
</mapper>

⑤配置log4j.properties文件中的日志输出:

log4j.rootLogger=DEBUG, stdout 
log4j.appender.stdout=org.apache.log4j.ConsoleAppender 
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout 
log4j.appender.stdout.layout.ConversionPattern=%d [%-5p] %c - %m%n
#show sql
log4j.logger.java.sql.ResultSet=INFO  
log4j.logger.org.apache=INFO  
log4j.logger.java.sql.Connection=DEBUG  
log4j.logger.java.sql.Statement=DEBUG  
log4j.logger.java.sql.PreparedStatement=DEBUG 

⑥建立Mapper接口，用来对应xml文件中的sql语句(映射),从而方便我们调用

package com.briup.mappers;
import java.util.List;
import com.briup.pojo.Student;

//创建映射器Mapper接口StudentMapper
//方法名和StudentMapper.xml中定义的SQL映射定义名相同
//这个其实就是dao层接口(数据访问层,负责和数据库进行交互)
public interface StudentMapper {
	List<Student> findAllStudents(); 
	Student findStudentById(Integer id); 
	void insertStudent(Student student);
}

⑦创建一个测试类StudentMapperTest.java

package test;
import java.io.InputStream;
import java.util.Date;

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.briup.mappers.StudentMapper;
import com.briup.pojo.Student;

public class StudentMapperTest {
	
	@Test
	public void test_insert(){
		
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); 
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			SqlSession sqlSession = sqlSessionFactory.openSession();
			
			StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);
			Student s = new Student(1,"tom","123@briup.com",new Date());
			studentMapper.insertStudent(s);
			sqlSession.commit();
		} catch (Exception e) {
			e.printStackTrace();
		}
		
	}
}

⑧运行成功后会在控制台中看到log4j日志输出的这个程序运行的相关信息

⑨ 对mybatis的一些基本封装

每次读取配置文件,产生一个工厂对象SqlSessionFactory,然后再生成出SqlSession对象,这个过程虽然并不复杂,但是也都是一些重复的代码流程,所以我们可以对其进行一个简单的封装:

package com.briup.utils;

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;

public class MyBatisSqlSessionFactory {
	private static SqlSessionFactory sqlSessionFactory;
	
	public static SqlSessionFactory getSqlSessionFactory(){
		if(sqlSessionFactory == null){
			InputStream inputStream = null;
			try {
				inputStream = Resources.getResourceAsStream("mybatis-config.xml"); 
				sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			} catch (IOException e) {
				e.printStackTrace();
				throw new RuntimeException(e.getCause());
			}
		}
		return sqlSessionFactory;
	}
	
	public static SqlSession openSession() { 
		return openSession(false); 
	}
	public static SqlSession openSession(boolean autoCommit) { 
		return getSqlSessionFactory().openSession(autoCommit); 
	}
	
}

之后每次使用的时候只需要调用该类中的静态方法openSession即可
上面的代码可简写为: //注意事务是自动提交还是手动提交
MyBatisSqlSessionFactory.openSession().getMapper(StudentMapper.class).insertStudent(s);

*******************************************************
注意:xml文件中写的sql语句,最后面不要写分号,否则会报错误,ORA-00911: 无效字符
*******************************************************