Spring Boot JPA 스키마 추가

build.gradle.kts

dependencies {
    implementation("org.springframework.boot:spring-boot-starter-data-jpa")
    runtimeOnly("mysql:mysql-connector-java")
}

> Could not find mysql:mysql-connector-java:.

https://velog.io/@yiseull/Could-not-find-mysqlmysql-connector-java-%ED%95%B4%EA%B2%B0

artifcat id가 변경되었다고 한다.

dependencies {
	runtimeOnly("com.mysql:mysql-connector-j")
}

src/main/resources/application.properties

spring.datasource.url=jdbc:mysql://localhost:3306/home_company
spring.datasource.username=your_username
spring.datasource.password=your_password
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver

spring.jpa.hibernate.ddl-auto=update
spring.jpa.show-sql=true
spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQL8Dialect

package com.cozzin.homecompany.model;

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

@Entity
public class User {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    private String name; // TODO: Validation
    private String email; // TODO: Validation
    private String password; // TODO: Validation, Security
}

다시 실행해보면 SQL이 자동으로 실행되는 것을 알 수 있다.

Hibernate: create table user (id bigint not null auto_increment, email varchar(255), name varchar(255), password varchar(255), primary key (id)) engine=InnoDB