Mybatis的xml配置实例

最新推荐文章于 2024-07-30 08:00:00 发布

方块糖

最新推荐文章于 2024-07-30 08:00:00 发布

阅读量993

点赞数

分类专栏： mybatis 文章标签： Mybstis配置

本文链接：https://blog.csdn.net/gui66497/article/details/47986467

版权

mybatis 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

主表：

  
  
   
   
    
    <?xml version="1.0" encoding="UTF-8"?>
   
   
   
   
    
    	<!DOCTYPE mapper   
   
   
   
   
    
    	  PUBLIC "-//mybatis.org//DTD Mapper 3.1//EN"   
   
   
   
   
    
    	  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
   
   
   
   
    
    <!-- 软件信息数据查询相关 yangxuefeng@dnion.com -->
   
   
   
   
    
    <mapper namespace="com.dnion.platform.dao.mybatis.DeploySoftwareInfoMapper">
   
   
   
   
    
    	<resultMap type="DeploySoftwareInfo" id="DeploySoftwareInfoResult">
   
   
   
   
    
    		<id column="id" jdbcType="INTEGER" property="id"/>
   
   
   
   
    
    		<result column="soft_name" jdbcType="VARCHAR" property="softName"/>
   
   
   
   
    
    		<result column="install_path" jdbcType="VARCHAR" property="installPath"/>
   
   
   
   
    
    		<result column="soft_desc" jdbcType="VARCHAR" property="softDesc"/>
   
   
   
   
    
    		
   
   
   
   
    
    		<!-- 关联软件详情集合 -->
   
   
   
   
    
    		<collection property="deploySoftwareDetailList" ofType="deploySoftwareDetail"
   
   
   
   
    
    			column="id">
   
   
   
   
    
    			<id column="id" jdbcType="INTEGER" property="id" />
   
   
   
   
    
    			<result column="sw_id" jdbcType="INTEGER" property="swId" />
   
   
   
   
    
    			<result column="version_code" jdbcType="VARCHAR" property="versionCode" />
   
   
   
   
    
    			<result column="release_date" jdbcType="VARCHAR" property="releaseDate" />
   
   
   
   
    
    			<result column="package_name" jdbcType="VARCHAR" property="packageName" />
   
   
   
   
    
    			<result column="package_size" jdbcType="INTEGER" property="packageSize" />
   
   
   
   
    
    			<result column="package_md5" jdbcType="VARCHAR" property="packageMD5" />
   
   
   
   
    
    			<result column="major_files" jdbcType="VARCHAR" property="majorFiles" />
   
   
   
   
    
    			<result column="release_note" jdbcType="VARCHAR" property="releaseNote" />
   
   
   
   
    
    		</collection>
   
   
   
   
    
    	</resultMap>
   
   
   
   
    
    </mapper>

附属表：

   
   
    
    
     
     <?xml version="1.0" encoding="UTF-8"?>
    
    
    
    
     
     	<!DOCTYPE mapper   
    
    
    
    
     
     	  PUBLIC "-//mybatis.org//DTD Mapper 3.1//EN"   
    
    
    
    
     
     	  "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
    
    
    
    
     
     <!-- 软件详情数据查询相关 yangxuefeng@dnion.com -->
    
    
    
    
     
     <mapper namespace="com.dnion.platform.dao.mybatis.DeploySoftwareDetailMapper">
    
    
    
    
     
     	<!-- 软件详情查询数据封装 -->
    
    
    
    
     
     	<resultMap type="DeploySoftwareDetail" id="DeploySoftwareDetailResult">
    
    
    
    
     
     		<id column="id" jdbcType="INTEGER" property="id" />
    
    
    
    
     
     		<result column="sw_id" jdbcType="INTEGER" property="swId" />
    
    
    
    
     
     		<result column="version_code" jdbcType="VARCHAR" property="versionCode" />
    
    
    
    
     
     		<result column="release_date" jdbcType="VARCHAR" property="releaseDate" />
    
    
    
    
     
     		<result column="package_name" jdbcType="VARCHAR" property="packageName" />
    
    
    
    
     
     		<result column="package_size" jdbcType="INTEGER" property="packageSize" />
    
    
    
    
     
     		<result column="package_md5" jdbcType="VARCHAR" property="packageMD5" />
    
    
    
    
     
     		<result column="major_files" jdbcType="VARCHAR" property="majorFiles" />
    
    
    
    
     
     		<result column="release_note" jdbcType="VARCHAR" property="releaseNote" />
    
    
    
    
     
     	</resultMap>
    
    
    
    
     
     </mapper>