JPA操作数据库---增删改查代码部分

1. dao层配置bean和table建立映射

import jakarta.persistence.Column;
import jakarta.persistence.Entity;
import jakarta.persistence.Id;
import jakarta.persistence.Table;
import lombok.Data;

@Entity
@Data
@Table(name = "table1")
public class Table1 {

    @Id
    private int id;

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

2. repository层写sql或者用jpa自带的方法

import com.gy.testdemo01.dao.Table1;
import jakarta.transaction.Transactional;
import org.apache.ibatis.annotations.Param;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;

public interface TableInterRepository extends CrudRepository<Table1, Integer> {

    @Modifying
    @Transactional
    @Query(value = "update table1 set name = :name where id =