Question

String sql="select * from book where name like '%"+?+"%'";错误在哪？

Exception in thread "main" java.lang.Error: Unresolved compilation problems:
Syntax error on token "?", delete this token
The operator + is undefined for the argument type(s) String
at com.dao.impl.BookDaoImpl.selectByNameD(BookDaoImpl.java:210)
at com.dao.impl.BookDaoImpl.main(BookDaoImpl.java:26)

Answer 1

String sql="select * from book where name like '%?%'";

追问

java.sql.SQLException: Parameter index out of range (1 > number of parameters, which is 0).
可是又有这个问题了。。

追答

其他问题我就帮不上了,我都忘了,刚刚那个语法错误还能记起,其他的我就不熟悉了