在HQL中绑定参数

方法1String hql="from test where name=:name and age>:age";//name和age为参数命名

Query query=session.CreateQuery(hql);

query.setParameter("name","zhangsan");

query.setParameter("age","23");

List lt=querty.list();//执行查询

方法2

String hql="from test where name=？and age>？";//参数用？替换

Query query=session.CreateQuery(hql);

query.setParameter("0","zhangsan");

query.setParameter("1","23");

List lt=querty.list();//执行查询

在配置文件中配置HQL

<hibernate-mapping>

    .

    .

    .

    .

</class>

<query name="search">

<![CDATA[

from test where name=:name and age>:age

]]>

</query>

</hibernate-mapping>

java类

Query query=session.getNameQuery("search");

query.setParameter("name","zhangsan");

query.setParameter("age","23");

List lt=query.list();