sql = "SELECT id, name, url ,country FROM websites";/*需要從表里面讀取的數(shù)據(jù)*/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);
}
這是讀取數(shù)據(jù)庫的代碼，需要分頁讀取的代碼，麻煩詳細(xì)些，我剛剛接觸java，謝謝
1 回答
回首憶惘然
TA貢獻(xiàn)1847條經(jīng)驗 獲得超11個贊
下面方法select(String page)的page是前臺傳到后臺的 ，然后處理下page從數(shù)據(jù)庫中分頁順序取出數(shù)據(jù)
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);
}}添加回答
舉報
0/150
提交
取消