organizationdbcontrol.java

公司自己开发的工作流引擎

package cn.com.iaspec.workflow.organize.ext;

import java.sql.*;

/**
 *
 * <p>Title:工作流引擎组织库连接控制 </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: IASPEC Technologies</p>
 * @author xiesonglin
 * @version 1.0
 */

public class OrganizationDBControl{
  protected static DBConnectionManager dBConnectionManager;

  static{
    dBConnectionManager=DBConnectionManager.getInstance();
  }

  /**
   * get DB connection
   * @return Connection
   */
  public static Connection getConnection()
      throws SQLException{
    Connection connection=dBConnectionManager.getConnection();
    return connection;
  }

  /**
   * release DB connection
   */
  public static void releaseConnection(ResultSet resultSet,
      PreparedStatement preStm,Statement statement,Connection connection){
    try{
      if(resultSet!=null){
        resultSet.close();
      }
      if(preStm!=null){
        preStm.close();
      }

      if(statement!=null){
        statement.close();
      }
      if(connection!=null){
        dBConnectionManager.freeConnection(connection);
      }
    }
    catch(SQLException ex){
      ex.printStackTrace();
    }
  }

  /**
   * rollback DB transaction
   * @param connection
   * @throws SQLException
   */
  public static void rollBackConnection(Connection connection){
    if(connection!=null){
      try{
        if(!connection.getAutoCommit()){
          connection.rollback();
        }
      }
      catch(Exception e){
        e.printStackTrace();
      }
    }

  }

}