DBManager.java
上一篇 /
下一篇 2013-03-22 14:45:22
/ 个人分类:java
package com.softeem.util;
import java.sql.*;
public class DBManager {
/**
*用于管理数据库连接的 取得连接 关闭连接 connection statement resultset
**/
private final static String DRIVER="com.microsoft.sqlserver.jdbc.SQLServerDriver";
private final static String URL="jdbc:sqlserver://localhost:1433;databaseName=Stu";
private final static String USER="sa";
private final static String PASS="751641493";
private static Connection conn=null;
//加载驱动
static{
try{
Class.forName(DRIVER);
}catch(ClassNotFoundException e){
e.printStackTrace();
}
}
//获得connection
public static Connection getConn(){
try{
if(conn==null||conn.isClosed())
{
conn=DriverManager.getConnection(URL,USER,PASS);
}
}catch(SQLException e)
{
e.printStackTrace();
}
return conn;
}
/**
* 关闭连接connection statement resultset的对象
* @param conn
* @param st
* @param rs
*/
public static void closeConn(Connection conn,Statement st,ResultSet rs)
{
try {
if(rs!=null){
rs.close();
}
if(st!=null){
st.close();
}
if(conn!=null){
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
public static void closeConn(Connection conn,PreparedStatement ps,ResultSet rs){
try {
if(!rs.isClosed())
{
rs.close();
}
if(!ps.isClosed())
{
ps.close();
}
if(!conn.isClosed())
{
conn.close();
}
} catch (SQLException e) {
e.printStackTrace();
}
}
}
收藏
举报
TAG: