Spring Mybatis 연동 (mysql)


HKH

Share

Maven이 깔려 있다는 가정하에


1. pom.xml을 열어 dependency를 추가한다.

 

<!-- Mysql connector --> 

 <dependency>

           <groupId>mysql</groupId>

           <artifactId>mysql-connector-java</artifactId>

           <version>5.1.31</version>

</dependency> 

 

<!-- mybatis -->

<dependency>

<groupId>org.mybatis</groupId>

  <artifactId>mybatis</artifactId>

  <version>${mybatis.version}</version>

</dependency>

<dependency>

          <groupId>org.mybatis</groupId>

  <artifactId>mybatis-spring</artifactId>

  <version>${mybatis-spring.version}</version>

</dependency> 

 

2. *-context.xml 파일 설정

 

                                               

    <bean id="dataSource"

class="org.springframework.jdbc.datasource.SimpleDriverDataSource">

<property name="driverClass" value="com.mysql.jdbc.Driver"></property>

<property name="url" value="://ip주소:3306/db명"></property>

<property name="username" value="아이디"></property>

<property name="password" value="비밀번호"></property>

    </bean>

    

<!-- Mybatis를 사용하는 패키지 경로를 적어준다.  -->

 

    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource" />
        <!-- 아래부분은 매핑할 xml파일이 있는 패키지경로를 설정한다. -->
        <property name="typeAliasesPackage" value="com/demo/test/mapper/" />
        <property name="mapperLocations" value="classpath:com/demo/test/mapper/*.xml" />
    </bean>
    
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">

<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory"></constructor-arg>

    </bean>
 

<!-- 트랜잭션 -->

    <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

<property name="dataSource" ref="dataSource"></property>

    </bean> 

                                                                                                                                                                   

datasource를 property파일로 빼서 관리하려면 빨간색 네모 부분에 프로퍼티 경로를 추가한 

<bean class="org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">

<property name="locations">

<value>/WEB-INF/spring/dbpool.properties</value>

</property>

</bean> 

경로 추가 후 datasource 내용도 바꿈

<bean id="dataSource"

class="org.springframework.jdbc.datasource.SimpleDriverDataSource">

<property name="driverClass" value="${jdbc.driverClassName}"></property>

<property name="url" value="${jdbc.url}"></property>

<property name="username" value="${jdbc.username}"></property>

<property name="password" value="${jdbc.password}"></property>

</bean> 

 

locations에 설정한 위치에 프로퍼티 파일 추가

 

dbpool.properties

 

jdbc.driverClassName=com.mysql.jdbc.Driver

jdbc.url=jdbc:mysql://ip주소:3306/db명

jdbc.username= db아이디

jdbc.password= 비밀번호 

                                                                                                                                                                      

 

DAO 서비스 구현

 

Member.java

- 간단하게 아이디 이름 비밀번호, getter setter 만들어 줌

 

package com.demo.DAO;

 

public class Member { 

String id;

String name;

String password;

 

public String getId() {

return id;

}

public void setId(String id) {

this.id = id;

}

public String getName() {

return name;

}

public void setName(String name) {

this.name = name;

public String getPassword() {

return password;

}

public void setPassword(String password) {

this.password = password;

}

 

MemberDAO.java

 

package com.demo.DAO;

 

import java.util.ArrayList;

 

public interface MemberDAO {

public ArrayList<Member> getMember();

}

 

MemberDAOImpl.java

 

package com.demo.DAO;

 

import java.util.ArrayList;

 

import org.apache.ibatis.session.SqlSession;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.stereotype.Repository;

 

@Repository

public class MemberDAOImpl​ implements MemberDAO {

@Autowired

private SqlSession sqlSession;

@Override

public ArrayList<Member> getMember() {

// TODO Auto-generated method stub

ArrayList<Member> result = new ArrayList<Member>();

MemberMapper memberMapper = sqlSession.getMapper(MemberMapper.class);

result = memberMapper.getMember();

return result;

}

}

 

MemberMapper.java

 

package com.demo.DAO;

 

import java.util.ArrayList;

 

public interface MemberMapper {

public ArrayList<Member> getMember();

}

 

MemberMapper.xml

- *-context.xml에 설정한 위치에 만들어 준다.

<mapper namespace="com.demo.DAO.MemberMapper">

<!-- <cache-ref namespace=""/> -->

  <resultMap type="Member" id="MemberResultMap">

  <result property="id" column="id"/>

  <result property="password" column="password"/>

  <result property="name" column="name"/>

  </resultMap>

 

  <select id="getMember" resultMap="MemberResultMap">

  select  id , name , password from member

  </select>

 

 

 </mapper> 

 

 

첨부파일
첨부된 파일이 없습니다.
Sign in required
  • : {{i.writer }}
    {{i.regdate}}


    {{i.content||breakFilter }}