SQL:select *from tableName order by (colName using gbk);
使用HIBERNATE的createSQLQuery查询取值:
List<entityName> list;
query=session.createSQLQuery(sql).addEntity(entityName);
list=query.list();
for(entityName entity:list){
System.out.println(entity);
}