druid mysql_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