Druid使用配置

package com.omniprimeinc.manualjob.scheduler.utils;

import java.util.HashMap;
import java.util.Map;

import org.ini4j.Ini;
import org.ini4j.Profile.Section;

import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;

public class AuditorDataSource {
    private static DruidDataSource instance = null;
    private static final Logger logger = Logger.getLogger(AuditorDataSource.class);
    static {
        // 0)获取 ini单例
        Ini config = ConfigUtils.getInstance();
        if (null == config) {
            logger.error("ini is null,exit");
            System.exit(-1);
        }
        // 1)读取auditor section
        Section auditor = config.get(ConfigUtils.AUDITOR);
        // 2)获取url
        String url = auditor.get(ConfigUtils.AUDITOR_URL);
        // 3)获取username
        String username = auditor.get(ConfigUtils.AUDITOR_USERNAME);
        // 4)获取password
        String password = auditor.get(ConfigUtils.AUDITOR_PASSWORD);
        // 5)获取driver
        String driver = auditor.get(ConfigUtils.AUDITOR_DRIVER);
        // 6)获取initial size
        String initialSize = auditor.get(ConfigUtils.AUDITOR_INITIAL_SIZE);
        // 7)设置minIdle
        String minIdle = auditor.get(ConfigUtils.AUDITOR_MIN_IDLE);
        // 8)设置maxActive
        String maxActive = auditor.get(ConfigUtils.AUDITOR_MAX_ACTIVE);
        // 9)设置maxWait
        String maxWait = auditor.get(ConfigUtils.AUDITOR_MAX_WAIT);
        // 10)设置timeBetweenEvictionRunsMillis
        String timeBetweenEviction = auditor.get(ConfigUtils.AUDITOR_TIME_BETWEEN_EVICTION);
        // 11)设置 minEvictableIdleTimeMillis
        String minEvictableIdleTimeMillis = auditor.get(ConfigUtils.AUDITOR_MIN_EVICTABLE_IDLE);
        // 12)获取validationQuery
        String validationQuery = auditor.get(ConfigUtils.AUDITOR_VALIDATION_QUERY);
        // 13)获取testWhileIdle
        String testWhileIdle = auditor.get(ConfigUtils.AUDITOR_TEST_WHILE_IDLE);
        // 14) 获取testOnBorrow
        String testOnBorrow = auditor.get(ConfigUtils.AUDITOR_TEST_ON_BORROW);
        // 15)获取testOnReturn
        String testOnReturn = auditor.get(ConfigUtils.AUDITOR_TEST_ON_RETURN);
        // 16)获取init
        String init = auditor.get(ConfigUtils.AUDITOR_INIT);
        // 17)初始化map
        Map<String, String> map = new HashMap<String, String>();
        map.put(DruidDataSourceFactory.PROP_URL, url);
        map.put(DruidDataSourceFactory.PROP_USERNAME, username);
        map.put(DruidDataSourceFactory.PROP_PASSWORD, password);
        map.put(DruidDataSourceFactory.PROP_DRIVERCLASSNAME, driver);
        map.put(DruidDataSourceFactory.PROP_INITIALSIZE, initialSize);
        map.put(DruidDataSourceFactory.PROP_MINIDLE, minIdle);
        map.put(DruidDataSourceFactory.PROP_MAXACTIVE, maxActive);
        map.put(DruidDataSourceFactory.PROP_MAXWAIT, maxWait);
        map.put(DruidDataSourceFactory.PROP_TIMEBETWEENEVICTIONRUNSMILLIS, timeBetweenEviction);
        map.put(DruidDataSourceFactory.PROP_MINEVICTABLEIDLETIMEMILLIS, minEvictableIdleTimeMillis);
        map.put(DruidDataSourceFactory.PROP_VALIDATIONQUERY, validationQuery);
        map.put(DruidDataSourceFactory.PROP_TESTWHILEIDLE, testWhileIdle);
        map.put(DruidDataSourceFactory.PROP_TESTONBORROW, testOnBorrow);
        map.put(DruidDataSourceFactory.PROP_TESTONRETURN, testOnReturn);
        map.put(DruidDataSourceFactory.PROP_INIT, init);
        logger.info(map.toString());
        try {
            instance = (DruidDataSource) DruidDataSourceFactory.createDataSource(map);
        } catch (Exception e) {
            logger.error(e.toString());
            System.exit(-1);
        }
    }

    public static DruidDataSource getInstance() {
        return instance;
    }

    // private void executeUpdateBySQL(String sql) throws SQLException {
    // DbPoolConnection dbp = DbPoolConnection.getInstance();
    // DruidPooledConnection con = dbp.getConnection();
    // PreparedStatement ps = con.prepareStatement(sql);
    // ps.executeUpdate();
    // ps.close();
    // con.close();
    // dbp = null;
    // }
}

 

配置文件如下：

#############################################
# ini4j example #
#############################################
#http://blog.csdn.net/pk490525/article/details/12621649
[auditor]
url=jdbc:mysql://x.x.x.x:3306/dev_as_manualjob
username=xxx
password=xxx
driver=com.mysql.jdbc.Driver
initialSize=20
minIdle=20
maxActive=50
maxWait=6000
timeBetweenEvictionRunsMillis=60000
minEvictableIdleTimeMillis=300000
validationQuery=SELECT 'x'
testWhileIdle=true
testOnBorrow=false
testOnReturn=false
init=true

 

使用代码如下：

 

scheduledThreadPool = Executors.newScheduledThreadPool(THREAD_COUNT);
        scheduledThreadPool.scheduleAtFixedRate(new Runnable() {
            public void run() {
                DruidPooledConnection conn = null;
                Statement stat = null;
                try {
                    logger.info("begin to fetch auditor information..." + this);
                    conn = AuditorDataSource.getInstance().getConnection();
                    logger.info("used conn---" + conn);
                    stat = conn.createStatement();
                    stat.executeQuery("select 1");
                } catch (Exception e) {
                    logger.error(e.toString());
                } finally {
                    // 尝试关闭stat
                    if (null != stat) {
                        try {
                            stat.close();
                        } catch (SQLException e) {
                            logger.error(e.toString());
                        }
                    }
                    // 尝试关闭connection
                    if (null != conn) {
                        try {
                            conn.close();
                        } catch (SQLException e) {
                            logger.error(e.toString());
                        }
                    }
                }

            }
        }, 1, 3, TimeUnit.SECONDS);
    }

 

参考文档:

http://www.open-open.com/lib/view/open1430558786084.html

http://blog.csdn.net/pk490525/article/details/12621649

https://my.oschina.net/hanzhankang/blog/95772

http://lj6684.iteye.com/blog/1770093

 

转载自：https://my.oschina.net/qiangzigege/blog/788341