package com.beiruan.util;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Properties;
public class DBConnectionUtil {
//连接数据库的四个参数
private static String jdbcDriver="";
private static String jdbcURL="";
private static String jdbcUser="";
private static String jdbcPassword="";
static {
//这是读取连接数据库四个参数的文件,所以用此操作之前需要在工程src文件下建一个jdbc.properties文件,里面放置连接数据库的四个参数
InputStream is=DBConnectionUtil.class.
getClassLoader().getResourceAsStream("jdbc.properties");
Properties p=new Properties();
try {
p.load(is);
jdbcDriver=p.getProperty("jdbcDriver");
jdbcURL=p.getProperty("jdbcURL");
jdbcUser=p.getProperty("jdbcUser");
jdbcPassword=p.getProperty("jdbcPassword");
} catch (IOException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
}
public static Connection getConnetion() {
Connection conn=null;
try {
Class.forName(jdbcDriver);//可以control+1引出try-catch
//获取连接
conn=DriverManager.getConnection(jdbcURL, jdbcUser, jdbcPassword);
} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
e.printStackTrace();
}
return conn;
}
public static void closeAll(Statement st,Connection conn) {
if(st!=null )
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
if(conn!=null)
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
public static void main(String[] args) {
System.out.println(DBConnectionUtil.getConnetion());
}
}