<%@ page language="java" import="java.sql.*"
contentType="text/html; charset=utf-8" pageEncoding="utf-8"%>
<jsp:useBean id="liuliking" scope="page" class="net.liulixin.ku.LianJie" />
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>西安小升初西安Java培训</title>
</head>
<body>
<%
Connection con = liuliking.getConn();
Statement stmt = con.createStatement();
String sql = "select * from people order by pk";
ResultSet rs = stmt.executeQuery(sql);//实际上,每点一次链接,这个语句要执行一次
String pages = request.getParameter("page");
int pageInt = 1, i = 1;
if (pages == null) {
} else {
pageInt = Integer.parseInt(pages);
}
while (i <=20 * (pageInt - 1) && rs.next()) {//rs.next()起到了越过前面已经显示了的条目的作用
i++;
}
%>
<%
int j = 1;
while (rs.next() && j <= 20) {
j++;
out.println(rs.getInt("pk"));
out.println(rs.getString("Music"));
out.println("<br/>");
}
%>
<%
for (int jj = 2; jj < 10; jj++) {
%>
<a href="NewFile3.jsp?page=<%=jj%>">第<%=jj%>页
</a>
<%
}
%>
<%
try {
rs.close();
stmt.close();
con.close();
} catch (Exception ex) {
}
%>
</body>
</html>
源代码:http://pan.baidu.com/share/link?shareid=461812&uk=3878681452
使用的表:http://blog.csdn.net/weiyanghuadi/article/details/8861667 这个表中有1000条记录