terminal>> sudo apt install mysql-server
terminal>> mysql -u root -p
termianl>> 설정한 비밀번호 입력
음~역시 갓구름!
terminal>> ps -A|grep mysql
terminal>> sudo pkill mysql
termianl>> ps -A|grep mysqld
termianl>> sudo pkill mysqld
termianl>> service mysql restart
terminal>> mysql -u root -p
termianl>> 설정한 비밀번호 입력
create schema schedule_schema;
use schedule_schema;
CREATE TABLE `sample` (
`name` varchar(10),
`age` int(3),
PRIMARY KEY(`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
runtimeOnly 'mysql:mysql-connector-java
compileOnly 'org.projectlombok:lombok'
annotationProcessor 'org.projectlombok:lombok''
# API 호출시, SQL 문을 콘솔에 출력한다.
spring.jpa.show-sql=true
# DDL 정의시 데이터베이스의 고유 기능을 사용합니다.
# ex) 테이블 생성, 삭제 등
spring.jpa.generate-ddl=true
# MySQL 을 사용할 것.
spring.jpa.database=mysql
# MySQL 설정
spring.datasource.url=jdbc:mysql://localhost:3306/스키마명?useSSL=false&characterEncoding=UTF-8&serverTimezone=UTC
spring.datasource.username=db아이디
spring.datasource.password=db비번
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
# MySQL 상세 지정
spring.jpa.database-platform=org.hibernate.dialect.MySQL5InnoDBDialect
package com.scheduleAutomatic.model;
import lombok.*;
import javax.persistence.*;
@Data
@AllArgsConstructor
@NoArgsConstructor(access = AccessLevel.PROTECTED)
@Entity(name="sample")
public class sampleDTO {
@Id
@GeneratedValue(strategy = GenerationType.IDENTITY)
private String name;
private int age;
@Builder
public MemberVo(String name, int age) {
this.id = id;
this.name = name;
}
}
import com.scheduleAutomatic.model.SampleDTO;
public interface SampleDAO {
List<SampleDTO> findAll();
SampleDTO findById(String name);
void save(SampleDTO sampleDTO);
void deleteById(String name);
}