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

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