从递归hibernate查询中获取字符串最小值

// 使用HQL进行递归查询
String hql = "WITH RECURSIVE recursive_query AS ("
        + "SELECT id, parent_id, name FROM your_table WHERE id = :parentId"
        + "UNION ALL"
        + "SELECT t.id, t.parent_id, t.name FROM your_table t"
        + "INNER JOIN recursive_query r ON t.parent_id = r.id"
        + ")"
        + "SELECT name FROM recursive_query";

Query query = session.createQuery(hql);
query.setParameter("parentId", parentId);
List<String> resultList = query.list();

// 获取字符串最小值
String minString = null;
if (!resultList.isEmpty()) {
    minString = resultList.get(0);
    for (String str : resultList) {
        if (str.compareTo(minString) < 0) {
            minString = str;
        }
    }
}

System.out.println("最小值为：" + minString);