mysql批量查询_Spring boot+mybatis+mysql实现数据批量查询

在Video视频控制器类中提供页面跳转功能链接，增加两种链接

1)/home 跳转到home.html页面，数据查询结果使用List返回

2)/home2跳转到home.html页面，数据查询结果使用List>返回

3) /home3跳转到home.html页面，采用分页查询方式返回List>对象

@RequestMapping("/home")

public String getHomePage(Model model)

{

RestTemplate restTemplate = new RestTemplate();

String url="http://localhost:8080/video/list";

List videoList=restTemplate.getForObject(url, List.class);

model.addAttribute("files", videoList);

return "home";

}

@RequestMapping("/home2")

public String getHomePage2(Model model)

{

RestTemplate restTemplate = new RestTemplate();

String url="http://localhost:8080/video/listmap";

List> videoList=restTemplate.getForObject(url, List.class);

model.addAttribute("files", videoList);

return "home";

}

@RequestMapping("/home3")

public String getHomePage3(Model model,@RequestParam("startIndex") int startIndex,@RequestParam("endIndex") int endIndex)

{

RestTemplate restTemplate = new RestTemplate();

String url="http://localhost:8080/video/listpage/"+startIndex+"/"+endIndex;

List> videoList=restTemplate.getForObject(url, List.class);

model.addAttribute("files", videoList);

return "home";

}