mybatis-plus视图查询

最新推荐文章于 2024-07-10 20:09:54 发布

柏伦 Belen

最新推荐文章于 2024-07-10 20:09:54 发布

阅读量8.9k

点赞数 1

分类专栏： mybatis java 文章标签： mybatis mybatis-plus mybatisplus 视图查询

本文链接：https://blog.csdn.net/programmer_sir/article/details/116717338

版权

java 同时被 2 个专栏收录

9 篇文章 0 订阅

订阅专栏

mybatis

4 篇文章 0 订阅

订阅专栏

其实不管是视图还是表查询，mybatis-plus使用方法都一样，你可以把视图当作一个表。
PO：

/**
 * 视图 容器查询位置信息
 */
@Data
@Builder
@AllArgsConstructor
@NoArgsConstructor
@TableName("CONTAINER_PATH")
public class ViewContainerPath implements Serializable {
    private static final long serialVersionUID = 986772875698776276L;

    /**
    * 容器ID
    */
    private String containerId;

    /**
    * 容器地址
    */    
    private String containerPath;
}

Mapper:

import com.belen.sample.db.core.BaseMapper;
import com.belen.sample.db.entity.ViewContainerPath;

public interface ViewContainerPathMapper extends BaseMapper<ViewContainerPath>  {

}

测试：

@Slf4j

@ActiveProfiles("dev,db-dev")
@RunWith(SpringRunner.class)
@ContextConfiguration(classes = SampleInterfaceApplication.class)
@SpringBootTest
public class SearchTest {

    @Resource
    private ViewContainerPathMapper viewContainerPathMapper;

    @Test
    public void testViewContainerPath() {
        LambdaQueryWrapper<ViewContainerPath> tempWrapper = new QueryWrapper<ViewContainerPath>().lambda();
        tempWrapper.eq(ViewContainerPath::getContainerId,"64629");
        List<ViewContainerPath> list = viewContainerPathMapper.selectList(tempWrapper);
        if (!list.isEmpty()) {
            System.out.println("查询结果:"+list.get(0).getContainerPath());
        }
    }
}

结果：

2021-05-12 17:58:56.694 logback [main] INFO  com.belen.sample.SearchTest - Started SearchTest in 7.356 seconds (JVM running for 9.066)
2021-05-12 17:58:57.120 logback [main] DEBUG c.b.s.d.m.V.selectList - ==>  Preparing: SELECT container_id,container_path FROM CONTAINER_PATH WHERE container_id = ? 
2021-05-12 17:58:57.337 logback [main] DEBUG c.b.s.d.m.V.selectList - ==> Parameters: 64629(String)
2021-05-12 17:58:57.447 logback [main] DEBUG c.b.s.d.m.V.selectList - <==      Total: 1
查询结果:4℃-层3-D8*
2021-05-12 17:58:57.478 logback [SpringContextShutdownHook] INFO  c.alibaba.druid.pool.DruidDataSource - {dataSource-1} closing ...
2021-05-12 17:58:57.554 logback [SpringContextShutdownHook] INFO  c.alibaba.druid.pool.DruidDataSource - {dataSource-1} closed

Process finished with exit code 0