国产成人精品久久免费动漫-国产成人精品天堂-国产成人精品区在线观看-国产成人精品日本-a级毛片无码免费真人-a级毛片毛片免费观看久潮喷

您的位置:首頁技術(shù)文章
文章詳情頁

MyBatis Plus 將查詢結(jié)果封裝到指定實體的方法步驟

瀏覽:2日期:2023-10-22 14:43:36

思路

自定義方法,使用Wrapper,自定義映射結(jié)果集

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}') /* 只指定2個,其他列能自動匹配的,也會被映射。 @Results({ @Result(id = true, column = 'ORDER_ID', property = 'orderId', jdbcType = JdbcType.VARCHAR), @Result(column = 'USER_ID', property = 'userId', jdbcType = JdbcType.INTEGER) }) */ 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 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 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());}

到此這篇關(guān)于MyBatis Plus 將查詢結(jié)果封裝到指定實體的方法步驟的文章就介紹到這了,更多相關(guān)MyBatis Plus查詢結(jié)果封裝到指定實體內(nèi)容請搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章希望大家以后多多支持好吧啦網(wǎng)!

標(biāo)簽: Mybatis 數(shù)據(jù)庫
相關(guān)文章:
主站蜘蛛池模板: 亚洲在成人网在线看 | 国产精品19禁在线观看2021 | 亚洲精品一区二区三区国产 | 国产国产人免费人成成免视频 | 免费观看女人一摸全是水 | 亚欧视频在线 | 亚洲专区在线 | 日韩一区二区在线视频 | 失禁h啪肉尿出来高h男男 | 欧美毛片在线 | 在线观看精品国产 | 国产99视频精品免费观看9e | 国产精品毛片久久久久久久 | 一级毛片成人免费看a | a一级毛片录像带 录像片 | 三级毛片三级毛片 | 热伊人99re久久精品最新地 | 欧美成人午夜影院 | 亚洲系列国产系列 | 老湿菠萝蜜在线看 | 欧美在线综合视频 | 男人免费看片 | 99久久精品毛片免费播放 | 成人国产精品一级毛片天堂 | 久久精品操 | 亚洲美女性视频 | 亚洲成人在线视频 | 91香蕉国产在线观看免费永久 | 波多野结衣一区二区三区高清在线 | 伊人色综合久久天天网蜜月 | 成年片人免费www | 中国美女乱淫免费看视频 | 久久精品国产精品亚洲毛片 | www夜色| 日韩一级一欧美一级国产 | 亚洲欧美日韩久久一区 | 欧美黄色一级在线 | 俺来也俺来也天天夜夜视频 | 嫩模大尺度人体福利视频 | 久久综合亚洲一区二区三区 | 99久久免费精品国产免费高清 |