数据源配置

1.CommonDbUtilsDao.java

package com.jdrx.ecis.core.dao;


import java.sql.SQLException;
import java.util.List;
import java.util.Map;


import javax.sql.DataSource;


import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.ArrayHandler;
import org.apache.commons.dbutils.handlers.ArrayListHandler;
import org.apache.commons.dbutils.handlers.BeanHandler;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.commons.dbutils.handlers.ColumnListHandler;
import org.apache.commons.dbutils.handlers.MapHandler;
import org.apache.commons.dbutils.handlers.MapListHandler;
import org.apache.commons.dbutils.handlers.ScalarHandler;


public class CommonDbUtilsDAO  {

DataSource dataSource;

public Object[] query(String sql,Object[] argus) throws SQLException{
QueryRunner qr=new QueryRunner(dataSource);
return qr.query(sql, new ArrayHandler(),argus);
}


public List<Object[]> queryListArray(String sql,Object[] argus) throws SQLException{
QueryRunner qr=new QueryRunner(dataSource);
    return  qr.query(sql,new ArrayListHandler() ,argus);
}


public <T> T queryObjectList(String sql,Object[] argus,Class<T> clazz) throws SQLException{
QueryRunner qr=new QueryRunner(dataSource);
return  qr.query(sql,new BeanHandler<T>(clazz) , argus);
}

public <T> List<T> queryListArray2(String sql,Object[] argus,Class<T> clazz) throws SQLException{
QueryRunner qr=new QueryRunner(dataSource);
List<T> acclist = qr.query(sql,new BeanListHandler<T>(clazz),argus);
return acclist;
}


public Map<String,Object> get(String sql,Object[] argus) throws SQLException{
QueryRunner qr=new QueryRunner(dataSource);
return qr.query(sql,new MapHandler(),argus );
}

public  List<Map<String, Object>> queryMapList(String sql,Object[] argus) throws SQLException{
QueryRunner qr=new QueryRunner(dataSource);
return qr.query(sql,new MapListHandler(),argus );
}


public  List<Map<String, Object>> queryColumnList(String sql,Object[] argus,String clumnName) throws SQLException{
QueryRunner qr=new QueryRunner(dataSource);
return (List<Map<String, Object>>) qr.query(sql,new ColumnListHandler(clumnName) );
}


public long count(String sql,Object[] argus) throws SQLException{
QueryRunner qr=new QueryRunner(dataSource);
        Long count = (Long)qr.query(sql,new ScalarHandler(1),argus );
        return count;
}


public void setDataSource(DataSource dataSource) {
this.dataSource = dataSource;
}
 
}

2.spring 配置文件

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context" xmlns:jdbc="http://www.springframework.org/schema/jdbc"  
xmlns:jee="http://www.springframework.org/schema/jee" xmlns:tx="http://www.springframework.org/schema/tx"
    xmlns:util="http://www.springframework.org/schema/util" xmlns:task="http://www.springframework.org/schema/task" xsi:schemaLocation="
http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd
http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.0.xsd
http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-4.0.xsd
http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-4.0.xsd
http://www.springframework.org/schema/util http://www.springframework.org/schema/util/spring-util-4.0.xsd
http://www.springframework.org/schema/task http://www.springframework.org/schema/task/spring-task-4.0.xsd"
default-lazy-init="true">


<description>Spring azkaban DS Configuration</description>

    <!-- 加载配置属性文件 -->
<!-- <context:property-placeholder ignore-unresolvable="true" location="classpath:azkaban.properties" /> -->

    <bean id="azkaBanDbUtilsDAO" class="com.jdrx.ecis.core.dao.CommonDbUtilsDAO">
    
    <property name="dataSource" ref="azkaBanDataSource" />
    </bean>
    
<!-- 数据源配置, 使用 BoneCP 数据库连接池 -->
<bean id="azkaBanDataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close"> 
   <!-- 数据源驱动类可不写，Druid默认会自动根据URL识别DriverClass -->
   <property name="driverClassName" value="com.mysql.jdbc.Driver" />
   
<!-- 基本属性 url、user、password -->
<property name="url" value="jdbc:mysql://192.168.10.202:3306/azkaban"/>
<property name="username" value="root" />
<property name="password" value="root" />

<!-- 配置初始化大小、最小、最大 -->
<property name="initialSize" value="1" />
<property name="minIdle" value="3" /> 
<property name="maxActive" value="20" />

<!-- 配置获取连接等待超时的时间 -->
<property name="maxWait" value="60000" />

<!-- 配置间隔多久才进行一次检测，检测需要关闭的空闲连接，单位是毫秒 -->
<property name="timeBetweenEvictionRunsMillis" value="60000" />

<!-- 配置一个连接在池中最小生存的时间，单位是毫秒 -->
<property name="minEvictableIdleTimeMillis" value="300000" />

<property name="validationQuery" value="select 1" />
<property name="testWhileIdle" value="true" />
<property name="testOnBorrow" value="false" />
<property name="testOnReturn" value="false" />

<!-- 打开PSCache，并且指定每个连接上PSCache的大小（Oracle使用）
<property name="poolPreparedStatements" value="true" />
<property name="maxPoolPreparedStatementPerConnectionSize" value="20" /> -->

<!-- 配置监控统计拦截的filters -->
   <property name="filters" value="stat" /> 
</bean>

</beans>