connectionmanager.java

来自「新闻系统的具体的一块」· Java 代码 · 共 40 行

package dao;
import java.sql.*;

public class ConnectionManager {
	public static Connection getConnection(){
		Connection conn=null;
		try{
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
		} catch(ClassNotFoundException e){
			e.printStackTrace();
		} 
		try{
			conn=DriverManager.getConnection("jdbc:sqlserver://localhost:1433;DataBaseName=bbs","sa","sa");
		} catch(SQLException e){
			e.printStackTrace();
		}
		return conn;
	}
	public static void closeAll(ResultSet rs,PreparedStatement pStatement,Connection conn){
		try{
			if(rs!=null){rs.close();}
		}catch(SQLException e){
			System.out.print("记录集关闭时出错！");
			e.printStackTrace();
		}
		try{
			if(pStatement!=null){pStatement.close();}
		}catch(SQLException e){
			System.out.print("状态集关闭时出错！");
			e.printStackTrace();
		}
		try{
			if(conn!=null){conn.close();}
		}catch(SQLException e){
			System.out.print("连接关闭时出错！");
			e.printStackTrace();
		}
	}
}