文件名:db2_sql.xml
- XML code
<?xml version="1.0"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><!-- Mapping file autogenerated by MyEclipse - Hibernate Tools--><hibernate-mapping> <sql-query name="mySQL"> <return-scalar column="id" type="integer" /> <return-scalar column="qid" type="int" /> <return-scalar column="orgAddr" type="string" /> <return-scalar column="destAddr" type="string" /> <return-scalar column="id" type="string" /> <return-scalar column="name" type="string" /> select ans.id,ans.qid,ans.orgAddr,ans.destAddr,anth.id,anth.name from tbl_answers ans left outer join tbl_authority anth on ans.qid=anth.id where ans.id in (:list_value) </sql-query> [color=#FF0000]<!-有什么用?->[/color] <sql-query name="mms.updatePicType"> <return-scalar column="id" type="int" /> <return-scalar column="userId" type="string" /> <return-scalar column="picTypeId" type="string" /> <return-scalar column="picTypeName" type="timestamp" /> <return-scalar column="oprTime" type="int" /> update tbl_PicTypeManager set PicTypeName=?,OprTime=current_timestamp where id = ? </sql-query> [color=#FF0000]....此处省略大量类似的[/color][color=#FF0000]<!-有什么用?->[/color] <sql-query name="regmainmanagerdelete-sql1">delete from tbl_UserRegSub where sub_id=?</sql-query> <sql-query name="regmainindex-sql1">insert into tbl_UserRegMain (main_name,create_date) values (?,getdate())</sql-query> <sql-query name="regmainindex-sql2">delete from tbl_UserRegMain where main_id=?</sql-query> <sql-query name="regmainindex-sql3">delete from tbl_UserRegSub where main_id=?</sql-query> <sql-query name="regmainindex-sql4">select * from tbl_UserRegMain</sql-query>
文件名:db2_hql.xml
- XML code
<?xml version="1.0"?><!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN""http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd"><!-- Mapping file autogenerated by MyEclipse - Hibernate Tools--><hibernate-mapping> <!-- Group model begin --> <query name="judgeGroup"> <![CDATA[ select a.oldDestAddr from SmToSendCycle as a ]]> </query> <query name="querygrouppower"> <![CDATA[ select b from GroupPower as b where b.operatorId =? ]]> </query> <query name="queryChildInfo"> <![CDATA[ select gg.groupName,gg.groupId from Groups as gg where char(gg.groupId) in (select gm.memberMobile from Groups as g ,GroupMemberRelation as gm where gm.memberFlag=1 and g.groupId=gm.groupId and gm.groupId =?) ]]> </query> <query name="groupBaseInfo"> <![CDATA[ select a from Groups as a where groupId=? ]]> </query> <query name="queryFatherGroup"> <![CDATA[ select a.groupId from GroupMemberRelation as a where a.memberMobile=? ]]> </query> [color=#FF0000]......省略大量类似[/color][color=#FF0000]<!-有什么用?->[/color] <query name="SMSManager.querySMControlMsg"> <![CDATA[ select a from SMControlMsg as a where a.destModule=? and a.cmdContent like '%'||? ]]> </query> <query name="mmsconfig.edit.sysconfig"> <![CDATA[ update SysConfig set value=? where name=? ]]> </query>