sql="select b_id,name,author,publisher,price from book where "+type1+" like '%"+keyword+"%";
这个地方(%的后面)少了一个',改成下面
sql="select b_id,name,author,publisher,price from book where "+type1+" like '%"+keyword+"%'";
这个地方(%的后面)少了一个',改成下面
sql="select b_id,name,author,publisher,price from book where "+type1+" like '%"+keyword+"%'";
/web/book/search.jsp:31: Invalid character constant.
sql="select b_id,name,author,publisher,price from book where "+type1+" like '%"+keyword+"%"' ;
^
/web/book/search.jsp:31: ';' expected.
sql="select b_id,name,author,publisher,price from book where "+type1+" like '%"+keyword+"%"' ;
^
2 errors是什么原因呀?
sql="select b_id,name,author,publisher,price from book where "+type1+" like '%"+keyword+"%"' ;
改成
sql="select b_id,name,author,publisher,price from book where "+type1+" like %"+keyword+"%";
select b_id,name,author,publisher,price from book where author like %刘传% java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][SQL Server]第 1 行: '刘传' 附近有语法错误。
你上面的错误是因为你把后面的单引号放到了外面了
keyword+"%"'; 应该是keyword+"%'";
sql="select b_id,name,author,publisher,price from book where "+type1+" like '%"+keyword+"%'"; 注意空格之类的