โœ๏ธ TIL

Wrraperํด๋ž˜์Šค: Auto Boxing Wrapper ํด๋ž˜์Šค: ๊ธฐ๋ณธ ๋ฐ์ดํ„ฐ ์œ ํ˜•์„ ๊ฐ์ฒด๋กœ ๋ž˜ํ•‘ํ•˜์—ฌ ๊ฐ์ฒด๋กœ ๋‹ค๋ฃฐ ์ˆ˜ ์žˆ๋„๋ก ํ•˜๋Š” ํด๋ž˜์Šค (Integer, Double, Boolean) โœ“ Auto Boxing: ๊ธฐ๋ณธ ๋ฐ์ดํ„ฐ ์œ ํ˜• ๊ฐ’์„ Wrapper ํด๋ž˜์Šค๋กœ ์ž๋™์œผ๋กœ ๋ณ€ํ™˜ํ•˜๋Š” ๊ฒƒ โœ“ Auto Unboxing: ๋ฐ˜๋Œ€๋กœ Wrapper ํด๋ž˜์Šค๋ฅผ ๊ธฐ๋ณธ ๋ฐ์ดํ„ฐ ์œ ํ˜•์œผ๋กœ ์ž๋™ ๋ณ€ํ™˜ํ•˜๋Š” ๊ฒƒ // Auto Boxing: int -> Integer int primitiveInt = 42; Integer wrapperInt = primitiveInt; // ๊ธฐ๋ณธ ๋ฐ์ดํ„ฐ ์œ ํ˜•์ด Wrapper ํด๋ž˜์Šค๋กœ ์ž๋™์œผ๋กœ ๋ณ€ํ™˜๋จ // Auto Unboxing: Integer -> int Integer wrapperInt2 = 99; i..
์ฝ”๋”ฉ ์—ฐ์Šต 4 public class WeatherAdviser { public String provideWeatherAdvisory(int temperature) { // TODO: Provide a weather advisory message based on the temperature. if (temperature = 0 && temperature = 11 && temperature 2>1>0 int sum=0; while(number>0){ sum+=number%10; number=number/10; } return sum; } } ์ฝ”๋”ฉ ์˜ˆ์ œ: ์ˆซ์ž ์—ญ์ˆœ์œผ๋กœ ๋งŒ๋“ค๊ธฐ..
์ฝ”๋”ฉ ์—ฐ์Šต 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..
Yuuuki
'โœ๏ธ TIL' ์นดํ…Œ๊ณ ๋ฆฌ์˜ ๊ธ€ ๋ชฉ๋ก (6 Page)