其实不管是视图还是表查询,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
Logo

权威|前沿|技术|干货|国内首个API全生命周期开发者社区

更多推荐