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='2'order by book.Id desc' at line 1
...................................
}else{
sqlStr="select count(*) from book";
}
int rscount=pageSize;
try{
ResultSet rs1=stmt.executeQuery(sqlStr);
if(rs1.next())recordCount=rs1.getInt(1);
rs1.close();
}catch(SQLException e){
System.out.println(e.getMessage());
return false;
}
if(recordCount<1)
pageCount=0;
else
pageCount=(int)(recordCount-1)/pageSize+1;
if(page<1)
page=1;
else if(page>pageCount)
page=pageCount;
rscount=(int)recordCount%pageSize;
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";
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+"%'orupper(book.content)like'%"+
keyword+"%') order by book.Id desc";
}else{
sqlStr=sqlStr+"and(upper(book.bookname)like'%"+
keyword+"%'orupper(book.content)like'%"+
keyword+"%') order by book.Id desc";
}
}else{
if(!classid.equals("")){
sqlStr=sqlStr+"andbook.Bookclass='"+
classid+"'and(upper(book.bookname)like'%"+
keyword+"%'orupper(book.content)like'%"+
keyword+"%')limit"+(recordCount-pageSize*page)+","+
(recordCount-pageSize*(page-1));
}else{
sqlStr=sqlStr+"and(upper(book.bookname)like'%"+
keyword+"%'orupper(book.content)like'%"+
keyword+"%')limit"+(recordCount-pageSize*page)+","+
(recordCount-pageSize*(page-1));
}
}