use CachedRowSet to delegate sql manipulation

最新推荐文章于 2025-08-09 23:26:39 发布

原创最新推荐文章于 2025-08-09 23:26:39 发布 · 471 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#sql #null #string #exception #branch #dao

工作心得专栏收录该内容

42 篇文章

订阅专栏

本文介绍了一个用于查询银行名称、城市、路由代码等信息的方法。通过使用DAO模式，该方法能够从数据库中检索相关信息并将其封装到BankRoutineCodeList对象中返回。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

delegate sql manipulation to a DAO Util

public static final BankRoutineCodeList getBankRoutineCodeList(String searchBankName, String hidReason, int curSize) throws BaseException {
           CachedRowSet rs = null;
          BankRoutineCodeList bankRoutineCodeList = null;
            BankRoutineCode bankRoutineCode = null;

try {

bankRoutineCodeList = new BankRoutineCodeList();

String sqlQuery = "select BANK_NAME,CITY,ROUTING_CODE,EXT_ROUTING_CODE,BKBR_SEQNO,BRANCH_CODE";
sqlQuery += " from " + tableName;

BaseParam params[] = new BaseParam[1];

rs = BaseDAO.getResultSet(sqlQuery, params);

   while (rs.next()) {
                bankRoutineCode = new BankRoutineCode();
               bankRoutineCode.setBankName(rs.getString("BANK_NAME"));
                bankRoutineCodeList.addBankRoutineCode(bankRoutineCode);
   }

}catch(){

  } finally {
        try {
                   if (rs != null)
                          rs.close();

        } catch (java.sql.SQLException sqe) {
                         throw new BaseException(sqe, "SQL Exception while closing connection : " + sqe);
   }

}
return bankRoutineCodeList;
}

In BaseDAO:

public static CachedRowSet getResultSet(String sSql, Object[] objParams) throws SQLException,BaseException
{
  Connection connection= null;
  PreparedStatement ps = null;
  Statement stmt = null;
  ResultSet rs = null;
  CachedRowSet _cachedRowSet = null;

  try
  {
   connection = getDB2Connection();
   if(objParams == null || objParams.length == 0){
    stmt = connection.createStatement();
    rs = stmt.executeQuery(sSql);
   }else{

    ps = connection.prepareStatement(sSql);
    for(int i=0 ; i < objParams.length; i++) {
     BaseParam prepareParams = (BaseParam)objParams[i];
     int datatype = prepareParams.getDataType();
     switch(datatype){
      case BaseConstants.INTEGER:
       ps.setInt((i + 1),Integer.parseInt(prepareParams.getValue()));
       break;
      case BaseConstants.STRING:
       ps.setString((i + 1),prepareParams.getValue());
       break;
      case BaseConstants.LONG:
       ps.setLong((i + 1),Long.parseLong(prepareParams.getValue()));
       break;
      case BaseConstants.FLOAT:
       ps.setFloat((i + 1),Float.parseFloat(prepareParams.getValue()));
       break;
      case BaseConstants.DOUBLE:
       ps.setDouble((i + 1),Double.parseDouble(prepareParams.getValue()));
       break;
     }

    }
    rs =ps.executeQuery();
   }
   _cachedRowSet = new CachedRowSet();
   _cachedRowSet.populate(rs);

}catch(java.sql.SQLException se)
{

   throw new BaseException(se,"SQLException occured in getResultSet () method of BaseDao while fetching records: " + se.getMessage () );
  }
  finally
  {
   try
   {
    if(rs != null)
     rs.close();
    if(ps != null)
     ps.close();
    if(connection != null)
     connection.close();
   }catch(java.sql.SQLException se)
   {
    se.printStackTrace();
   }
  }
  return _cachedRowSet;
}