SpringBoot学习之JPA自定义查询

在BookDao接口类中自定义方法

package org.hx.springboot_jpa_demo30.dao;

import org.hx.springboot_jpa_demo30.model.Book;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;

import java.util.List;

public interface BookDao extends JpaRepository<Book,Integer> {
    List<Book> getBookByAuthorEquals(String author);

    @Query(nativeQuery = true,value = "select * from t_book where id=(select max(id) from t_book)")
    Book maxIdBook();

    @Query("update t_book set b_name=:name where id=:id")
    @Modifying
    void updateBookById(String name ,Integer id);
}

新建BookService类

package org.hx.springboot_jpa_demo30.service;

import org.hx.springboot_jpa_demo30.dao.BookDao;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import javax.transaction.Transactional;

@Service
public class BookService {
    @Autowired
    BookDao bookDao;
    @Transactional
    public void updateBookById(String name ,Integer id){
        bookDao.updateBookById(name, id);
    }
}

在测试类中进行测试

@Test
    void test4(){
        System.out.println("最大id为："+bookDao.maxIdBook());
    }
    @Autowired
    BookService bookService;
    @Test
    void test5(){
        bookService.updateBookById("星辰",6);
    }