📄 show.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%
Connection con;
Statement sql;
ResultSet rs;
int i=0,j=0;
int perPage=3;
int PageNums=0;
int currentPage=0;
int total=0;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e){out.println("forname err");
}
try{
con=DriverManager.getConnection("jdbc:odbc:shop","","");
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
String condition="SELECT book_name,picname FROM book";
rs=sql.executeQuery(condition);
rs.last();//将游标移动到最后一行。
if(rs.getRow() % perPage ==0)
PageNums= rs.getRow() / perPage ;//rs.getRow获取最后一行的行号。
else{
PageNums= rs.getRow() / perPage+1;
}
for(i=1;i<=PageNums;i++)
out.println("<a href=show.jsp?PageNo=" + Integer.toString(i) + "> " + Integer.toString(i) +" </a>");
String PageNo=request.getParameter("PageNo");
if (PageNo==null)
{ currentPage=1; }
else { currentPage=Integer.parseInt(PageNo); }
rs.absolute((currentPage-1)*perPage+1); //移动游标。
for(i=1;i<=perPage;i++)
{
out.println("<p>"+rs.getString(1)+"<p>");
rs.next();
}
}
catch (Exception e){e.printStackTrace();}
/* String PageNo=request.getParameter("PageNo");
if (PageNo==null)
{
}
else {
out.print(PageNo);
out.print("now in page3");
}
*/
%>
<!--a href="show.jsp?PageNo=3">goto page3</a> -->
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -