package com.bbs_project.dao;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
/**
* 数据库连接类
* @author Administrator
*
*/
public class DatabaseConnectionDao {
/**
* 获取数据库连接
* @return
*/
public Connection getConnection(){
Connection con=null;
try {
//加载驱动
Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost/bbs_db?" +
"user=root&password=&useUnicode=true&characterEncoding=GBK");
} catch (ClassNotFoundException e) {
// TODO Auto-generated catch block
System.out.println("驱动注册失败!");
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
System.out.println("获取连接失败!");
e.printStackTrace();
}
return con;
}
/**
* 关闭数据库连接,释放资源
* @param rs
* @param pst
* @param con
*/
public void close(ResultSet rs,PreparedStatement pst,Connection con){
try{
if (rs!=null) {
try {
rs.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if (pst!=null) {
try {
pst.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}else if (con!=null) {
try {
con.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}finally{
rs=null;
pst=null;
con=null;
}
}
}