package utils;
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
/**
- 存在的问题:
-
1.注册驱动只需要注册一次即可,这样每次调用该方法是都会注册一次,影响性能
-
解决:将注册驱动的代码放到静态代码块中
-
2.代码没用通用性,如果改了数据库的话,代码也要改动,
-
解决:把一些参数放到配置文件中,配置文件也只需要加载一次所以也可以放到静态代码块中
*/
public class UtilJdbc {
private static String url;
private static String user;
private static String password;
private static String driver;
static {
InputStream is = null;
try {
Properties pro = new Properties();
is = UtilJdbc.class.getClassLoader().getResourceAsStream("jdbc.properties");
pro.load(is);
url = pro.getProperty("url");
user = pro.getProperty("username");
password = pro.getProperty("password");
driver = pro.getProperty("driver");
Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
}finally {
if (is != null){
try {
is.close();
} catch (IOException e) {
e.printStackTrace();
}
}
}
}
/**
* 获取连接
* @return Connection对象
* @throws Exception
*/
public static Connection getConnection () throws Exception{
return DriverManager.getConnection(url,user,password);
}
/**
* 用于释放资源
*/
public static void colse(Statement sta, Connection conn){
close(null, sta,conn);
}
public static void close(ResultSet res, Statement sta, Connection conn){
try {
if (res != null){
res.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (sta != null){
sta.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
if (conn != null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}