JDBC PreparedStatement 字符串字段 模糊查询 注意事项
针对字符串类型字段模糊查询的正确写法:
String sql = "select count(*) from category c where 1 = 1 and c.category_name like ? ";
pstmts = conn.prepareStatement(sql);
pstmts.setString(1,"%资讯%");
rs = pstmts.executeQuery();
注意:
这里“pstmts.setString(1,"%资讯%"); ”
不能写为:pstmts.setString(1,"'%资讯%'");