Jpa-crud-自定义sql

1.添加依赖

<!--springBoot JPA的起步依赖 -->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>

2.实体类

package com.qf.pojo;

import com.fasterxml.jackson.annotation.JsonFormat;
import lombok.Data;
import org.springframework.format.annotation.DateTimeFormat;

import javax.persistence.*;
import java.util.Date;


@Data
@Entity//entity 标注当前是jpa的实体类
@Table(name = "student_jpa")// @Table 当前实体与数据库的对应关系 name：数据库表名
public class StudentJpa {
   
    //主键
    @Id
    //自增策略
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private  Integer id;

    //实体类属性与数据库列名的映射
    @Column(name = "student_name")
    private String studentName;

    @Column(name = "pic")
    private String pic;

    @Column(name = "birthday")
    @DateTimeFormat(pattern = "yyyy-MM-dd")
    @JsonFormat(pattern = "yyyy-MM-dd")
    private Date birthday;

}

dao层

package com.qf.dao;

import com.qf.pojo.StudentJpa;
import org