MyBatis原生环境搭建

1. mybatis-druid.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="mybatis.DruidDataSourceFactory">
				<property name="driverClass" value="com.mysql.jdbc.Driver"/>
				<property name="url" value="jdbc:mysql://127.0.0.1:3306/test"/>
				<property name="username" value="admin"/>
				<property name="password" value="admin"/>
				<property name="validationQuery" value="select now()"/>
				<property name="testWhileIdle" value="true"/>
				<property name="testOnBorrow" value="false"/>
				<property name="testOnReturn" value="false"/>
				<property name="poolPreparedStatements" value="false"/>
				<property name="maxOpenPreparedStatements" value="-1"/>
			</dataSource>
		</environment>
	</environments>
	
	<mappers>
        <!-- src/main/resources -->
        <mapper resource="mappers/testMapper.xml"/>
    </mappers>
    
</configuration>

2. 使用Druid作为连接池

package mybatis;

import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;

import com.alibaba.druid.pool.DruidDataSource;

public class DruidDataSourceFactory extends UnpooledDataSourceFactory {
	
	public DruidDataSourceFactory() {  
        this.dataSource = new DruidDataSource();  
    }  
}

3. 创建SessionFactory

package mybatis;

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

import org.apache.ibatis.io.Resources;
import org.apache.ibatis.session.SqlSessionFactory;
import org.apache.ibatis.session.SqlSessionFactoryBuilder;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import conf.SysConstants;

public class MyBatisTemplate {
	
	public static Logger logger = LoggerFactory.getLogger(MyBatisTemplate.class);
	
	private static MyBatisTemplate myBatisTemplate = null;
	
	private static ThreadLocal<SqlSessionFactory> sessionFactoryThreadLocal = new ThreadLocal<SqlSessionFactory>(); 
	
	private MyBatisTemplate(){ }
	
	public static MyBatisTemplate getInstance() {
		if(myBatisTemplate == null)
			myBatisTemplate = new MyBatisTemplate();
		return myBatisTemplate;
	}
	
	public SqlSessionFactory getSessionFactory(){
		SqlSessionFactory sessionFacroty = sessionFactoryThreadLocal.get();
		if(null == sessionFacroty){
			sessionFacroty = init();
			sessionFactoryThreadLocal.set(sessionFacroty);
		}
		
		return sessionFacroty;
	}
	
	public static SqlSessionFactory init() {
		Reader reader = null;
		try {
            //src/main/resources
		    reader = Resources.getResourceAsReader("mybatis-druid.xml");
		} catch (IOException e) {
			logger.error("[JDBC Exception] --> "
					+ "Failed to configured the Druid DataSource, the exceprion message is:" + e.getMessage());
		}
		return new SqlSessionFactoryBuilder().build(reader);
	}

}

 

转载于:https://my.oschina.net/jos/blog/1509694