if page=1 then
StrSql="Select top " & pagesize & " Demand_Id,TrueName,LessonName,MajorName,CityName,PostTime From TrainDemand" & StrOrder
else
StrSql="Select top " & pagesize & " Demand_Id,TrueName,LessonName,MajorName,CityName,PostTime From TrainDemand Where Demand_Id<(select min(Demand_Id) from (select top " & cstr(pagesize*(page-1)) & " Demand_Id From TrainDemand" & StrOrder & ") as t)" & StrOrder
end if
StrSql="Select top " & pagesize & " Demand_Id,TrueName,LessonName,MajorName,CityName,PostTime From TrainDemand" & StrOrder
else
StrSql="Select top " & pagesize & " Demand_Id,TrueName,LessonName,MajorName,CityName,PostTime From TrainDemand Where Demand_Id<(select min(Demand_Id) from (select top " & cstr(pagesize*(page-1)) & " Demand_Id From TrainDemand" & StrOrder & ") as t)" & StrOrder
end if
解决方案 »
- 如果整合hibernate,struts,spring启动时报嵌套错误,是怎么回事!
- Hibernate session问题~
- 地址的表示
- 在JSP中执行SQL,SQL语句中没有 order by时一切正常,加上order by 时慢得要死,为什么啊?
- jar中存在外部文件读取的情况。
- javascript如何得到jsp中变量???
- 怎样用Jbuild9打包jsp文件?
- 急!急!急!java 群发邮件(1万封以上) 如何处理
- 有谁利用jsp做过upop的银联支付接口求分享
- 从那里可以下载APACHE,可以给完整的下载地址吗?
- 文本传值问题??
- Tomcat 配置问题(急急急急急急急急!!!!)
StrSql="Select top " & pagesize & " Demand_Id,TrueName,LessonName,MajorName,CityName,PostTime From TrainDemand" & StrOrder
else
StrSql="Select top " & pagesize & " Demand_Id,TrueName,LessonName,MajorName,CityName,PostTime From TrainDemand Where Demand_Id<(select min(Demand_Id) from (select top " & cstr(pagesize*(page-1)) & " Demand_Id From TrainDemand" & StrOrder & ") as t)" & StrOrder
end if
有个利用ResultSet定位的例子
rs.last()之类的方法,微软提供的驱动是不行的。
http://blog.csdn.net/jfy3d