mybatis使用工具类生成sqlSession

注：由于sqlSession的创建代价很大，所以我们要把sqlSession变成单例的。

1、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">
<mapper namespace="test">
	<insert id="insertStudent" parameterType="com.beans.Student">
		INSERT INTO STUDENT(NAME, AGE, SCORE) VALUES(#{name}, #{age}, #{score})
	</insert>
</mapper>

2、mybatis.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="mysqlEM">
		<environment id="mysqlEM">
			<transactionManager type="JDBC"/>
			<dataSource type="POOLED">
				<property name="driver" value="com.mysql.jdbc.Driver"/>
				<property name="url" value="jdbc:mysql://127.0.0.1:3306/student"/>
				<property name="username" value="duchao"/>
				<property name="password" value="123456"/>
			</dataSource>
		</environment>
	</environments>
	
	<!-- 加载映射文件 -->
	<mappers>
		<mapper resource="com/dao/mapper.xml"/>
	</mappers>
</configuration>

3、StudentDaoImpl

package com.dao;

import java.io.IOException;
import java.io.InputStream;
import java.io.Reader;

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 com.beans.Student;
import com.utils.SqlSessionUtils;

public class StudentDaoImpl implements IStudentDao {

	private SqlSession sqlSession;
	
	@Override
	public void insertStudent(Student student) {
		
		try {
			SqlSession sqlSession = SqlSessionUtils.getSqlSession();
			
			sqlSession.insert("insertStudent", student);
			
			sqlSession.commit();
		} 
		finally {
			if (sqlSession != null) {
				sqlSession.close();
			}
		}
	}

}

4、SqlSessionUtils

package com.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 SqlSessionUtils {
	
	private static SqlSession sqlSession;

	public static SqlSession getSqlSession() {
		
		try {
			InputStream inputStream = Resources.getResourceAsStream("mybatis.xml");
			SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(inputStream);
			sqlSession = sqlSessionFactory.openSession();
			return sqlSession;
			
		} catch (IOException e) {
			e.printStackTrace();
		}
		return null;
	}

}

5、MyTest

package com.test;



import org.junit.Test;

import com.beans.Student;
import com.dao.IStudentDao;
import com.dao.StudentDaoImpl;

public class MyTest {
	
	private IStudentDao dao;
	
	@org.junit.Before
	public void Before() {
		dao = new StudentDaoImpl();
	}
	
	@Test
	public void testInsert() {
		Student student = new Student("王五", 25, 95.5);
		dao.insertStudent(student);
	}

}

6、log4j.propeties

log4j.appender.console = org.apache.log4j.ConsoleAppender  

log4j.appender.console.Target = System.out  

log4j.appender.console.layout = org.apache.log4j.PatternLayout  

log4j.appender.console.layout.ConversionPattern = [%-5p] %m%n  

log4j.logger.test = debug,console