java Druid连接mysql

DBUtil 工具类===========================

package dbtest;

import com.alibaba.druid.pool.DruidDataSource;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import com.alibaba.druid.pool.DruidPooledConnection;

import java.io.FileInputStream;

import java.sql.SQLException;

import java.util.Properties;

public class DBUtil {

private static DruidDataSource druidDataSource =null;

    static {

try {

Properties props =new Properties();

            props.load(new FileInputStream("src/db.properties"));

            druidDataSource = (DruidDataSource)DruidDataSourceFactory

                    .createDataSource(props);

        }catch (Exception e) {

e.printStackTrace();

        }

}

private static DruidPooledConnection getConnection() {

DruidPooledConnection connection =null;

        try {

connection =druidDataSource.getConnection();

        }catch (SQLException e) {

e.printStackTrace();

        }

if (connection ==null) {

System.exit(0);

        }

return connection;

    }

public static void main(String[] args) {

System.out.println(getConnection());

    }

}

db.properties 配置文件===========================

driverClassName=com.mysql.jdbc.Driver

url=jdbc:mysql://127.0.0.1:3306/demo

username=root

password=root

filters=stat

initialSize=2

maxActive=300

maxWait=60000

timeBetweenEvictionRunsMillis=60000

minEvictableIdleTimeMillis=300000

validationQuery=SELECT 1

testWhileIdle=true

testOnBorrow=false

testOnReturn=false

poolPreparedStatements=false

maxPoolPreparedStatementPerConnectionSize=200