以下代码演示了如何从EAS系统查询科目余额，用于后台业务逻辑（app目录下的ControllerBean）。
/** * 查询科目余额，封装数据，返回值映射中，键：科目ID；值：科目余额队列 * @param ctx 上下文 * @param easOrgId 财务组织 * @param periodId 会计期间 */ @SuppressWarnings({ "unchecked", "unused" }) private Map<String, List> getParentAcctBalCache(Context ctx, String easOrgId, String periodId) throws BOSException { StringBuffer sql = new StringBuffer(); Map<String, List> map = new HashMap<String, List>(); sql.append("select FBalType, fperiodyear, fperiodnumber,").append("\n"); sql.append("FOrgUnitID, FPeriodID, FAccountID, FCurrencyID,").append("\n"); sql.append("FBeginBalanceFor, FBeginBalanceLocal, FBeginBalanceRpt,").append("\n"); sql.append("FDebitFor, FDebitLocal, FDebitRpt,").append("\n"); sql.append("FCreditFor, FCreditLocal, FCreditRpt,").append("\n"); sql.append("FYearDebitFor, FYearDebitLocal, FYearDebitRpt,").append("\n"); sql.append("FYearCreditFor, FYearCreditLocal, FYearCreditRpt,").append("\n"); sql.append("FEndBalanceFor, FEndBalanceLocal, FEndBalanceRpt").append("\n"); sql.append("from T_GL_AccountBalance").append("\n"); sql.append("where FBalType = ? and FOrgUnitID = ?").append("\n"); sql.append("and FPeriodID = ? and FCurrencyID = ?"); List params = new ArrayList(); params.add(5); //已过帐 params.add(easOrgId); //财务组织 params.add(periodId); //期间 params.add(CURRENCYID); //币别，人民币 IRowSet rs = DbUtil.executeQuery(ctx, sql.toString(), params.toArray()); try { while(rs.next()){ List list = new ArrayList(); String accountId = rs.getString("FAccountID"); //科目ID list.add(5); //余额类型 list.add(rs.getInt("fperiodyear")); //年 list.add(rs.getInt("fperiodnumber")); //月 list.add(easOrgId); //财务组织 list.add(periodId); //期间 list.add(accountId); //科目 list.add(CURRENCYID); //币别 list.add(rs.getBigDecimal("FBeginBalanceFor")); //期初余额原币 list.add(rs.getBigDecimal("FBeginBalanceLocal")); //本位币 list.add(rs.getBigDecimal("FBeginBalanceRpt")); //报告币 list.add(rs.getBigDecimal("FDebitFor")); //本期发生借方原币 list.add(rs.getBigDecimal("FDebitLocal")); //本位币 list.add(rs.getBigDecimal("FDebitRpt")); //报告币 list.add(rs.getBigDecimal("FCreditFor")); //本期发生贷方原币 list.add(rs.getBigDecimal("FCreditLocal")); //本位币 list.add(rs.getBigDecimal("FCreditRpt")); //报告币 list.add(rs.getBigDecimal("FYearDebitFor")); //本年累计借方原币 list.add(rs.getBigDecimal("FYearDebitLocal")); //本位币 list.add(rs.getBigDecimal("FYearDebitRpt")); //报告币 list.add(rs.getBigDecimal("FYearCreditFor")); //本年累计贷方原币 list.add(rs.getBigDecimal("FYearCreditLocal")); //本位币 list.add(rs.getBigDecimal("FYearCreditRpt")); //报告币 list.add(rs.getBigDecimal("FEndBalanceFor")); //期末余额原币 list.add(rs.getBigDecimal("FEndBalanceLocal")); //本位币 list.add(rs.getBigDecimal("FEndBalanceRpt")); //报告币 map.put(accountId, list); } } catch (SQLException e) { throw new BOSException(e); } return map; }