首先自定义方言:
package org.han.entity; import org.hibernate.Hibernate; import org.hibernate.dialect.Oracle10gDialect; import org.hibernate.dialect.function.SQLFunctionTemplate; public class MyDialect extends Oracle10gDialect{ public MyDialect() { super(); // TODO Auto-generated constructor stub this.registerFunction("getno", new SQLFunctionTemplate(Hibernate.INTEGER,"aaa(?1)")); } } ?1表第一个参数,?2第二个,以此类推配置XML:
<property name="dialect">org.han.entity.MyDialect</property>将Hibernatenate.dialect修改成自定义的java调用:
Query q = session.createQuery("select getno(e.empno) from Emp e"); List list = q.list(); System.out.println(list.size());更多信息观摩 org.hibernate.dialect.function.SQLFunctionTemplate和org.hibernate.dialect.function Interface SQLFunction