[JPA]SpringBoot + JPA

📌알아두기

작성중

🙆‍♀️ 사용툴

1. STS

🎯 연동방법

1. build.gradle파일에 의존성주입

implementation 'org.springframework.boot:spring-boot-starter-data-jpa:3.1.6' //jpa
compileOnly 'org.projectlombok:lombok:1.18.26' //lombok

2. application.properties파일에 DB와 JPA설정

#JPA가 애플리케이션 실행 시 데이터베이스 스키마를 자동으로 생성 또는 수정할지를 결정하는 설정
spring.jpa.hibernate.ddl-auto=update

#oracleDB
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.Oracle12cDialect

#oracleDB
spring.datasource.driverClassName=oracle.jdbc.OracleDriver
spring.datasource.url=jdbc:oracle:thin:@localhost:1521/xe
spring.datasource.username=아이디
spring.datasource.password=비밀번호

3. 테이블과 컬럼값과 대응하는 Entity생성

package com.example.demo.entity;

import jakarta.persistence.Entity;
import jakarta.persistence.GeneratedValue;
import jakarta.persistence.GenerationType;
import jakarta.persistence.Id;

import lombok.Builder;
import lombok.Getter;
import lombok.NoArgsConstructor;

@Getter
@NoArgsConstructor //기본생성자 생성 어노테이션
@Entity(name="테이블명") //테이블과 매칭될 엔티티임을 나타내는 어노테이션
public class testEntity {

	@Id //pk를 나타냄
	@GeneratedValue(strategy = GenerationType.IDENTITY)
	private long notiSeq;
	
	//기본적으로 @Column 장착되어있음
	private String notiKindCd;
	private String notiKindNm;
	private String notiTitle;
	private String notiDate;
	private String notiContent;
	
	@Builder //Setter대신 초기화
	public testEntity(String notiKindCd, String notiKindNm, String noti_kind_nm, String notiTitle, String notiDate, String notiContent) {
		this.notiKindCd = notiKindCd;
		this.notiKindNm = notiKindNm;
		this.notiTitle = notiTitle;
		this.notiDate = notiDate;
		this.notiContent = notiContent;
	}

}

4. Entity를 사용하는 Repository생성

package com.example.demo.entity;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.stereotype.Repository;

@Repository
public interface lostNotiRepository  extends JpaRepository<testEntity, Long>{//연결한 엔티티<이름, pk 변수형>
//테스트만하기위해 jpa메소드 미기입
}

5. 컨트롤러

package com.example.demo.controller;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;

import com.example.demo.entity.testEntity;
import com.example.demo.entity.lostNotiRepository;

import java.util.List;

//import org.junit.After;
//import org.junit.Test;

@RestController
public class MainController {
	lostNotiRepository lostNotiRepository;
	
	@Autowired //빈주입
	public MainController(lostNotiRepository lostNotiRepository) {
		this.lostNotiRepository = lostNotiRepository;
	}
	
	@RequestMapping("/hello")
	public String hello() {
		List<testEntity> temp = lostNotiRepository.findAll(); //테이블에 있는 모든 데이터들을 가져오는 findAll함수
		return "hello";
	}
	

}