static int gogo = 0;
static int to =3;
public static List querydList(String desttermid){
Connection con = ConnectionManager.getConnection();
PreparedStatement pre = null;
ResultSet res = null;
List<DeleteBean> list = new ArrayList<DeleteBean>();
boolean isTRue = true;
try{
while(isTRue){
String sqlStr = "SELECT id,name,sex,age,ptal, from whiteswap limit ?,?";
pre = con.prepareStatement(sqlStr);
pre.setInt(1, gogo);
pre.setInt(2, to);
res = pre.executeQuery();
while(res.next()){
String number = res.getString("number");
//
DeleteBean db =new DeleteBean();
db.setNumber(number);
list.add(db);
}
gogo += to; ///////////////////// to 为啥不跌加 初使是3 下次还是3
System.out.println(to+"ddddd");
System.out.println(gogo+"uuuuu");
/* if(res.next()==false){
System.out.println("我进入false了");
isTRue = false;
}*/
}
}catch(SQLException e){
e.printStackTrace();
}finally{
try{
pre.close();
con.close();
}catch(SQLException e){
e.printStackTrace();
}
}
return list;
}
static int to =3;
public static List querydList(String desttermid){
Connection con = ConnectionManager.getConnection();
PreparedStatement pre = null;
ResultSet res = null;
List<DeleteBean> list = new ArrayList<DeleteBean>();
boolean isTRue = true;
try{
while(isTRue){
String sqlStr = "SELECT id,name,sex,age,ptal, from whiteswap limit ?,?";
pre = con.prepareStatement(sqlStr);
pre.setInt(1, gogo);
pre.setInt(2, to);
res = pre.executeQuery();
while(res.next()){
String number = res.getString("number");
//
DeleteBean db =new DeleteBean();
db.setNumber(number);
list.add(db);
}
gogo += to; ///////////////////// to 为啥不跌加 初使是3 下次还是3
System.out.println(to+"ddddd");
System.out.println(gogo+"uuuuu");
/* if(res.next()==false){
System.out.println("我进入false了");
isTRue = false;
}*/
}
}catch(SQLException e){
e.printStackTrace();
}finally{
try{
pre.close();
con.close();
}catch(SQLException e){
e.printStackTrace();
}
}
return list;
}
你只对gogo叠加了、、、
直接在方法内,to=。。就可以赋值啊。。你这个代码就是要完成数据库查询分页??
为什么不给querydList方法添加两个参数start,limit表示这次查询的区间呢public static List querydList(String desttermid, int start, int limit)
比如每页10个,则要查询第一页就调用querydList("",0,10),第二页querydList("",1,10)
当然,最好是把limit作为这个类的静态变量,这样不用每次传参
System.out.println("我进入false了");
isTRue = false;
}如果我这么写的话 查询玩 3条就断了 不继续查了