Hibernate 利用配置文件配置HQL/SQL

最新推荐文章于 2026-05-07 05:10:00 发布

原创最新推荐文章于 2026-05-07 05:10:00 发布 · 370 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

标签

#hibernate #query #mapping #xml #hbm

收录于

资料搜集专栏收录该内容

48 篇文章

订阅专栏

本文介绍了一个使用Hibernate框架进行数据库查询的具体配置实例。通过定义XML映射文件Query.hbm.xml及配置文件hibernate.cfg.xml，实现了参数化的SQL和HQL查询。展示了如何在Java代码中调用这些预定义的查询来获取用户数据。

Query.hbm.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">

<hibernate-mapping>

<query name="QueryUser">
<![CDATA[
FROM User u
WHERE u.userName = :userName
]]>

<sql-query name="SqlQueryUser">
<![CDATA[
SELECT
{u.*}
FROM
user u
WHERE
u.user_name = :userName
]]>
<return alias="u" class="com.test.entity.User"/>
</sql-query>

</hibernate-mapping>
hibernate.cfg.xml
<?xml version="1.0"?>
<!DOCTYPE hibernate-configuration PUBLIC
"-//Hibernate/Hibernate Configuration DTD//EN"
"http://hibernate.sourceforge.net/hibernate-configuration-3.0.dtd">

<hibernate-configuration>
<session-factory>
...
<mapping resource="User.hbm.xml"/>

<mapping resource="query/Query.hbm.xml"/>

...
</session-factory>
</hibernate-configuration>
Java Code:
String username = "...";
Session session = ...;
Query query = session.getNamedQuery("QueryUser");
//Query query = session.getNamedQuery("SqlQueryUser");
query.setString("name", username);
List userList = query.list();