in shardingsphere-elasticjob-cloud-ui/shardingsphere-elasticjob-cloud-ui-backend/src/main/java/org/apache/shardingsphere/elasticjob/cloud/ui/web/controller/search/JobEventRdbSearch.java [235:251]
private String buildOrder(final Collection<String> tableFields, final String sortName, final String sortOrder) {
if (Strings.isNullOrEmpty(sortName)) {
return "";
}
String lowerUnderscore = CaseFormat.LOWER_CAMEL.to(CaseFormat.LOWER_UNDERSCORE, sortName);
if (!tableFields.contains(lowerUnderscore)) {
return "";
}
StringBuilder sqlBuilder = new StringBuilder();
sqlBuilder.append(" ORDER BY ").append(lowerUnderscore);
if ("DESC".equals(sortOrder.toUpperCase())) {
sqlBuilder.append(" DESC");
} else {
sqlBuilder.append(" ASC");
}
return sqlBuilder.toString();
}