sqlStr = "select count(*) from my_users"; //取出记录数
int rscount = pageSize;
try
{
ResultSet rs1 = stmt.executeQuery(sqlStr);
if (rs1.next()) recordCount = rs1.getInt(1);
rs1.close();
}
catch (SQLException e)
{
close();
return false;
}
//设定有多少pageCount
if (recordCount < 1)
pageCount = 0;
else
pageCount = (int)(recordCount - 1) / pageSize + 1;
//检查查看的页面数是否在范围内
if (page < 1)
page = 1;
else if (page > pageCount)
page = pageCount;
rscount = (int) recordCount % pageSize; // 最后一页记录数 //sql为倒序取值
sqlStr = "select * from My_users ";
if (page == 1)
{
sqlStr = sqlStr + " order by Id desc";
} else {
sqlStr = sqlStr + " where Id not in ( select Id from My_users ORDER BY id) and Id in " +
"(select Id from My_users ORDER BY ID) " + " order by Id desc"; //这句怎么理解看不懂 怎么分页
}
try
{
rs = stmt.executeQuery(sqlStr);
userlist = new Vector();
while (rs.next()){
shopuser user = new shopuser();
user.setId(rs.getLong("Id"));
user.setUserName(rs.getString("UserName"));
user.setPassWord(rs.getString("PassWord"));
user.setNames(rs.getString("Names"));
user.setSex(rs.getString("Sex"));
user.setAddress(rs.getString("Address"));
user.setPhone(rs.getString("Phone"));
user.setPost(rs.getString("Post"));
user.setEmail(rs.getString("Email"));
user.setRegTime(rs.getString("RegTime"));
user.setRegIpAddress(rs.getString("RegIpAddress"));
userlist.addElement(user);
}
rs.close();
return true;
}
catch (SQLException e)
{
System.out.println(e);
return false;
}
}
int rscount = pageSize;
try
{
ResultSet rs1 = stmt.executeQuery(sqlStr);
if (rs1.next()) recordCount = rs1.getInt(1);
rs1.close();
}
catch (SQLException e)
{
close();
return false;
}
//设定有多少pageCount
if (recordCount < 1)
pageCount = 0;
else
pageCount = (int)(recordCount - 1) / pageSize + 1;
//检查查看的页面数是否在范围内
if (page < 1)
page = 1;
else if (page > pageCount)
page = pageCount;
rscount = (int) recordCount % pageSize; // 最后一页记录数 //sql为倒序取值
sqlStr = "select * from My_users ";
if (page == 1)
{
sqlStr = sqlStr + " order by Id desc";
} else {
sqlStr = sqlStr + " where Id not in ( select Id from My_users ORDER BY id) and Id in " +
"(select Id from My_users ORDER BY ID) " + " order by Id desc"; //这句怎么理解看不懂 怎么分页
}
try
{
rs = stmt.executeQuery(sqlStr);
userlist = new Vector();
while (rs.next()){
shopuser user = new shopuser();
user.setId(rs.getLong("Id"));
user.setUserName(rs.getString("UserName"));
user.setPassWord(rs.getString("PassWord"));
user.setNames(rs.getString("Names"));
user.setSex(rs.getString("Sex"));
user.setAddress(rs.getString("Address"));
user.setPhone(rs.getString("Phone"));
user.setPost(rs.getString("Post"));
user.setEmail(rs.getString("Email"));
user.setRegTime(rs.getString("RegTime"));
user.setRegIpAddress(rs.getString("RegIpAddress"));
userlist.addElement(user);
}
rs.close();
return true;
}
catch (SQLException e)
{
System.out.println(e);
return false;
}
}
可以这样写分页(如果数据不多可以这样写,数据多了就写个proc方便)
select top @perPageCount * from table where id not in(select top @perPageCount*(@page-1) id from table order by id) order by id --@perPageCount是每页显示的数据行数,@page是当前第几页,id是自动编号的