강의

멘토링

커뮤니티

인프런 커뮤니티 질문&답변

아틀00님의 프로필 이미지
아틀00

작성한 질문수

스프링 입문 - 코드로 배우는 스프링 부트, 웹 MVC, DB 접근 기술

순수 JDBC

db연결이 되지 않습니다

작성

·

229

0

이클립스 자바 8버전, 메이븐으로 따라하고 있습니다.

jdbcmemberrepository는 그대로 복붙하였습니다

springConfig도 내용 동일하나.. 안되어서 복붙해봤지만 여전히 안됩니다 ㅠㅠ

자꾸 새로운 객체에 생성되어서 객체에 저장되네요

<?xml version="1.0" encoding="UTF-8"?>

<project xmlns="http://maven.apache.org/POM/4.0.0"

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"

xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">

<modelVersion>4.0.0</modelVersion>

<parent>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-parent</artifactId>

<version>2.5.4</version>

<relativePath /> <!-- lookup parent from repository -->

</parent>

<groupId>hello</groupId>

<artifactId>hello-spring</artifactId>

<version>0.0.1-SNAPSHOT</version>

<name>hello-spring</name>

<description>Demo project for Spring Boot</description>

<properties>

<java.version>1.8</java.version>

</properties>

<dependencies>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-thymeleaf</artifactId>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-web</artifactId>

</dependency>

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-test</artifactId>

<scope>test</scope>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-jdbc</artifactId>

<version>5.3.9</version>

</dependency>

<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jdbc -->

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-jdbc</artifactId>

<version>2.5.4</version>

<scope>runtime</scope>

</dependency>

<!-- https://mvnrepository.com/artifact/com.h2database/h2 -->

<dependency>

<groupId>com.h2database</groupId>

<artifactId>h2</artifactId>

<version>1.4.200</version>

<scope>runtime</scope>

</dependency>

<!-- https://mvnrepository.com/artifact/org.springframework/org.springframework.jdbc -->

<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-test -->

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-test</artifactId>

<version>2.5.4</version>

<scope>test</scope>

</dependency>

</dependencies>

<build>

<plugins>

<plugin>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-maven-plugin</artifactId>

</plugin>

</plugins>

</build>

</project>

ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ

spring.datasource.url=jdbc:h2:tcp://localhost/~/test

spring.datasource.username=sa

spring.datasource.driverClassName=org.h2.Driver

ㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡㅡ

import hello.hellospring.repository.JdbcMemberRepository;

//import hello.hellospring.repository.JdbcTemplateMemberRepository;

import hello.hellospring.repository.MemberRepository;

import hello.hellospring.repository.MEmoryMemberRepository;

import hello.hellospring.service.MemberService;

import org.springframework.context.annotation.Bean;

import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

@Configuration

public class sprinfConfig {

private final DataSource dataSource;

public sprinfConfig(DataSource dataSource) {

this.dataSource = dataSource;

}

@Bean

public MemberService memberService() {

return new MemberService(memberRepository());

}

@Bean

public MemberRepository memberRepository() {

// return new MemoryMemberRepository();

return new JdbcMemberRepository(dataSource);

}

}

답변 1

0

안녕하세요. 아틀00님, 공식 서포터즈 OMG입니다.

// 아래는 <dependency> </dependency>는 삭제

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-jdbc</artifactId>

<version>5.3.9</version>

</dependency>

<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-jdbc -->

 

// 아래는  <version>2.5.4</version>, <scope>runtime</scope>삭제

<dependency>

<groupId>org.springframework.boot</groupId>

<artifactId>spring-boot-starter-jdbc</artifactId>

<version>2.5.4</version>

<scope>runtime</scope>

</dependency>

 

+ 반드시 reload 하셔야 합니다.

안 될 경우 에러메시지와 문제 상황에 대해 파악할 수 있도록 관련 정보를 상세하게 알려주시면 도움드리겠습니다.

감사합니다.

아틀00님의 프로필 이미지
아틀00

작성한 질문수

질문하기