import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;
import javax.sql.DataSource;
import org.apache.commons.dbcp.BasicDataSourceFactory;
public class JDBCUtil {
private static DataSource dataSource;
//缓存
private static ThreadLocal local =new ThreadLocal<>();
static {
try {
Properties properties = new Properties();
properties.load(JDBCUtil.class.getClassLoader().getResourceAsStream("db.properties"));
dataSource = BasicDataSourceFactory.createDataSource(properties);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static Connection getConnection() throws Exception {
Connection connection = local.get();
if(connection==null){
connection=dataSource.getConnection();
local.set(connection);
}
return connection;
}
public static void close(ResultSet rs, PreparedStatement ps, Connection conn) {
try {
if (rs != null) {
rs.close();
}
if (ps != null) {
ps.close();
}
if (conn != null) {
conn.close();
}
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://127.0.0.1:3306/day03?CharacterEncoding=utf-8
username=root
password=
@Override
public List getAllStudent() throws Exception {
Connec