Controller에서 간단하게 DB 테스트 하기: jdbcTemplate.queryForObject

의존성 추가

implementation 'org.springframework.boot:spring-boot-starter-data-jpa'
implementation 'org.springframework.boot:spring-boot-starter-jdbc'
implementation 'org.postgresql:postgresql:42.2.18'

 

 

 

 

db연결정보 기입(~에 알맞게 입력)

spring.datasource.url=jdbc:postgresql://localhost:5432/~
spring.datasource.username=~
spring.datasource.password=~

 

 

 

jdbc template으로 select 1 실행

package com.standout.scard.main;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.ResponseBody;

@Controller
public class MainController {

	 @Autowired
	 private JdbcTemplate jdbcTemplate;
	 
	@GetMapping("/")
	public String home() {
		return "home";
	}
	
	 @GetMapping("/test-db")
	    @ResponseBody
	    public String testDatabaseConnection() {
	        try {
	            // 간단한 쿼리 실행으로 연결 테스트
	            Integer result = jdbcTemplate.queryForObject("SELECT 1", Integer.class);
	            return "Database connection test result: " + result;
	        } catch (Exception e) {
	            return "Database connection test failed: " + e.getMessage();
	        }
	    }

}

 

 

완료