📄 pagesize.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" import="java.io.*" errorPage="errorpage.jsp" %>
<%@ include file="conn.jsp"%>
<%
int i;
int ipage=10; //分页单位
int allpage; //总页数
int pages; //接受的页码变量
int cpage=1; //当前页
int spage; //开始页
Statement stmtp=conn.createStatement();
String sqlp="select count(ID) as rscount from text_content";
ResultSet rsp=stmtp.executeQuery(sqlp);
rsp.next();
int allCol = rsp.getInt("rscount");
allpage = (int)Math.ceil((allCol + ipage-1) / ipage);//获得总页面数
if (request.getParameter("pages")==null) {
pages=1;
} else {
pages = new Integer(request.getParameter("pages")).intValue();
} //判断参数pages是否为空
if(pages > allpage || pages == 0){
cpage = 1;
} else {
cpage = pages;
} //判断当前页
spage=(cpage-1)*ipage;
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from text_content";
ResultSet rs = stmt.executeQuery(sql);
rs.absolute(spage+1);
%>
<!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=gb2312">
<title></title>
</head>
<body>
<%out.print(rsp.getInt("rscount")+"个记录");%>
<%int n=1;
while (n<=(ipage)){
out.print(rs.getInt("ID")+",");
rs.next();
n++;
out.print(allpage);
}
out.print(request.getServletPath());
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -