今天把我平时写的JDBC连接数据库一些代码封装成一个工具类,方便我以后做项目时候,比较便捷。
public class JDBCUtils {
private static String url;
private static String name;
private static String driver;
private static String password;
/**
* 从db中获取数据库配置信息
* 因为我们外面的类并不需要调用这个方法,所以我们把它写成静态代码块
*/
static {
try {
ClassLoader classLoader = JDBCUtils.class.getClassLoader();
InputStream resourceAsStream = classLoader.getResourceAsStream("db.properties");
Properties properties = new Properties();
properties.load(resourceAsStream);
driver = properties.getProperty("driver");
url = properties.getProperty("url");
name = properties.getProperty("name");
password = properties.getProperty("password");
} catch (IOException e) {
e.printStackTrace();
}
}
/**
* 注册驱动,获取连接
* @return
*/
public static Connection getConnection() {
Connection connection = null;
try {
Class.forName(driver);
connection= DriverManager.getConnection(url, name, password);
} catch (Exception e) {
e.printStackTrace();
}
return connection;
}
/**
* //做非空判断,释放创建的对象
* @param connection
* @param statement
* @param resultSet
* @throws SQLException
*/
public static void release(Connection connection, PreparedStatement statement, ResultSet resultSet) throws SQLException {
if(resultSet!=null){
resultSet.close();
}
if(statement!=null){
statement.close();
}
if(connection!=null){
connection.close();
}
}
}