search

dev-hiyoon / finnq-v40-study

0 stars 0 forks source link

1. 2021-05-18 db 연결 / jpa #2

Open dev-hiyoon opened 3 years ago

dev-hiyoon commented 3 years ago

  1. 항목

    • docker/mariadb
    • db 연결
    • jpa

  2. 과제

dev-hiyoon commented 3 years ago

  1. docker 설치

  2. mariadb 설치

    • docker pull mariadb
    • docker container run -d -p 3306:3306 -e MYSQL_ROOT_PASSWORD=1234 -v {윈도우경로}:/var/lib/mysql --name mariadb mariadb
    • docker exec -it mariadb bash
    • mysql -uroot -p1234

  3. mariadb& jpa설정

build.gradle implementation 'org.springframework.boot:spring-boot-starter-data-jpa' runtimeOnly 'org.mariadb.jdbc:mariadb-java-client' // MariaDB

  1. application.yaml spring: datasource: url: jdbc:mariadb://localhost:4406/finnq_v40 driver-class-name: org.mariadb.jdbc.Driver username: root password: 1234 jpa: open-in-view: false generate-ddl: true show-sql: true hibernate: ddl-auto: update

  2. data INSERT INTO finnq_v40.MEMBER (MEMBER_ID, MEMBER_NAME, PHONE, CRE_DT, CRE_ID) VALUES ('h', 'hiyoon', '01054202788', now(), 'hiyoon');

freeangelsun commented 3 years ago

create table MEMBER ( MEMBER_ID varchar(30) not null, MEMBER_NAME varchar(50) not null, PHONE varchar(20) null, ADDR varchar(200) null, CRE_DT DATETIME not null, CRE_ID varchar(30) not null, constraint MEMBER_pk unique (MEMBER_ID) );

dev-hiyoon commented 3 years ago

create database finnq_v40;

dev-hiyoon commented 3 years ago

과제

  1. member 테이블 crud 하는 controller 생성할 것
    • get/post/update/delete