oracle:select name,age,address,rownum from userInfo rownum between startNum and endNum;mysql:select name,age,address,rownum from userInfo limited startNum endNum;
请问楼上的, sqlserver版的sql语句怎么写??
String sql; String block=request.getParameter("block"); if (block==null) sql="select * from content order by id DESC"; elsesql="select * from content where block='"+block+"'order by id DESC"; ResultSet rs=stmt.executeQuery(sql);String title; String content; String c_block; String reply;int intPageSize; int intRowCount; int intPageCount; int intPage; String strPage; int i; intPageSize = 5 //ÿҳÏÔʾµÄÒ³Êý ; strPage = request.getParameter("page"); if(strPage==null){ intPage = 1; } else { intPage = Integer.parseInt(strPage); if(intPage<1){ intPage = 1;} } rs.last(); intRowCount = rs.getRow(); intPageCount =(intRowCount+intPageSize-1) / intPageSize; if(intPage>intPageCount) intPage = intPageCount; if(intPageCount>0){ rs.absolute((intPage-1) * intPageSize+1); i = 0; 显示
只要web发送xml请求,包括属性,查询从第几开始,到第几结束。然后在程序中处理就好办了。把list都拿到数组中,在cache中遍历速度很快的,拿到从几到几就可以了。如果在sql中,可用between。oracle,有个rownum的概念。如果每页100条,取第二页从101条到200条,可以rownum 200 minus rownum100
sqlserver版的sql语句怎么写??
String block=request.getParameter("block");
if (block==null)
sql="select * from content order by id DESC";
elsesql="select * from content where block='"+block+"'order by id DESC";
ResultSet rs=stmt.executeQuery(sql);String title;
String content;
String c_block;
String reply;int intPageSize;
int intRowCount;
int intPageCount;
int intPage;
String strPage;
int i;
intPageSize = 5 //ÿҳÏÔʾµÄÒ³Êý
;
strPage = request.getParameter("page");
if(strPage==null){
intPage = 1;
}
else
{
intPage = Integer.parseInt(strPage);
if(intPage<1){ intPage = 1;}
}
rs.last();
intRowCount = rs.getRow();
intPageCount =(intRowCount+intPageSize-1) / intPageSize;
if(intPage>intPageCount) intPage = intPageCount;
if(intPageCount>0){
rs.absolute((intPage-1) * intPageSize+1);
i = 0; 显示