，Hibernate Tools有这个功能

求助，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> 
 

本人还没有使用过EJB，一直用SSH开发，对于其中的"Mapping file autogenerated by MyEclipse - Hibernate Tools"，本人还不知道如何使用myeclipse利用hibernate生成类似的xml文件及代码，只知道生成POJO类及相应的数据库cfg配置文件，
也不知道其中的“delete from tbl_UserRegMain where main_id=?”这类的SQL代码储存在该文件有什么用？是为了方便修改么？个人认为该代码是手写的，只是复制了下xml头部...
请教下会用的朋友~~~

[解决办法]
不会。。学习。
[解决办法]
再补充一下就是把SQL语句从你的程序代码中分离出来
[解决办法]
这是Hibernate本地sql的用法

查看更多 下一篇