package com.lrk.login.jdbcdao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 作用:连接数据库及关闭相关链接
* @author kevin
*
*/
public class Jdbcdao {
public Connection con =null;
//通过单利模式公开一个复用数据库连接的方法
private static Jdbcdao mjdbc=null;
public static Jdbcdao getInstace(){
if(mjdbc==null){
mjdbc=new Jdbcdao();
}
return mjdbc;
}
private Jdbcdao(){
try {
//加载JDBC驱动
Class.forName("oracle.jdbc.driver.OracleDriver");
//通过DriverManager.getConnection连接数据库
con = DriverManager.getConnection("jdbc:oracle:thin:@192.168.0.102:1521:ORCL", "scott",
"212121");
} catch (ClassNotFoundException e) {
System.out.println("JDBC 加载失败");
e.printStackTrace();
} catch (SQLException e) {
System.out.println("oracle 连接失败");
e.printStackTrace();
}
}
//关闭连接
public void close(ResultSet rs,PreparedStatement pr,Connection conn){
try {
if(rs!=null){
if(!rs.isClosed()){
rs.close();
}
}
} catch (SQLException e) {
e.printStackTrace();
rs=null;
}
try {
if(pr!=null){
if(!pr.isClosed()){
pr.close();
}
}
} catch (SQLException e) {
e.printStackTrace();
pr=null;
}
try {
if(conn!=null){
if(!conn.isClosed()){
conn.close();
}
}
} catch (SQLException e) {
e.printStackTrace();
conn=null;
}
}
}