package goddess.util;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DButil {
static String user,pass,url,driver;
static{
user="scott";
pass="asd";
url="jdbc:oracle:thin:@localhost:1521:orcl";
driver="oracle.jdbc.driver.OracleDriver";
}
public static Connection getConnection(){
Connection co=null;
try {
//加载驱动
Class.forName(driver);
//与数据库连接
co=DriverManager.getConnection(url,user,pass);
} catch (Exception e) {
e.printStackTrace();
}
return co;
}
//关闭各种资源
public static void close(Connection con,Statement st,ResultSet rs){
if(con!=null){
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(st!=null){
try {
st.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
if(rs!=null){
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}
public static void main(String[] args) {
System.out.println(getConnection());
}
}