连接数据库的封装类
1.db.properties文件:
driver="com.mysql.jdbc.Driver"
url=jdbc:mysql://localhost:3306/mysql-me
user=root
password=123456
2.封装方法
package com.cdsxt.utils;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.Properties;
public class DBUtil {
private static String driver;
private static String url;
private static String user;
private static String password;
static{
try {
//读取配置文件db.properties的信息
InputStream is=DBUtil.class.getResourceAsStream("/db.properties");
Properties ps=new Properties();
ps.load(is);
driver=ps.getProperty("driver");
url=ps.getProperty("url");
user=ps.getProperty("user");
password=ps.getProperty("password");
Class.forName(driver);
} catch (Exception e) {
e.printStackTrace();
}
}
//获取数据库连接
public static Connection getConn(){
Connection conn=null;
try{
conn=DriverManager.getConnection(url,user,password);
}catch(Exception e){
e.printStackTrace();
System.out.println("获取数据库连接异常");
}
return conn;
}
//关闭资源
public static void close(Object...objs){
if(objs!=null&&objs.length>0){
for(int i=0;i<objs.length;i++){
try{
if(objs[i] instanceof Connection){
((Connection) objs[i]).close();
}else if(objs[i] instanceof PreparedStatement){
((PreparedStatement) objs[i]).close();
}else if(objs[i] instanceof ResultSet){
((ResultSet)objs[i]).close();
}
}catch(Exception e){
e.printStackTrace();
System.out.println("关闭资源异常");
}
}
}
}
}