数据库分页技术的基本语句

  这个是在sql server 2005里面的语句

public static List<Suggestion> findAllSuggestion() throws SQLException {
   int Size = 4,start=1;
   
   List<Suggestion> suggestionList = new ArrayList<Suggestion>();
   String sql ="select top "+Size+" * from Suggestion where S_id not in(select top "+start+" S_id from Suggestion order by S_id)";  
   QueryRunner runner = new QueryRunner(JdbcUtil.getDataSource());
   System.out.println("sql:"+sql);
   suggestionList = (List<Suggestion>)runner.query(sql,new BeanListHandler(Suggestion.class));
   System.out.println("this is suggestionList"+suggestionList);
   return suggestionList;
  }

 

这里的和sql server 2000里面有着很大不同,下面是sql server 2000里面的。

public static List<Suggestion> findAllSuggestion(int size,int sizestart) throws SQLException {
  List<Suggestion> suggestionList = new ArrayList<Suggestion>();
  String sql ="select top ? * from Suggestion where S_id not in(select top ? S_id from Suggestion order by S_id);";
  QueryRunner runner = new QueryRunner(JdbcUtil.getDataSource());
  suggestionList = (List<Suggestion>)runner.query(sql, new Object[]{size,sizestart},new BeanListHandler(Suggestion.class));
  return suggestionList;
 }