1,bookDao接口,添加注解,nativeQuery=true,表示启动本地查询,查询三个并随机排列
@Query(value="select * from t_book order by RAND() limit ?1",nativeQuery=true) public List randomList(Integer num); |
2,BookController ,
@ResponseBody @RequestMapping("/randomList") public List randomList(){ List bookList = bookDao.randomList(3); return bookList; } |
3,测试