MyBatis Plus 将查询结果封装到指定实体的方法步骤

时间:2021-05-20

思路

自定义方法,使用Wrapper,自定义映射结果集

Mapper接口

package com.mozq.boot.mpsand01.dao;import com.baomidou.mybatisplus.core.conditions.Wrapper;import com.baomidou.mybatisplus.core.mapper.BaseMapper;import com.baomidou.mybatisplus.core.toolkit.Constants;import com.mozq.boot.mpsand01.pojo.OrderInfo;import com.mozq.boot.mpsand01.vo.OrderVO;import org.apache.ibatis.annotations.*;import java.util.List;@Mapperpublic interface OrderInfoDao extends BaseMapper<OrderInfo> { @Select("select * from order_info ${ew.customSqlSegment}") List<OrderVO> findByCondition(@Param(Constants.WRAPPER)Wrapper wrapper); List<OrderVO> selectOrderVOList(@Param(Constants.WRAPPER)Wrapper wrapper);}

Mapper.xml

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.mozq.boot.mpsand01.dao.OrderInfoDao"> <resultMap id="BaseResultMapVO" type="com.mozq.boot.mpsand01.vo.OrderVO"> <id column="ORDER_ID" property="orderId" jdbcType="VARCHAR" /> <result column="USER_ID" property="userId" jdbcType="INTEGER" /> <result column="COMPANY_ID" property="companyId" jdbcType="INTEGER" /> <result column="CUSTOMER_ID" property="customerId" jdbcType="INTEGER" /> <result column="CUSTOMER_NAME" property="customerName" jdbcType="VARCHAR" /> <result column="MOBILE_PHONE" property="mobilePhone" jdbcType="VARCHAR" /> <result column="ACCOUNT_ID" property="accountId" jdbcType="VARCHAR" /> <result column="PRODUCT_ID" property="productId" jdbcType="INTEGER" /> <result column="PRODUCT_NAME" property="productName" jdbcType="VARCHAR" /> <result column="ORDER_TYPE" property="orderType" jdbcType="INTEGER" /> <result column="QUANTITY" property="quantity" jdbcType="DECIMAL" /> <result column="LICENSE_PLATE_NUMBER" property="licensePlateNumber" jdbcType="VARCHAR" /> <result column="PRICE" property="price" jdbcType="DECIMAL" /> <result column="TOTAL_MONEY" property="totalMoney" jdbcType="DECIMAL" /> <result column="PAY_QUANTITY" property="payQuantity" jdbcType="DECIMAL" /> <result column="PAY_MONEY" property="payMoney" jdbcType="DECIMAL" /> <result column="THE_WEIGHT" property="theWeight" jdbcType="INTEGER" /> <result column="DELIVERY_ADDRESS" property="deliveryAddress" jdbcType="VARCHAR" /> <result column="RECEIVE_ADDRESS" property="receiveAddress" jdbcType="VARCHAR" /> <result column="ORDER_STATUS" property="orderStatus" jdbcType="INTEGER" /> <result column="REMARK" property="remark" jdbcType="VARCHAR" /> <result column="PICKUP_TIME" property="pickupTime" jdbcType="TIMESTAMP" /> <result column="CREATE_TIME" property="createTime" jdbcType="TIMESTAMP" /> <result column="UPDATE_TIME" property="updateTime" jdbcType="TIMESTAMP" /> </resultMap> <sql id="Base_Column_List"> ORDER_ID, USER_ID, COMPANY_ID, CUSTOMER_ID, CUSTOMER_NAME, MOBILE_PHONE, ACCOUNT_ID, PRODUCT_ID, PRODUCT_NAME, ORDER_TYPE, QUANTITY, LICENSE_PLATE_NUMBER, PRICE, TOTAL_MONEY, PAY_QUANTITY, PAY_MONEY, THE_WEIGHT, DELIVERY_ADDRESS, RECEIVE_ADDRESS, ORDER_STATUS, REMARK, PICKUP_TIME, CREATE_TIME, UPDATE_TIME </sql> <select id="selectOrderVOList" resultMap="BaseResultMapVO"> select <include refid="Base_Column_List"></include> from order_info ${ew.customSqlSegment} </select></mapper>

测试类

@Testpublic void selectOrderVOList(){ List<OrderVO> orderVOList = orderInfoDao.selectOrderVOList( Wrappers.<OrderInfo>lambdaQuery() .eq(OrderInfo::getUserId, 123456) .eq(OrderInfo::getCompanyId, 1) ); System.out.println(orderVOList.size()); List<OrderVO> byCondition = orderInfoDao.findByCondition( Wrappers.<OrderInfo>lambdaQuery() .eq(OrderInfo::getUserId, 123456) .eq(OrderInfo::getCompanyId, 1) ); System.out.println(byCondition.size()); List<OrderInfo> orderInfoList = orderInfoDao.selectList( Wrappers.<OrderInfo>lambdaQuery() .eq(OrderInfo::getUserId, 123456) .eq(OrderInfo::getCompanyId, 1) ); System.out.println(orderInfoList.size());}

到此这篇关于MyBatis Plus 将查询结果封装到指定实体的方法步骤的文章就介绍到这了,更多相关MyBatis Plus查询结果封装到指定实体内容请搜索以前的文章或继续浏览下面的相关文章希望大家以后多多支持!

声明:本页内容来源网络,仅供用户参考;我单位不保证亦不表示资料全面及准确无误,也不保证亦不表示这些资料为最新信息,如因任何原因,本网内容或者用户因倚赖本网内容造成任何损失或损害,我单位将不会负任何法律责任。如涉及版权问题,请提交至online#300.cn邮箱联系删除。

相关文章