mybatics第一次使用(初体验)

1.数据库中建表

数据库建表 dob=Date of Birth

CREATE TABLE STUDENTS ( 
	stud_id number PRIMARY KEY, 
	name varchar2(50) , 
	email varchar2(50) , 
	dob date 
); 

2.新建一个java项目

新建一个文件夹folder为lib，专门放jar包的文件夹，将mybatis-3.3.0.jar、ojdbc14.jar、junit-4.7.jar、 log4j-1.2.17.jar放进去，并将这四个jar包添加到项目环境中。

3.创建相应的package及class

package com.briup.pojo;
import java.util.Date;
public class Student {
	private Integer studId; 
	private String name; 
	private String email; 
	private Date dob;
	public Student() {
		super();
	}
	public Student(Integer studId, String name, String email, Date dob) {
		super();
		this.studId = studId;
		this.name = name;
		this.email = email;
		this.dob = dob;
	}
	public Integer getStudId() {
		return studId;
	}
	public void setStudId(Integer studId) {
		this.studId = studId;
	}
	public String getName() {
		return name;
	}
	public void setName(String name) {
		this.name = name;
	}
	public String getEmail() {
		return email;
	}
	public void setEmail(String email) {
		this.email = email;
	}
	public Date getDob() {
		return dob;
	}
	public void setDob(Date dob) {
		this.dob = dob;
	}
	@Override
	public String toString() {
		return "Student [studId=" + studId + ", name=" + name + ", email=" + email + ", dob=" + dob + "]";
	}
}

4.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="cao" />
				<property name="password" value="cao" />
			</dataSource>
		</environment>
	</environments>
	<mappers>
		<mapper resource="com/briup/mappers/StudentMapper.xml"/>
	</mappers>
</configuration>

5.新建包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>

6.在src下新建文件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 

7.com.briup.mappers包下面新建一个接口StudentMapper.java,用来对应xml文件中的sql语句(映射)

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

8.src下新建包com.test,表示存放测试类的包，在这个地下新建测试类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 testCreateStudent(){
		try {
			//获取读取mybatis配置文件的字节流
			InputStream inputStream = Resources.getResourceAsStream("mybatis-config.xml"); 
			//通过SqlSessionFactoryBuilder构建SqlSessionFactory工厂实例
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			//通过工厂获取SqlSession实例
			SqlSession sqlSession = sqlSessionFactory.openSession();
			
			StudentMapper studentMapper = sqlSession.getMapper(StudentMapper.class);
			Student s = new Student(1,"tom","123@qq.com",new Date());
			studentMapper.insertStudent(s);
			sqlSession.commit();
		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

查看数据库是否插入数据正常。。

9.将SqlSessionFactory对象提取出来封装成单独的工具类

每次读取配置文件,产生一个工厂对象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); 
	}
}