天天看點

JDBC封裝工具類,使用Durid連接配接池

package itcast.util;

import com.alibaba.druid.pool.DruidDataSourceFactory;

import javax.sql.DataSource;

import java.io.InputStream;

import java.sql.Connection;

import java.sql.SQLException;

import java.util.Properties;

public class JDBCUtils {

private static DataSource ds ;

static {

try {

Properties pro = new Properties();

InputStream is = cn.itcast.util.JDBCUtils.class.getClassLoader().getResourceAsStream(“druid.properties”);

pro.load(is);

ds = DruidDataSourceFactory.createDataSource(pro);

} catch (Exception e) {

e.printStackTrace();

}

}

public static DataSource getDataSource(){

return ds;

}

public static Connection getConnection() throws SQLException {

return ds.getConnection();

}

}