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