为了便于管理,并提高代码的复用性。我们可以单独建立一个公共类,ConnectionManager类,专门负责建立数据库连接以及执行关闭等代码。
- import java.sql.*;
- public class ConnectionManager
- {
- //声明全局常量 驱动类名称,数据库连接字符串,用户名,密码
- public static final String Driver = "com.microsoft.sqlserver.jdbc.SqlServerDriver";
- public static final String URL = "jdbc:sqlserver://localhost:1433;DataBaseName = Hamber";
- public static final String USER = "sa";
- public static final String PASSWORD = "123456";
- //返回数据库连接对象Connection方法getConnection
- public static Connection getConnection()
- {
- Connection conn = null;
- try
- {
- Class.forName(DRIVER);
- conn = DriverManager.getConnection(URL,USER,PASSWORD);
- }
- catch(ClassNotFoundException ex)
- {
- ex.printStackTrace();
- }
- catch(SQLException ex)
- {
- ex.printStackTrace();
- }
- return conn;
- }
- //关闭ResultSet对象
- public static void closeRS(ResultSet rs)
- {
- try
- {
- if(rs != null)
- {
- rs.close();
- }
- }
- catch(SQLException ex)
- {
- ex.printStackTrace();
- }
- }
- //关闭Statement对象
- public static void closeST(Statement st)
- {
- try
- {
- if(st!= null)
- {
- st.close();
- }
- }
- catch(SQLException ex)
- {
- ex.printStackTrace();
- }
- }
- //关闭数据库连接对象Connection
- pubic static void closeConnection(Connection conn)
- {
- try
- {
- if(conn != null && ! conn.isClosed())
- {
- conn.close();
- }
- }
- catch(SQLException ex)
- {
- ex.printStackTrace();
- }
- }
- //关闭全部
- public static void closeAll(Connection conn,ResultSet rs ,Statement st)
- {
- closeRS(rs);
- closeST(st);
- closeConnection(conn);
- }
- }