1. BookDao写接口,注解中写Hql语句,其中?1表示 匹配第一个参数对应bookName字符串
public interface BookDao extends JpaRepository<Book, Integer>{ @Query("select b from Book b where b.name like %?1%") public List<Book> queryByName(String bookName); } |
2,BookController 中,因为要直接返回json给前台页面,所有用注解:@ResponseBody,
@ResponseBody @RequestMapping("/queryByName") public List<Book> queryByName(){ List<Book> bookList = bookDao.queryByName("1"); return bookList; } |
3,测试,