DruidDataSourceFactory如何设置方言

2024-11-09 19:20:45

1、jar包依赖Druid依赖代码<dependency><groupId>com.alibaba</groupId><artifactId>druid</artifactId><version>0.2.15</version></dependency>

2、applicationContext-resources.xml 配置数据库连接池，以mysql数据库为例Xml代码<beanid="dataSource"class="com.alibaba.druid.pool.DruidDataSource"init-method="init"destroy-method="close"><propertyname="url"value="jdbc:mysql://127.0.0.1:3306/XXX"/><propertyname="username"value="root"/><propertyname="password"value="root"/><propertyname="maxActive"value="20"/><propertyname="initialSize"value="1"/><propertyname="maxWait"value="60000"/><propertyname="minIdle"value="1"/><propertyname="timeBetweenEvictionRunsMillis"value="3000"/><propertyname="minEvictableIdleTimeMillis"value="300000"/><propertyname="validationQuery"value="SELECT'x'FROMDUAL"/><propertyname="testWhileIdle"value="true"/><propertyname="testOnBorrow"value="false"/><propertyname="testOnReturn"value="false"/><propertyname="filters"value="stat"/></bean>

3、内置监控界面使用配置修改web.xml，加入如下内容：Xml代码<servlet><servlet-name>DruidStatView</servlet-name><servlet-class>com.alibaba.druid.support.http.StatViewServlet</servlet-class></servlet><servlet-mapping><servlet-name>DruidStatView</servlet-name><url-pattern>/druid/*</url-pattern></servlet-mapping>然后访问druid/index.html页面。

4、通过访问druid/index.html 可以查看项目的运行情况，也可以分析SQL语句的执行情况，便于调优详见图。

5、在spring和hibernate结合的框架中配置配置druid<bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">  <property name="driverClassName" value="${jdbc.driverClassName}"></property><property name="url" value="${jdbc.url}"></property><property name="username" value="${jdbc.username}"></property><property name="password" value="${jdbc.password}"></property>

6、MyBatis在非Spring环境下第三方DataSource设置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="userDefine"> <environment id="userDefine"> <transactionManager type="JDBC" />  <dataSource type="com.chenjun.mysite.common.MyselfDefineDataSourceFactory"> <property name="driverClass" value="com.mysql.jdbc.Driver"/> <property name="url" value="jdbc:mysql://localhost:3306/site-aliyun"/> <property name="username" value="root"/> <property name="password" value="123456"/> </dataSource> </environment> </environments> <mappers> <mapper resource="mappings/modules/sys/userDao.xml"/> </mappers></configuration>