DBAPP ~

###데이터베이스 생성 방법

CREATE USER 'korea'@'%' IDENTIFIED BY 'korea1234';
GRANT ALL PRIVILEGES ON *.* TO 'korea'@'%';
CREATE database koreadb;

###추가 의존성

<dependency>
    <groupId>org.apache.tomcat</groupId>
    <artifactId>tomcat-jasper</artifactId>
    <version>9.0.46</version>
</dependency>

<!-- https://mvnrepository.com/artifact/javax.servlet/jstl -->
<dependency>
	<groupId>javax.servlet</groupId>
	<artifactId>jstl</artifactId>
	<version>1.2</version>
</dependency>

###JSTL teglib

<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>

application.yml

server:
 port: 8000
 servlet:
    encoding:
      charset: UTF-8
      

spring:
  mvc:
    view:
      prefix: /WEB-INF/views/
      suffix: .jsp
      
  datasource:
    driver-class-name: org.mariadb.jdbc.Driver
    username: korea
    password: korea1234
    url: jdbc:mysql://localhost:3306/koreadb      
    
    
  jpa:
    hibernate:
      ddl-auto: none #create:, update, none
    show-sql: true

더미데이터

INSERT INTO user(username, PASSWORD)VALUES('ssar','1234');
INSERT INTO user(username, PASSWORD)VALUES('cos','1234');


INSERT INTO post(title, content, user_id)VALUES('제목1','내용1',1);
INSERT INTO post(title, content, user_id)VALUES('제목2','내용2',1);
INSERT INTO post(title, content, user_id)VALUES('제목3','내용3',1);
INSERT INTO post(title, content, user_id)VALUES('제목4','내용4',2);
INSERT INTO post(title, content, user_id)VALUES('제목5','내용5',2);

###주소 API 승인키

https://www.juso.go.kr/addrlink/addrLinkUrl.do?confmKey=devU01TX0FVVEgyMDIxMDcwNTE3MjgyMzExMTM2MTE=&returnUrl=http://localhost:8000

###터미널 알록달록

spring:
  output:
    ansi:
      enabled: always

###collSms 의존성

 <dependency>
    <groupId>net.nurigo</groupId>
    <artifactId>javaSDK</artifactId>
    <version>2.2</version>
  </dependency>