<%! int Size=20;//每页几行数据。
int Count=0;//总页数。
int zz=0;
%>
<% handlePage.setPageSize(Size);%>
<%String strtext=request.getParameter("textfield4");
handlePage.CovC(strtext);
%>
<% Connection con;
Statement sql,sqls;
ResultSet rs,rss;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
con=DriverManager.getConnection("jdbc:odbc:6848","sa","123");
sqls=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rss=sqls.executeQuery("select count(cname) from info where cname like '%"+handlePage.getCovC()+"%'");
rss.next();
int lastRow=Integer.parseInt(rss.getString(1));
handlePage.setPageCount(lastRow,Size);
//当前页码。
%>
<%String str=response.encodeRedirectURL("select.jsp");%>
<% String integer=request.getParameter("a"); //获取表单提交的信息。
int s;
out.print(integer);
if(integer==null)
{ handlePage.setShowPage(0);
}
else if(integer.equals("next"))
{ s=handlePage.getShowPage();
s=s+1;
handlePage.setShowPage(s);
if(s<1)//当小于最小页码的时候;
{s=1;
handlePage.setShowPage(0);}
if(s>=handlePage.getPageCount())//当大于总页的时候;
{s=handlePage.getPageCount();
handlePage.setShowPage(s); }
}
else if(integer.equals("previous"))
{ s=handlePage.getShowPage();
s=s-1;
handlePage.setShowPage(s);
if(s<1)
{s=1;
handlePage.setShowPage(0);}
if(s>=handlePage.getPageCount())
{s=handlePage.getPageCount();
handlePage.setShowPage(s);}
}
else{
try{s=Integer.parseInt(integer);}
catch(NumberFormatException e)
{s=1;}
if(s<=1)
{s=1;
handlePage.setShowPage(0);
zz=1;
}
if(s>=handlePage.getPageCount())
{s=handlePage.getPageCount();}
handlePage.setShowPage(s);
}
if(lastRow<handlePage.getPageSize())
{
handlePage.setShowPage(0);
s=1;
zz=1;
}
else { zz=handlePage.getPageCount();
s=handlePage.getShowPage()+1;
}
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("select top "+handlePage.getPageSize()+" webadd,cname from info where cname like '%"+handlePage.getCovC()+"%' and cname not in(select top "+(handlePage.getShowPage()*handlePage.getPageSize())+" cname from info where cname like '%"+handlePage.getCovC()+"%'order by cname asc) order by cname asc");
out.print("<table border=0 width=300 align=left cellpadding=0 cellspacing=0>");
while(rs.next())
{out.print("<tr>");
out.print("<td><font size=2><a href="+rs.getString(1)+" target='_blank'>"+rs.getString(2)+"</a></font></td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
%>
int Count=0;//总页数。
int zz=0;
%>
<% handlePage.setPageSize(Size);%>
<%String strtext=request.getParameter("textfield4");
handlePage.CovC(strtext);
%>
<% Connection con;
Statement sql,sqls;
ResultSet rs,rss;
try{Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
catch(ClassNotFoundException e){}
con=DriverManager.getConnection("jdbc:odbc:6848","sa","123");
sqls=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rss=sqls.executeQuery("select count(cname) from info where cname like '%"+handlePage.getCovC()+"%'");
rss.next();
int lastRow=Integer.parseInt(rss.getString(1));
handlePage.setPageCount(lastRow,Size);
//当前页码。
%>
<%String str=response.encodeRedirectURL("select.jsp");%>
<% String integer=request.getParameter("a"); //获取表单提交的信息。
int s;
out.print(integer);
if(integer==null)
{ handlePage.setShowPage(0);
}
else if(integer.equals("next"))
{ s=handlePage.getShowPage();
s=s+1;
handlePage.setShowPage(s);
if(s<1)//当小于最小页码的时候;
{s=1;
handlePage.setShowPage(0);}
if(s>=handlePage.getPageCount())//当大于总页的时候;
{s=handlePage.getPageCount();
handlePage.setShowPage(s); }
}
else if(integer.equals("previous"))
{ s=handlePage.getShowPage();
s=s-1;
handlePage.setShowPage(s);
if(s<1)
{s=1;
handlePage.setShowPage(0);}
if(s>=handlePage.getPageCount())
{s=handlePage.getPageCount();
handlePage.setShowPage(s);}
}
else{
try{s=Integer.parseInt(integer);}
catch(NumberFormatException e)
{s=1;}
if(s<=1)
{s=1;
handlePage.setShowPage(0);
zz=1;
}
if(s>=handlePage.getPageCount())
{s=handlePage.getPageCount();}
handlePage.setShowPage(s);
}
if(lastRow<handlePage.getPageSize())
{
handlePage.setShowPage(0);
s=1;
zz=1;
}
else { zz=handlePage.getPageCount();
s=handlePage.getShowPage()+1;
}
sql=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
rs=sql.executeQuery("select top "+handlePage.getPageSize()+" webadd,cname from info where cname like '%"+handlePage.getCovC()+"%' and cname not in(select top "+(handlePage.getShowPage()*handlePage.getPageSize())+" cname from info where cname like '%"+handlePage.getCovC()+"%'order by cname asc) order by cname asc");
out.print("<table border=0 width=300 align=left cellpadding=0 cellspacing=0>");
while(rs.next())
{out.print("<tr>");
out.print("<td><font size=2><a href="+rs.getString(1)+" target='_blank'>"+rs.getString(2)+"</a></font></td>");
out.print("</tr>");
}
out.print("</table>");
con.close();
%>
比如要获得100-200之间的记录
create view v1 as select top 200 * from tbl order by id asc
select top 100 * from v1 order by id desc