Java Doc for DbConnectionManager.java in  » Net » openfire » org » jivesoftware » database » Java Source Code / Java DocumentationJava Source Code and Java Documentation

This class also provides a set of utility methods that abstract out operations that may not work on all databases such as setting the max number or rows that a query should return.
author:
   Jive Software
See Also:   ConnectionProvider

 Connection con = null;
 PrepatedStatment pstmt = null;
 ResultSet rs = null;
 try {
 con = ConnectionManager.getConnection();
 pstmt = con.prepareStatement("select * from blah");
 rs = psmt.executeQuery();
 ....
 }
 catch (SQLException sqle) {
 Log.error(sqle);
 }
 finally {
 ConnectionManager.closeConnection(rs, pstmt, con);
 }

 Connection con = null;
 PrepatedStatment pstmt = null;
 try {
 con = ConnectionManager.getConnection();
 pstmt = con.prepareStatement("select * from blah");
 ....
 }
 catch (SQLException sqle) {
 Log.error(sqle);
 }
 finally {
 DbConnectionManager.closeConnection(pstmt, con);
 }

 Connection con = null;
 try {
 con = ConnectionManager.getConnection();
 ....
 }
 catch (SQLException sqle) {
 Log.error(sqle);
 }
 finally {
 DbConnectionManager.closeConnection(con);
 }

 public void doSomething(Connection con) {
 ResultSet rs = null;
 PreparedStatement pstmt = null;
 try {
 pstmt = con.prepareStatement("select * from blah");
 rs = pstmt.executeQuery();
 ....
 }
 catch (SQLException sqle) {
 Log.error(sqle);
 }
 finally {
 ConnectionManager.closeResultSet(rs);
 ConnectionManager.closePreparedStatement(pstmt);
 }
 } 

 public void doSomething(Connection con) {
 PreparedStatement pstmt = null;
 try {
 pstmt = con.prepareStatement("select * from blah");
 ....
 }
 catch (SQLException sqle) {
 Log.error(sqle);
 }
 finally {
 ConnectionManager.closePreparedStatement(pstmt);
 }
 }