728x90
๋ฐ˜์‘ํ˜•

2024/04 29

[bootstrap] mutiselect enableCaseInsensitiveFiltering

Bootstrap Multiselect ํ”Œ๋Ÿฌ๊ทธ์ธ์—์„œ ๋Œ€์†Œ๋ฌธ์ž๋ฅผ ๊ตฌ๋ถ„ํ•˜์ง€ ์•Š๋Š” ํ•„ํ„ฐ๋ง์„ ํ™œ์„ฑํ™”ํ•˜๋ ค๋ฉด ์ผ๋ฐ˜์ ์œผ๋กœ ์˜ต์…˜ enableCaseInsensitiveFiltering์„ true. ๋‹ค์Œ์€ ์ด๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ๋ฐฉ๋ฒ•์— ๋Œ€ํ•œ ๊ธฐ๋ณธ ์˜ˆ์ž…๋‹ˆ๋‹ค.$('#mySelect').multiselect({ enableCaseInsensitiveFiltering: true});

IT์ง€์‹ 2024.04.30

[DB][MySQL] ๋ฐฉ๊ธˆ์ „์— Insertํ•œ ๊ฒฐ๊ณผ ์กฐํšŒ

1. TIMESTAMP ์ปฌ๋Ÿผ ์‚ฌ์šฉ: ๋ฐ์ดํ„ฐ๋ฅผ ์‚ฝ์ž…ํ•  ๋•Œ TIMESTAMP ํ˜น์€ DATETIME ์ปฌ๋Ÿผ์— ์‚ฝ์ž…๋œ ์‹œ๊ฐ„์„ ๊ธฐ๋กํ•˜๊ณ  ์žˆ๋‹ค๋ฉด, ์ด ์ •๋ณด๋ฅผ ํ™œ์šฉํ•˜์—ฌ ๋ฐฉ๊ธˆ ์ „์— ์‚ฝ์ž…ํ•œ ๋ฐ์ดํ„ฐ๋ฅผ ์กฐํšŒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.์˜ˆ๋ฅผ ๋“ค์–ด, insert_time์ด๋ผ๋Š” TIMESTAMP ์ปฌ๋Ÿผ์ด ์žˆ๋‹ค๋ฉด, ๋‹ค์Œ๊ณผ ๊ฐ™์ด ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.SELECT * FROM your_tableWHERE insert_time >= NOW() - INTERVAL 1 MINUTE; 2.AUTO_INCREMENT ID ์‚ฌ์šฉ: ๋งŒ์•ฝ ๋ฐ์ดํ„ฐ๊ฐ€ AUTO_INCREMENT ID์™€ ํ•จ๊ป˜ ์‚ฝ์ž…๋˜์—ˆ๋‹ค๋ฉด, ์ด ID๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋ฐฉ๊ธˆ ์‚ฝ์ž…๋œ ๋ฐ์ดํ„ฐ๋ฅผ ์กฐํšŒํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.์˜ˆ๋ฅผ ๋“ค์–ด, id๊ฐ€ AUTO_INCREMENT์ธ ๊ฒฝ์šฐ:SELECT * FROM your_tableWHERE..

DB 2024.04.29

[SPRINGBOOT]@Scheduled

@ScheduledSpring Boot์—์„œ @Scheduled ์–ด๋…ธํ…Œ์ด์…˜์„ ์‚ฌ์šฉํ•˜๋ฉด ์ผ์ •ํ•œ ์‹œ๊ฐ„ ๊ฐ„๊ฒฉ์œผ๋กœ, ํ˜น์€ ํŠน์ • ์‹œ๊ฐ„์— ์ฝ”๋“œ๊ฐ€ ์‹คํ–‰๋˜๋„๋ก ์„ค์ •ํ•  ์ˆ˜ ์žˆ๋‹ค.์ถœ์ฒ˜: https://dev-coco.tistory.com/176 [์Šฌ๊ธฐ๋กœ์šด ๊ฐœ๋ฐœ์ƒํ™œ:ํ‹ฐ์Šคํ† ๋ฆฌ]

JAVA/SPRINGBOOT 2024.04.27

[js] concat()

https://developer.mozilla.org/ko/docs/Web/JavaScript/Reference/Global_Objects/Array/concat Array.prototype.concat() - JavaScript | MDNArray ์ธ์Šคํ„ด์Šค์˜ concat() ๋ฉ”์„œ๋“œ๋Š” ๋‘ ๊ฐœ ์ด์ƒ์˜ ๋ฐฐ์—ด์„ ๋ณ‘ํ•ฉํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค. ์ด ๋ฉ”์„œ๋“œ๋Š” ๊ธฐ์กด ๋ฐฐ์—ด์„ ๋ณ€๊ฒฝํ•˜์ง€ ์•Š๊ณ , ์ƒˆ ๋ฐฐ์—ด์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.developer.mozilla.org Array ์ธ์Šคํ„ด์Šค์˜ concat() ๋ฉ”์„œ๋“œ๋Š” ๋‘ ๊ฐœ ์ด์ƒ์˜ ๋ฐฐ์—ด์„ ๋ณ‘ํ•ฉํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค. ์ด ๋ฉ”์„œ๋“œ๋Š” ๊ธฐ์กด ๋ฐฐ์—ด์„ ๋ณ€๊ฒฝํ•˜์ง€ ์•Š๊ณ , ์ƒˆ ๋ฐฐ์—ด์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.

Front/JS & jQuery 2024.04.26

[Error][JAVA] java switch ์—์„œ ๋‹ค๋ฅธ case ์— ๊ฐ™์€์ด๋ฆ„์˜ ๋ณ€์ˆ˜ ์‚ฌ์šฉ

Java์˜ switch ๋ฌธ์—์„œ๋Š” ๊ฐ case ๋ธ”๋ก ๋‚ด์—์„œ ๋™์ผํ•œ ์ด๋ฆ„์˜ ๋ณ€์ˆ˜๋ฅผ ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ํ•˜์ง€๋งŒ Java์˜ ์Šค์ฝ”ํ”„ ๊ทœ์น™์— ๋”ฐ๋ผ, ๋ณ€์ˆ˜๋Š” ๊ทธ ๋ฒ”์œ„ ๋‚ด์—์„œ๋งŒ ์œ ํšจํ•ฉ๋‹ˆ๋‹ค. ๋‹ค์‹œ ๋งํ•ด, switch ๋ฌธ ๋‚ด์˜ ๊ฐ case๋Š” ์„œ๋กœ ๋‹ค๋ฅธ ๋ธ”๋ก์œผ๋กœ ์ทจ๊ธ‰๋˜๋ฉฐ, ๊ฐ๊ฐ์˜ ๋ธ”๋ก ๋‚ด์—์„œ ๋ณ€์ˆ˜ ์ด๋ฆ„์ด ์ค‘๋ณต๋˜์–ด๋„ ์„œ๋กœ ์˜ํ–ฅ์„ ๋ฏธ์น˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๊ฐ case ๋ธ”๋ก์€ ๋…๋ฆฝ์ ์ธ ์Šค์ฝ”ํ”„๋ฅผ ๊ฐ€์ง€๊ณ  ์žˆ๊ธฐ ๋•Œ๋ฌธ์— ๋ณ€์ˆ˜ ์ด๋ฆ„์ด ์ค‘๋ณต๋˜์–ด๋„ ์„œ๋กœ ๊ฐ„์„ญํ•˜์ง€ ์•Š์Šต๋‹ˆ๋‹ค. ๊ทผ๋ฐ ์˜ค๋ฅ˜๊ฐ€ ๋‚˜์„œ ๋‹ค์‹œ๊ฒ€์ƒ‰.๋ฌธ์ œ๋ฅผ ํ•ด๊ฒฐํ•˜๊ธฐ ์œ„ํ•ด, ๋‘ ๊ฐœ์˜ case ๋ธ”๋ก์—์„œ ๊ฐ๊ฐ์˜ ๋ณ€์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ์ฆ‰, ๊ฐ case ๋ธ”๋ก ๋‚ด์—์„œ reqCrUpdateDTO ๋ณ€์ˆ˜๋ฅผ ๋‹ค๋ฅธ ์ด๋ฆ„์œผ๋กœ ๋ณ€๊ฒฝํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, ์ฒซ ๋ฒˆ์งธ case ๋ธ”๋ก์—์„œ๋Š” reqCrUpdateDTO1, ..

Error 2024.04.25

[SPRINGBOOT] Spring Boot ํŒŒ์ผ ์—…๋กœ๋“œ ์šฉ๋Ÿ‰ ์ œํ•œ

https://hjh0827.tistory.com/91#google_vignette Spring Boot ํŒŒ์ผ ์šฉ๋Ÿ‰ ์„ค์ • ์„œ๋ก  ์ด๋ฏธ์ง€ ์—…๋กœ๋“œ ํ…Œ์ŠคํŠธ ์ค‘ ์—๋Ÿฌ๊ฐ€ ๋‚˜์™€์„œ ์ •๋ฆฌํ•ฉ๋‹ˆ๋‹ค. ์—๋Ÿฌ org.apache.tomcat.util.http.fileupload.impl.FileSizeLimitExceededException: The field img exceeds its maximum permitted size of 1048576 bytes. ์›์ธ ์—…๋กœ๋“œํ•  ์ˆ˜ ์žˆ hjh0827.tistory.com โ“ํฌ๊ธฐ์„ค์ •์— ์ œํ•œ์ด ์žˆ๋‚˜? โžก๏ธ Spring์—์„œ ํŒŒ์ผ ์—…๋กœ๋“œ ๋ฐ ์š”์ฒญ ํฌ๊ธฐ ์„ค์ •์— ์ œํ•œ์ด ์žˆ๋Š” ๊ฒฝ์šฐ๋Š” ๋ณดํ†ต ์‹œ์Šคํ…œ์˜ ๋ฆฌ์†Œ์Šค์™€ ์—ฐ๊ฒฐ๋ฉ๋‹ˆ๋‹ค. ์ผ๋ฐ˜์ ์œผ๋กœ ์ด๋Ÿฌํ•œ ์„ค์ •์€ ์„œ๋ฒ„์˜ ์šฉ๋Ÿ‰๊ณผ ์„ฑ๋Šฅ์— ๋”ฐ๋ผ ์ œํ•œ๋ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, ..

JAVA/SPRINGBOOT 2024.04.23

[js][Dropzone] parallelUploads ์™€ maxFiles ์˜ ์ฐจ์ด

Dropzone.js์—์„œ parallelUploads์™€ maxFiles๋Š” ํŒŒ์ผ ์—…๋กœ๋“œ ๊ด€๋ จ ์„ค์ •์—์„œ ๊ฐ๊ฐ ๋‹ค๋ฅธ ์—ญํ• ์„ ํ•ฉ๋‹ˆ๋‹ค. 1. parallelUploads: ์ด ์˜ต์…˜์€ ๋™์‹œ์— ์—…๋กœ๋“œํ•  ์ˆ˜ ์žˆ๋Š” ํŒŒ์ผ์˜ ์ตœ๋Œ€ ์ˆ˜๋ฅผ ๊ฒฐ์ •ํ•ฉ๋‹ˆ๋‹ค. ์ฆ‰, ํ•œ ๋ฒˆ์— ์„œ๋ฒ„๋กœ ์ „์†ก๋˜๋Š” ํŒŒ์ผ์˜ ์ˆ˜๋ฅผ ์ œํ•œํ•˜๋Š” ์—ญํ• ์„ ํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, parallelUploads๋ฅผ 2๋กœ ์„ค์ •ํ•˜๋ฉด ์‚ฌ์šฉ์ž๊ฐ€ ๋™์‹œ์— ์ตœ๋Œ€ 2๊ฐœ์˜ ํŒŒ์ผ์„ ์—…๋กœ๋“œํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ด ์„ค์ •์„ ํ†ตํ•ด ์„œ๋ฒ„ ๋ฐ ํด๋ผ์ด์–ธํŠธ์˜ ๋ถ€ํ•˜๋ฅผ ์ œ์–ดํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.maxFiles: ์ด ์˜ต์…˜์€ ํ—ˆ์šฉ๋˜๋Š” ์ตœ๋Œ€ ํŒŒ์ผ ์ˆ˜๋ฅผ ๊ฒฐ์ •ํ•ฉ๋‹ˆ๋‹ค. ์‚ฌ์šฉ์ž๊ฐ€ ์—…๋กœ๋“œํ•  ์ˆ˜ ์žˆ๋Š” ํŒŒ์ผ์˜ ์ด ์ˆ˜๋ฅผ ์ œํ•œํ•˜๋Š” ์—ญํ• ์„ ํ•ฉ๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, maxFiles๋ฅผ 5๋กœ ์„ค์ •ํ•˜๋ฉด ์‚ฌ์šฉ์ž๋Š” ์ด 5๊ฐœ์˜ ํŒŒ์ผ๋งŒ ์—…๋กœ๋“œํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. Dro..

Front/JS & jQuery 2024.04.22

[js][Dropzone] dropzone ์—…๋กœ๋“œ๋‹น ์ตœ๋Œ€์šฉ๋Ÿ‰

Dropzone.js์—์„œ๋Š” ํŒŒ์ผ ์—…๋กœ๋“œ๋‹น ์ตœ๋Œ€ ์šฉ๋Ÿ‰์„ ์„ค์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์ด๋ฅผ ์„ค์ •ํ•˜๋Š” ๋ฐฉ๋ฒ•์€ Dropzone ๊ฐ์ฒด๋ฅผ ์ƒ์„ฑํ•  ๋•Œ maxFilesize ์˜ต์…˜์„ ์‚ฌ์šฉํ•˜์—ฌ ์„ค์ •ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. ์˜ˆ๋ฅผ ๋“ค์–ด, ํŒŒ์ผ ์—…๋กœ๋“œ๋‹น ์ตœ๋Œ€ ์šฉ๋Ÿ‰์„ 5MB๋กœ ์„ค์ •ํ•˜๋ ค๋ฉด ๋‹ค์Œ๊ณผ ๊ฐ™์ด Dropzone ๊ฐ์ฒด๋ฅผ ์ƒ์„ฑํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. Dropzone.options.myDropzone = { maxFilesize: 5, // ๋‹จ์œ„: MB }; ๊ทธ๋ฆฌ๊ณ  ํ—ˆ์šฉ๋˜๋Š” ์ตœ๋Œ€ ํŒŒ์ผ ์ˆ˜๋ฅผ ์ง€์ • ๊ฐ€๋Šฅํ•ฉ๋‹ˆ๋‹ค. Dropzone.options.myDropzone = { maxFiles: 5, // ์ตœ๋Œ€ ํŒŒ์ผ ์ˆ˜ };

Front/JS & jQuery 2024.04.21
728x90
๋ฐ˜์‘ํ˜•