JSP+MYSQL·ÖÒ³Ôõôд

//¶¨ÒåËĸöÓû§±äÁ¿
int pageSize = 3;  //ÿҳÏÔʾµÄÊý¾ÝÊýÁ¿
int pageNow =1;    //µ±Ç°ÏÔʾµÄÒ³ºÅ
int rowCount =0;  //¸ÃÖµ´ÓÊý¾Ý¿â²éѯ
int pageCount =0; //¸Ãֵͨ¹ýpageSizeºÍrowCount¼ÆËã

//²éѯ³öÐèÒªÏÔʾµÄ¼Ç¼
rs = sm.executeQuery("select * from users limit"+ pageSize*(pageNow - 1) + "," + pageCount);

·ÃÎÊʱ×ÜÊÇÏÔʾ´íÎó
javax.servlet.ServletException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '3' at line 1

Çë¸÷λָ½Ì£¬Ð»Ð»

         

---

rs = sm.executeQuery("select * from users limit("+ pageSize*(pageNow - 1) + "," + pageCount));

---

rs = sm.executeQuery("select * from users limit("+ pageSize*(pageNow - 1) + "," + pageCount+")");

---

Â¥Éϵķ½·¨ÎÒÊÔ¹ýÁË£¬¿ÉÊÇûÓ𥣬²»¹ý»¹ÊÇлл

---

´òÓ¡sqlÓï¾äÊÔÊÔ

---

rs = sm.executeQuery("select * from users limit "+ pageSize*(pageNow - 1) + "," + pageCount);limit ºóÃæÐèÒª¿Õ¸ñ°É

---

ÒýÓÃ

rs = sm.executeQuery("select * from users limit "+ pageSize*(pageNow - 1) + "," + pageCount);limit ºóÃæÐèÒª¿Õ¸ñ°É

Õâ¸ö´íÎóÎÒÒ²·¸¹ý£¬ÎÒµ±Ê±¾ÍÊÇÕâµã´íÁË

---

лл¥ÉϵĻØÌû£¬ÎÊÌâ½â¾öÁË£¬ÕýÈ·´ð°¸ÊÇ rs = sm.executeQ