jqGrid分页技术学习（六）spring jdbc 通用DAO——查询所有记录

来源：互联网发布：php json null 编辑：程序博客网时间：2024/04/30 07:06

TablePagingController上的查询记录解析：

......} else {// _search:falsefinal JQGridPTO<InvHeader> pto = this.getDao().query();model.put("JSON_OBJECT", pto);}......

TablePagingDao上的查询所有记录的操作：

....../** * 查询所有对象.未分页. * * @return List<JSONResHost> */public List<InvHeader> query(){// a json array is part of the json-lib APIfinal List<InvHeader> array = new ArrayList<InvHeader>();JdbcTemplate jdbcTemplate = this.getJdbcTemplate();String sql = "SELECT id, invdate, client_id, amount, tax, total, closed, ship_via, note"+ " FROM invheader";jdbcTemplate.query(sql, new PreparedStatementSetter(){public void setValues(PreparedStatement ps)throws SQLException{// ps.setString(1, id);}}, new RowCallbackHandler(){public void processRow(ResultSet rs)throws SQLException{InvHeader data = new InvHeader();data.setId(rs.getInt(1));data.setInvdate(rs.getString(2));data.setClient_id(rs.getInt(3));data.setAmount(rs.getFloat(4));data.setTax(rs.getFloat(5));data.setTotal(rs.getFloat(6));data.setClosed(rs.getString(7));data.setShip_via(rs.getString(8));data.setNote(rs.getString(9));array.add(data);}});return array;}......