Hibernate中sql-query return CDATA 用法

iteye_11505

于 2011-07-13 11:09:51 发布

阅读量500

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库文章标签： java

本文链接：https://blog.youkuaiyun.com/iteye_11505/article/details/82093285

数据库专栏收录该内容

14 篇文章

订阅专栏

本文详细介绍了Hibernate映射文件的配置方法，包括UserReport类的映射定义、ID生成策略及属性映射等内容。此外，还提供了根据用户ID查询报告信息及删除报告信息的SQL查询示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


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

<hibernate-mapping package="com.boomlink.web.model">

	<class name="com.boomlink.web.model.UserReport" table="T_USER_REPORT">

		<id column="ID" name="id" unsaved-value="0">
			<generator class="increment" />
		</id>
		<property column="USERID" name="userid" />
		<property column="REPORT" name="report" />
	</class>


	<sql-query name="SelectReportByUserId"> 
	    <return alias="t" class="com.boomlink.web.model.UserReport"></return>
		<![CDATA[ 
                 SELECT
                 um.ID AS {t.id},
                 um.USERID AS {t.userid},
                 um.REPORT AS {t.report}
                 FROM
                 T_USER_REPORT um
                 WHERE
                 um.USERID=?
                 ORDER BY um.ID
    ]]>
  </sql-query>


  <sql-query name="DeleteReportByUserId">
		<return alias="t" class="com.boomlink.web.model.UserReport"></return>
		<![CDATA[ 
                 DELETE
                 FROM
                 T_USER_REPORT
                 WHERE
                 USERID=?
    ]]>
  </sql-query>
</hibernate-mapping>