List<OrderDto> list = orderMapper.selectJoinList(OrderDto.class,newMPJQueryWrapper<Order>() .selectAll(Order.class) .select("t2.unit_price","t2.name as product_name") .select("t1.name as user_name") .leftJoin("t
@文心快码mybatisplus selectjoinlist 文心快码 MyBatis-Plus 是一个 MyBatis 的增强工具,在 MyBatis 的基础上只做增强不做改变,为简化开发、提高效率而生。它继承了 MyBatis 的所有特性,并提供了更加强大的功能,如分页、性能分析、条件构造器、代码生成器等。 selectJoinList 方法的作用和使用场景 selectJoinList...
selectAll(UserDO.class) 查询主表全部字段(主表实体类)默认主表别名 "t" select mp的select策略是覆盖,以最后一次为准,这里的策略是追加,可以一直select 主表字段可以用lambda,会自动添加表别名,主表别名默认是 t ,非主表字段必须带别名查询 leftJoin rightJoin innerJoin 传sql片段 格式 (表 + 别名 + 关联...
.leftJoin(ChatMultiList.class,ChatMultiList::getId,ChatRecord::getMultiId) .eq(ChatRecord::getMemberId,3213); List list = chatRecordMybatisJoinMapper.selectJoinList(Map.class, mpjLambdaWrapper); 对应查询语句 SELECT t.id, t.red_money, t1.username, t2.name FROM chat_record t LEFT JOIN of_...
void testJoin() { List<UserDTO> list = userMapper.selectJoinList(UserDTO.class, new MPJLambdaWrapper<UserDO>() .selectAll(UserDO.class) .select(UserAddressDO::getTel) .selectAs(UserAddressDO::getAddress, UserDTO::getUserAddress)
public void testSelect() {MPJLambdaWrapperwrapper = new MPJLambdaWrapper() .selectAll(User.class)//查询user表全部字段 .select(Address::getCity, Address::getAddress) .leftJoin(Address.class, Address::getUserId, User::getId); ListuserList = userMapper.selectJoinList(UserDTO.class, wrapper); ...
voidtestJoin() { List<UserDTO>list=userMapper.selectJoinList(UserDTO.class, newMPJLambdaWrapper<UserDO>() .selectAll(UserDO.class) .select(UserAddressDO::getTel) .selectAs(UserAddressDO::getAddress,UserDTO::getUserAddress) .select(AreaDO::getProvince,AreaDO::getCity) ...
.selectAs(Product::getName,OrderDto::getProductName) .leftJoin(User.class, User::getId, Order::getUserId) .leftJoin(Product.class, Product::getId, Order::getProductId) .eq(Order::getStatus,3)); list.forEach(System.out::println); ...
class test {@Resourceprivate UserMapper userMapper;void testJoin() {List<UserDTO> list = userMapper.selectJoinList(UserDTO.class,new MPJLambdaWrapper<UserDO>().selectAll(UserDO.class).select(UserAddressDO::getTel).selectAs(UserAddressDO::getAddress, UserDTO::getUserAddress).select(AreaDO::ge...
classtest{@ResourceprivateUserMapper userMapper;voidtestJoin(){List<UserDTO>list=userMapper.selectJoinList(UserDTO.class,newMPJLambdaWrapper<UserDO>().selectAll(UserDO.class).select(UserAddressDO::getTel).selectAs(UserAddressDO::getAddress,UserDTO::getUserAddress).select(AreaDO::getProvince,AreaDO...