Hibernate QBC对汉字进行排序

通常在Criteria查询时，是通过criteria.addOrder(Order.asc("name"))排序;

但是默认情况下是不支持GBK格式，所以汉字无法按照拼音进行排序。下面的方法是重写HibernateOrder方法实现对汉字排序。

packagecomm;

importjava.sql.Types;

importorg.hibernate.Criteria;

importorg.hibernate.HibernateException;

importorg.hibernate.criterion.CriteriaQuery;

importorg.hibernate.criterion.Order;

importorg.hibernate.engine.SessionFactoryImplementor;

importorg.hibernate.type.Type;

publicclassGBKOrderextendsOrder{

privateStringencoding="GBK";

privatebooleanascending;

privatebooleanignoreCase;

privateStringpropertyName;

@Override

publicStringtoString(){

return"CONVERT("+propertyName+"USING"+encoding+")"+(ascending?"asc":"desc");

}

@Override

publicOrderignoreCase(){

ignoreCase=true;

returnthis;

}

/**

*ConstructorforOrder.

*/

protectedGBKOrder(StringpropertyName,booleanascending){

super(propertyName,ascending);

this.propertyName=propertyName;

this.ascending=ascending;

}

/**

*ConstructorforOrder.

*/

protectedGBKOrder(StringpropertyName,Stringdir){

super(propertyName,dir.equalsIgnoreCase("ASC")?true:false);

ascending=dir.equalsIgnoreCase("ASC")?true:false;

this.propertyName=propertyName;

this.ascending=ascending;

}

/**

*RendertheSQLfragment

*

*/

@Override

publicStringtoSqlString(Criteriacriteria,CriteriaQuerycriteriaQuery)throwsHibernateException{

String[]columns=criteriaQuery.getColumnsUsingProjection(criteria,propertyName);

Typetype=criteriaQuery.getTypeUsingProjection(criteria,propertyName);

StringBufferfragment=newStringBuffer();

for(inti=0;i<columns.length;i++){

SessionFactoryImplementorfactory=criteriaQuery.getFactory();

booleanlower=ignoreCase&&type.sqlTypes(factory)[i]==Types.VARCHAR;

if(lower){

fragment.append(factory.getDialect().getLowercaseFunction()).append('(');

}

fragment.append("CONVERT("+columns[i]+"USING"+encoding+")");

if(lower)

fragment.append(')');

fragment.append(ascending?"asc":"desc");

if(i<columns.length-1)

fragment.append(",");

}

returnfragment.toString();

}

/**

*Ascendingorder

*

*@parampropertyName

*@returnOrder

*/

publicstaticOrderasc(StringpropertyName){

returnnewGBKOrder(propertyName,true);

}

/**

*Descendingorder

*

*@parampropertyName

*@returnOrder

*/

publicstaticOrderdesc(StringpropertyName){

returnnewGBKOrder(propertyName,false);

}

}

但是如果用上面的方法之后。数字的排序就达不到预期的目的了，需要利用反射对java类的属性进行判断，查看其类型：

Class<?>c=object.getClass().getField(str).getType();

System.out.println(c.getName());

通过判断类型的不同进行部不同的处理。