package com.shayiheng.api.utils;
import com.alibaba.druid.pool.DruidDataSource;
import com.alibaba.druid.pool.DruidDataSourceFactory;
import com.shayiheng.api.druid.DruidUsePart;
import javax.sql.DataSource;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.SQLException;
import java.util.Properties;
public class JdbcUtils {
private static DataSource dataSource=null;
static {
Properties properties=new Properties();
InputStream ips = DruidUsePart.class.getClassLoader().getResourceAsStream("druid.properties");
try {
properties.load(ips);
}catch (IOException e){
throw new RuntimeException(e);
}
try {
dataSource= DruidDataSourceFactory.createDataSource(properties);
}catch (Exception e){
throw new RuntimeException(e);
}
}
public static Connection getConnection() throws SQLException {
return dataSource.getConnection();
}
public static void freeConnection(Connection connection) throws SQLException {
connection.close();
}
}
package com.shayiheng.api.utils;
import java.sql.Connection;
import java.sql.SQLException;
public class JdbcCrudPart {
public void testInsert() throws SQLException {
Connection connection = JdbcUtils.getConnection();
JdbcUtils.freeConnection(connection);
}
}