Spring Boot整合Spring Data JPA进行CRUD和模糊查询

<dependencies>
    <!--  JPA   -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-data-jpa</artifactId>
    </dependency>
    <!--   MySql driver -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>5.1.47</version>
    </dependency>
    <!--  lombok -->
    <dependency>
        <groupId>org.projectlombok</groupId>
        <artifactId>lombok</artifactId>
        <optional>true</optional>
    </dependency>
    <!--    单元测试   -->
    <dependency>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-test</artifactId>
        <scope>test</scope>
    </dependency>
</dependencies>
复制代码

#classname
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#url
spring.datasource.url=jdbc:mysql://localhost:3306/sp_jpa
#username
spring.datasource.username=root
#password
spring.datasource.password=12345
#数据库类型
spring.jpa.database=MySQL
#是否自动生成
spring.jpa.generate-ddl=true
#每次运行程序，没有表格会新建表格，表内有数据不会清空，只会更新
spring.jpa.hibernate.ddl-auto=update
复制代码

/**
 * @author 17122
 */
@Entity
@Data
@Setter
@Getter
@Accessors(chain = true)
public class Student {
    @Id
    @GeneratedValue//ID自动递增
    private Long sId;
    private String sName;
    private Integer sAge;
}
复制代码

/**
 * @author 17122
 */
@Repository
//JpaRepository < 实体类,主键类型 >  
public interface StudentDAO extends JpaRepository<Student,Long> {
    //模糊查询
    //nativeQuery = true 表示为原生SQL
    @Query(value = "select s_id,s_name,s_age from student s where s.s_name like ?1 ", nativeQuery = true)
    List<Student> findByFirstName(@Param("firstName") String firstName);
}
复制代码

/**
 * @author 17122
 */
public interface StudentService {
    //添加一个
    int saveStudent(Student student);
    //根据Sid查找
    Student findStudentBySid(Long sId);
    //查看全部
    List<Student> findAllStudent();
    //根据id修改
    int updateStudentById(Student student);
    //根据id删除
    void deleteStudentById(Long sId);
    //根据姓模糊查询
    List<Student> findStudentByFirstName(String firstName);
}
复制代码

/**
 * @author 17122
 */
@Service
public class StudentServiceImpl implements StudentService {
    @Autowired
    private StudentDAO studentDAO;
    @Override
    public int saveStudent(Student student) {
        Student save = studentDAO.save(student);
        return ObjectUtils.isEmpty(save) ? 0 : 1;
    }
    @Override
    public Student findStudentBySid(Long sId) {
        return studentDAO.findById(sId).get();
    }
    @Override
    public List<Student> findAllStudent() {
        return studentDAO.findAll();
    }
    @Override
    public int updateStudentById(Student student) {
        Student student1 = studentDAO.saveAndFlush(student);
        return ObjectUtils.isEmpty(student1) ? 0 : 1;
    }
    @Override
    public void deleteStudentById(Long sId) {
        studentDAO.deleteById(sId);
    }
    @Override
    public List<Student> findStudentByFirstName(String firstName) {
        return studentDAO.findByFirstName(firstName+"%");
    }
}
复制代码

@SpringBootTest
class SpJpaApplicationTests {
    @Autowired
    private StudentService studentService;
    @Test
    void saveStudent() {
        Student student = new Student();
        student.setSName("张三")
                .setSAge(100);
        studentService.saveStudent(student);
    }
    @Test
    void findStudentById() {
        Student student = studentService.findStudentBySid(1L);
        System.out.println(student);
    }
    @Test
    void findAllStudent() {
        List<Student> students = studentService.findAllStudent();
        System.out.println(students);
    }
    @Test
    void updateStudent() {
        Student student = new Student();
        student.setSId(3L)
                .setSName("张四")
                .setSAge(10);
        studentService.updateStudentById(student);
    }
    @Test
    void deleteStudent() {
        studentService.deleteStudentById(3L);
    }
    @Test
    void findBySome(){
        System.out.println(studentService.findStudentByFirstName("张"));
    }
}
复制代码