import java.io.FileReader;
import java.io.IOException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class JDBCUtilsConfig {
//在成员位置定义相关的成员表里来接收文件信息
private static String driver;
private static String url;
private static String username;
private static String password;
//定义数据库链接对象
private static Connection conn;
//定义静态代码块,在调用类初始化数据库配置
static {
try {
// 使用properties来获取数据库配置信息
readConfig();
Class.forName(driver);
conn = DriverManager.getConnection(url, username, password);
} catch (Exception e) {
e.printStackTrace();
}
}
//返回数据库链接对象
public static Connection getConnection() {
return conn;
}
public static void readConfig() throws Exception, IOException {
Properties properties = new Properties();
properties.load(new FileReader("jdbc.properties"));
driver = properties.getProperty("driver");
url = properties.getProperty("url");
username = properties.getProperty("username");
password = properties.getProperty("password");
}
//关闭流方法
public static void close(ResultSet rs, Statement stat, Connection conn) {
try {
if (rs != null) {
rs.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
try {
stat.close();
} catch (SQLException e) {
e.printStackTrace();
}
try {
conn.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
driver = com.mysql.jdbc.Driver
url = jdbc:mysql://127.0.0.1:3306/day_04
username = root
password = root