mybatis级联查询

最新推荐文章于 2025-07-13 16:54:57 发布

原创最新推荐文章于 2025-07-13 16:54:57 发布 · 326 阅读

0 ·

CC 4.0 BY-SA版权

mybatis 专栏收录该内容

4 篇文章

订阅专栏

本文介绍了一种使用MyBatis进行订单查询的配置方法，包括SQL映射文件中的查询语句与结果映射配置。通过示例展示了如何定义查询语句及结果映射规则，确保从数据库获取的数据能准确地映射到Java对象。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

 <select id="getOrder" parameterType="string" resultMap="OrderResultMap">
        SELECT *
        FROM order WHERE order_number=#{parameter}
 </select>

 <resultMap id="OrderResultMap" type="com.test.crm.module.order.CrmOrder">
        <id column="ID" property="id" jdbcType="BIGINT"/>
        <result column="buy_way" property="buyWay" jdbcType="INTEGER"/>
        <result column="product_id" property="productId" jdbcType="BIGINT"/>
        <result column="order_number" property="orderNumber" jdbcType="VARCHAR"/>
        <result column="sell_term" property="sellTerm" jdbcType="INTEGER"/>
        <result column="benefit_fee" property="benefitFee" jdbcType="DOUBLE"/>
        <result column="service_start" property="serviceStart" jdbcType="VARCHAR"/>
        <result column="service_end" property="serviceEnd" jdbcType="VARCHAR"/>
        <result column="pro_price" property="proPrice" jdbcType="DOUBLE"/>
        <result column="payfee" property="payFee" jdbcType="DOUBLE"/>
        <result column="over_fee" property="overFee" jdbcType="DOUBLE"/>
        <result column="contract_id" property="contractId" jdbcType="VARCHAR"/>
        <result column="contract_state" property="contractState" jdbcType="INTEGER"/>
        <result column="invoice_id" property="invoiceId" jdbcType="VARCHAR"/>
        <result column="courier_id" property="courierId" jdbcType="VARCHAR"/>
        <result column="salesman_id" property="salesManId" jdbcType="BIGINT"/>
        <result column="salesmanager_id" property="salesManagerId" jdbcType="BIGINT"/>
        <result column="department_id" property="departmentId" jdbcType="BIGINT"/>
        <result column="customer_id" property="customerId" jdbcType="BIGINT"/>
        <result column="order_memo" property="orderMemo" jdbcType="VARCHAR"/>
        <result column="deal_time" property="dealTime" jdbcType="VARCHAR"/>
        <result column="create_user_id" property="createUserId" jdbcType="BIGINT"/>
        <result column="create_user" property="createUser" jdbcType="VARCHAR"/>
        <result column="create_time" property="createTime" jdbcType="TIMESTAMP"/>
        <result column="update_user_id" property="updateUserId" jdbcType="BIGINT"/>
        <result column="update_user" property="updateUser" jdbcType="VARCHAR"/>
        <result column="update_time" property="updateTime" jdbcType="TIMESTAMP"/>
        <result column="post_address" property="postAddress" jdbcType="VARCHAR"/>
        <result column="post_code" property="postCode" jdbcType="VARCHAR"/>
        <result column="payed_fee" property="payedFee" jdbcType="DOUBLE"/>
        <result column="order_status" property="orderStatus" jdbcType="INTEGER"/>
        <result column="before_order" property="beforeOrder" jdbcType="VARCHAR"/>
        <result column="used_fee" property="usedFee" jdbcType="DOUBLE"/>
        <result column="cus_service_confirm_flag" property="cus_service_confirm_flag" jdbcType="INTEGER"/>
        <result column="cus_service_confirm_pic" property="cus_service_confirm_pic" jdbcType="VARCHAR"/>
        <result column="is_settled" property="isSettled" jdbcType="INTEGER"/>
        <result column="customer_name" property="customerName" jdbcType="VARCHAR"/>
        <result column="customer_number" property="customerNumber" jdbcType="VARCHAR"/>
        <result column="salesman" property="salesMan" jdbcType="VARCHAR"/>
        <result column="salesmanager" property="salesManager" jdbcType="VARCHAR"/>
        <result column="pro_name" property="productName" jdbcType="VARCHAR"/>
        <result column="department" property="department" jdbcType="VARCHAR"/>
        <result column="infoconfirm" property="infoconfirm" jdbcType="VARCHAR"/>
        <result column="evaluate" property="evaluate" jdbcType="VARCHAR"/>
        <result column="riskcaution" property="riskcaution" jdbcType="VARCHAR"/>
        <result column="discount" property="discount" jdbcType="DOUBLE"/>
    </resultMap>

    <resultMap id="BaseResultMap" type="com.test.crm.module.salesman.SalesmanPerformancePool">
        <id column="id" property="id" jdbcType="BIGINT" />
        <result column="code" property="code" jdbcType="VARCHAR" />
        <result column="employee_id" property="employeeId" jdbcType="INTEGER" />
        <result column="divide_percent" property="dividePercent" jdbcType="DOUBLE" />
        <result column="order_payment_number" property="orderPaymentNumber" jdbcType="VARCHAR" />
        <result column="order_number" property="orderNumber" jdbcType="VARCHAR" />
        <result column="customer_id" property="customerId" jdbcType="INTEGER" />
        <result column="product_id" property="productId" jdbcType="INTEGER" />
        <result column="figure" property="figure" jdbcType="DOUBLE" />
        <result column="join_time" property="joinTime" jdbcType="TIMESTAMP" />
        <result column="memo" property="memo" jdbcType="VARCHAR" />
        <result column="status" property="status" jdbcType="INTEGER" />
        <result column="delete_reason" property="deleteReason" jdbcType="VARCHAR" />
        <result column="create_person" property="createPerson" jdbcType="INTEGER" />
        <result column="create_time" property="createTime" jdbcType="TIMESTAMP" />
        <result column="update_person" property="updatePerson" jdbcType="INTEGER" />
        <result column="update_time" property="updateTime" jdbcType="TIMESTAMP" />
        <association property="crmOrder" column="order_number" javaType="com.test.crm.module.order.CrmOrder" select="getOrder"/>
    </resultMap>

<select id="find" parameterType="java.util.Map" resultMap="BaseResultMap">
    SELECT * FROM xxxxxxxx
</select>