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