📄 rock.jsp
字号:
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>专题</title>
<style>
td{font-size:10pt;}
.size10{font-size:10pt}
</style>
</head>
<body>
<table><tr><td>序号</td><td>标题</td></tr>
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*" %>
<%@ page import="java.lang.*"%>
<jsp:useBean id="reg" class="rock.myoracle_scroll"/>
<%
int pagesize=8;
int rownum;
int pagecount;
int intpage;
String strpage=request.getParameter("intpage");
if (strpage==null)
strpage="1";
intpage=Integer.parseInt(strpage);
String sql="select title from media_table";
ResultSet rs=reg.executequery(sql);
rs.last();
rownum=rs.getRow();
pagecount=(rownum+pagesize-1)/pagesize;
if (intpage>pagecount)
intpage=pagecount;
rs.absolute((intpage-1)*pagesize+1);
int i=0;
do{
String title=rs.getString("title");
i+=1;
%>
<tr><td><%=(intpage-1)*pagesize+i%></td><td><%=title%></td></tr>
<%
}while((rs.next())&&(i<pagesize));
rs.close();
%>
</table>
<div class="size10">第<%=intpage%>页 共<%=pagecount%>页
<%
if (intpage!=1){
%>
 <a href="rock.jsp?intpage=<%=intpage-1%>">上一页</a>
<%
}
if (intpage!=pagecount){
%>
 <a href="rock.jsp?intpage=<%=intpage+1%>">下一页</a>
<%
}
%>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -