jdbc.properties为配置文件,配置文件内容查看:数据库连接的五种方式_qq_46053741的博客-CSDN博客
public class jdbcConnection {
public static Connection connection(){
Connection conn=null;
try {
//1、读取配置文件中的四个信息
InputStream is=ClassLoader.getSystemClassLoader().getResourceAsStream("jdbc.properties");
Properties pros=new Properties();
pros.load(is);
String user=pros.getProperty("user");
String password=pros.getProperty("password");
String url=pros.getProperty("url");
String driver=pros.getProperty("driverClass");
//2、加载驱动
Class.forName(driver);
//3、连接数据库
conn = DriverManager.getConnection(url, user, password);
System.out.println("数据库连接状态"+conn);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return conn;
}
//关闭资源
public static void CloseResource(Connection conn,PreparedStatement ps){
try {
if(conn!=null)
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
try{
if(ps!=null)
ps.close();
}catch (Exception e) {
e.printStackTrace();
}
}
//关闭资源
public static void CloseResource(Connection conn,PreparedStatement ps,ResultSet rs){
try {
if(conn!=null)
conn.close();
} catch (Exception e) {
e.printStackTrace();
}
try{
if(ps!=null)
ps.close();
}catch (Exception e) {
e.printStackTrace();
}
try {
if(rs!=null)
rs.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}