通过JdbcTemplate调用存贮过程例子

最新推荐文章于 2024-04-18 10:12:09 发布

kevin_w_l

最新推荐文章于 2024-04-18 10:12:09 发布

阅读量1.7k

点赞数

分类专栏： spring 文章标签： list float report integer string object

本文链接：https://blog.csdn.net/kevin_w_l/article/details/1667400

版权

spring 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

public List getTransFeeDate(final String departmentCode,
   final String subDepartmentCode, final String countDate) {
  // TODO Auto-generated method stub
  List list = new ArrayList();
  //exec P_TRANS_FEE_REPORT ?,?,? 为存储过程，TransFeeView是一个视图，并不是与数据库关联的实体类
  list = (List) getJdbcTemplate().execute("exec P_TRANS_FEE_REPORT ?,?,?", new PreparedStatementCallback(){

   public Object doInPreparedStatement(PreparedStatement stmt) throws SQLException, DataAccessException {
    // TODO Auto-generated method stub
    List result = new ArrayList();
    stmt.setString(1, countDate);
    stmt.setString(2,departmentCode);
    stmt.setString(3, subDepartmentCode);
    ResultSet rs = stmt.executeQuery();
    while(rs.next()){
     TransFeeView feeView = new TransFeeView();
     feeView.setItem(rs.getString("Fld_Item"));
     feeView.setOder(new Integer(rs.getInt("Fld_Order")).toString());
     feeView.setDayFee(new Float(rs.getDouble(3)).toString());
     feeView.setMonthFee(new Float(rs.getFloat(4)).toString());
     feeView.setYearFee(new Float(rs.getFloat(5)).toString());
     feeView.setReturnFee(new Float(rs.getFloat(6)).toString());
     result.add(feeView);
    }
    return result;
   }

  });

  return list;
}