一、说明
上两篇记录了mybatis的使用
本文是记录mybatis与druid在非spring环境中整合,用到的只有三个基础包:
1、mysql-connector-java-5.1.38.jar 2、mybatis-3.4.1.jar 3、druid-0.2.9.jar
二、创建druid数据源
package com.bjx.common;
import org.apache.ibatis.datasource.unpooled.UnpooledDataSourceFactory;
import com.alibaba.druid.pool.DruidDataSource;
public class MybatisDruidSourceFactory extends UnpooledDataSourceFactory{
public MybatisDruidSourceFactory() {
this.dataSource = new DruidDataSource();
}
}
三、修改后的mybatis配置文件
<?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>
<!-- 引入外部配置资源 -->
<properties resource="jdbc.properties"></properties>
<!-- mybatis数据库连接和应用环境 -->
<environments default="dev">
<environment id="dev">
<!-- JDBC事务 -->
<transactionManager type="JDBC" />
<!--
需要修改的主要是两点:
1、POOLED:代表使用mybatis自带的连接池 ,需要修改为上面写的类,表示使用druid的数据源
2、把属性(property)中的driver改为driverClass,值不变
当然druid的很多参数也都可以通过<property />进行设置
-->
<dataSource type="com.bjx.common.MybatisDruidSourceFactory">
<!-- <property name="driver" value="${driver}" /> -->
<property name="driverClass" value="${driver}" />
<property name="url" value="${url}" />
<property name="username" value="${username}" />
<property name="password" value="${password}" />
<property name="initialSize" value="1"/>
<property name="maxActive" value="20" />
</dataSource>
</environment>
</environments>
<!-- 加载mybatis的映射文件 -->
<mappers>
<mapper resource="com/bjx/Mapping/UserMapper.xml" />
<mapper resource="com/bjx/Mapping/NewsMapper.xml" />
</mappers>
</configuration>