DetachedCriteria mysql 中文排序
使用hibernate的detachedCriteria进行查询，需要对字符串排序，按照hibernate提供的排序方式并不是十分爽，实现按照拼音排序，数据库使用的mysql。
MysqlOrder .java 写道
import org.hibernate.Criteria;
import org.hibernate.HibernateException;
import org.hibernate.criterion.CriteriaQuery;
import org.hibernate.criterion.Order;
public class MysqlOrder extends Order{
private String propertyName;
protected MysqlOrder(String propertyName) {
super(propertyName, false);
this.propertyName = propertyName;
}
/**
* 只考虑按一个字段排序的情况
*/
public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException {
String[] columns = criteriaQuery.getColumnsUsingProjection(criteria, propertyName);
return ” CONVERT( “+ columns[0] +” USING GBK) “;
}
public static MysqlOrder getOrder(String propertyName)
{
return new MysqlOrder(propertyName);
}
}
?
