optional:<\/code>\uc744 \ubd99\uc785\ub2c8\ub2e4.<\/li>\n<\/ul>\n6-5. TimeappApplication.java<\/h3>\n
start.spring.io\uac00 \uc0dd\uc131\ud55c \ud30c\uc77c\uc744 \uadf8\ub300\ub85c \uc0ac\uc6a9\ud569\ub2c8\ub2e4.<\/p>\n
package com.example.timeapp;\n\nimport org.springframework.boot.SpringApplication;\nimport org.springframework.boot.autoconfigure.SpringBootApplication;\n\n@SpringBootApplication\npublic class TimeappApplication {\n\n public static void main(String[] args) {\n SpringApplication.run(TimeappApplication.class, args);\n }\n}<\/code><\/pre>\n6-6. TimeController.java<\/h3>\n
DB\uc5d0\uc11c \ud604\uc7ac \uc2dc\uac04\uc744 \uc870\ud68c\ud574 HTML\ub85c \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n
package com.example.timeapp;\n\nimport java.util.Map;\n\nimport org.springframework.http.MediaType;\nimport org.springframework.jdbc.core.JdbcTemplate;\nimport org.springframework.web.bind.annotation.GetMapping;\nimport org.springframework.web.bind.annotation.RestController;\n\n@RestController\npublic class TimeController {\n\n private final JdbcTemplate jdbcTemplate;\n\n public TimeController(JdbcTemplate jdbcTemplate) {\n this.jdbcTemplate = jdbcTemplate;\n }\n\n @GetMapping(value = "\/", produces = MediaType.TEXT_HTML_VALUE)\n public String now() {\n Map<String, Object> row = jdbcTemplate.queryForMap("""\n SELECT\n to_char(now() AT TIME ZONE 'Asia\/Seoul', 'YYYY-MM-DD HH24:MI:SS') AS seoul_time,\n to_char(now() AT TIME ZONE 'UTC', 'YYYY-MM-DD HH24:MI:SS') AS utc_time,\n version() AS db_version\n """);\n\n return """\n <!doctype html>\n <html lang="ko">\n <head>\n <meta charset="utf-8">\n <title>DB \ud604\uc7ac \uc2dc\uac04<\/title>\n <style>\n body { font-family: sans-serif; max-width: 640px; margin: 60px auto; padding: 0 16px; }\n .time { font-size: 2rem; font-weight: bold; margin: 8px 0 24px; }\n .muted { color: #666; font-size: 0.9rem; }\n <\/style>\n <\/head>\n <body>\n <h1>PostgreSQL \ud604\uc7ac \uc2dc\uac04<\/h1>\n <p>\uc11c\uc6b8 (KST)<\/p>\n <div class="time">%s<\/div>\n <p>UTC<\/p>\n <div class="time">%s<\/div>\n <p class="muted">%s<\/p>\n <p class="muted">\uc811\uc18d\uc815\ubcf4 \ucd9c\ucc98: AWS SSM Parameter Store<\/p>\n <\/body>\n <\/html>\n """.formatted(row.get("seoul_time"), row.get("utc_time"), row.get("db_version"));\n }\n}<\/code><\/pre>\n\nEC2\uc758 \uae30\ubcf8 \uc2dc\uac04\ub300\ub294 UTC\uc774\ubbc0\ub85c, PostgreSQL\uc758 now()<\/code>\ub3c4 \uae30\ubcf8\uc801\uc73c\ub85c UTC \uae30\uc900\uc73c\ub85c \ud45c\uc2dc\ub429\ub2c8\ub2e4. \uc5ec\uae30\uc11c\ub294 AT TIME ZONE<\/code>\uc73c\ub85c \uc11c\uc6b8 \uc2dc\uac04\uacfc UTC\ub97c \ud568\uaed8 \ubcf4\uc5ec\uc90d\ub2c8\ub2e4.<\/p>\n<\/blockquote>\n
\n7. \ube4c\ub4dc, \ubc30\ud3ec, \uc2e4\ud589<\/h2>\n7-1. \ub85c\uceec\uc5d0\uc11c \ube4c\ub4dc<\/h3>\n.\/gradlew clean bootJar<\/code><\/pre>\nbuild\/libs\/timeapp-0.0.1-SNAPSHOT.jar<\/code> \ud30c\uc77c\uc774 \uc0dd\uc131\ub429\ub2c8\ub2e4.<\/p>\n\n\ub85c\uceec PC\uc5d0\ub294 IAM Role\uc774 \uc5c6\uc73c\ubbc0\ub85c, \uc774 \uc0c1\ud0dc\ub85c \ub85c\uceec\uc5d0\uc11c \uc2e4\ud589\ud558\uba74 Parameter Store\ub97c \uc77d\uc9c0 \ubabb\ud574 \uc2dc\uc791\uc5d0 \uc2e4\ud328\ud569\ub2c8\ub2e4. \ub85c\uceec \uc2e4\ud589\uc6a9 \uc124\uc815\uc740 10. \uc815\ub9ac \ubc0f \ub2e4\uc74c \ub2e8\uacc4<\/a>\ub97c \ucc38\uace0\ud558\uc138\uc694.<\/p>\n<\/blockquote>\n