原因:模糊查询进行了转义 %‘字段’% 的值加上了 ‘ ’ 导致查库报错
解决办法:String s ="%"+proName+"%";
为模糊查询的条件直接加上%%,整体作为一个参数传入
String sql = "SELECT COUNT(*) FROM product WHERE p_name LIKE ?";
String newStr = "%"+str+"%";
long total = 0;
try {
Object query = queryRunner.query(DbUtils.getConnection(), sql, new ScalarHandler<>(), newStr);
total = (long)query;
} catch (SQLException e) {
e.printStackTrace();
}
return total;