mybatis-plus视图查询
其实不管是视图还是表查询,mybatis-plus使用方法都一样,你可以把视图当作一个表。PO:/*** 视图 容器查询位置信息*/@Data@Builder@AllArgsConstructor@NoArgsConstructor@TableName("CONTAINER_PATH")public class ViewContainerPath implements Serializable {
·
其实不管是视图还是表查询,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
更多推荐
已为社区贡献1条内容
所有评论(0)