# 나만의 스프링부트 교재 - 2장 강사님 요약 $$youtube IXQxnaYOw0s $$ # 스프링부트 기초 ### 포트 사용중일때 - lsof -i :8080 - kill -9 <포트번호> # 스프링부트 2장 ### application.properties ```java # CONSOLE spring.output.ansi.enabled=always # DATABASE spring.datasource.driverClassName=org.mariadb.jdbc.Driver spring.datasource.url=jdbc:mariadb://127.0.0.1:3306/sbb_dev?useUnicode=true&characterEncoding=utf8&autoReconnect=true&serverTimezone=Asia/Seoul spring.datasource.username=root spring.datasource.password= # JPA spring.jpa.hibernate.ddl-auto=update spring.jpa.properties.hibernate.format_sql=true spring.jpa.properties.hibernate.show_sql=true # LOGGING logging.level.org.hibernate.orm.jdbc.bind=TRACE logging.level.org.hibernate.orm.jdbc.extract=TRACE ``` ### Build.gradle ```java implementation 'org.springframework.boot:spring-boot-starter-web' testImplementation 'org.projectlombok:lombok:1.18.28' compileOnly 'org.projectlombok:lombok' developmentOnly 'org.springframework.boot:spring-boot-devtools' annotationProcessor 'org.projectlombok:lombok' testImplementation 'org.springframework.boot:spring-boot-starter-test' // h2 runtimeOnly 'com.h2database:h2' // jpa implementation 'org.springframework.boot:spring-boot-starter-data-jpa' // mariadb implementation 'org.mariadb.jdbc:mariadb-java-client:3.3.0' // thymeleaf implementation 'org.springframework.boot:spring-boot-starter-thymeleaf' implementation 'nz.net.ultraq.thymeleaf:thymeleaf-layout-dialect' // Bootstrap implementation 'org.springframework.boot:spring-boot-starter-validation' // Spring Boot Validation implementation 'org.springframework.boot:spring-boot-starter-security' implementation 'org.thymeleaf.extras:thymeleaf-extras-springsecurity6:3.1.1.RELEASE' // markdown implementation 'org.commonmark:commonmark:0.21.0' } ``` # 스프링부트 3장 ## 자바스크립트를 사용하지 않은 구문 (삭제, 추천) ### 질문삭제 ```java ``` ### 답변삭제 ```java ``` ### 질문추천 ```java ``` ### 답변추천 ```java ``` ## 검색기능 ```mysql select distinct q.id, q.author_id, q.content, q.create_date, q.modify_date, q.subject from question q left outer join site_user u1 on q.author_id=u1.id left outer join answer a on q.id=a.question_id left outer join site_user u2 on a.author_id=u2.id where q.subject like '%스프링%' #question의 제목을 검색하는 구문 or q.content like '%스프링%' #question의 내용을 검색하는 구문 or u1.username like '%스프링%' #question의 작성자를 검색하는 구문 or a.content like '%스프링%' # answer의 내용을 검색하는 구문 or u2.username like '%스프링%' #answer의 작성자를 검색하는 구문 ```

스프링부트 나만의 교재