Question

java模糊查询like后面%？ 数字%这块没看懂求助

@Query(value = "SELECT details FROM WmDetails details where address like %?3% or content like %?3% or title like %?3% or choice like %?3% order by abs(details.positionX - ?1)*abs(details.positionX - ?1)+abs(details.positionY - ?2)*abs(details.positionY - ?2) ")谢谢各位
这里%？3% 我没怎么看懂

Answer 1

你把这个稍微改改就行了，用StringBuilder 拼的sql语句，那样的话就会实现“果输入为空就输出所有”其他的一样
public static List getString(String name){
String sql = null;
StringBuilder str = new StringBuilder();
str.append("select * from 12.guzhang ");