JDBC公共类

为了便于管理，并提高代码的复用性。我们可以单独建立一个公共类，ConnectionManager类，专门负责建立数据库连接以及执行关闭等代码。

Code:

1. import java.sql.*;   
2.   
3. public class ConnectionManager   
4. {   
5.   
6.                   //声明全局常量 驱动类名称，数据库连接字符串，用户名，密码   
7.                   public static final String Driver = "com.microsoft.sqlserver.jdbc.SqlServerDriver";   
8.                   public static final String URL = "jdbc:sqlserver://localhost:1433;DataBaseName = Hamber";   
9.                   public static final String USER = "sa";   
10.                   public static final String PASSWORD = "123456";   
11.   
12.   
13.                   //返回数据库连接对象Connection方法getConnection   
14.                   public static Connection getConnection()   
15.                  {   
16.                                Connection conn = null;   
17.                                try  
18.                               {   
19.                                      Class.forName(DRIVER);   
20.                                      conn = DriverManager.getConnection(URL,USER,PASSWORD);   
21.                               }   
22.                               catch(ClassNotFoundException ex)   
23.                               {   
24.                                       ex.printStackTrace();   
25.                               }   
26.                              catch(SQLException ex)   
27.                              {   
28.                                       ex.printStackTrace();   
29.                              }   
30.                                return conn;   
31.                  }   
32.   
33.                 //关闭ResultSet对象   
34.                  public static void closeRS(ResultSet rs)   
35.                  {   
36.                              try  
37.                              {   
38.                                         if(rs != null)   
39.                                         {   
40.                                               rs.close();   
41.                                         }    
42.                              }   
43.                              catch(SQLException ex)   
44.                              {   
45.                                          ex.printStackTrace();   
46.                              }   
47.                  }   
48.   
49.                  //关闭Statement对象   
50.        public static void closeST(Statement st)   
51.                {   
52.                             try  
53.                            {   
54.                                     if(st!= null)   
55.                                     {   
56.                                             st.close();   
57.                                     }   
58.                            }   
59.                            catch(SQLException ex)   
60.                           {   
61.                                       ex.printStackTrace();   
62.                           }   
63.                }     
64.   
65.               //关闭数据库连接对象Connection   
66.                 pubic static void closeConnection(Connection conn)   
67.                {   
68.                          try  
69.                         {   
70.                                   if(conn != null && ! conn.isClosed())   
71.                                   {   
72.                                            conn.close();   
73.                                   }   
74.                         }   
75.                         catch(SQLException ex)   
76.                         {   
77.                                 ex.printStackTrace();   
78.                         }   
79.                }   
80.   
81.               //关闭全部   
82.       public static void closeAll(Connection conn,ResultSet rs ,Statement st)   
83.               {   
84.                         closeRS(rs);   
85.                         closeST(st);   
86.                         closeConnection(conn);   
87.                }   
88. }