<%@ page import="java.lang.*"%>
<%@ page contentType="text/html;charset=gb2312" %>
<%@ include file="..\..\..\data.jsp" %>
<head>
</head>
<body bgcolor=#eff3ff>
所有文章分页bean测试
<%
Rst = db.executeQuery("select count(*) from Article" );
Rst.next();
long data_num=Rst.getLong(1);
long Current_Page = 0;
String currentpage=(String)request.getParameter("currentpage");
if (currentpage != null && !currentpage.equals("")){
Current_Page = Integer.parseInt(request.getParameter("currentpage"));
}
String Query_Page=(String)request.getParameter("Query_Page");
if (Query_Page!=null && !Query_Page.equals("")){
Current_Page = Integer.parseInt(request.getParameter("Query_Page"))-1;
}
PageCount.Init(Current_Page,data_num);
long l_start = PageCount.getStart();
long l_end = PageCount.getEnd();
//查询记录
Rst= db.executeQuery("select * from Article " );
long i=0;
while((i
i++;
}
//输出查询结果
long j=0;
while(Rst.next() && (i
j=i+1;
String col1=Rst.getString(1);
String col2 = Rst.getString(2);
String col3 = Rst.getString(3);
String col4 = Rst.getString(4);
String col5 = Rst.getString(5);
String col6 = Rst.getString(6);
String col7 = Rst.getString(7);
String col8 = Rst.getString(8);
String col10=Rst.getString(10);
//打印所显示的数据
out.println("<table border=0 width=600>");
out.println("<tr><td colspan=2>" + j + "、ID号 "+(col1==null?"":col1)+"</td></tr><tr><td colspan=2>资源名："+(col3==null?"":col3)+"</td></tr>");
out.println("<tr><td> 作者："+(col4==null?"":col4)+"</td><td>
↑返回目录
前一篇: 高效的jsp分页查询
后一篇: JSP调用JavaBean在网页上动态生成柱状图