package com.nuvole.util;
|
|
/**
|
* @Description:
|
* @Company: TOO (ps：公司名称)
|
* @author: 唐
|
* @date: 2020/2/18 下午12:49
|
* @version: V1.0.0
|
*/
|
public class PageUtils {
|
|
public static String orderParser(String sortName, String sortOrder, String... prefix) {
|
|
// Determine sortOrder equals 'asc' or 'desc'
|
if (!(sortOrder.equals("asc") || sortOrder.equals("desc"))) {
|
throw new IllegalArgumentException("Illegal sortOrder parameter");
|
}
|
|
// 判断列名称的合法性，防止SQL注入。只能是【字母，数字，下划线】
|
if (!sortName.matches("[A-Za-z0-9_]+")) {
|
throw new IllegalArgumentException("Illegal sortName parameter");
|
}
|
|
StringBuilder sb = new StringBuilder();
|
// 存在前缀
|
if (prefix.length != 0) {
|
sb.append(prefix[0] + ".");
|
}
|
|
sb.append(CommonUtil.camel2Underline("`" + sortName + "`") + " " + sortOrder);
|
|
return sb.toString();
|
}
|
|
public static void main(String[] args) {
|
// System.out.println(orderParser("createTime", "asc"));
|
// System.out.println(orderParser("createTime", "asc", "abc"));
|
// System.out.println(orderParser("createTime,if((1=1),sleep(1),sleep(0))", "asc", "abc"));
|
System.out.println(orderParser("createTime", "asc,if((1=1),sleep(1),sleep(0))", "abc"));
|
}
|
}
|
