服务器之家

服务器之家 > 正文

mybatis Plus 多表联合查询的实现示例

时间:2020-09-26 00:47     来源/作者:葵儿啊

本文主要介绍了mybatis Plus 多表联合查询,分享给大家,具体如下:

?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
//实体类package com.sk.skkill.entity;
 
 
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
 
import java.io.Serializable;
import java.util.Date;
import java.util.List;
 
 
@TableName("orders")
@Data
public class Order implements Serializable
{
  public static final long serialVersionUID =1L;
  private String id;
  private String orderName;
  private Date createTime;
  private Date updateTime;
  private String userID;
 
  @TableField(exist = false)
  private List<Users> listUsers;
 
 
  public Order(){
 
  }
 
  public Order(String id, String orderName) {
    this.id = id;
    this.orderName = orderName;
  }
}
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
//dao层
package com.sk.skkill.mapper;
 
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sk.skkill.entity.Order;
import com.sun.javafx.collections.MappingChange;
import org.apache.ibatis.annotations.Select;
 
import java.util.List;
import java.util.Map;
 
public interface OrderMapper extends BaseMapper<Order>
{
List<Order> selectOrder();
int addOrder(Order order);
?
1
2
3
4
5
//多表联合查询 按条件orderID
@Select("select t1.*,t2.user_name,t2.nick_name from orders t1 LEFT JOIN users t2 ON t1.user_id =t2.id WHERE t1.user_id= #{id}")
 List<Map<String,Object>> orderUserList(Page<Map<String,Object>> page,String id);
 
}
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
//service层
package com.sk.skkill.service;
 
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.IService;
import com.sk.skkill.entity.Order;
 
import java.util.List;
import java.util.Map;
 
public interface OrderService extends IService<Order>
{
  List<Order> selectOrder();
  int addOrder(Order order);
//  List<Map<String,Object>> orderUserList(Page<Map<String,Object>> page, String id);
  Page<Map<String,Object>> selectListPage(int current,int number,String id);
}
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
//serviceImpl层
package com.sk.skkill.service.impl;
 
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.sk.skkill.entity.Order;
import com.sk.skkill.mapper.OrderMapper;
import com.sk.skkill.service.OrderService;
import org.springframework.stereotype.Service;
 
import java.util.List;
import java.util.Map;
 
@Service
public class OrderServiceImpl extends ServiceImpl<OrderMapper, Order> implements OrderService
{
 
  @Override
  public List<Order> selectOrder() {
    return baseMapper.selectList(null);
  }
 
  @Override
  public int addOrder(Order order) {
    return baseMapper.insert(order);
  }
 
  @Override
  public Page<Map<String, Object>> selectListPage(int current, int number,String id) {
    //新建分页
    Page<Map<String,Object>> page =new Page<Map<String,Object>>(current,number);
    //返回结果
    return page.setRecords(this.baseMapper.orderUserList(page,id));
  }
}
?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
//controller层
package com.sk.skkill.controller;
 
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
import com.sk.skkill.entity.Order;
import com.sk.skkill.service.impl.OrderServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
 
import java.util.List;
import java.util.Map;
 
@RestController
@RequestMapping("order")
public class OrderController
{
  @Autowired
  private OrderServiceImpl service;
 
  @RequestMapping("selectOrder")
  public List<Order> selectOrder()
  {
    return service.selectOrder();
  }
  @RequestMapping("addOrder")
 public int addOrder(Order order){
    order=new Order("FGGG","蒙牛MILK");
    return service.addOrder(order);
 
 
 
 }
 @RequestMapping("selectListPage")
  public List<Map<String,Object>>  selectListPage(String id)
  {
    Page<Map<String, Object>> page = service.selectListPage(1, 2,id);
    return page.getRecords();
  }
}

 到此这篇关于mybatis Plus 多表联合查询的实现示例的文章就介绍到这了,更多相关mybatis Plus 多表联合查询内容请搜索服务器之家以前的文章或继续浏览下面的相关文章希望大家以后多多支持服务器之家!

原文链接:https://www.cnblogs.com/LQ970811/p/12100296.html

相关文章

热门资讯

2020微信伤感网名听哭了 让对方看到心疼的伤感网名大全
2020微信伤感网名听哭了 让对方看到心疼的伤感网名大全 2019-12-26
Intellij idea2020永久破解,亲测可用!!!
Intellij idea2020永久破解,亲测可用!!! 2020-07-29
歪歪漫画vip账号共享2020_yy漫画免费账号密码共享
歪歪漫画vip账号共享2020_yy漫画免费账号密码共享 2020-04-07
电视剧《琉璃》全集在线观看 琉璃美人煞1-59集免费观看地址
电视剧《琉璃》全集在线观看 琉璃美人煞1-59集免费观看地址 2020-08-12
最新idea2020注册码永久激活(激活到2100年)
最新idea2020注册码永久激活(激活到2100年) 2020-07-29
返回顶部