package util;
import java.io.IOException;
import java.io.InputStream;
import java.sql.*;
import java.util.Properties;
public class JdbcUtil {
private static final String URL = "url";
private static final String DBINFO_FIIE_NAME = "dbinfo.properties";
private static Properties infos = new Properties();
private static String url = null;
static{
InputStream is = JdbcUtil.class
.getClassLoader()
.getResourceAsStream(DBINFO_FIIE_NAME);
try {
infos.load(is);
} catch (Exception e) {
e.printStackTrace();
throw new ExceptionInInitializerError("属性文件加载错误");
} finally {
try {
is.close();
} catch (Exception e) {
}
}
url = infos.getProperty(URL);
}
public static Connection getConnection() {
try {
return DriverManager.getConnection(url, infos);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public static void close(ResultSet rs, Statement stat, Connection con) {
try {
rs.close();
} catch (Exception e) {
// TODO Auto-generated catch block
// e.printStackTrace();
}
try {
stat.close();
} catch (Exception e) {
// TODO Auto-generated catch block
// e.printStackTrace();
}
try {
con.close();
} catch (Exception e) {
// TODO Auto-generated catch block
// e.printStackTrace();
}
}
public static void main(String[] args){
System.out.println(JdbcUtil.getConnection());
}
}
