Hibernate的简单数据操作

命名HQL查询语句

<query name="search"><![CDATA[from myTable]]></query>
Query query = session.getNamedQuery("search");
List list = query.list();

anno:@NamedQuery(name,query)

命名SQL查询语句

<sql-query name="search">
<![CDATA[select * from dual]]>
<return alias="别名" class="完整类名"/>
</sql-query>
session.getNamedQuery("search");

anno:

@NamedNativeQuery(name,query,resultSetMapping)

@SqlResultSetMapping(name,

                                            entities={

                                                             @EntiryResult(entityClass,fields={@FieldResult})

                                                            }

                                               )

查询绑定数据可以用"?"和":name"

?    query.setEntity(num,value);

:     query.setParameter(name,value);