Database connection Tool Class--contains access to connect and close resources Connutil.java

2. Package com.util;
6. Import java.sql.Connection;
8. Import Java.sql.DriverManager;
10. Import java.sql.PreparedStatement;
12. Import Java.sql.ResultSet;
14. Import java.sql.SQLException;
20. /**
22. * @className: Connutil.java
24. * @classDescription: Database Connection Tool Class--includes getting connections and shutting down resources
26. * @function:
28. * @author: Wentasy
30. * @createTime: 2012-9-24 11:51:15
32. * @modifyTime:
34. * @modifyReason:
36. * @since: JDK 1.6
38. */
40. Public class Connutil {
42. public static final String url = "Jdbc:mysql://xxx.xxx.xxx.xxx:3306/dbadapter";
44. public static final String user = "root";
46. public static final String password = "XXXXXX";
50. /** 
52. * Get Connected
54. * @return
56. * @throws SQLException
58. * @throws ClassNotFoundException
60. */
62. public static Connection Establishconn () throws sqlexception,classnotfoundexception{
64. Class.forName ("Com.mysql.jdbc.Driver");
66. return drivermanager.getconnection (URL, user, password);
68. }
72. /** 
74. * Close Connection
76. * @param Conn
78. * @throws SQLException
80. */
82. public static void Close (Connection conn) throws sqlexception{
84. if (conn! = null) {
86. Conn.close ();
88. conn = null;
90. }
92. }
96. /** 
98. * Close PreparedStatement
100. * @param pstmt
102. * @throws SQLException
104. */
106. public static void Close (PreparedStatement pstmt) throws sqlexception{
108. if (pstmt! = null) {
110. Pstmt.close ();
112. PSTMT = null;
114. }
116. }
120. /** 
122. * Close result set
124. * @param RS
126. * @throws SQLException
128. */
130. public static void Close (ResultSet rs) throws sqlexception{
132. if (rs! = null) {
134. Rs.close ();
136. rs = null;
138. }
140. }
142. }

Database connection Tool Class--contains access to connect and close resources Connutil.java