jsp求助

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 'book.bookclass='4limit0,10' at line 1
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 'book.bookclass='4limit0,10' at line 1





sqlStr="select book.id,book.bookname,book.bookclass,bookclass.classname,"+

  "book.author,book.publish,book.bookno,book.content,book.prince,book.amount,"+

  "book.Leav_number,book.regtime,book.picture from book ,bookclass "+
 "where book.bookclass=bookclass.Id";
  // "where book.Bookclass=bookclass.Id";

  if(!classid.equals("")&&keyword.equals("")){

  if(page==1)

  {

  sqlStr=sqlStr+"and book.bookclass='"+classid+" order by book.Id desc" ;

  }else{

  sqlStr=sqlStr+"and book.bookclass='" + classid + "limit" (recordCount-pageSize*page)+","+(recordCount-pageSize*(page-1));

  }

  }else if(!keyword.equals("")){

  if(page==1){

  if(!classid.equals("")){

  sqlStr=sqlStr+"and book.Bookclass='"+

  classid+"'and (upper(book.bookname)like'%"+

  keyword+"%'or upper(book.content)like'%"+

  keyword+"%') order by book.Id desc";

  }else{

  sqlStr=sqlStr+"and(upper(book.bookname)like'%"+

  keyword+"%'or upper(book.content)like'%"+

  keyword+"%') order by book.Id desc";

  }

  }else{

  if(!classid.equals("")){

  sqlStr=sqlStr+"and book.Bookclass='"+

  classid+" 'and (upper(book.bookname)like'%"+

  keyword+"%'orupper(book.content)like'%"+





  keyword+"%')limit"+(recordCount-pageSize*page)+","+

  (recordCount-pageSize*(page-1));




如何修改代码

------解决方案--------------------

Java code

sqlStr="select  book.id,book.bookname,book.bookclass,bookclass.classname,"+ 

            "book.author,book.publish,book.bookno,book.content,book.prince,book.amount,"+ 

            "book.Leav_number,book.regtime,book.picture from book ,bookclass "+ 
"where book.bookclass=bookclass.Id"; 
          // "where book.Bookclass=bookclass.Id"; 

  if(!classid.equals("")&&keyword.equals("")){ 

            if(page==1) 

            { 

                  sqlStr=sqlStr+" and book.bookclass='"+classid+"' order by book.Id desc" ; 

            }else{ 

                  sqlStr=sqlStr+" and book.bookclass='" + classid + "' limit " (recordCount-pageSize*page)+","+(recordCount-pageSize*(page-1)); 

            } 

  }else if(!keyword.equals("")){ 

    if(page==1){ 

      if(!classid.equals("")){ 

          sqlStr=sqlStr+" and  book.Bookclass='"+ 

          classid+"' and (upper(book.bookname) like '%"+ 

          keyword+"%' or upper(book.content) like '%"+ 

          keyword+"%') order by book.Id desc"; 

      }else{ 

          sqlStr=sqlStr+" and (upper(book.bookname) like '%"+ 

          keyword+"%' or upper(book.content) like '%"+ 

          keyword+"%') order by book.Id desc"; 

      } 

      }else{ 

      if(!classid.equals("")){ 

            sqlStr=sqlStr+" and book.Bookclass='"+ 

            classid+"' and (upper(book.bookname) like '%"+ 

            keyword+"%' or upper(book.content) like'%"+ 


            keyword+"%') limit "+(recordCount-pageSize*page)+","+ 

            (recordCount-pageSize*(page-1));