SQL和jdbc中进行模糊查询

String sql="select * from book where bookID like %?%";//错误：java.sql.SQLSyntaxErrorException: ORA-00911: 无效字符

String sql="select * from book where bookID like '%?%'";//错误：java.sql.SQLException: 无效的列索引

在SQL中，模糊查询：select * from book where bookID like "%str%";

但是在jdbc中要写成如代码所示：

String sql="select * from book where bookID like ?";//1 
String bookID="id";	
Class.forName("oracle.jdbc.OracleDriver");
// 通过驱动管理来建立连接
con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system", "sun");
pst=con.prepareStatement(sql);
pst.setString(1, "%"+bookID+"%");//2