๋ณธ๋ฌธ ๋ฐ”๋กœ๊ฐ€๊ธฐ
๐Ÿ“Certificate/Engineer Information Processing

[์ •๋ณด์ฒ˜๋ฆฌ๊ธฐ์‚ฌ] ์‹ค๊ธฐ ํ”„๋กœ๊ทธ๋ž˜๋ฐ์–ธ์–ด 3๋ฌธ์ œ (15)

by Sun A 2024. 10. 1.

1๏ธโƒฃ [JAVA]

2023.2

๋‹ค์Œ์€ JAVA ์ฝ”๋“œ ๋ฌธ์ œ์ด๋‹ค. ๊ฐ€์ง€๊ณ  ์žˆ๋Š” ๋ˆ์ด ์ด 4620์›์ผ ๊ฒฝ์šฐ 1000์›, 500์›, 100์›, 10์›์˜ ์ง€ํ ๋ฐ ๋™์ „์„ ์ด์šฉํ•˜์—ฌ ๋ณด๊ธฐ์˜ ์กฐ๊ฑด์— ๋งž์ถฐ "์ตœ์†Œํ•œ์˜ ์ฝ”๋“œ"๋ฅผ ์ž‘์„ฑํ•ด ๋นˆ ๊ด„ํ˜ธ ์•ˆ์„ ์ฑ„์šฐ์‹œ์˜ค.

public class Problem {
	public static void main(String[] args) {
    	int m = 4620;
        
        int a = (           );
        int b = (           );
        int c = (           );
        int d = (           );
        
        System.out.printIn(a); //์ฒœ์›์งœ๋ฆฌ 4์žฅ ์ถœ๋ ฅ
        System.out.printIn(b); //์˜ค๋ฐฑ์›์งœ๋ฆฌ 1๊ฐœ ์ถœ๋ ฅ
        System.out.printIn(c); //๋ฐฑ์›์งœ๋ฆฌ 1๊ฐœ ์ถœ๋ ฅ
        System.out.printIn(d); //์‹ญ์›์งœ๋ฆฌ 2๊ฐœ ์ถœ๋ ฅ
    }
}

 

[๋ณด๊ธฐ]
์•„๋ž˜ ์ฃผ์–ด์ง„ ํ•ญ๋ชฉ๋“ค์„ ์‘์šฉํ•˜์—ฌ ๊ด„ํ˜ธ ์•ˆ ์ฝ”๋“œ๋ฅผ ์ž‘์„ฑ.
๋ณ€์ˆ˜ : m
์—ฐ์‚ฐ์ž : / , %
๊ด„ํ˜ธ : [ , ] , ( , )
์ •์ˆ˜ : 1000, 500, 100, 10
a = m / 1000
b = ( m % 1000 ) / 500
c = ( m % 500 ) / 100
d = ( m % 100 ) / 10

 

2๏ธโƒฃ [SQL]

2023.1ํšŒ

[ํ•™์ƒ] ํ…Œ์ด๋ธ”์—์„œ ํ•™์ƒ ์ด๋ฆ„์ด '๋ฏผ์ˆ˜'์ธ ํŠœํ”Œ์„ ์‚ญ์ œํ•˜๋Š” ์ฟผ๋ฆฌ๋ฅผ ์ž‘์„ฑํ•˜์‹œ์˜ค.

์กฐ๊ฑด
- ์ปฌ๋Ÿผ์˜ ๊ฐ’์ด ๋ฌธ์ž์—ด์ผ ๊ฒฝ์šฐ ์ž‘์€ ๋”ฐ์˜ดํ‘œ (' ')๋ฅผ ํ‘œ์‹œํ•˜์‹œ์˜ค.
- SQL ๋งˆ์ง€๋ง‰์— ์„ธ๋ฏธ์ฝœ๋ก (;)์€ ํ‘œ๊ธฐํ•˜์ง€ ์•Š์•„๋„ ๊ด€๊ณ„ ์—†์Šต๋‹ˆ๋‹ค.
DELETE
FROM ํ•™์ƒ
WHERE ์ด๋ฆ„ = '๋ฏผ์ˆ˜';

 

3๏ธโƒฃ [JAVA]

2024.2ํšŒ

๋‹ค์Œ Java๋กœ ๊ตฌํ˜„๋œ ํ”„๋กœ๊ทธ๋žจ์„ ๋ถ„์„ํ•˜์—ฌ ๊ทธ ์‹คํ–‰ ๊ฒฐ๊ณผ๋ฅผ ์“ฐ์‹œ์˜ค.

public class Main {
	public static void check(int[] x, int[] y) {
		if(x==y) System.out.print("O");
		else System.out.print("N");
	}
	public static void main(String[] args) {
		int a[] = new int[] {1, 2, 3, 4};
		int b[] = new int[] {1, 2, 3, 4};
		int c[] = new int[] {1, 2, 3};
		check(a, b);
		check(b, c);
		check(a, c);
	}
}
NNN

a ๋ฐฐ์—ด์— {1, 2, 3 ,4}

b ๋ฐฐ์—ด์— {1, 2, 3, 4}

c ๋ฐฐ์—ด์— {1, 2, 3}

์„ ๋„ฃ๊ณ  check ํ•จ์ˆ˜๋ฅผ ์‚ฌ์šฉํ•œ๋‹ค.

๋ฐฐ์—ด์€ ๋ฉ”๋ชจ๋ฆฌ์— ๋…๋ฆฝ์ ์œผ๋กœ ์ €์žฅ๋œ๋‹ค.

a, b, c๋Š” ๊ฐ์ž new int[]๋กœ ์ƒˆ ๋ฐฐ์—ด์„ ์ƒ์„ฑํ–ˆ๋‹ค.

๊ทธ๋ ‡๋‹ค๋ฉด ์ด a, b, c๋Š” ๊ฐ์ž ๋‹ค๋ฅธ ๋ฉ”๋ชจ๋ฆฌ ์˜์—ญ์— ํ• ๋‹น์ด ๋œ ์ƒํƒœ์ด๋‹ค.

=> a, b, c๋Š” ๋…๋ฆฝ์ ์ธ ๋ฉ”๋ชจ๋ฆฌ ๊ณต๊ฐ„์„ ๊ฐ–๋Š”๋‹ค.

์ด ์ƒํƒœ์—์„œ ckeck(a, b)์˜ ๊ฐ’์„ ํ™•์ธํ–ˆ์„ ๋•Œ, if(x==y)์—์„œ x์—๋Š” x, y์—๋Š” y๊ฐ€ ๋“ค์–ด๊ฐ€์žˆ๋Š”๋ฐ ==์—์„œ ์˜๋ฏธํ•˜๋Š” ๊ฒƒ์€ ๊ฐ™์€ ๊ณต๊ฐ„์—์„œ ํ• ๋‹น๋œ ๋ฐฐ์—ด์ธ์ง€๋ฅผ ํ™•์ธํ•˜๋Š” ์กฐ๊ฑด๋ฌธ์ด๋‹ค.

ํ•˜์ง€๋งŒ a์™€ b๋Š” ๊ฐ์ž ์ƒˆ๋กœ์šด new int๋กœ ์ƒˆ๋กœ์šด ๊ณต๊ฐ„์„ ํ• ๋‹น๋ฐ›์•˜๊ธฐ ๋•Œ๋ฌธ์— ๊ฐ™์ง€ ์•Š์œผ๋ฏ€๋กœ N์ด ์ถœ๋ ฅ๋œ๋‹ค.