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));