1、中文排序SQL语句(MySQL)select 列名 from 表名 order by convert(列名 using gb2312) asc;
2、中文排序Hibernate
2.1、自定义一个类,继承MySQL5Dialectpackage com.rk.core.utils;
import org.hibernate.dialect.MySQL5Dialect;
import org.hibernate.dialect.function.SQLFunctionTemplate;
import org.hibernate.type.StandardBasicTypes;
public class MySQLExtendDialect extends MySQL5Dialect {
public MySQLExtendDialect() {
super();
registerFunction("convert_gbk", new SQLFunctionTemplate(StandardBasicTypes.STRING , "convert(?1 using gbk)"));
}
}
这里虽然是MySQL5Dialect,也可以是其它类。
2.2、在applicationContext中使用自定义的类
修改sessionFactory的部分
org.hibernate.dialect.MySQL5Dialect
true
false
update
classpath:com/rk/*/entity/*.hbm.xml
改变之前:org.hibernate.dialect.MySQL5Dialect
改变之后:com.rk.core.utils.MySQLExtendDialect
2.3、排序
下面是RoleAction.java的一段代码//列表页面
public String listUI(){
//加载权限集合
ActionContext.getContext().getContextMap().put("privilegeMap", PrivilegeStatics.PRIVILEGE_MAP);
try {
QueryHelper queryHelper = new QueryHelper(Role.class, "r");
queryHelper.addCondition("r.state=?", Role.ROLE_STATE_VALID);
if(StringUtils.isNotBlank(searchContent)){
searchContent = URLDecoder.decode(searchContent, "utf-8");
queryHelper.addCondition("r.name like ?", "%"+searchContent+"%");
}
queryHelper.addOrderByProperty("convert_gbk(r.name)", QueryHelper.ORDER_BY_ASC);
String hql = queryHelper.getQueryListHql();
System.out.println(hql);
pageResult = roleService.getPageResult(queryHelper, pageNo, pageSize);
} catch (Exception e) {
e.printStackTrace();
}
return "listUI";
}
其中使用排序的地方是queryHelper.addOrderByProperty("convert_gbk(r.name)", QueryHelper.ORDER_BY_ASC);