packagecom.gton.servlet.utils;importcom.alibaba.druid.pool.DruidDataSourceFactory;importjavax.sql.DataSource;import java.sql.*;importjava.util.Properties;/*** @program: Jdbc-start
* @description: Druid工具类
*@author: GuoTong
* @create: 2020-09-01 15:23
**/
public classDruidUtils {//初始化连接池
staticDataSource dataSource;static{//创建druid连接池
try{
Properties properties= newProperties();
properties.load(DruidUtils.class.getClassLoader().getResourceAsStream("druid.properties"));
dataSource=DruidDataSourceFactory.createDataSource(properties);
}catch(Exception e) {
e.printStackTrace();
}
}public staticDataSource getDataSource(){returndataSource;
}public staticConnection getConnection(){try{returndataSource.getConnection();
}catch(SQLException e) {
e.printStackTrace();
}return null;
}//关闭资源
public static voidclose(Connection conn, Statement stmt) {if (stmt != null) {try{
stmt.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if (conn != null) {try{
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}public static voidclose(Connection conn, PreparedStatement stmt) {if (stmt != null) {try{
stmt.close();
}catch(SQLException e) {
e.printStackTrace();
}
}if (conn != null) {try{
conn.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
}public static voidclose(Connection conn, Statement stmt, ResultSet rs) {if (rs != null) {try{
rs.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
close(conn, stmt);
}public static voidclose(Connection conn, PreparedStatement stmt, ResultSet rs) {if (rs != null) {try{
rs.close();
}catch(SQLException e) {
e.printStackTrace();
}
}
close(conn, stmt);
}
}