当前位置: 代码迷 >> Java Web开发 >> ,Hibernate Tools有这个功能
  详细解决方案

,Hibernate Tools有这个功能

热度:154   发布时间:2016-04-17 01:18:45.0
求助,Hibernate Tools有这个功能?
文件名: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>
  相关解决方案