SPRING3.0 #08( Mybatis )

 

Mybatis를 이용하여 select, insert, update, delete 테스트 한다.

 

파일 구조 >

 

; Referenced Library 에 해당 라이브러리

; Mybatis 관련 jar 파일

 

 

 

(1) TestMain.java

package test.app;

 

import java.util.List;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;

import test.dao.MembersDao;
import test.vo.MembersVo;

 

public class TestMain {
    public static void main(String[] args) {
        ApplicationContext context = new ClassPathXmlApplicationContext("test/app/app.xml");
        MembersDao dao = (MembersDao)context.getBean("membersDao");

        int n = dao.insert(new MembersVo("my1","122","m","00",null));
        if(n>0){
            System.out.println("추가.성공!!");
        }

        n = dao.delete("my1");
        if(n>0){
            System.out.println("삭제성공!!");
        }

        MembersVo vo = dao.getInfo("my");
        if(vo!=null){
            System.out.println("아이디:" + vo.getId() );
            System.out.println("비밀번호:" + vo.getPwd() );
            System.out.println("이메일:" + vo.getEmail() );
            System.out.println("전화:" + vo.getPhone() );
        }else{
            System.out.println("검색된 아이디가 없어요!!");
        }
        System.out.println("---------------------------------------");
       
        List<MembersVo> list = dao.getList();
        for( MembersVo vo1: list){
            System.out.println("아이디:" + vo1.getId() );
            System.out.println("비밀번호:" + vo1.getPwd() );
            System.out.println("이메일:" + vo1.getEmail() );
            System.out.println("전화:" + vo1.getPhone() );
            System.out.println("=============");
        }
    }
}

 

 

스프링에서 MyBatis와 연동순서

1. DataSource설정(DB접속 정보)
2. SqlSessionFactory설정(dataSource주입,mapper파일에 대한 정보)
3. SqlSessionTemplate설정(SqlSessionFactory주입)
4. Dao설정(sqlSessionTemplate주입) 

 

 

(2) app.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"
    xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-3.1.xsd">

    
    <!-- 1. DataSource설정(DB접속 정보) -->
    <bean id="dataSource" class="org.apache.tomcat.dbcp.dbcp.BasicDataSource" destroy-method="close">
        <property name="driverClassName" value="oracle.jdbc.OracleDriver"/>
        <property name="url" value="jdbc:oracle:thin:@localhost:1521:XE" />
        <property name="username" value="scott" />
        <property name="password" value="tiger" />
    </bean>   
   
    <!--     2. SqlSessionFactory설정(dataSource주입,mapper파일에 대한 정보) -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!-- dataSource설정 -->
        <property name="dataSource" ref="dataSource"/>
        <!--
            SQLMapper파일 설정 : 클래스패스위치의 test/mybatis 경로의 모든xml파일을 읽어와라.!
         -->
        <property name="mapperLocations" value="classpath:test/mybatis/ *.xml"/>
    </bean>
   
    <!--     3. SqlSessionTemplate설정(SqlSessionFactory주입) -->
    <bean id="sqlSession" class="org.mybatis.spring.SqlSessionTemplate">
        <!--  생성자 0번째 인자에 sqlSessionFactory를 넣어라 -->
        <constructor-arg ref="sqlSessionFactory" index="0"/>
    </bean>
   
    <!--     4. Dao설정(sqlSessionTemplate주입) -->
    <bean id="membersDao" class="test.dao.MembersDao">
        <property name="sqlSession" ref="sqlSession" />
    </bean>   
</beans>

 

 

 

스프링에서는 SqlSession을 사용하기 위한 공통작업을 템플릿화한 SqlSessionTemplate을 사용한다.
( SqlSession 오픈, 종료에 관련된 작업을 관리해줌 )

 

(3) MembersDao.java

;

package test.dao;

import java.util.List;

import org.mybatis.spring.SqlSessionTemplate;

import test.vo.MembersVo;

public class MembersDao {
    private SqlSessionTemplate sqlSession;
    //스프링을 통해 주입받아야 하므로 setter메소드가 있어야 함.
    public void setSqlSession(SqlSessionTemplate sqlSession) {
        this.sqlSession = sqlSession;
    }
    public int insert(MembersVo vo){
        int n = sqlSession.insert("insert", vo);
        return n;
    }
    public int delete(String id){
        return sqlSession.delete("delete", id);
    }
    public MembersVo getInfo(String id){
        return (MembersVo)sqlSession.selectOne("getInfo", id);
    }
    public List<MembersVo> getList(){
        return (List<MembersVo>)sqlSession.selectList("getList");
    }
}

 

 

 

MyBatis

(5) MembersMapper.xml
;

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="orm.mybatis.MembersMapper">
    <insert id="insert" parameterType="test.vo.MembersVo">
        insert into Members values ( #{ id }, #{ pwd }, #{ email }, #{ phone }, sysdate )
    </insert>
    <select id="getList" resultType="test.vo.MembersVo">
        select * from members
    </select>
    <delete id="delete" parameterType="String">
        delete from members where id=#{value}
    </delete>
    <select id="getInfo" resultType="test.vo.MembersVo" parameterType="String">
        select * from members where id=#{value}
    </select>
</mapper>

 

 

(4) MembersVo.java

package test.vo;

import java.sql.Timestamp;

public class MembersVo {
    private String id;
    private String pwd;
    private String email;
    private String phone;
    private Timestamp regdate;
   
    public MembersVo(){}
   
    public MembersVo(String id, String pwd, String email, String phone, Timestamp regdate) {
        super();
        this.id = id;
        this.pwd = pwd;
        this.email = email;
        this.phone = phone;
        this.regdate = regdate;
    }

    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }

    public String getPwd() {
        return pwd;
    }

    public void setPwd(String pwd) {
        this.pwd = pwd;
    }

    public String getEmail() {
        return email;
    }

    public void setEmail(String email) {
        this.email = email;
    }

    public String getPhone() {
        return phone;
    }

    public void setPhone(String phone) {
        this.phone = phone;
    }

    public Timestamp getRegdate() {
        return regdate;
    }

    public void setRegdate(Timestamp regdate) {
        this.regdate = regdate;
    }   
}