SQL模糊查询工具类处理转义字符

/**
 * 模糊查询时候，参数转义
 */
public class SqlUtil {
    public SqlUtil() {
    }

    public static String escapeLike(String value) {
        if (value == null) {
            return null;
        }

        value = value.replace("%", "\\%");
        value = value.replace("_", "\\_");

        return value;
    }

    public static String asLike(String value) {
        String trim = value.trim();
        trim = "%" + trim + "%";
        return trim;
    }
}