728x90
๋ฐ˜์‘ํ˜•

2024/11 28

[DB][Oracle] ๋‹ค์ค‘ Insert INSERT ALL๊ตฌ๋ฌธ ์‚ฌ์šฉ

INSERT ALL INTO T_LD_EXHB_CLS (TENANT_CD, LD_CD, EXHB_CLS_TP, MEMO, INS_USER_CD, UPD_USER_CD) VALUES ('TNT202405280001', 'LD202410150002', '101', '๋‚ด์šฉ1 ๋‚ด์šฉ2', 'US202305290057', 'US202305290057') INTO T_LD_EXHB_CLS (TENANT_CD, LD_CD, EXHB_CLS_TP, MEMO, INS_USER_CD, UPD_USER_CD) VALUES ('TNT202405280001', 'LD202410150002', '102', '๋‚ด์šฉ1 ๋‚ด์šฉ2', 'US202305290057', 'US202305290057') INTO T_L..

JAVA 2024.11.30

[DB][Oracle] ๋‹ค์ค‘ Insert UNION ALL ์‚ฌ์šฉ

INSERT INTO T_LD_EXHB_CLS ( TENANT_CD, LD_CD, EXHB_CLS_TP, MEMO, INS_USER_CD, UPD_USER_CD)SELECT 'TNT202405280001', 'LD202410150002', '101', '๋‚ด์šฉ1 ๋‚ด์šฉ2', 'US202305290057', 'US202305290057' FROM DUALUNION ALLSELECT 'TNT202405280001', 'LD202410150002', '102', '๋‚ด์šฉ1 ๋‚ด์šฉ2', 'US202305290057', 'US202305290057' FROM DUALUNION ALLSELECT 'TNT202405280001', 'LD202410150002', '103', '๋‚ด์šฉ1 ๋‚ด์šฉ2', 'US2023052900..

DB 2024.11.29

[DB][Mybatis] size() / length()

1.size()์ ์šฉ ๋Œ€์ƒ: Collection ์ธํ„ฐํŽ˜์ด์Šค๋ฅผ ๊ตฌํ˜„ํ•˜๋Š” ์œ ํ˜•(์˜ˆ: List, Set, Map) ๋˜๋Š” ๊ฐ์ฒด java.util.Collection.๋ชฉ์ : ์ปฌ๋ ‰์…˜์— ์žˆ๋Š” ์š”์†Œ์˜ ์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.์˜ˆ:์˜ ๊ฒฝ์šฐ List, ํ˜ธ์ถœํ•˜๋ฉด list.size()๋ชฉ๋ก์— ์žˆ๋Š” ์š”์†Œ์˜ ๊ฐœ์ˆ˜๊ฐ€ ๋‚˜์˜ต๋‹ˆ๋‹ค.์˜ ๊ฒฝ์šฐ Map, ํ˜ธ์ถœํ•˜๋ฉด map.size()ํ‚ค-๊ฐ’ ์Œ์˜ ๊ฐœ์ˆ˜๊ฐ€ ๋ฐ˜ํ™˜๋ฉ๋‹ˆ๋‹ค. 0">  2.length์ ์šฉ ๋Œ€์ƒ: ๋ฐฐ์—ด( String[], int[], ๋“ฑ).๋ชฉ์ : ๋ฐฐ์—ด์˜ ์š”์†Œ ์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. ๋ฉ”์„œ๋“œ๊ฐ€ ์•„๋‹ˆ๋ผ ์†์„ฑ์ด๋ฏ€๋กœ ๊ด„ํ˜ธ๋ฅผ ์‚ฌ์šฉํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค.์˜ˆ:a์˜ ๊ฒฝ์šฐ String[] array, ํ˜ธ์ถœํ•˜๋ฉด array.length๋ฐฐ์—ด์— ์žˆ๋Š” ์š”์†Œ์˜ ๊ฐœ์ˆ˜๊ฐ€ ๋‚˜์˜ต๋‹ˆ๋‹ค. 0">  ์ฃผ์š” ์ฐจ์ด์ ํŠน์ง•size()length์œ ํ˜•๋ฐฉ๋ฒ• ( ..

DB 2024.11.28

[Error][Mybatis]org.apache.ibatis.builder.BuilderException: Error evaluating expression 'param.exhbClsTps != null and param.exhbClsTps.size() > 0'. Cause: org.apache.ibatis.ognl.MethodFailedException: Method "size" failed for object

๋ฐฐ์—ด์„ ๋‹ค๋ฃจ๋Š” ๊ฒฝ์šฐ size()๋ฉ”์„œ๋“œ๋ฅผ ์†์„ฑ์œผ๋กœ ๋ฐ”๊พธ์„ธ์š” .lengthparam.exhbClsTps๋ฐฐ์—ด์ธ ๊ฒฝ์šฐ (์˜ˆ: String[]) ๋‹ค์Œ์„ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. 0">

Error 2024.11.27

[js][datatables] ์—‘์…€ ํŒŒ์ผ๋ช… ์„ค์ •

ํŒŒ์ผ๋ช… ์„ค์ • ๋ฐฉ๋ฒ•buttons ์˜ต์…˜์—์„œ filename ์†์„ฑ์„ ์„ค์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ํŒŒ์ผ๋ช…์— &๋ฅผ ํฌํ•จํ•˜๊ณ  ์‹ถ๋‹ค๋ฉด, ๋‹ค์Œ๊ณผ ๊ฐ™์ด ์„ค์ •ํ•ด ๋ณด์„ธ์š”.$('#example').DataTable({ dom: 'Bfrtip', buttons: [ { extend: 'excel', text: 'Export to Excel', filename: 'Company & Sales Data', // ์—ฌ๊ธฐ์„œ '&' ์‚ฌ์šฉ title: 'Exported Data' // ์ œ๋ชฉ ์„ค์ • (optional) } ]});

Front/JS & jQuery 2024.11.26

[JAVA] BigDecimal ๋‚˜๋ˆ„๊ธฐ

1. ๊ธฐ๋ณธ ๋‚˜๋ˆ—์…ˆBigDecimal์˜ divide ๋ฉ”์„œ๋“œ๋Š” ์ •ํ™•ํ•œ ๊ณ„์‚ฐ์„ ๋ณด์žฅํ•ฉ๋‹ˆ๋‹ค. ๊ทธ๋Ÿฌ๋‚˜ ๊ฒฐ๊ณผ๊ฐ€ ๋ฌดํ•œ์†Œ์ˆ˜์ผ ๊ฒฝ์šฐ, ArithmeticException์ด ๋ฐœ์ƒํ•˜๋ฏ€๋กœ, ์†Œ์ˆ˜์  ์ž๋ฆฌ์ˆ˜์™€ ๋ฐ˜์˜ฌ๋ฆผ ๋ชจ๋“œ๋ฅผ ์ง€์ •ํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค.import java.math.BigDecimal;import java.math.RoundingMode;public class BigDecimalDivision { public static void main(String[] args) { BigDecimal numerator = new BigDecimal("10"); BigDecimal denominator = new BigDecimal("3"); // Scale์„ 2๋กœ ์„ค์ •ํ•˜๊ณ , ๋ฐ˜์˜ฌ๋ฆผ ๋ชจ๋“œ HALF..

JAVA 2024.11.25

[JAVA] JWT์ธ์ฆ ํ† ํฐ์„ ๊ฑฐ์น˜์ง€ ์•Š๋Š” ์˜ˆ์™ธ API ์„ค์ •ํ•˜๊ธฐ ๋ฐฉ๋ฒ• ์ข…ํ•ฉ

@Configuration@EnableWebSecuritypublic class SecurityConfig { private final JwtRequestFilter jwtRequestFilter; public SecurityConfig(JwtRequestFilter jwtRequestFilter) { this.jwtRequestFilter = jwtRequestFilter; } @Bean public SecurityFilterChain securityFilterChain(HttpSecurity http) throws Exception { return http .httpBasic().disable() ..

JAVA 2024.11.24

[JAVA] JWT์ธ์ฆ ํ† ํฐ์„ ๊ฑฐ์น˜์ง€ ์•Š๋Š” ์˜ˆ์™ธ API ์„ค์ •ํ•˜๊ธฐ ๋ฐฉ๋ฒ•2

๋ฐฉ๋ฒ• 2: WebSecurityCustomizer๋กœ ๋ณด์•ˆ ๋ฌด์‹œ ์„ค์ •WebSecurityCustomizer๋ฅผ ์‚ฌ์šฉํ•ด ํŠน์ • ๊ฒฝ๋กœ์— ๋Œ€ํ•ด Spring Security์˜ ๋ชจ๋“  ํ•„ํ„ฐ๋ฅผ ๋ฌด์‹œํ•˜๋„๋ก ์„ค์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.@Beanpublic WebSecurityCustomizer webSecurityCustomizer() { return (web) -> web.ignoring() // JWT ์ธ์ฆ์„ ๊ฑฐ์น˜์ง€ ์•Š๋Š” ๊ฒฝ๋กœ .antMatchers("/api/public/**");}์ฃผ์š” ์‚ฌํ•ญ:๋ณด์•ˆ ๋ฌด์‹œ: ํ•ด๋‹น ๊ฒฝ๋กœ๋Š” Spring Security์˜ ๋ชจ๋“  ํ•„ํ„ฐ๋ฅผ ์šฐํšŒํ•˜๋ฏ€๋กœ, CORS๋‚˜ CSRF ๊ฐ™์€ ์„ค์ •๋„ ์˜ํ–ฅ์„ ๋ฐ›์ง€ ์•Š์Šต๋‹ˆ๋‹ค.๊ฒฝ๋กœ ์˜ˆ์™ธ: ๋ณด์•ˆ์ด ์™„์ „ํžˆ ๋น„ํ™œ์„ฑํ™”๋˜๋ฏ€๋กœ, ์ธ์ฆ์ด ํ•„์š” ์—†๋Š”..

JAVA 2024.11.23

[JAVA] JWT์ธ์ฆ ํ† ํฐ์„ ๊ฑฐ์น˜์ง€ ์•Š๋Š” ์˜ˆ์™ธ API ์„ค์ •ํ•˜๊ธฐ ๋ฐฉ๋ฒ•1

๋ฐฉ๋ฒ• 1: HttpSecurity์—์„œ permitAll() ์‚ฌ์šฉHttpSecurity๋ฅผ ํ™œ์šฉํ•ด ๊ฒฝ๋กœ์— ๋Œ€ํ•ด ๋ช…์‹œ์ ์œผ๋กœ ์ธ์ฆ์„ ๋น„ํ™œ์„ฑํ™”ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.@Beanpublic SecurityFilterChain securityFilterChain(HttpSecurity http) throws Exception { return http .httpBasic().disable() // ๊ธฐ๋ณธ ์ธ์ฆ ๋น„ํ™œ์„ฑํ™” .csrf().disable() // CSRF ๋น„ํ™œ์„ฑํ™” .authorizeHttpRequests() // JWT ์ธ์ฆ ์—†์ด ํ—ˆ์šฉํ•  API ๊ฒฝ๋กœ .antMatchers("/api/public/**").permitA..

JAVA 2024.11.22

[DB][Oracle] Number(1,0)

Oracle์—์„œ ๋ฐ์ดํ„ฐ ์œ ํ˜•์€ NUMBER(1,0)๋‹ค์Œ๊ณผ ๊ฐ™์€ ์ œ์•ฝ ์กฐ๊ฑด์ด ์žˆ๋Š” ์ˆซ์ž ๊ฐ’์„ ๋‚˜ํƒ€๋ƒ…๋‹ˆ๋‹ค.์ •๋ฐ€๋„( 1) : ์ˆซ์ž๋Š” ์ตœ๋Œ€ 1์ž๋ฆฌ๊นŒ์ง€ ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค.ํฌ๊ธฐ( 0) : ์ˆซ์ž์—๋Š” ์†Œ์ˆ˜ ์ž๋ฆฟ์ˆ˜๊ฐ€ ํฌํ•จ๋  ์ˆ˜ ์—†์œผ๋ฉฐ ์ •์ˆ˜์—ฌ์•ผ ํ•ฉ๋‹ˆ๋‹ค.์œ ํšจํ•œ ๊ฐ’๊ฐ’์˜ ๋ฒ”์œ„๋Š” -9๋ถ€ํ„ฐ 9 (ํ•œ ์ž๋ฆฌ ์ •์ˆ˜)๊นŒ์ง€์ž…๋‹ˆ๋‹ค.์œ ํšจํ•œ ๊ฐ’์˜ ์˜ˆ05-3์ž˜๋ชป๋œ ๊ฐ’์˜ ์˜ˆ10(1์ž๋ฆฌ ์ดˆ๊ณผ)1.2(์†Œ์ˆ˜์  ๋ถ€๋ถ„์ด ์žˆ์Œ)0์ด ๋ฐ์ดํ„ฐ ์œ ํ˜•์€ ํ”Œ๋ž˜๊ทธ๋‚˜ ๋ถ€์šธ๊ณผ ๊ฐ™์€ ๊ฐ’( ๋˜๋Š” ) ๊ณผ ๊ฐ™์€ ์ž‘์€ ์ •์ˆ˜๋ฅผ ์ €์žฅํ•˜๋Š” ๋ฐ ์ž์ฃผ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค . ๋” ์—„๊ฒฉํ•œ ๊ฐ’(์˜ˆ: ๋˜๋Š” 1)์„ ์ ์šฉํ•ด์•ผ ํ•˜๋Š” ๊ฒฝ์šฐ ์ผ๋ฐ˜์ ์œผ๋กœ ์ œ์•ฝ ์กฐ๊ฑด์ด๋‚˜ ๊ฒ€์ฆ์„ ์‚ฌ์šฉํ•˜์—ฌ ์ด๋ฅผ ์ฒ˜๋ฆฌํ•ฉ๋‹ˆ๋‹ค.01

DB 2024.11.21
728x90
๋ฐ˜์‘ํ˜•