SpringBoot之自定义查询Query

   下面讲解下SpringBoot之自定义查询Query的实例

SpringBoot之自定义查询Query有HQL语句查询（Hibernate），还可以采用sql语句本地查询

BookDao类查询接口

package com.hik.dao;

import java.util.List;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;

import com.hik.entity.Book;

/**
 * 图书Dao接口
 * @author jed
 *
 */
public interface BookDao extends JpaRepository<Book, Integer>{
    
    //Hql语句查询
    @Query("select b from Book b where b.bookName like %?1%")
    public List<Book> findByBookName(String bookName);
    
    //本地sql语句查询
    @Query(value="select * from t_book order by RAND() limit ?1",nativeQuery=true)
    public List<Book> randomList(Integer n);
}

BookController类

package com.hik.Controller;

import java.util.List;

import javax.annotation.Resource;

import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PathVariable;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.servlet.ModelAndView;

import com.hik.dao.BookDao;
import com.hik.entity.Book;

/**
 * Book控制类
 * @author jed
 *
 */
@Controller
@RequestMapping("/book")
public class BookController {
    
    @Resource
    private BookDao bookDao;
    
    /**
     * 查询所有图书
     * @return
     */
    @RequestMapping(value="/list")
    public ModelAndView list() {
        ModelAndView mav = new ModelAndView ();
        mav.addObject("bookList", bookDao.findAll());
        mav.setViewName("bookList");
        return mav;
    }

    /**
     * 添加图书
     * @param book
     * @return
     */
    @RequestMapping(value="/add", method=RequestMethod.POST)
    public String add(Book book) {
        bookDao.save(book);
        return "forward:/book/list";
    }
    
    @GetMapping(value="/preUpdate/{id}")
    public ModelAndView preUpdate(@PathVariable("id") Integer id) {
        ModelAndView mav = new ModelAndView();
        mav.addObject("book", bookDao.getOne(id));
        mav.setViewName("bookUpdate");
        return mav;
    }
    
    /**
     * 修改图书
     * @param book
     * @return
     */
    @PostMapping(value="/update")
    public String update(Book book) {
        bookDao.save(book);
        return "forward:/book/list";
    }
    
    /**
     * 删除图书
     * @param id
     * @return
     */
    @RequestMapping(value="/delete",method = RequestMethod.GET)
    public String delete(Integer id) {
        bookDao.delete(id);
        return "forward:/book/list";
    }
    
    @ResponseBody
    @GetMapping(value="/queryByName")
    public List<Book> queryByName() {
        return bookDao.findByBookName("思想");
    }
    
    @ResponseBody
    @GetMapping(value="/randomList")
    public List<Book> randomList(){
        return bookDao.randomList(2);
    }
}

hql查询结果：

 

 本地sql查询结果：