gu123xin
2018-08-01 02:26
采纳率: 95.2%
浏览 1.5k
已采纳

java读取mysql数据了过大,如何实现分页读取,求代码

sql = "SELECT id, name, url ,country FROM websites";/*需要从表里面读取的数据*/
ResultSet rs = stmt.executeQuery(sql);

String fn = "F://NEWtest//again1.txt";
wf(fn,"ID ,站点名称, 站点,country.");
while(rs.next()){

    int id  = rs.getInt("id");            
    String name = rs.getString("name");
    String url = rs.getString("url");
    String country = rs.getString("country");



    System.out.print("ID: " + id);

    System.out.print(", 站点名称: " + name);

    System.out.print(", 站点 URL: " + url);
    System.out.print(", country: " + country);

    System.out.print("\n");
    wf(fn,id+"," + name+ "," + url+ "," + country);
}
    这是读取数据库的代码,需要分页读取的代码,麻烦详细些,我刚刚接触java,谢谢
  • 写回答
  • 好问题 提建议
  • 追加酬金
  • 关注问题
  • 邀请回答

14条回答 默认 最新

  • qq_32126131 2018-08-01 02:39
    最佳回答

    下面方法select(String page)的page是前台传到后台的 ,然后处理下page从数据库中分页顺序取出数据
    public JSONArray select(String page) {

        int limit = 10;
        JSONArray jsonArr = new JSONArray();
        Statement stmt = null;
        int start = (Integer.valueOf(page).intValue()-1) * limit;
        String sql = "SELECT id, name, url ,country FROM websites ORDER BY CREATTIME DESC LIMIT " + start + ",10;";
        ResultSet rs = stmt.executeQuery(sql);
                while(rs.next()){
    
    int id  = rs.getInt("id");            
    String name = rs.getString("name");
    String url = rs.getString("url");
    String country = rs.getString("country");
    
    
    
    System.out.print("ID: " + id);
    
    System.out.print(", 站点名称: " + name);
    
    System.out.print(", 站点 URL: " + url);
    System.out.print(", country: " + country);
    
    System.out.print("\n");
    wf(fn,id+"," + name+ "," + url+ "," + country);
    

    }
    }

    评论
    解决 无用
    打赏 举报
查看更多回答(13条)

相关推荐 更多相似问题