[spring][myBatis][RDS][mariaDB] 프로젝트 초기 세팅

개발 환경

Backend java

Frontend	react.js, javascript, html, css
DB	mariaDB, AWS RDS
Framework	spring
Tool	eclipse, figma‣
API	mybatis, jpa

AWS RDS: mariaDB

• 보안 그룹

보안 그룹 클릭후→인바운드 규칙 클릭

인바운드 규칙 편집 클릭

내 ip를 추가해야 jdbc로 db에 접속할 수 있다.

spring 설정

• pom.xml

jdbc 라이브러리

		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>

myBatis 두개 모두 설치 해줘야 한다.

<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.2</version>
		</dependency>
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.6</version>
		</dependency>

mariaDB 드라이버 설치

<!-- mariaDB -->
		<dependency>
			<groupId>org.mariadb.jdbc</groupId>
			<artifactId>mariadb-java-client</artifactId>
			<version>2.3.0</version>
		</dependency>
	</dependencies>

• eclipse marketplace

mybaipse와 mybatis generator 두개를 설치해준다.

• root-context.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	 xmlns:aop="http://www.springframework.org/schema/aop"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:jdbc="http://www.springframework.org/schema/jdbc"
    xmlns:mybatis-spring="http://mybatis.org/schema/mybatis-spring"
	xsi:schemaLocation="http://www.springframework.org/schema/beans https://www.springframework.org/schema/beans/spring-beans.xsd
	http://www.springframework.org/schema/jdbc http://www.springframework.org/schema/jdbc/spring-jdbc-4.1.xsd
        http://mybatis.org/schema/mybatis-spring http://mybatis.org/schema/mybatis-spring-1.2.xsd
        http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.1.xsd
        http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-4.1.xsd">
	
	<!-- Root Context: defines shared resources visible to all other web components -->
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
    <property name="driverClassName" value="org.mariadb.jdbc.Driver"/>
    <property name="url" value="jdbc:mariadb://RDS엔드포인트"/>
    <property name="username" value="id"/>
    <property name="password" value="pw"/>
</bean>
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">		
	<property name="dataSource" ref="dataSource" />		
	<property name="mapperLocations" value="classpath:/mapper/*" /><!--mapper파일의 위치 지정-->
</bean>		
<bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>

</beans>