?? page.jsp
字號:
<%@ page import="java.sql.*,java.util.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%
String table=request.getParameter("table");
String sql="";
ResultSet rs=null;
int n=0;
int count=0;
int pages=1;//當前頁數,默認為1
int pagesize=2;
String nowpage=request.getParameter("pages");
if((nowpage!=null)&&(nowpage!=""))
pages=Integer.parseInt("nowpage");
if(pages>0)
{
try{
sql="select count(*) as id from "+table;
rs=yy.executeQuery(sql);
}catch(Exception e)
{
out.println(e.getMessage());
}
}if(rs.next())
count=rs.getInt("id");
yy.closeConn();
if(count>0)
{
n=(int)(count/pagesize);
if(n*pagesize<count)
n++;
if(n>=1)
{%>共<%=n%>頁:
<%
for(int i=1;i<=n;i++)
out.println("<a href=query.jsp?pages="+i+">"+i+" </a>");
}
}%>
<form action=query.jsp method=post>
跳到第:<input type=text name=pages size=2>頁
<input type=submit value=go>
</form>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -