๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ

์ฝ”๋”ฉ ์—ฐ์Šต 2 ์ฝ”๋”ฉ ์˜ˆ์ œ: ์ธ์น˜๋ฅผ ๊ฐ์ฒด๋กœ(ํ”ผํŠธ, ์ธ์น˜) public class Dimension { private int feet; private int inches; public Dimension(int inches) { if (inches < 0) { this.feet = -1; this.inches = -1; } else { this.feet = inches / 12; this.inches = inches % 12; } // TODO: Convert the total inches into feet and inches. One foot is 12 inches. // Store the feet and inches in their respective instance variables. } public i..
์ €๋ฒˆ์‹œ๊ฐ„๊นŒ์ง„ , Jshll์„ ์ด์šฉํ•˜์˜€์ง€๋งŒ ์˜ค๋Š˜๋ถ€ํ„ฐ ์ดํด๋ฆฝ์Šค๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ๋ณธ๊ฒฉ์ ์œผ๋กœ ์ž๋ฐ”์˜ ๊ฐ์ฒด์ง€ํ–ฅ ๊ฐœ๋… ๊ณต๋ถ€๋ฅผ ์‹œ์ž‘ํ•˜์˜€๋‹ค. Class //Main(Runner)ํ•จ์ˆ˜ package com.firstjavaproject; public class MulitplicationRunner { public static void main(String[] args) { // TODO Auto-generated method stub Multiplication table=new Multiplication(); //table.print(); table.print(6); table.print(6,11,20); } } package com.firstjavaproject; public class Multiplication { voi..
for๋ฌธ ๋ฐ˜๋ณต๋ฌธ ์ค‘ ํ•˜๋‚˜๋กœ, ํŠน์ • ์กฐ๊ฑด์ด ์ฐธ์ธ ๋™์•ˆ ์ผ๋ จ์˜ ์ฝ”๋“œ ๋ธ”๋ก์„ ๋ฐ˜๋ณต ์‹คํ–‰ํ•ฉ๋‹ˆ๋‹ค. for (์ดˆ๊ธฐํ™”์‹; ์กฐ๊ฑด์‹; ์ฆ๊ฐ์‹) { // ๋ฐ˜๋ณต ์‹คํ–‰๋  ์ฝ”๋“œ } for(i=1;i
์˜ค๋Š˜๋ถ€ํ„ฐ ๋“œ๋””์–ด javaํ•™์Šต์„ ์‹œ์ž‘ํ•˜์˜€๋‹ค. ๋ณ€์ˆ˜ Type ๊ธฐ๋ณธ ๋ฐ์ดํ„ฐ ํƒ€์ž… (Primitive Data Types): ์ •์ˆ˜ ํƒ€์ž…: byte: 8๋น„ํŠธ ๋ถ€ํ˜ธ ์žˆ๋Š” ์ •์ˆ˜ (-128 ~ 127) short: 16๋น„ํŠธ ๋ถ€ํ˜ธ ์žˆ๋Š” ์ •์ˆ˜ (-32,768 ~ 32,767) int: 32๋น„ํŠธ ๋ถ€ํ˜ธ ์žˆ๋Š” ์ •์ˆ˜ (-2^31 ~ 2^31-1) long: 64๋น„ํŠธ ๋ถ€ํ˜ธ ์žˆ๋Š” ์ •์ˆ˜ (-2^63 ~ 2^63-1) ๋ถ€๋™ ์†Œ์ˆ˜์  ํƒ€์ž…: float: 32๋น„ํŠธ ๋ถ€๋™ ์†Œ์ˆ˜์  (๋‹จ์ •๋ฐ€๋„) double: 64๋น„ํŠธ ๋ถ€๋™ ์†Œ์ˆ˜์  (๋ฐฐ์ •๋ฐ€๋„) ๋ฌธ์ž ํƒ€์ž…: char: 16๋น„ํŠธ ์œ ๋‹ˆ์ฝ”๋“œ ๋ฌธ์ž ๋…ผ๋ฆฌ ํƒ€์ž…: boolean: ๋…ผ๋ฆฌ ๊ฐ’ (true ๋˜๋Š” false) ์ฐธ์กฐ ๋ฐ์ดํ„ฐ ํƒ€์ž… (Reference Data Types): ํด๋ž˜์Šค ํƒ€์ž…: ์‚ฌ์šฉ์ž๊ฐ€ ์ •์˜ํ•œ ํด๋ž˜..
์ œ์•ฝ ์กฐ๊ฑด PRIMARY KEY (๊ธฐ๋ณธ ํ‚ค): PRIMARY KEY๋Š” ํ…Œ์ด๋ธ”์˜ ๊ฐ ๋ ˆ์ฝ”๋“œ๋ฅผ ๊ณ ์œ ํ•˜๊ฒŒ ์‹๋ณ„ํ•˜๋Š” ๋ฐ ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค. ๊ฐ ํ…Œ์ด๋ธ”์€ ํ•˜๋‚˜์˜ PRIMARY KEY๋ฅผ ๊ฐ€์งˆ ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค. PRIMARY KEY๋Š” NULL ๊ฐ’์„ ๊ฐ€์งˆ ์ˆ˜ ์—†์Šต๋‹ˆ๋‹ค. CREATE TABLE Users ( UserID INT PRIMARY KEY, UserName VARCHAR(50), Email VARCHAR(50) ); ์‚ฌ์šฉ์ž ํ…Œ์ด๋ธ”์—์„œ ์‚ฌ์šฉ์ž ID๋ฅผ PRIMARY KEY๋กœ ์ง€์ •ํ•˜๋ฉด ๊ฐ ์‚ฌ์šฉ์ž์˜ ID๊ฐ€ ๊ณ ์œ ํ•˜๊ฒŒ ์‹๋ณ„๋ฉ๋‹ˆ๋‹ค. FOREIGN KEY (์™ธ๋ž˜ ํ‚ค): FOREIGN KEY๋Š” ๋‹ค๋ฅธ ํ…Œ์ด๋ธ”์˜ PRIMARY KEY์™€ ์—ฐ๊ฒฐ๋˜๋Š” ํ•„๋“œ๋กœ, ๋‘ ํ…Œ์ด๋ธ” ๊ฐ„์˜ ๊ด€๊ณ„๋ฅผ ์„ค์ •ํ•˜๋ฉฐ, ๋ณดํ†ต์€ ๋‘ ๊ฐœ์˜ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค ํ…Œ์ด๋ธ”์„ ์ž‡๊ณ ์ž ๊ธฐ๋ณธ ํ‚ค์™€ ..
SQL 2์ผ์ฐจ ์˜ค๋Š˜์€ ๋‹จ์ผ ๋ฐ์ดํ„ฐ๊ฐ€ ์•„๋‹Œ ์™ธ๋ถ€๋ฐ์ดํ„ฐ์™€ JOIN, ์ˆ˜๋ฆฌ์—ฐ์‚ฐ,๋ฌธ์ž์—ด ํ•จ์ˆ˜, sub query ๋“ฑ์„ ํ•™์Šตํ•˜์˜€๋‹ค. INNER JOIN ๋‘ ํ…Œ์ด๋ธ”์„ ์กฐ์ธํ•  ๋•Œ, ๋‘ ํ…Œ์ด๋ธ”์— ๋ชจ๋‘ ์ง€์ •ํ•œ ์—ด์˜ ๋ฐ์ดํ„ฐ๊ฐ€ ์žˆ์–ด์•ผ ํ•œ๋‹ค. โ—๏ธ๋‘ ํ…Œ์ด๋ธ” ๋ชจ๋‘ ์กด์žฌํ•˜๊ธฐ ๋•Œ๋ฌธ์—, ์ˆœ์„œ ์ƒ๊ด€์—†์ด ๋™์ผํ•œ ๊ฒฐ๊ณผ๊ฐ€ ์ถœ๋ ฅ๋œ๋‹ค. SELECT * FROM Registrations //1๋ฒˆ์งธ ํ…Œ์ด๋ธ” INNER JOIN Logins //2๋ฒˆ์งธ ํ…Œ์ด๋ธ” ON Registrations.name=Logins.name //์กฐ์ธ์กฐ๊ฑด OUTER JOIN ๋‘ ํ…Œ์ด๋ธ”์„ ์กฐ์ธํ•  ๋•Œ, 1๊ฐœ์˜ ํ…Œ์ด๋ธ”์—๋งŒ ๋ฐ์ดํ„ฐ๊ฐ€ ์žˆ์–ด๋„ ๊ฒฐ๊ณผ๊ฐ€ ๋‚˜์˜จ๋‹ค. FULL OUTER JOIN : ์™ผ์ชฝ ๋˜๋Š” ์˜ค๋ฅธ์ชฝ ํ…Œ์ด๋ธ”์˜ ๋ชจ๋“  ๊ฐ’์ด ์ถœ๋ ฅ๋˜๋Š” ์กฐ์ธ  SELECT * FROM instruct..
์˜ค๋Š˜๋ถ€ํ„ฐ 3์ผ๊ฐ„ SQL ์ˆ˜์—… ์‹œ์ž‘! SELECT : SELECT ๋ฌธ์€ ๋ฐ์ดํ„ฐ๋ฒ ์ด์Šค์—์„œ ํŠน์ • ์—ด์˜ ๊ฐ’์„ ๊ฒ€์ƒ‰ํ•˜๋Š” ๋ฐ ์‚ฌ์šฉํ•˜๋ฉฐ, ๊ธฐ๋ณธ์ ์œผ๋กœ ๋ชจ๋“  ํ–‰์„ ์„ ํƒํ•˜๊ณ  ํŠน์ • ์—ด์˜ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. SELECT column1, column2 FROM table_name; SELECT DESTINCT : ์ค‘๋ณต๋œ ๊ฐ’์„ ์ œ์™ธํ•˜๊ณ  ๊ณ ์œ ํ•œ ๊ฐ’์„ ๋ฐ˜ํ™˜ํ•˜์—ฌ, ์ค‘๋ณต๋œ ํ–‰์ด ์žˆ์„ ๋•Œ, ์ค‘๋ณต๋œ ๊ฐ’์„ ํ•˜๋‚˜๋งŒ ๋ฐ˜ํ™˜ํ•ฉ๋‹ˆ๋‹ค. SELECT DISTINCT column1 FROM table_name; COUNT : ํŠน์ • ์ฟผ๋ฆฌ ์กฐ๊ฑด์— ๋งž๋Š” ์ž…๋ ฅ ํ–‰์˜ ์ˆ˜๋ฅผ ๋ฐ˜ํ™˜ํ•œ๋‹ค. (table์˜ ํŠน์„ฑ ์ƒ ์•„๋ฌดrow๋‚˜ ์ž…๋ ฅํ•ด๋„ ๊ฐ’์€ ๋™์ผํ•˜๋‹ค) SELECT COUNT (DISTINCT name) โ—๏ธํŠน์ • ๋Œ€์ƒ์— ์ž‘์šฉํ•˜๋Š” ํ•จ์ˆ˜์ด๊ธฐ ๋•Œ๋ฌธ์—, ๊ด„ํ˜ธ๋Š” ํ•„์ˆ˜์ด๋‹ค! WHERE ..
์ด์–ด์ œ์— ์ด์–ด์„œ ๋ฆฌ์•กํŠธ ํ•™์Šต์„ ํ•˜์˜€๋‹ค! ๋‹จ๊ธฐํŠน๊ฐ• ์ฝ”์Šค๋กœ ๋“ฃ๋‹ค๋ณด๋‹ˆ, ํ•™์Šต์˜ ์–‘์ด ์ข€ ๋งŽ์•˜๋‹ค! ์กฐ๊ฑด๋ถ€ ๋ Œ๋”๋ง ๋‹ค์–‘ํ•œ ๋ฐฉ์‹์œผ๋กœ ์กฐ๊ฑด์— ๋”ฐ๋ผ ์ปดํฌ๋„ŒํŠธ ๋ Œ๋”๋ง์„ ํ•  ์ˆ˜ ์žˆ๋Š”๋ฐ, ์ง€๊ธˆ๊ณผ ๊ฐ™์ด true ๊ฒฝ์šฐ์—๋งŒ ๋ Œ๋”๋งํ• ๋•, &&์—ฐ์‚ฐ์ž๋ฅผ ์‚ฌ์šฉํ•˜๋Š” ๊ฒƒ์ด ์ข‹๋‹ค! 3ํ•ญ ์—ฐ์‚ฐ์ž {ModalIsVisible ? ( ) : null} false์ผ๋• null &&์—ฐ์‚ฐ์ž {ModalIsVisible && ( )} ๋ณ€์ˆ˜ ์‚ฌ์šฉ let modalContent; if (ModalIsVisible) { modalContent = ( ); } return ( {modalContent} ); } ๋ณ€์ˆ˜๋ฅผ ์‚ฌ์šฉํ•ด์„œ ๊ด€๋ฆฌํ• ๋•Œ, ์ข€ ๋” ํšจ์œจ์ ์ธ ๊ฒฝ์šฐ๊ฐ€ ์žˆ์ง€๋งŒ ์ง€๊ธˆ๊ณผ ๊ฐ™์ด ๋‹จ์ˆœํ•œ ๊ฒฝ์šฐ์—๋Š” ์ง€์–‘ํ•˜๋Š” ๊ฒƒ์ด ์ข‹๋‹ค. useState์˜ ์ƒํƒœ ์—…๋ฐ์ดํŠธ ํ•จ์ˆ˜ con..
Yuuuki
'๋ถ„๋ฅ˜ ์ „์ฒด๋ณด๊ธฐ' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๊ธ€ ๋ชฉ๋ก (15 Page)