// 数据库字段为double, 又想模糊查询, 例如输入0.9得到0.9,0.91,0.94......
if (houdu != null) {
// Oracle
query.add(Restrictions.sqlRestriction("to_char({alias}.houdu) like ?", String.valueOf(houdu) + "%", StringType.INSTANCE));
// Mysql
query.add(Restrictions.sqlRestriction("CAST({alias}.houdu AS CHAR) like ?", String.valueOf(houdu) + "%", StringType.INSTANCE));
}