스프링부트 설정

1. 스웨거 반영

build.gradle에 아래 내용 추가

// Swagger(Spring 3.x.x 이상부터 SpringFox 대신, SpringDoc)

implementation 'org.springdoc:springdoc-openapi-starter-webmvc-ui:2.0.2' 

 

config 폴더 생성 후, 아래 SwaggerConfig.java 파일 추가

import io.swagger.v3.oas.models.Components;

import io.swagger.v3.oas.models.OpenAPI;

import io.swagger.v3.oas.models.info.Info;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

@Configuration

public class SwaggerConfig {

    @Bean

    public OpenAPI openAPI() {

        return new OpenAPI()

                .components(new Components())

                .info(apiInfo());

    }

    private Info apiInfo() {

        return new Info()

                .title("Spring Boot REST API Specifications")

                .description("Specification")

                .version("1.0.0");

    }

}

 

2. DB 테이블 생성-- banbu.apt_sales definition

CREATE TABLE `apt_sales` (

  `id` int unsigned NOT NULL AUTO_INCREMENT,

  `regional_code` int NOT NULL,

  `dong` varchar(30) DEFAULT NULL,

  `jibun` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',

  `apartment_name` varchar(80) DEFAULT NULL,

  `area` float DEFAULT '0',

  `area_str` varchar(8) DEFAULT NULL,

  `floor` int DEFAULT '1',

  `deal_amount` int DEFAULT '0',

  `build_year` int DEFAULT '0',

  `deal_date` date NOT NULL,

  `trade_type` int DEFAULT NULL COMMENT '거래구분, 중개거래: 0, 직거래: 1',

  `agency_address` varchar(150) DEFAULT NULL COMMENT '중개사 소재지 주소',

  `registration_date` varchar(8) DEFAULT NULL COMMENT '등기일자 YY.MM.DD 형식',

  `seller` varchar(20) DEFAULT NULL COMMENT '매도자',

  `buyer` varchar(20) DEFAULT NULL COMMENT '매수자',

  `apartment_dong` varchar(50) DEFAULT NULL COMMENT '아파트 동 번호',

  `apt_seq` varchar(11) DEFAULT NULL,

  `road_name` varchar(150) DEFAULT NULL,

  `road_name_bonbun_bubun` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,

  PRIMARY KEY (`id`),

  KEY `idx_apt_sales4` (`regional_code`,`deal_date`),

  KEY `idx_apt_sales5` (`regional_code`),

  KEY `idx_apt_sales1` (`regional_code`,`dong`,`jibun`,`apartment_name`,`area_str`,`deal_date`),

  KEY `idx_apt_sales_regional_code_deal_date` (`regional_code`,`deal_date`),

  KEY `apt_sales_apt_seq_IDX` (`apt_seq`,`area_str`,`deal_date`) USING BTREE

) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;