jsp使用mysql分页_jsp+mysql实现分页 | 学步园

.恭喜你

 登录成功！

返回重新登录

用户信息列表

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

QQ

email

//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) {

out.println("

+ ">上一页

");

}

for (int i = 1; i <= pageCount; i++) {

out

.println("[" + i

+ "]");

}

if (pageNow != pageCount) {

out.println("

+ ">下一页

");

}

%>

之前分页那儿遇到瓶颈，今天来看，突然就发现好简单                大概当时思维太乱吧