mysql desc 分页显示_基于Mysql的分页显示

代码写在了下面，可以将Java代码进行封装，然后直接页面调用就行了，这样直接写在jsp页面中显得比较混乱，不过写下来防止忘记，方便查阅！！

String path = request.getContextPath();

String basePath = request.getScheme() + "://"

+ request.getServerName() + ":" + request.getServerPort()

+ path + "/";

%>

String str = "";%>

String login = (String) session.getAttribute("login");

if (login != null && login.equals("true")) {

flag = true;

}

%>

int pageSize = 3; //每页记录的条数

int pageNo = 0; //第几页

int tolPage = 0; //共几页

Class.forName("com.mysql.jdbc.Driver");

String url = "jdbc:mysql://localhost/bbs?user=root&password=wangkang";

Connection conn = DriverManager.getConnection(url);

Statement stmt = conn.createStatement();

ResultSet rs = null;

//关于分页的算法--计算总页数

Statement stmt1 = conn.createStatement();

rs = null;

rs = stmt1

.executeQuery("select count(*) from article where pid = 0");

rs.next();

int tolNum = rs.getInt(1);

stmt1.close();

//计算总页数

if (tolNum % pageSize == 0) {

tolPage = tolNum / pageSize;

} else {

tolPage = tolNum / pageSize + 1;

}

/**

*分页算法

*/

String pageStr = request.getParameter("pageNo");

if (pageStr == null || pageStr.equals("")) {

pageNo = 1;

} else {

if (Integer.parseInt(pageStr) <= 0) {

pageNo = 1;

} else if (Integer.parseInt(pageStr) >= tolPage) {

pageNo = tolPage;

} else {

pageNo = Integer.parseInt(pageStr);

}

}

int pagePos = (pageNo - 1) * pageSize; //起始记录位置

//Mysql中关于分页的sql语句

rs = stmt

.executeQuery("select * from article where pid=0 order by pdate desc limit "

+ pagePos + "," + pageSize);

String strLogin = "";

String fStr = "";

while (rs.next()) {

if (flag) {

fStr = "删除";

}

str += "

" + rs.getInt("id") + ""

+ "" + rs.getString("title") + "" + "

"

+ fStr + "

";

}

/*

//关于分页的算法--计算总页数

Statement stmt1 = conn.createStatement();

rs = null;

rs = stmt1

.executeQuery("select count(*) from article where pid = 0");

rs.next();

int tolNum = rs.getInt(1);

stmt1.close();

if (tolNum % 3 == 0) {

tolPage = tolNum / 3;

} else {

tolPage = tolNum / 3 + 1;

}

*/

/*

if (pageStr == null || pageStr.equals("")) {

pageNo = 1;

} else {

if (Integer.parseInt(pageStr) <= 0) {

pageNo = 1;

} else if(pageNo >= tolPage){

pageNo = tolPage;

} else {

pageNo = Integer.parseInt(pageStr);

}

}

*/

rs.close();

stmt.close();

conn.close();

%>

My JSP 'ShowArticleTree.jsp' starting page

增加新话题

str = "";

flag = false;

%>

共页  第页

<

>

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

%>

>

第页

}

%>

name="pageNo">