public List<Subject> findAll(int currentPage, int pageSize) {String sql = "select subid,subContent from tb_subject limit ?,?";return DAOHelper.executeQuery(conn1, sql, new Object[]{(currentPage-1)*pageSize,pageSize}, new CallBack() {public List getList(ResultSet rs) {List list = new ArrayList();Subject sub = null;OptionsDAO odao = new OptionsDAO();try {while(rs.next()){sub = new Subject();sub.setSubId(rs.getInt("subid"));sub.setSubContent(rs.getString("subContent"));sub.setOptions(odao.findBySubId(rs.getInt("subid")));list.add(sub);}} catch (SQLException e) {e.printStackTrace();}return list;}});}
