gettablesequenceid.java

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

package cn.com.iaspec.workflow.util;

import java.sql.*;
import org.apache.log4j.*;
import cn.com.iaspec.workflow.db.*;

/**
 *
 * <p>Title: 取得表的主键id</p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2005</p>
 * <p>Company: IASPEC Technologies</p>
 * @author xiesonglin
 * @version 1.0
 */
public class GetTableSequenceId{
  private static Logger logger=Logger.getLogger(GetTableSequenceId.class);
  public GetTableSequenceId(){
  }

  /**
   * 取得指定表名的主键id
   * @param tableName String 表名
   * @throws SQLException
   * @return String 主键id
   */
  public static String getTableId(String tableName)
      throws Exception{
    String tableId="";
    Connection conn=null;
    CallableStatement callStm=null;
    if(tableName==null||tableName.equals("")){
      logger.debug("tableName is null...");
      return tableId;
    }

    try{
      //取得有权限的功能接点id

      conn=WorkflowDBConnectionManager.getInstance().getConnection();
      String sql="{call PROC_GET_TABLE_ID(?,?)}";
      callStm=conn.prepareCall(sql);
      callStm.registerOutParameter(2,java.sql.Types.VARCHAR);
      callStm.setString(1,tableName);
      callStm.execute();
      tableId=callStm.getString(2);
      callStm.close();
    }
    finally{
      WorkflowDBConnectionManager.getInstance().close(conn);
    }
    logger.info("getTableId: tableName is:"+tableName+" tableId is:"+tableId);

    return tableId;
    //return "6400";
  }
}