[Spring Boot] JPA 설정

implementation 'org.springframework.boot:spring-boot-starter-data-jpa:2.5.4'
implementation 'mysql:mysql-connector-java:8.0.22'

gradle 추가

# mysql
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://주소:3306/스키마?serverTimezone=UTC&characterEncoding=UTF-8
spring.datasource.username=사용자
spring.datasource.password=비밀번호
# JPA
spring.jpa.show-sql=true
spring.jpa.hibernate.ddl-auto=update
spring.jpa.properties.hibernate.format_sql=true
# 기존 변수 명 그대로 사용
spring.jpa.hibernate.naming.physical-strategy = org.hibernate.boot.model.naming.PhysicalNamingStrategyStandardImpl

application.properties 추가

[JPA 설정]

├─java
│  └─com
│      └─example
│          └─webservice
│              │  ServletInitializer.java
│              │  MyWebApplication.java
│              │
│              ├─Config
│              ├─Controller
│              │      APIController.java
│              │      ViewController.java
│              │
│              ├─entity
│              │      member.java
│              │
│              └─repository
│                      memberRepository.java
│  
구조

import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
 
import lombok.Builder;
import lombok.Getter;
import lombok.NoArgsConstructor;
 
@Entity
@Table(name = "MEMBER")
@Getter
@NoArgsConstructor
public class member {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private int id;
 
    @Column(name = "age")
    private Integer age;
 
    @Column(name = "office")
    private String office;
 
    @Column(name = "comment")
    private String comment;
 
    @Builder
    public wgsGenotype(Integer age, String office, String comment) {
        this.age= age;
        this.office= office;
        this.comment = comment;
    }
 
}

member.java

 

import org.springframework.data.jpa.repository.JpaRepository;
import member 위치;
 
public interface memberRepository extends JpaRepository<member , Integer>{
}

memberRepository.java

 

@Autowired
memberRepository memberrepo;
 
@GetMapping("member")
public List<member> findAllMember() {
    return member.findAll();
}
 

APIController.java

findAll()으로 모두 가져온다.