spring mariadb 연동방법 (xml방식)

1.spring 프로젝트 생성후

 

mariadb연동에 필요한 라이브러리들을 porm.xml에 기입

<!-- mybatis -->
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis</artifactId>
			<version>3.4.6</version>
		</dependency>
	
		<dependency>
			<groupId>org.mybatis</groupId>
			<artifactId>mybatis-spring</artifactId>
			<version>1.3.2</version>
		</dependency>
	
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-jdbc</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
		
		<dependency>
			<groupId>org.springframework</groupId>
			<artifactId>spring-test</artifactId>
			<version>${org.springframework-version}</version>
		</dependency>
	
		<dependency>
		    <groupId>org.apache.commons</groupId>
		    <artifactId>commons-dbcp2</artifactId>
		    <version>2.6.0</version>
		</dependency>
	
		<!-- mariaDB -->
		<dependency>
			<groupId>org.mariadb.jdbc</groupId>
			<artifactId>mariadb-java-client</artifactId>
			<version>2.3.0</version>
		</dependency>

 

2.root- context.xml namespace 수정

 

 

 

3.root-context db관련 정보  기입

<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
		<property name="driverClassName" value="org.mariadb.jdbc.Driver" />
		<property name="url" value="" />
		<property name="username" value="" />
		<property name="password" value="" />
	</bean>
    
	<!-- mybatis SqlSessionFactoryBean -->
	<!-- sqlsession객체를 생성하는 존재 , 개발에서 sqlsession을 통해서 connection을 생성,데이터 베이스 접속 정보와 mapper파일을 관리하는 객체입니다 -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<property name="dataSource" ref="dataSource" />
		<property name="configLocation" value="classpath:/mybatis-config.xml" />
        <property name="mapperLocations" value="classpath:/mappers/**/*Mapper.xml" />
	</bean>
	
	<!-- 쿼리전달 객체 -->
	<bean class='org.mybatis.spring.SqlSessionTemplate' id='sqlSessionTemplate'>
		<constructor-arg index='0' ref='sqlSessionFactory'/>
	</bean>	

4.mybatis-config.xml 파일과 mapper파일 생성