본문 바로가기

개발36

1.Spring Boot 환경 셋팅 1. Eclipse Download 2. Eclipse 환경설정 Preference > Maven > User Settings create Maven Project 3. Spring Boot Web 설정 확인 0) pom.xml 4.0.0 com.kangong boot-kangong 0.0.1-SNAPSHOT war boot-kangong Kangong Project org.springframework.boot spring-boot-starter-parent 2.4.2 15 org.springframework.boot spring-boot-starter-web 1) Spring Boot Application package com.kangong; import org.springframework.boot.S.. 2021. 2. 6.
Mybatis 쿼리 바인딩 로그 출력 1. Interceptor.java 설정 package secretary.common.util; import java.lang.reflect.Field; import java.sql.Statement; import java.util.List; import java.util.Map; import java.util.Properties; import org.apache.ibatis.executor.statement.StatementHandler; import org.apache.ibatis.mapping.BoundSql; import org.apache.ibatis.mapping.ParameterMapping; import org.apache.ibatis.plugin.Interceptor; import org.. 2020. 8. 24.
MessageBundle DB로 전환 1. 테이블 생성 --테이블 생성 CREATE TABLE ST_COM_MESSAGE( ID bigint(20) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID', CREATE_DATE TIMESTAMP DEFAULT NOW() COMMENT '생성일', CREATE_USER VARCHAR(50) COMMENT '생성자', UPDATE_DATE TIMESTAMP COMMENT '수정일', UPDATE_USER VARCHAR(50) COMMENT '수정자', DELETE_YN VARCHAR(1) DEFAULT 'N' COMMENT '삭제여부', MESSAGE_CODE VARCHAR(100) COMMENT '메시지코드', LABLE_KO VARCHAR(100) COMMENT '.. 2020. 8. 23.
Mysql vo 만들기 1. vo 만들기 SELECT #CONCAT(COL,',')AS '' CONCAT('private ', CASE WHEN DATA_TYPE = 'timestamp' THEN 'Timestamp ' ELSE 'String ' END, GENERATOR_COL,';' , ' //' , IFNULL(COLUMN_COMMENT, ''))AS '' #CONCAT('#{', GENERATOR_COL,'},')AS '' FROM ( SELECT COL, CASE WHEN COL1 ='' THEN '_id' ELSE CONCAT(LOWER(COL1),UPPER(SUBSTR(COL2, 1, 1)),LOWER(SUBSTR(COL2, 2)),UPPER(SUBSTR(COL3, 1, 1)),LOWER(SUBSTR(COL3, 2.. 2020. 8. 15.

티스토리툴바