jdbc환경설정(mysql)이란?

jdbc환경설정(mysql)이란?

JDBC 실행

실행전 환경설정(드라이버설치,라이브러리설치,Bean설정)

pom.xml(mysql과Spring-jdbc추가)

<!-- MySQL database driver --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>5.1.9</version> </dependency> <!-- https://mvnrepository.com/artifact/org.springframework/spring-jdbc --> <dependency> <groupId>org.springframework</groupId> <artifactId>spring-jdbc</artifactId> <version>4.3.12.RELEASE</version> </dependency> </beans>

프로퍼티파일에 추가하기.

db.driverClass=com.mysql.jdbc.Driver db.url=jdbc:mysql://주소명:포트명/db명?characterEncoding=UTF-8 db.uesrname=아이디 db.password=비밀번호

bean.xml에 추가하기.

<!-- componnent scan설정 (패키지)--> <context:component-scan base-package="myspring.user" /> <!-- dataSource등록 --> <bean id="dataSource" class="org.springframework.jdbc.datasource.SimpleDriverDataSource"> <property name="driverClass" value="${db.driverClass}" /> <property name="url" value="${db.url}" /> <property name="username" value="${db.uesrname}" /> <property name="password" value="${db.password}" /> </bean>

Test 클래스 코드작성.

@RunWith(SpringJUnit4ClassRunner.class) @ContextConfiguration(locations="classpath:config/beans.xml") public class HelloUserClient { @Autowired ApplicationContext context; @Test public void dataSourceTest() { DataSource ds = (DataSource) context.getBean("dataSource"); try { System.out.println(ds.getConnection()); } catch (SQLException e) { e.printStackTrace(); } } }

연결된것 확인방법.

콘솔로그에 com.mysql.jdbc.JDBC4Connection@31368b99 출력되는 것 확인한다.