56일차 시험친날, boot프로젝트 생성

요약정리

이거 메뉴주문테이블 메뉴테이블 고객테이블 
릴레이션쉽 이해 다시 해보기 

 

dto vo entity는 

뒤에 수정하면 문제 많음 처음부터 완벽하게 설계 하려고 노력

 

오전일과

이거 프로젝트 간략한 순서인듯 중요중요중요중요중요중요

db.vuerd.json 만듬

restauranttbl

SQL DDL 사진참고

식당이미지테이블 만듬
SQLDDL 눌러보니까
외래키를 들고오는 SQL문이 있음.
ALTER 사용

이거 메뉴주문테이블 메뉴테이블 고객테이블 
릴레이션쉽 이해 다시 해보기 

주문테이블은 외래키 2개를 가짐..


심하면 2주정도 걸린뎅

뒤에 수정하면 문제 많음 처음부터 완벽하게 설계 하려고 노력

DTO가 하나 바뀌면 전체 코드에 영향을 끼침

가장 기본적이고 가장 어렵고 가장 중요함

이거 이렇게 만든거 유료나 무료 툴 사용으로
바로 테이블 만들 수 있음.
유로는 양방향이 됨.
근데 우리는 무료라 SQLDDL사용

SQLDDL 복붙하여
ORACLE 기입
근데 외래키 이름이 너무 길어서 삭제하고 다시 만들어줌 




----- 오후 일과

마이바티스 기준 프로젝트 생성

application프로퍼티 작성

# 127.0.0.1:8080/BOOT1/
server.port=8080
server.servlet.context-path=/BOOT1
# server.servlet.context-path=/BOOT2
# 프로젝트 두명에서 할꺼면 요래 넣어줘야함

# 소스코드 변경시 자동으로 서버구동하기
spring.devtools.livereload.enabled=true

#view에 해당하는 html의 위치 설정
#cache=false 개발시, 서비스 배포시에는 trye
spring.thymeleaf.cache=false
spring.thymeleaf.prefix=classpath:/templates/
spring.thymeleaf.suffix=.html

home.html
각종 폴더 4개 controller, dto, mapper, service
boot파일에

컨트롤러랑 서비스 연동해줌

package com.example.boot_20220915;

import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;
import org.springframework.context.annotation.ComponentScan;

// 서비스, 컨트롤러, 환경설정
@ComponentScan(basePackages = {
	"com.example.service",
	"com.example.controller"
})



@SpringBootApplication
public class Boot20220915Application {

	public static void main(String[] args) {
		SpringApplication.run(Boot20220915Application.class, args);
	}

}

 

pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
	<modelVersion>4.0.0</modelVersion>
	<parent>
		<groupId>org.springframework.boot</groupId>
		<artifactId>spring-boot-starter-parent</artifactId>
		<version>2.7.4-SNAPSHOT</version>
		<relativePath/> <!-- lookup parent from repository -->
	</parent>
	<groupId>com.example</groupId>
	<artifactId>boot_20220915</artifactId>
	<version>0.0.1-SNAPSHOT</version>
	<name>boot_20220915</name>
	<description>Demo project for Spring Boot</description>
	<properties>
		<java.version>11</java.version>
	</properties>
	<dependencies>
		<!-- tomcat embedded was -->
		<dependency>
			<groupId>org.apache.tomcat.embed</groupId>
			<artifactId>tomcat-embed-jasper</artifactId>
			<scope>provided</scope>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-thymeleaf</artifactId>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-web</artifactId>
		</dependency>

		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-devtools</artifactId>
			<scope>runtime</scope>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.projectlombok</groupId>
			<artifactId>lombok</artifactId>
			<optional>true</optional>
		</dependency>
		<dependency>
			<groupId>org.springframework.boot</groupId>
			<artifactId>spring-boot-starter-test</artifactId>
			<scope>test</scope>
		</dependency>
	</dependencies>

	<build>
		<plugins>
			<plugin>
				<groupId>org.springframework.boot</groupId>
				<artifactId>spring-boot-maven-plugin</artifactId>
				<configuration>
					<excludes>
						<exclude>
							<groupId>org.projectlombok</groupId>
							<artifactId>lombok</artifactId>
						</exclude>
					</excludes>
				</configuration>
			</plugin>
		</plugins>
	</build>
	<repositories>
		<repository>
			<id>spring-milestones</id>
			<name>Spring Milestones</name>
			<url>https://repo.spring.io/milestone</url>
			<snapshots>
				<enabled>false</enabled>
			</snapshots>
		</repository>
		<repository>
			<id>spring-snapshots</id>
			<name>Spring Snapshots</name>
			<url>https://repo.spring.io/snapshot</url>
			<releases>
				<enabled>false</enabled>
			</releases>
		</repository>
	</repositories>
	<pluginRepositories>
		<pluginRepository>
			<id>spring-milestones</id>
			<name>Spring Milestones</name>
			<url>https://repo.spring.io/milestone</url>
			<snapshots>
				<enabled>false</enabled>
			</snapshots>
		</pluginRepository>
		<pluginRepository>
			<id>spring-snapshots</id>
			<name>Spring Snapshots</name>
			<url>https://repo.spring.io/snapshot</url>
			<releases>
				<enabled>false</enabled>
			</releases>
		</pluginRepository>
	</pluginRepositories>

</project>