TablePagingController上的查询记录解析: ...... } else {// _search:false final 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 API final 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; } ......