SELEC TOP 20 *
FROM TABLE
WHERE ID NOT IN (SELECT TOP 20 * (N - 1)) ID FROM TABLE ORDER BY ID)
ORDER BY ID
FROM TABLE
WHERE ID NOT IN (SELECT TOP 20 * (N - 1)) ID FROM TABLE ORDER BY ID)
ORDER BY ID
解决方案 »
- <s:optiontransferselect 标签的属性
- 请教高手jfreechart异常
- struts2 标签问题
- linux-jsp-jdbc
- 从 word 中把复制的图片 粘贴 到Fck! 以前都行.怎么突然一下又不行了?
- 关于N级分类在多个列表框取值问题
- JSP连接数据库问题,急啊,在线等~~
- 前页是用下拉菜单选取的值,下一页怎样读取此值在下拉框中成为不可变灰值,数据库又可以读取
- 关于JSP+TOMCAT4的中文显示问题,!!!
- 求助求助,求大佬求解!
- 急!明天就要出差了!这个分页带来的乱码问题还是解决不了?解决了马上给分!
- 紧急求救:如何发送一个http请求,截取某网站的文本内容,在线跪等!!!
<%@ page contentType="text/html;charset=gb2312"%>
<jsp:useBean id="cn" scope="page" class="myConnection.Conn" /><!--引用数据库操作的bean,自己完成,这里不再赘述-->
<%
int curpage=1;//当前页
int page_record=20;//每页显示的记录数
//用下面的方法(sql查询完成,速度快)
curpage=Integer.parseInt(request.getParameter("page"));//获取传递的值,需要显示的页
ResultSet rs=cn.rsexecuteQuery("select top "+page_record+" * from tablename where id not in (select top "+(curpage*page_record)+" id from tablename order by id desc) order by id desc");
//本查询语句得到的是所要显示的1000页的20条记录,大致思路为――子查询排除需要显示的记录前的所有记录,父查询则对余下的记录进行降序排列
while(rs.next) {
out.println(rs.getInt("id").toString());
}
rs.close();
%>
查查分页
java.lang.NumberFormatException: null真是急死我了 是什么原因?
select * from t_user limit 3,这是搜前3条记录;
select * from t_user limit 3,5 这是搜从第3条记录开始的5条记录。根据实际情况自己灵活运用。
int ipage;//当前页
try
{
String page=request.getParameter("page");//分页参数,读取请求的当前页
ipage=java.lang.Integer.parseInt(page,10);
}
catch (Exception e)
{
ipage=m_UserEditForm.getPage();
}
if(ipage<1)ipage=1;
Collection col = m_UserEditDAO.findSQL(sql,ipage);//通过DAO对象查询数据
request.setAttribute("UserEdit",col); //保存数据
String pagestr=m_UserEditDAO.getPagestr(ipage);//分页字符串,分页内容
String s_find,str;
if(!"search".equals(search)) //查找和全部显示两个不同的操作,其分页字符串不同,在此进行处理。如果是全部显示则去掉"search=search&"
{
s_find="search=search&";
while(pagestr.indexOf(s_find)!=-1)
{
str=pagestr.substring(0,pagestr.indexOf(s_find));
str+=pagestr.substring(pagestr.indexOf(s_find)+s_find.length(),pagestr.length());
pagestr=str;
}
}
m_UserEditForm.setPagestr(pagestr);
m_UserEditForm.setAction(action);
request.setAttribute("UserEditForm",m_UserEditForm);
<%@ page import="java.sql.*"%>
<%
int pagesize=2;//每页显示记录数
int recordcount=0;//记录总数
int pagecount=0;//总页数
int pageid=1;//待显页码
Connection conn=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
conn=DriverManager.getConnection("jdbc:odbc:jspguest","sa","sa");
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
//String name=request.getParameter("name");
//String pwd=request.getParameter("pwd");
//String sql="select * from system where adminname like '%"+name+"%' and name like '%"+pwd+"%' order by user_id desc";
String sql="select * from message";
ResultSet rs=stmt.executeQuery(sql);
rs.last();
recordcount=rs.getRow();//取得总记录数
pagecount=(recordcount%pagesize==0?(recordcount/pagesize):(recordcount/pagesize)+1);//取得总页数
int count=1;
String strpage=request.getParameter("pageid");
if(strpage==null) pageid=1;
else pageid=Integer.parseInt(strpage);
if(pageid>recordcount) pageid=recordcount;
if(recordcount>0){
rs.absolute((pageid-1)*pagesize+1);}
int i=0;
//rs.previous();
rs.beforeFirst();
while(rs.next()&&count<=pagesize){
count++;
i++;
out.print(rs.getString("name"));
out.print("||");
out.print(rs.getString("title"));
out.print("<br>");
}
out.print("共");
out.print(pagecount);
out.print("页");
out.print("共");
out.print(recordcount);
out.print("条");
out.print("第");
out.print(pageid);
out.print("页");
out.print("<br>");
if(pageid<pagecount){
out.print("<a href=del.jsp?pageid=");
out.print(pageid+1);
out.print(">下一页</a>");}
if(pageid>1){
out.print("<a href=del.jsp?pageid=");
out.print(pageid-1);
out.print(">上一页</a>");}
out.print("<br>");
for(int j=1;j<=pagecount;j++){
out.print("<a href=del.jsp?pageid=");
out.print(j);
out.print(">");
out.print(j);
out.print("</a>");}
stmt.close();
conn.close();
}
catch(ClassNotFoundException e){
out.println(e.getMessage());
}
catch(SQLException e) {
out.println(e.getMessage());
}
finally{
try{
if(conn != null)
conn.close();
}
catch(Exception e){}
}
%>