mybatis的映射

//一对一

    <resultMap id="给resultMap取的id名" type="类名">

    	<result property="字段名" column="sql里的字段名"/>

                <association property="类里面的字段名" javaType="类型">

                    <result property="字段名" column="sql里的字段名"/>

                </association>

    </resultMap>

//一对多

    <resultMap type="com.dlzb.enterprising.vo.category.CategoryPageVo" id="HopsConCategoryMap">

        <result property="字段名" column="sql里的字段名"/>

        <collection property="类里面的字段名" ofType="类型">

            <result property="字段名" column="sql里的字段名"/>

        </collection>

    </resultMap>

//多对一

     <resultMap type="Order" id="orderBean">

	<id column="orderId" property="id"/>

	<result column="orderNumber" property="number"/>

	<result column="orderPrice" property="price"/>

	<!-- 多对一的关系 -->

	<!-- property: 指的是属性的值, javaType：指的是属性的类型-->

	<association property="person" javaType="Person">

		<id column="personId" property="id"/>

		<result column="personName" property="name"/>

		<result column="personAddress" property="address"/>

		<result column="personTel" property="tel"/>

	</association>

     </resultMap>

//多对多

<resultMap id="userOrder" type="com.fh.entity.Account">

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

   <result property="userName" column="USERNAME"/>

   <collection property="orders" ofType="com.fh.entity.Order">

      <id property="id" column="ORDER_ID"/>

      <result property="name" column="NAME"/>

      <result property="number" column="NUMBER"/>

      <collection property="orderDetails" ofType="com.fh.entity.OrderDetail">

         <id property="id" column="DID"/>

         <result property="name" column="DNAME"/>

         <result property="itemNumber" column="ITEM_NUMBER"/>

      </collection>

   </collection>

</resultMap>
巴特西

mybatis的映射

最新文章

热门文章
