.恭喜你
登录成功!
用户信息列表
int pageSize = 3;
int pageNow = 1;//默认显示第一页
int pageCount = 0; //通过pageSize 和rowCount 计算
int rowCount = 0;
//对下面传过来的pageNow的值做处理
String s_pageNow = request.getParameter("pageNow");
if (s_pageNow != null) {
pageNow = Integer.parseInt(s_pageNow);
}
//加驱动
String url = "jdbc:mysql://localhost/userms_db";
String username = "root";
String password = "333";
//连接数据库
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn = DriverManager.getConnection(url, username,
password);
//生成Statement
Statement stmt = conn.createStatement();
String sql = "select count(*) from user";
ResultSet rs = stmt.executeQuery(sql);
//得到rowCount
if (rs.next()) {
rowCount = rs.getInt(1);
}
//得到pageCount
if (rowCount % pageSize == 0) {
pageCount = rowCount / pageSize;
} else {
pageCount = rowCount / pageSize + 1;
}
%>
user_id | user_name | passwd | sex |
//sql = "select top " + pageSize
//+ "* from user where user_id not in( select top " + pageSize
//* (pageNow - 1) + " user_id from user)";//难道只适合sqlsever?用到这里会报错
sql = "select * from user order by user_id LIMIT "+(pageNow-1)*pageSize+"," + pageSize+" ";//如果pageNow为2,
//那么他前面有一页,每页显示3条记录,那么第二页显示的记录就该是从(2-1)*3【第4条(记录是从0开始编号的)】记录开始,依次往后加3条【包括第四条】
rs = stmt.executeQuery(sql);
while (rs.next()) {
%>
}
%>
//显示超链接部分
if (pageNow != 1) {
");}
for (int i = 1; i <= pageCount; i++) {
out
.println("[" + i
+ "]");
}
if (pageNow != pageCount) {
");}
%>
之前分页那儿遇到瓶颈,今天来看,突然就发现好简单 大概当时思维太乱吧