[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/JAVA] 11. ์ง์ˆ˜์™€ ํ™€์ˆ˜
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/์•Œ๊ณ ๋ฆฌ์ฆ˜ ์ฝ”๋“œ์นดํƒ€
โ‡๏ธ ๋ฌธ์ œ ์„ค๋ช…์ •์ˆ˜ num์ด ์ง์ˆ˜์ผ ๊ฒฝ์šฐ "Even"์„ ๋ฐ˜ํ™˜ํ•˜๊ณ  ํ™€์ˆ˜์ธ ๊ฒฝ์šฐ "Odd"๋ฅผ ๋ฐ˜ํ™˜ํ•˜๋Š” ํ•จ์ˆ˜, solution์„ ์™„์„ฑํ•ด์ฃผ์„ธ์š”.https://school.programmers.co.kr/learn/courses/30/lessons/12937 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr โ‡๏ธ ์š”๊ตฌ์‚ฌํ•ญ1. ์ •์ˆ˜ num์ด ์ง์ˆ˜์ผ ๊ฒฝ์šฐ Even, ํ™€์ˆ˜์ผ ๊ฒฝ์šฐ Odd ๋ฐ˜ํ™˜ํ•˜๊ธฐ โ‡๏ธ ์ž‘์„ฑ์ฝ”๋“œclass Solution { public String solution(int num) { String answer = ""; if ((num%2) == 0) { a..
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/MYSQL] 10. ์–ด๋ฆฐ ๋™๋ฌผ ์ฐพ๊ธฐ
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/SQL ์ฝ”๋“œ์นดํƒ€
โ‡๏ธ ๋ฌธ์ œ ์„ค๋ช…๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋“ค์–ด์˜จ ๋™๋ฌผ ์ค‘ ์ Š์€ ๋™๋ฌผ์˜ ์•„์ด๋””์™€ ์ด๋ฆ„์„ ์กฐํšŒํ•˜๋Š” SQL ๋ฌธ์„ ์ž‘์„ฑํ•ด์ฃผ์„ธ์š”. ์ด๋•Œ ๊ฒฐ๊ณผ๋Š” ์•„์ด๋”” ์ˆœ์œผ๋กœ ์กฐํšŒํ•ด์ฃผ์„ธ์š”.https://school.programmers.co.kr/learn/courses/30/lessons/59037 โ‡๏ธ ์š”๊ตฌ์‚ฌํ•ญ1. ์ Š์€ ๋™๋ฌผ (INTAKE_CONDITION์ด Aged๊ฐ€ ์•„๋‹Œ ๊ฒฝ์šฐ)์˜ ์•„์ด๋””์™€ ์ด๋ฆ„ ์กฐํšŒ2. ๊ฒฐ๊ณผ๋Š” ์•„์ด๋”” ์ˆœ์œผ๋กœ ์ •๋ ฌ โ‡๏ธ ์ž‘์„ฑ์ฝ”๋“œSELECT ANIMAL_ID, NAMEFROM ANIMAL_INSWHERE INTAKE_CONDITION != 'Aged'ORDER BY 1 โ‡๏ธ ์ฝ”๋“œ ํ’€์ด1. ์ Š์€ ๋™๋ฌผ (INTAKE_CONDITION์ด Aged๊ฐ€ ์•„๋‹Œ ๊ฒฝ์šฐ) ์กฐํšŒใ€€: WHERE INTAKE_CONDITION != 'Aged' ..
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/JAVA] 10. ๋ฐฐ์—ด์˜ ํ‰๊ท 
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/์•Œ๊ณ ๋ฆฌ์ฆ˜ ์ฝ”๋“œ์นดํƒ€
โ‡๏ธ ๋ฌธ์ œ ์„ค๋ช…์ •์ˆ˜ ๋ฐฐ์—ด numbers๊ฐ€ ๋งค๊ฐœ๋ณ€์ˆ˜๋กœ ์ฃผ์–ด์ง‘๋‹ˆ๋‹ค. numbers์˜ ์›์†Œ์˜ ํ‰๊ท ๊ฐ’์„ returnํ•˜๋„๋ก solution ํ•จ์ˆ˜๋ฅผ ์™„์„ฑํ•ด์ฃผ์„ธ์š”.https://school.programmers.co.kr/learn/courses/30/lessons/120817 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr โ‡๏ธ ์š”๊ตฌ์‚ฌํ•ญ1. ๋ฐฐ์—ด์˜ ํ•ฉ ๊ตฌํ•˜๊ธฐ2. ๋ฐฐ์—ด์˜ ํ‰๊ท  ๊ตฌํ•˜๊ธฐ3. ์ •๋‹ต์˜ ์†Œ์ˆ˜ ๋ถ€๋ถ„์ด .0 ๋˜๋Š” .5์ธ ๊ฒฝ์šฐ๋งŒ ์ž…๋ ฅ์œผ๋กœ ์ฃผ์–ด์ง โ‡๏ธ ์ž‘์„ฑ์ฝ”๋“œclass Solution { public double solution(int[] numbers) { double answer = 0; ..
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/MYSQL] 9. ์ตœ์†Ÿ๊ฐ’ ๊ตฌํ•˜๊ธฐ
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/SQL ์ฝ”๋“œ์นดํƒ€
โ‡๏ธ ๋ฌธ์ œ ์„ค๋ช…๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๊ฐ€์žฅ ๋จผ์ € ๋“ค์–ด์˜จ ๋™๋ฌผ์€ ์–ธ์ œ ๋“ค์–ด์™”๋Š”์ง€ ์กฐํšŒํ•˜๋Š” SQL ๋ฌธ์„ ์ž‘์„ฑhttps://school.programmers.co.kr/learn/courses/30/lessons/59038 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr โ‡๏ธ ์š”๊ตฌ์‚ฌํ•ญ1. ๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋จผ์ € ๋“ค์–ด์˜จ(๋ณดํ˜ธ ์‹œ์ž‘์ผ)์ˆœ์œผ๋กœ ์ •๋ ฌ2. ๊ฐ€์žฅ ๋จผ์ € ๋“ค์–ด์˜จ ๋™๋ฌผ๋งŒ ์กฐํšŒ โ‡๏ธ ์ž‘์„ฑ์ฝ”๋“œSELECT DATETIME AS '์‹œ๊ฐ„'FROM ANIMAL_INSORDER BY DATETIMELIMIT 1; โ‡๏ธ ์ฝ”๋“œ ํ’€์ด1. ๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋จผ์ € ๋“ค์–ด์˜จ(๋ณดํ˜ธ ์‹œ์ž‘์ผ)์ˆœ์œผ๋กœ ์ •๋ ฌใ€€: ORDER BY DATETIME 2. ๊ฐ€์žฅ ๋จผ์ €..
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/JAVA] 9. ์ง์ˆ˜์˜ ํ•ฉ
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/์•Œ๊ณ ๋ฆฌ์ฆ˜ ์ฝ”๋“œ์นดํƒ€
โ‡๏ธ ๋ฌธ์ œ ์„ค๋ช…์ •์ˆ˜ n์ด ์ฃผ์–ด์งˆ ๋•Œ, n ์ดํ•˜์˜ ์ง์ˆ˜๋ฅผ ๋ชจ๋‘ ๋”ํ•œ ๊ฐ’์„ return ํ•˜๋„๋ก solution ํ•จ์ˆ˜๋ฅผ ์ž‘์„ฑํ•ด์ฃผ์„ธ์š”.https://school.programmers.co.kr/learn/courses/30/lessons/120831 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr โ‡๏ธ ์š”๊ตฌ์‚ฌํ•ญ1. n ์ดํ•˜์˜ ์ง์ˆ˜ ๋ชจ๋‘ ๋”ํ•˜๊ธฐ2. ๋”ํ•˜๋Š” ๊ฐ’์ด n์„ ์ดˆ๊ณผํ•˜๋ฉด ๊ฒฐ๊ณผ ์ถœ๋ ฅํ•˜๊ธฐ  โ‡๏ธ ์ž‘์„ฑ์ฝ”๋“œclass Solution { public int solution(int n) { int answer = 0; int a = 0; while (a  โ‡๏ธ ์ฝ”๋“œ ํ’€์ด1. n..
[๊ณ„์‚ฐ๊ธฐ ๋งŒ๋“ค๊ธฐ] ํ•ด์„ค ๊ฐ•์˜๋ฅผ ๋“ค์œผ๋ฉฐ ๋ฐฐ์šด ์ (+ ๋А๋‚€ ์ )
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/๋ณธ์บ ํ”„ ๊ณผ์ œ
1. While ์ข…๋ฃŒ ๋ฐฉ๋ฒ•๋‚˜๋Š” while(true)๋กœ ์ž…๋ ฅ๋ฐ›๊ณ  break๋กœ ๋น ์ ธ๋‚˜๊ฐ€๋Š” ๋ฐฉ๋ฒ•๋งŒ ์ƒ๊ฐํ–ˆ๋Š”๋ฐString exit = "";While (!exit.equlas("exit")){ }์ด๋ ‡๊ฒŒ ์ž‘์„ฑํ• ์ˆ˜๋„ ์žˆ๊ตฌ๋‚˜.. ์‹ถ์—ˆ๋‹ค. exit๋ฅผ ํ™œ์šฉํ•ด ํƒˆ์ถœํ•  ์ˆ˜ ์žˆ๋‹ค๋Š”๊ฒŒ ์ง๊ด€์ ์œผ๋กœ ๋А๊ปด์กŒ๋‹ค.. 2. nextLine()๊ฐ€ ํ•„์š”ํ•œ ๊ฒฝ์šฐ๋‚˜๋Š” nextInt() ์‹คํ–‰ํ•  ๋•Œ ๋งˆ๋‹ค nextLine์„ ๋ฐ”๋กœ ์•„๋ž˜์— ๊ณ„์† ์ž‘์„ฑํ–ˆ์—ˆ๋Š”๋ฐScanner sc = new Scanner(System.in);System.out.print("์ฒซ ๋ฒˆ์งธ ์ˆซ์ž ์ž…๋ ฅ: ");int num1 = sc.nextInt(); System.out.print("๋‘ ๋ฒˆ์งธ ์ˆซ์ž ์ž…๋ ฅ: ");int num2 = sc.nextInt();sc.nextLine();์ด๋ ‡๊ฒŒ ..
[๊ณ„์‚ฐ๊ธฐ ๋งŒ๋“ค๊ธฐ-5] ๊ณ„์‚ฐ๊ธฐ ๊ณผ์ œ ํšŒ๊ณ 
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/๋ณธ์บ ํ”„ ๊ณผ์ œ
1๏ธโƒฃ ๊ฐœ์š”๐Ÿ“ ์‹œ์Šคํ…œ ํ™˜๊ฒฝ (๊ฐœ๋ฐœ ํ™˜๊ฒฝ: Java ๋ฒ„์ „, IDE, OS ๋“ฑ)Java: 17JDK: 17.0.1IDE: IntelliJ ๐Ÿ“ GitHub ๋งํฌ & Read ME https://github.com/222eunji/calculator 2๏ธโƒฃ ๊ณผ์ œ ์„ค๋ช…๐Ÿ“ ์š”๊ตฌ์‚ฌํ•ญ๋ชฉํ‘œ: ์ฝ˜์†”๋กœ ์ž…๋ ฅ๋ฐ›์€ ์ •์ˆ˜๋“ค๋กœ ๊ฐ€๋‹จํ•œ ์‚ฌ์น™์—ฐ์‚ฐ ์ฒ˜๋ฆฌํ•˜๊ธฐ โœ… Lv1. ํด๋ž˜์Šค๋ฅผ ์‚ฌ์šฉํ•˜์ง€ ์•Š๋Š” ๊ณ„์‚ฐ๊ธฐ1. ์ ˆ์ฐจ์  ํ”„๋กœ๊ทธ๋ž˜๋ฐ ํ•˜๊ธฐ2. Scanner๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์ •์ˆ˜์™€ ์‚ฌ์น™์—ฐ์‚ฐ ๊ธฐํ˜ธ ์ž…๋ ฅ ๋ฐ›๊ธฐ (์˜ˆ์™ธ์ฒ˜๋ฆฌ๋ฅผ ํ™œ์šฉํ•˜์—ฌ ์ž˜๋ชป๋œ ์ž…๋ ฅ ๋ฐฉ์ง€)3. exit๋ฅผ ์ž…๋ ฅํ•˜๋ฉด ํ”„๋กœ๊ทธ๋žจ ์ข…๋ฃŒ โœ… Lv2. ํด๋ž˜์Šค ํ™œ์šฉํ•˜๊ธฐ1. calculator ํด๋ž˜์Šค๋กœ ์‚ฌ์น™์—ฐ์‚ฐ์„ ๋ณ„๋„์˜ ํด๋ž˜์Šค์— ์ง„ํ–‰2. ์—ฐ์‚ฐ ๊ฒฐ๊ณผ ArrayList์— ์ €์žฅ3. removeResult()๋ฉ”์†Œ๋“œ๋ฅผ ..
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/MYSQL] 8. ์ƒ์œ„ n๊ฐœ ๋ ˆ์ฝ”๋“œ
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/SQL ์ฝ”๋“œ์นดํƒ€
โ‡๏ธ ๋ฌธ์ œ ์„ค๋ช…๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๊ฐ€์žฅ ๋จผ์ € ๋“ค์–ด์˜จ ๋™๋ฌผ์˜ ์ด๋ฆ„์„ ์กฐํšŒํ•˜๋Š” SQL ๋ฌธ์„ ์ž‘์„ฑhttps://school.programmers.co.kr/learn/courses/30/lessons/59405 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr โ‡๏ธ ์š”๊ตฌ์‚ฌํ•ญ1. ๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋“ค์–ด์˜จ ์ˆœ์„œ๋Œ€๋กœ ์ •๋ ฌ2. ๊ฐ€์žฅ ๋จผ์ € ๋“ค์–ด์˜จ ๋™๋ฌผ ํ•œ ๋งˆ๋ฆฌ๋งŒ ์ถœ๋ ฅ โ‡๏ธ ์ž‘์„ฑ์ฝ”๋“œSELECT NAMEFROM ANIMAL_INSORDER BY DATETIMElimit 1; โ‡๏ธ ์ฝ”๋“œ ํ’€์ด1. ๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋“ค์–ด์˜จ ์ˆœ์„œ๋Œ€๋กœ ์ •๋ ฌใ€€: ORDER BY DATETIME 2. ๊ฐ€์žฅ ๋จผ์ € ๋“ค์–ด์˜จ ๋™๋ฌผ ํ•œ ๋งˆ๋ฆฌ๋งŒ ์ถœ๋ ฅใ€€: limit 1; โ‡๏ธ..
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/JAVA] 8. ๊ฐ๋„๊ธฐ
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/์•Œ๊ณ ๋ฆฌ์ฆ˜ ์ฝ”๋“œ์นดํƒ€
โ‡๏ธ ๋ฌธ์ œ ์„ค๋ช…๊ฐ angle์ด ๋งค๊ฐœ๋ณ€์ˆ˜๋กœ ์ฃผ์–ด์งˆ ๋•Œ ์˜ˆ๊ฐ์ผ ๋•Œ 1, ์ง๊ฐ์ผ ๋•Œ 2, ๋‘”๊ฐ์ผ ๋•Œ 3, ํ‰๊ฐ์ผ ๋•Œ 4๋ฅผ returnํ•˜๋„๋ก solution ํ•จ์ˆ˜๋ฅผ ์™„์„ฑํ•ด์ฃผ์„ธ์š”.https://school.programmers.co.kr/learn/courses/30/lessons/120829 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr โ‡๏ธ ์š”๊ตฌ์‚ฌํ•ญ1. ์ž…๋ ฅ๋˜๋Š” ๊ฐ๋„์— ๋”ฐ๋ผ 1,2,3,4 ์ถœ๋ ฅํ•˜๊ธฐ โ‡๏ธ ์ž‘์„ฑ์ฝ”๋“œclass Solution { public int solution(int angle) { int answer = -1; if (0 โ‡๏ธ ์ฝ”๋“œ ํ’€์ด1. ์ž…๋ ฅ๋˜..
[ํ”„๋กœ๊ทธ๋ž˜๋จธ์Šค/MYSQL] 7. ์•„ํ”ˆ ๋™๋ฌผ ์ฐพ๊ธฐ
ยท
๋‚ด์ผ๋ฐฐ์›€์บ ํ”„/SQL ์ฝ”๋“œ์นดํƒ€
โ‡๏ธ ๋ฌธ์ œ ์„ค๋ช…๋™๋ฌผ ๋ณดํ˜ธ์†Œ์— ๋“ค์–ด์˜จ ๋™๋ฌผ ์ค‘ ์•„ํ”ˆ ๋™๋ฌผ์˜ ์•„์ด๋””์™€ ์ด๋ฆ„์„ ์กฐํšŒํ•˜๋Š” SQL ๋ฌธ์„ ์ž‘์„ฑํ•ด์ฃผ์„ธ์š”. ์ด๋•Œ ๊ฒฐ๊ณผ๋Š” ์•„์ด๋”” ์ˆœ์œผ๋กœ ์กฐํšŒํ•ด์ฃผ์„ธ์š”. (์•„ํ”ˆ ๋„๋ฌผ์€ INTAKE_CONDITION์ด Sick์ธ ๊ฒฝ์šฐ๋ฅผ ์˜๋ฏธ)https://school.programmers.co.kr/learn/courses/30/lessons/59036 ํ”„๋กœ๊ทธ๋ž˜๋จธ์ŠคSW๊ฐœ๋ฐœ์ž๋ฅผ ์œ„ํ•œ ํ‰๊ฐ€, ๊ต์œก, ์ฑ„์šฉ๊นŒ์ง€ Total Solution์„ ์ œ๊ณตํ•˜๋Š” ๊ฐœ๋ฐœ์ž ์„ฑ์žฅ์„ ์œ„ํ•œ ๋ฒ ์ด์Šค์บ ํ”„programmers.co.kr โ‡๏ธ ์š”๊ตฌ์‚ฌํ•ญ1. ์•„ํ”ˆ ๋™๋ฌผ ์กฐํšŒํ•˜๊ธฐ2. ์•„์ด๋”” ์ˆœ์œผ๋กœ ์กฐํšŒ โ‡๏ธ ์ž‘์„ฑ์ฝ”๋“œSELECT ANIMAL_ID, NAMEFROM ANIMAL_INSWHERE INTAKE_CONDITION = "Sick"ORDER BY 1 โ‡๏ธ ์ฝ”๋“œ ํ’€..