注册为驱动,获取链接复用代码注册为驱动,获取链接复用代码
package com.qf.util;
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
public class DButils {
private static final String DRIVER;
private static final String URL;
private static final String USERNAME;
private static final String PASSWORD;
private static Properties properties = new Properties();
static {
InputStream stream = DButils.class.getClassLoader().getResourceAsStream("db.properties");
try {
properties.load(stream);
} catch (Exception e) {
e.printStackTrace();
}
DRIVER = properties.getProperty("driver");
URL = properties.getProperty("url");
USERNAME = properties.getProperty("username");
PASSWORD = properties.getProperty("password");
}
//加载驱动
public static void loadDriver() throws Exception {
Class.forName(DRIVER);
}
//获取连接
public static Connection getConnection() throws Exception {
loadDriver();
return DriverManager.getConnection(URL,USERNAME,PASSWORD);
}
//释放资源
public static void release(Connection connection, Statement statement, ResultSet resultSet){