Ibatisnet多表查询SQL形式总结

 

一、配置XML文件

<resultMap id="SelectResult1" class="SystemLog">

     <result property="ID" column="ID" /> 

     <result property="OpeObject" column="OpeObject" /> 

     <result property="OpeFileName" column="OpeFileName" /> 

     <result property="OpeInfo" column="OpeInfo" /> 

     <result property="OpeResult" column="OpeResult" /> 

     <result property="OpeDate" column="OpeDate" /> 

     <result property="SourcePath" column="sourcepath" /> 

     <result property="TargetPath" column="targetpath" /> 

     <result property="MessageId" column="messageid" /> 

     <result property="MessageInfo" resultMapping="SystemLog.MessageInfo-result" /> 

</resultMap>

<resultMap id="MessageInfo-result" class="MessageInfo">

     <result property="ID" column="ID" /> 

     <result property="MessageName" column="MessageName" /> 

</resultMap>

 

 

<select id="GetCom2Tables" resultMap="SelectResult1">

<![CDATA[ 

      select SystemLog.*, MessageInfo.* from SystemLog,MessageInfo

  ]]>

<dynamic prepend="WHERE">

<isNotEmpty prepend="and">

SystemLog.MessageId = MessageInfo.ID

</isNotEmpty> 

          <isNotEmpty prepend="and" property="ID">ID = #ID#</isNotEmpty> 

          <isNotEmpty prepend="and" property="OpeInfo">

OpeInfo = #OpeInfo#

</isNotEmpty> 

          <isNotEmpty prepend="and" property="MessageId">

MessageId = #MessageId#

</isNotEmpty> 

          <isNotEmpty prepend="and" property="OpeFileName">

OpeFileName LIKE '%$OpeFileName$%'

</isNotEmpty> 

          <isNotEmpty prepend="and" property="OpeDate">

OpeDate LIKE '%$OpeDate$%'

</isNotEmpty> 

  </dynamic>

  order by OpeDate desc 

</select>

 

二、实体类：

publicclass SystemLog

{

    private MessageInfo _messageinfo;

    public MessageInfo MessageInfo

    {

        get { return _messageinfo; }

        set { _messageinfo = value; }

    }

    publicstring Names

    {

        get { return _messageinfo.MessageName; }

}

}

 

三、绑定DataGridview

直接在DataGridview控件的模板列中，绑定实体类自定义的属性Names即可。