728x90
๋ฐ˜์‘ํ˜•

์ „์ฒด ๊ธ€ 1223

[DB][SQL] COUNT(DISTINCT *)/ COUNT(*) ์ฐจ์ด

โœ… COUNT(DISTINCT A.userid)์„ค๋ช…: ๊ฐ™์€ userid๊ฐ€ ์—ฌ๋Ÿฌ ๋ฒˆ ๋“ฑ์žฅํ•˜๋”๋ผ๋„ ํ•œ ๋ฒˆ๋งŒ ๊ณ„์‚ฐ๋ฉ๋‹ˆ๋‹ค.์˜๋ฏธ: ์œ ๋‹ˆํฌํ•œ ์‚ฌ์šฉ์ž ์ˆ˜, ์ฆ‰ ์กฐํšŒํ•œ ๊ณ ๊ฐ ์ˆ˜(์ค‘๋ณต ์ œ๊ฑฐ)์˜ˆ์‹œ:๐Ÿ‘‰ COUNT(DISTINCT userid) = 3 (user1, user2, user3)useriduser1user2user1user3โœ… COUNT(A.userid)์„ค๋ช…: userid๊ฐ€ ์ค‘๋ณต๋˜๋”๋ผ๋„ ์ „๋ถ€ ์นด์šดํŒ…ํ•ฉ๋‹ˆ๋‹ค.์˜๋ฏธ: ์ด ์กฐํšŒ ์ˆ˜(๋ˆ„์ )์˜ˆ์‹œ (๊ฐ™์€ ํ…Œ์ด๋ธ”):๐Ÿ‘‰ COUNT(userid) = 4๐Ÿงฉ ์ •๋ฆฌ:ํ•ญ๋ชฉ์˜๋ฏธ์ค‘๋ณต ์ œ๊ฑฐ ์—ฌ๋ถ€์‚ฌ์šฉ ์˜ˆCOUNT(DISTINCT A.userid)์กฐํšŒํ•œ ๊ณ ๊ฐ ์ˆ˜โœ… ์ œ๊ฑฐ๋จ"๋ช‡ ๋ช…์ด ๋ดค๋Š”๊ฐ€?"COUNT(A.userid)์ด ์กฐํšŒ ํšŸ์ˆ˜โŒ ์ œ๊ฑฐ๋˜์ง€ ์•Š์Œ"๋ช‡ ๋ฒˆ์ด๋‚˜ ๋ดค๋Š”๊ฐ€?"

DB 2025.03.31

[js] closest() ์ฃผ์˜์‚ฌํ•ญ - name ์†์„ฑ ๋ณด๋‹ค๋Š” id๋‚˜ class ์‚ฌ์šฉํ•˜๊ธฐ

closest()์˜ ๋™์ž‘ ๋ฐฉ์‹closest(selector)๋Š” ํ˜„์žฌ ์š”์†Œ๋ถ€ํ„ฐ ์ƒ์œ„ ์š”์†Œ๋ฅผ ํƒ์ƒ‰ํ•˜์—ฌ ๊ฐ€์žฅ ๊ฐ€๊นŒ์šด ์ผ์น˜ํ•˜๋Š” ์š”์†Œ๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.ํ•˜์ง€๋งŒ name ์†์„ฑ์€ CSS ์„ ํƒ์ž๊ฐ€ ์•„๋‹Œ ์†์„ฑ(attribute) ์ด๋ฏ€๋กœ closest("[name=${dsdKey}]")์€ ์˜ˆ์ƒ๊ณผ ๋‹ค๋ฅด๊ฒŒ ๋™์ž‘ํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. name ์†์„ฑ์œผ๋กœ closest()๊ฐ€ ์ž˜๋ชป ๋™์ž‘ํ•˜๋Š” ์ด์œ name ์†์„ฑ์€ input, select, textarea ๊ฐ™์€ ํผ ์š”์†Œ์—์„œ ์ฃผ๋กœ ์‚ฌ์šฉ๋˜๋ฉฐ, closest()๋Š” id๋‚˜ class์ฒ˜๋Ÿผ HTML ํƒœ๊ทธ์—์„œ ์ง์ ‘ ์š”์†Œ๋ฅผ ์ฐพ์„ ๋•Œ ๋” ์ ํ•ฉํ•ฉ๋‹ˆ๋‹ค. name ์†์„ฑ์œผ๋กœ closest()๋ฅผ ์‚ฌ์šฉํ•œ ๊ฒฝ์šฐ (์ž˜๋ชป๋œ ์ฝ”๋“œ) ๋ฒ„ํŠผ const $target = $("#srch-custDivTp");const $in..

Front/JS & jQuery 2025.03.30

[js] moment().format() ์™€ moment().toDate() ์˜ ์ฐจ์ด

moment().format()์€ ๋ฌธ์ž์—ด์„ ๋ฐ˜ํ™˜ํ•˜์ง€๋งŒ,moment().toDate()๋Š” Date ๊ฐ์ฒด๋ฅผ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค.let formattedString = moment().format('YYYY-MM-DD HH:mm'); // ๋ฌธ์ž์—ดlet jsDate = moment().toDate(); // JavaScript Date ๊ฐ์ฒดconsole.log(typeof formattedString); // stringconsole.log(typeof jsDate); // object  ๐Ÿ“Œ ์ฐจ์ด์ ๋ฉ”์„œ๋“œ๋ฐ˜ํ™˜ ๊ฐ’์„ค๋ช…moment().format('YYYY-MM-DD')"2024-04-01"๋ฌธ์ž์—ด(String)moment().toDate()Mon Apr 01 2024 12:34:56 GMT+0900 (KST)Date ๊ฐ์ฒด

Front/JS & jQuery 2025.03.29

[js] moment().toDate()

๐Ÿ“Œ moment().toDate()๋ž€?moment().toDate()๋Š” Moment.js์—์„œ ์‚ฌ์šฉํ•˜๋Š” ๋ฉ”์„œ๋“œ๋กœ,moment ๊ฐ์ฒด๋ฅผ JavaScript Date ๊ฐ์ฒด๋กœ ๋ณ€ํ™˜ํ•˜๋Š” ๊ธฐ๋Šฅ์„ ํ•ฉ๋‹ˆ๋‹ค. โœ… ์™œ toDate()๋ฅผ ์‚ฌ์šฉํ• ๊นŒ?moment()๋กœ ์ƒ์„ฑํ•œ ๋‚ ์งœ๋Š” Moment.js์˜ ๊ฐ์ฒด์ด๊ณ ,datepicker๋‚˜ ์ผ๋ฐ˜์ ์ธ JavaScript Date ํ•จ์ˆ˜๋Š” Date ๊ฐ์ฒด๋ฅผ ํ•„์š”๋กœ ํ•ฉ๋‹ˆ๋‹ค.๐Ÿ‘‰ ๋”ฐ๋ผ์„œ moment().toDate()๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ Moment ๊ฐ์ฒด๋ฅผ JavaScript Date ๊ฐ์ฒด๋กœ ๋ณ€ํ™˜ํ•˜๋Š” ๊ฒƒ์ž…๋‹ˆ๋‹ค.  ๐Ÿ›  ์‚ฌ์šฉ ์˜ˆ์ œ๐ŸŽฏ 1๏ธโƒฃ Moment.js์˜ toDate()๋ฅผ ์‚ฌ์šฉํ•œ ์˜ˆlet momentDate = moment(); // Moment ๊ฐ์ฒดconsole.log(momentDate); // ?..

Front/JS & jQuery 2025.03.28

์ดํด๋ฆฝ์Šค์—์„œ SPRING ์ ์šฉ ์˜ต์…˜์ด ์•ˆ๋ณด์ผ ๋•Œ

1. Spring ํ”Œ๋Ÿฌ๊ทธ์ธ ์„ค์น˜ ํ™•์ธSpring ๊ด€๋ จ ๊ธฐ๋Šฅ์„ ์‚ฌ์šฉํ•˜๋ ค๋ฉด Spring Tools ํ”Œ๋Ÿฌ๊ทธ์ธ์ด ์„ค์น˜๋˜์–ด ์žˆ์–ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ํ™•์ธ ๋ฐ ์„ค์น˜ ๋ฐฉ๋ฒ•์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค:Spring Tools 4 ์„ค์น˜: Eclipse์—์„œ Spring ํ”„๋กœ์ ํŠธ๋ฅผ ์ง€์›ํ•˜๋ ค๋ฉด Spring Tools 4๊ฐ€ ํ•„์š”ํ•ฉ๋‹ˆ๋‹ค. ์ด๋ฅผ ์„ค์น˜ํ•˜๋ ค๋ฉด:Eclipse์—์„œ Help > Eclipse Marketplace...๋กœ ์ด๋™ํ•ฉ๋‹ˆ๋‹ค."Spring Tools 4"๋ฅผ ๊ฒ€์ƒ‰ํ•ฉ๋‹ˆ๋‹ค."Go to the full listing"์—์„œ Spring Tools 4๋ฅผ ์ฐพ์•„ ์„ค์น˜ํ•ฉ๋‹ˆ๋‹ค.์„ค์น˜๊ฐ€ ์™„๋ฃŒ๋˜๋ฉด Eclipse๋ฅผ ์žฌ์‹œ์ž‘ํ•ฉ๋‹ˆ๋‹ค.2. Spring ํ”„๋กœ์ ํŠธ ์ƒ์„ฑSpring์„ ์ ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ํ”„๋กœ์ ํŠธ ์œ ํ˜•์„ ์ƒ์„ฑํ•ด์•ผ ํ•ฉ๋‹ˆ๋‹ค. ์ผ๋ฐ˜์ ์ธ ๋ฐฉ๋ฒ•์€ ๋‹ค์Œ๊ณผ ๊ฐ™์Šต๋‹ˆ๋‹ค:Sprin..

IT์ง€์‹ 2025.03.26

์ดํด๋ฆฝ์Šค์—์„œ ๋กฌ๋ณต์ด ์‹คํ–‰๋˜์ง€ ์•Š์„ ๋•Œ

๋กฌ๋ณต ๋ผ์ด๋ธŒ๋Ÿฌ๋ฆฌ ์ถ”๊ฐ€ ํ™•์ธํ”„๋กœ์ ํŠธ์˜ pom.xml (Maven์„ ์‚ฌ์šฉ ์ค‘์ด๋ผ๋ฉด) ๋˜๋Š” build.gradle (Gradle์„ ์‚ฌ์šฉ ์ค‘์ด๋ผ๋ฉด)์— ๋กฌ๋ณต ์˜์กด์„ฑ์ด ์ œ๋Œ€๋กœ ์ถ”๊ฐ€๋˜์—ˆ๋Š”์ง€ ํ™•์ธํ•˜์„ธ์š”.                                                                                                                                                            Gradle ์˜ˆ์‹œ: org.projectlombok lombok 1.18.24 providedMaven ์˜ˆ์‹œ:dependencies { compileOnly 'org.projectlombok:lombok:1.18.2..

IT์ง€์‹ 2025.03.25

[CSS] ๋ถ€๋ชจ์š”์†Œ์˜ padding ์˜ํ–ฅ์„ ๋ฐ›์ง€ ์•Š๊ฒŒ ํ•˜๊ธฐ

.wrap-type1 { padding: 1.6rem; } ์•ˆ์— ์š”์†Œ๋ฅผ ํ•˜๋‚˜๋งŒ ์ œ์™ธ์‹œํ‚ค๊ณ  ์‹ถ์„๋•?  ๋ฐฉ๋ฒ• 1: margin์„ ์ด์šฉํ•œ ๋ณด์ •.wrap-type1 { padding: 1.6rem;}.wrap-type1 .exclude-padding { margin: -1.6rem;}  ๋ฐฉ๋ฒ• 2: position: absolute ์‚ฌ์šฉ (์ƒํ™ฉ์— ๋”ฐ๋ผ).wrap-type1 { position: relative; padding: 1.6rem;}.wrap-type1 .exclude-padding { position: absolute; top: 0; left: 0; right: 0;}  ๋ฐฉ๋ฒ• 3: padding์„ ํŠน์ • ์š”์†Œ์—๋งŒ ์ ์šฉ.wrap-type1 { display:..

Front/CSS 2025.03.24
728x90
๋ฐ˜์‘ํ˜•