自己写的分页查询的步骤代码

第一步：前台页面（核心代码）

?主要是当前的页数，因为是第一次嘛，肯定是从第一页开始的。查询出来的页面我用的是iframe方式呈现。其他地方的代码不用嗦，该怎么写怎么写。

?
第二步：actionForm代码
?actionForm里面的字段名称和前台页面要保存一直，学过struts的同学应该明白自动填充的含义。
?
第五步：dao层组件代码
/** * 获取某广告信息列表 */public List getAdvertiseList(String sql) throws Exception {// TODO Auto-generated method stubList list = new ArrayList();Connection connection = null;PreparedStatement preparedStatement = null;ResultSet resultSet = null;try{connection = this.getJdbcTemplate().getDataSource().getConnection();preparedStatement = connection.prepareStatement(sql);resultSet = preparedStatement.executeQuery();while(resultSet.next()){Advertisement advertisement = new Advertisement();advertisement.setAdvertiseid(resultSet.getLong("ADVERTISEID"));advertisement.setAdvertisename(resultSet.getString("ADVERTISENAME"));advertisement.setPic(resultSet.getBlob("PIC"));advertisement.setLinkurl(resultSet.getString("LINKURL"));advertisement.setHoteladdnum(resultSet.getLong("HOTELADDNUM"));advertisement.setHolidayaddnum(resultSet.getLong("HOLIDAYADDNUM"));advertisement.setHolidaytypeaddnum(resultSet.getLong("HOLIDAYTYPEADDNUM"));advertisement.setPublishstate(resultSet.getLong("PUBLISHSTATE"));list.add(advertisement);}}catch (Exception e) {e.printStackTrace();}finally{if(resultSet!=null){resultSet.close();}if(preparedStatement!=null){preparedStatement.close();}if(connection!=null){connection.close();}}return list;}/** * 获取满足要求的广告总记录数（用于查询分页） */public int getTotalCount(String sql) throws Exception {// TODO Auto-generated method stubint totalCount = 0;Connection connection = null;PreparedStatement preparedStatement = null;ResultSet resultSet = null;try{connection = this.getJdbcTemplate().getDataSource().getConnection();preparedStatement = connection.prepareStatement(sql);resultSet = preparedStatement.executeQuery();while(resultSet.next()){totalCount = resultSet.getInt(1);}}catch (Exception e) {e.printStackTrace();}finally{if(resultSet!=null){resultSet.close();}if(preparedStatement!=null){preparedStatement.close();}if(connection!=null){connection.close();}}return totalCount;}
?