Hibernate中sql-query return CDATA 用法

最新推荐文章于 2021-02-02 15:42:07 发布

iteye_11505

最新推荐文章于 2021-02-02 15:42:07 发布

阅读量449

点赞数

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

本文链接：https://blog.csdn.net/iteye_11505/article/details/82093285

版权

数据库专栏收录该内容

14 篇文章 0 订阅

订阅专栏


<?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>