CPU使用率100%

學習如何使用Criterion裡面的方法：

Criterion似乎可以看成是寫一般sql語法一樣..，condition條件再用getTypedValues方法去實作出來即可。

下面的範例是利用hibernate的Criterion類別，實作一個sql substring的功能..

　 package com.xxx.utility; import org.hibernate.Criteria; import org.hibernate.HibernateException; import org.hibernate.criterion.CriteriaQuery; import org.hibernate.criterion.Criterion; import org.hibernate.engine.TypedValue; @SuppressWarnings("serial") public class SubstringRestriction implements Criterion { private String propertyName; private int start; private int length; private String value; public SubstringRestriction(String propertyName, int start, int length,String value) { this.propertyName = propertyName; this.start = start; this.length = length; this.value = value; } public String toString() { return "substring(" + propertyName + "," + start + "," + length + ")"; } public String toSqlString(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { StringBuffer buffer = new StringBuffer(); buffer.append("SUBSTRING").append("(") .append(criteriaQuery.getColumn(criteria, propertyName)).append(",") .append(start).append(",") .append(length).append(")=?"); return buffer.toString(); } public TypedValue[] getTypedValues(Criteria criteria, CriteriaQuery criteriaQuery) throws HibernateException { return new TypedValue[] { criteriaQuery.getTypedValue(criteria, propertyName, value) }; } }