XListView更新数据（分页版）

java端关键代码：
eclipse中的查询语句为：
public List game_list_limit(int m,int n) throws SQLException {
Connection conn=null;
PreparedStatement ps=null;
ResultSet rs=null;
List game2=new ArrayList();
conn=JdbcUtils.getConnection();
//利用limit来限制查询的数目和位置
ps=conn.prepareStatement(“select * from game limit ?,?”);
ps.setInt(1, m);
ps.setInt(2, n);
rs=ps.executeQuery();
while(rs.next()){
Game ga2=new Game(rs.getInt(“game_id”), rs.getString(“game_img”),rs.getString(“game_name”),
rs.getString(“game_size”),rs.getInt(“game_pnum”), rs.getString(“game_pres”),rs.getInt(“game_scor”),
rs.getBoolean(“game_rmb”),rs.getString(“game_class”),null);
game2.add(ga2);
}
close(conn,ps,rs);
return game2;
}
Servlet端的代码为:
//分页查询游戏列表
List list2=null;
//startIndex是查询位置，从0开始
int startIndex=Integer.parseInt(request.getParameter(“startIndex”));
//count是查询条数，每次查5条
int count=Integer.parseInt(request.getParameter(“count”));
System.out.println(“SendData_Game_home.doGet()”+startIndex+”,”+count);
Game_list_dao game_page=new Game_list_dao();
try {
list2=game_page.game_list_limit(startIndex, count);
} catch (SQLException e1) {
// TODO Auto-generated catch block
e1.printStackTrace();
}
String result3=gson.toJson(list2);
printWriter.write(result3);
System.out.println(“SendData_Game_home.doGet()”+result3);
printWriter.close();
break;
default:
break;
}
}
在安卓studio端：
先定义每次查询的位置和条数：
//游戏总量，还有每次显示的条数
int startIndex=0;
int pageCount=5;
//上拉刷新
清空列表数据再传入位置和条数
public void onRefresh() {
handler.postDelayed(new Runnable() {
@Override
public void run() {
game.clear();
startIndex=0;
getpageWeb(startIndex,pageCount);
onLoad();
}
},2000);
}
//上拉加载中
@Override
public void onLoadMore() {
handler.postDelayed(new Runnable() {
@Override
//位置从0变到了数组的下标位置
startIndex=game.size();
getpageWeb(startIndex,pageCount);
onLoad();
}
},2000);
}
//发送数据：
public Object getpageWeb(int m, int n) {
RequestParams params=new RequestParams(url); params.addQueryStringParameter(“flag”,”game_list_page”);
params.addQueryStringParameter(“startIndex”,m + “”);
params.addQueryStringParameter(“count”,n + “”);
Log.i(“zjn”, “getpageWeb: “+m+”,”+n);
x.http().get(params, new Callback.CommonCallback() {
@Override
public void onSuccess(String result) {
Type type=new TypeToken