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

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

by Sun A 2024. 10. 13.

1๏ธโƒฃ [JAVA]

2021.2ํšŒ

์ด๊ฒƒ์€ ํด๋ž˜์Šค ๋‚ด์—์„œ ๊ฐ์ฒด ์ƒ์„ฑ ์—†์ด ์‚ฌ์šฉํ•  ์ˆ˜ ์žˆ๋Š” ๋ฉ”์†Œ๋“œ์ด๋‹ค. ๋‹ค์Œ์˜ ์ถœ๋ ฅ ๊ฒฐ๊ณผ๋ฅผ ๋ณด๊ณ  ๊ด„ํ˜ธ์•ˆ์— ์•Œ๋งž์€ ๋‹ต์•ˆ์„ ์ž‘์„ฑํ•˜์‹œ์˜ค.

public class Test {
   public static void main(String[] args){
      system.out.print(Test.check(1));
   }
   
   (  ๊ด„ํ˜ธ  )  String check (int num) {
      return (num >= 0) ? "positive" : "negative";
   }
}
[์ถœ๋ ฅ๊ฒฐ๊ณผ] positive
static

main ๋ฉ”์„œ๋“œ๋Š” ์ •์  ๋ฉ”์„œ๋“œ๋กœ ์„ ์–ธ๋œ๋‹ค.

main ๋ฉ”์„œ๋“œ ๋‚ด์˜ Test.check(1)๋ฅผ ํ˜ธ์ถœํ•˜๊ธฐ ์œ„ํ•ด์„œ๋Š” check ๋ฉ”์„œ๋“œ๋„ ์ •์ ์ด์–ด์•ผ๋งŒ ํ˜ธ์ถœํ•  ์ˆ˜ ์žˆ๋‹ค.

๊ทธ๋ ‡๊ธฐ ๋•Œ๋ฌธ์— check๋ฅผ static ์œผ๋กœ ์„ ์–ธํ•ด์•ผ ํ•œ๋‹ค.

๋งŒ์•ฝ ์ธ์Šคํ„ด์Šค ๋ฉ”์„œ๋“œ๋กœ ํ˜ธ์ถœํ•˜๋ ค๋ฉด ๊ฐ์ฒด๋ฅผ ์ƒ์„ฑํ•ด์•ผ ํ•œ๋‹ค.

Test obj = new Test();

obj.check(1)

 

2๏ธโƒฃ [SQL]

2024.1ํšŒ

์•„๋ž˜ ๋ณด๊ธฐ์˜ SQL ๋ฌธ์žฅ๊ณผ ํ…Œ์ด๋ธ”์„ ์ฐธ๊ณ ํ•˜์—ฌ ์ถœ๋ ฅ ๊ฐ’์„ ํ‘œ๋กœ ์ž‘์„ฑํ•˜์‹œ์˜ค.

SELECT
    B
FROM
    R1
WHERE
    C IN (SELECT C FROM R2 WHERE D="k");
B
a
b

R2์˜ C ์ค‘์—์„œ D๊ฐ€ "k" ๊ฐ’์ธ C๋งŒ R1์˜ B์—์„œ ์ถœ๋ ฅ

 

3๏ธโƒฃ [Python]

2022.2ํšŒ

๋‹ค์Œ์€ ํŒŒ์ด์ฌ ์ฝ”๋“œ์ด๋‹ค. ์•Œ๋งž๋Š” ์ถœ๋ ฅ๊ฐ’์„ ์ž‘์„ฑํ•˜์‹œ์˜ค.

a = "REMEMBER NOVEMBER"
b = a[:3] + a[12:16];
c = "R AND %s" % "STR";
print(b+c);
REMEMBER AND STR

a์—์„œ [:3]์„ ์ถ”์ถœํ•˜๋ฉด REM

a[12:16]์„ ์ถ”์ถœํ•˜๋ฉด EMBE

c๋Š” R AND STR

b์™€ c๋ฅผ ํ•ฉ์น˜๋ฉด REMEMBER AND STR ๊ฐ€ ์ถœ๋ ฅ๋จ