直接上代码,
正常的模式:
String sql = "select * from tb_product where id=?";
preparedStatement.setString(1,id);
当like和preparedStatement结合的时候,需要把百分号写在preparedStatement.setString()括号里面,不可以写在SQL里面,会报错!
String sql = "select * from tb_product where id like ? ";
preparedStatement.setString(1,"%"+id+"%");