Java SQL.ORDER_BY属性代码示例

/**
 * This method was generated by MyBatis Generator.
 * This method corresponds to the database table user
 *
 * @mbg.generated
 */
public String selectByExample(UserCriteria example) {
    SQL sql = new SQL();
    if (example != null && example.isDistinct()) {
        sql.SELECT_DISTINCT("id");
    } else {
        sql.SELECT("id");
    }
    sql.SELECT("username");
    sql.SELECT("psw");
    sql.FROM("user");
    applyWhere(sql, example, false);
    
    if (example != null && example.getOrderByClause() != null) {
        sql.ORDER_BY(example.getOrderByClause());
    }
    
    return sql.toString();
}
 

public String select(String columns, String conditions, String groupBy, String orderBy) {
	String tableName = metadata.getTableName();
	SQL sql = new SQL().FROM(tableName + " _this");
	sql.SELECT(columns);
	// 加入查询条件
	if (!StringUtils.isEmpty(conditions)) {
		where(sql, conditions);
	}
	// 加入分组依据
	if (!StringUtils.isEmpty(groupBy)) {
		sql.GROUP_BY(groupBy);
	}
	// 加入排序条件
	if (!StringUtils.isEmpty(orderBy)) {
		sql.ORDER_BY(orderBy);
	}
	return sql.toString();
}
 

public String selectId(String conditions, String orderBy) {
	String tableName = metadata.getTableName();
	SQL sql = new SQL().FROM(tableName + " _this");
	List<IdProperty> properties = metadata.getIdProperties();
	for (IdProperty property : properties) {
		Path path = root.getPath(property);
		String column = path.getColumn() + " AS " + path.getMapping();
		sql.SELECT(column);
	}
	// 加入查询条件
	where(sql, conditions);
	// 加入排序条件
	if (!StringUtils.isEmpty(orderBy)) {
		sql.ORDER_BY(orderBy);
	}
	return sql.toString();
}
 

protected String findByPage(PageRequest request, String tableName) {
	SQL sql = new SQL();
	sql.SELECT("*").FROM(tableName);
	if (request.getSorts() != null && request.getSorts().length != 0) {
		for (int i = 0; i < request.getSorts().length; i++) {
			PageRequest.Sort sort = request.getSorts()[i];
			sql.ORDER_BY(sort.getField() + " " + sort.getType());
		}
	}
	String preSql = sql.toString();
	StringBuilder sb = new StringBuilder(preSql);
	sb.append(" limit #{page.start},#{page.size}");
	return sb.toString();
}
 

static void queryWHERE(SQL sql, Object query, String orderBy) {
    getAllDeclaredFields(query.getClass()).stream()
            .filter(field -> !field.isAnnotationPresent(Ignore.class))
            .forEach(field -> {
                String fieldName = field.getName();
                String columnName;
                String fieldExpression;
                if (field.isAnnotationPresent(Column.class)) {
                    Column annotation = field.getAnnotation(Column.class);
                    columnName = annotation.column().trim();
                    fieldExpression = fieldExpression("query." + fieldName, annotation);
                } else {
                    columnName = columnName(fieldName);
                    fieldExpression = fieldExpression("query." + fieldName, null);
                }
                Object value = valueOfField(query, fieldName);
                if (null != value) {
                    if (value instanceof String) {
                        if (!((String) value).isEmpty() && !value.equals("%%")) {
                            sql.WHERE(columnName + " like " + fieldExpression);
                        }
                    } else if (value instanceof Number
                            || value instanceof LocalDate
                            || value instanceof LocalDateTime) {
                        if (fieldName.startsWith("min")) {
                            sql.WHERE(columnName + ">=" + fieldExpression);
                        } else if (field.getName().startsWith("max")) {
                            sql.WHERE(columnName + "<=" + fieldExpression);
                        } else {
                            sql.WHERE(columnName + "=" + fieldExpression);
                        }
                    } else {
                        sql.WHERE(columnName + "=" + fieldExpression);
                    }
                }
            });
    if (null != orderBy && !orderBy.isEmpty()) {
        sql.ORDER_BY(orderBy);
    }
}
 

public String selectByCriteria(Map<String, Object> params) {
    Criteria criteria = (Criteria) params.get("criteria");
    Pageable pageable = null;
    if (params.containsKey("pageable")) {
        pageable = (Pageable) params.get("pageable");
    }
    EntityTable entityTable = getEntityTable(criteria.getEntityClass());
    SQL sql = new SQL();
    sql.SELECT(entityTable.getSelectColumns());
    sql.FROM(entityTable.getName());
    entityTable.getInnerJoins().forEach(sql::INNER_JOIN);
    sql.WHERE(criteria.getClause());
    StringJoiner stringJoiner = new StringJoiner(", ");
    if (criteria.getOrderBys() != null && !criteria.getOrderBys().isEmpty()) {
        criteria.getOrderBys().forEach(stringJoiner::add);
    } else if (entityTable.getOrderBys() != null && !entityTable.getOrderBys().isEmpty()) {
        entityTable.getOrderBys().forEach(stringJoiner::add);
    }
    if (stringJoiner.length() > 0) {
        sql.ORDER_BY(stringJoiner.toString());
    }
    if (pageable == null) {
        entityTable.getOrderBys().forEach(sql::ORDER_BY);
        return sql.toString();
    } else {
        return applyPageable(sql, pageable);
    }
}
 

protected String applyPageable(SQL sql, Pageable pageable) {
    StringJoiner stringJoiner = new StringJoiner(", ");
    pageable.getSort().forEach(order -> stringJoiner.add(CaseFormat.LOWER_CAMEL.to(CaseFormat.LOWER_UNDERSCORE
            , order.getProperty()) + " " + order.getDirection().name()));
    if (stringJoiner.length() > 0) {
        sql.ORDER_BY(stringJoiner.toString());
    }
    return sql.toString() + " LIMIT " + pageable.getOffset() + ", " + pageable.getPageSize();
}