<jsp:useBean id="yy" scope="page" class="yy.jdbc"/>
<%! String Notice_Id,sql,Not_Title,Not_Content,Submit_Button;%>
<%
int PageSize=10;
int RecordCount=0;
int PageCount=0;
int ShowPage=1;
Connection con=yy.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null; sql="Select * from 公告 order by 公告id desc";
// Statement stmt=con.createStatement();
rs=stmt.executeQuery(sql);
rs.last();
RecordCount=rs.getRow();
PageCount=(RecordCount % PageSize==0)?(RecordCount/PageSize):(RecordCount/PageSize+1);
String Page=request.getParameter("page");
if (Page!=null)
{
ShowPage=Integer.parseInt(Page);
if (ShowPage>PageCount)
ShowPage=PageCount;
else if(ShowPage<0)
ShowPage=1;
}else
ShowPage=1;if (RecordCount>0)
{
rs.absolute((ShowPage-1)*PageSize+1);
for (int i=1;i<PageSize;i++)
{
Notice_Id=rs.getString("公告id");
%>
哪位大侠帮忙解释一下这段代码啊~!跪求~!
<%! String Notice_Id,sql,Not_Title,Not_Content,Submit_Button;%>
<%
int PageSize=10;
int RecordCount=0;
int PageCount=0;
int ShowPage=1;
Connection con=yy.getConn();
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
ResultSet rs=null; sql="Select * from 公告 order by 公告id desc";
// Statement stmt=con.createStatement();
rs=stmt.executeQuery(sql);
rs.last();
RecordCount=rs.getRow();
PageCount=(RecordCount % PageSize==0)?(RecordCount/PageSize):(RecordCount/PageSize+1);
String Page=request.getParameter("page");
if (Page!=null)
{
ShowPage=Integer.parseInt(Page);
if (ShowPage>PageCount)
ShowPage=PageCount;
else if(ShowPage<0)
ShowPage=1;
}else
ShowPage=1;if (RecordCount>0)
{
rs.absolute((ShowPage-1)*PageSize+1);
for (int i=1;i<PageSize;i++)
{
Notice_Id=rs.getString("公告id");
%>
哪位大侠帮忙解释一下这段代码啊~!跪求~!
然后分页显示
最后对输出表的内容并进行分页处理