jspÖÐSqlServerµÄ·ÖÒ³ÎÊÌâ

Java code:
int startPos=pagesize*(pageNo-1);//pagesize±íʾÿҳÏÔʾÌõÊý pageNo±íʾҳÊý
Statement stmt = con.createStatement();
String sql="pdate not in (select top "+startPos+" pdate from article order by pdate desc)";//pdateΪ×Ö¶Î
ResultSet rs=stmt.executeQuery("select top "+pagesize+" * from article where pid=0 and "+sql+"order by pdate desc"
);



¿´ÁËÍøÉÏдµÄSqlServer·ÖÒ³ÊÇÕâÑùµÄѽ ¿ÉÊÇÖмä¼ÓÉÏsql×Ö·û´®Ê±¾Í³öÎÊÌâÁË ´ó¼ÒÄÜ·ñ¸øµã½¨Òé
»òÕß°ïæдһ¸ö ÕâÀïÀ§ÈÅÁËÎҺܾÃÁË

---

Äã°Ñ´«À´µÄÒ³Êý£¬Ò²¾ÍÊÇÄãÉÏÃæÄǸöpageNoÍùsqlÓï¾äÀïÌ×£¬ÄãºÃºÃ¿´¿´£¬¾ÍÖªµÀÁËÕâôԭÀíÁË¡£

---

Â¥Ö÷Ì«ÀÁÁË£¬Õâ¸öÓ¦¸ÃÊÇÄãSQLÓï¾äÓÐÎÊÌ⣬Ìù³öÀ´°¡

---

ÎÒÌù³öÀ´ÁËѽ ResultSet rs=stmt.executeQuery("select top "+pagesize+" * from article where pid=0 and "+sql+"order by pdate desc"
            );

---

order Ç°Ãæ¼ÓÒ»¸ö¿Õ¸ñ
½«±äÁ¿Ç°ºóµÃË«ÒýºÅÄÚ¶¼¼ÓÉÏ¿Õ¸ñ
°ÑsqlÓï¾äÏÈ´òÓ¡³öÀ´,¿´ÊÇ·ñÓÐÁ½¸öµ¥´ÊÕ³ÔÚÒ»ÆðÁË

---

if(page>1){
  num= PAGENUM*(page-1);
}
String sql="select top "
+ PAGENUM
+ " * from dbo.PRODUCT where productID not in(select top "
+ num
+ " productID from dbo.PRODUCT)";
ÆäÖÐPAGENUMÊÇÉ