어노테이션 사용

Configuration.xml (mapper 맵핑같은 설정이 없다)

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<!-- DB접속정보 값을 가지고 있는 파일 설정 -->

<properties resource="pack/mybatis/db.properties" />

<!-- DB접속 정보 셋팅 -->

<environments default="development">

<environment id="development">

<transactionManager type="JDBC" />

<dataSource type="POOLED">

<property name="driver" value="${driver}" />

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

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

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

</dataSource>

</environment>

</environments>

</configuration>

=======================================================================================================

ProcessDao.java

.....

public class ProcessDao {

private SqlSessionFactory factiory = SqlMapConfig.getSqlSession();

private SqlSession sqlSession = factiory.openSession(); 

SqlMapperInter inter = (SqlMapperInter)sqlSession.getMapper(SqlMapperInter.class); //어노테이션을 위한 설정

.....

=======================================================================================================

SqlMapperInter.java(인터페이스를 사용하여 작성)

import java.util.List;

import org.apache.ibatis.annotations.Delete;

import org.apache.ibatis.annotations.Insert;

import org.apache.ibatis.annotations.Select;

import org.apache.ibatis.annotations.Update;

public interface SqlMapperInter {

@Select("select * from membertab")

public List<DataDto> selectDataAll();

@Select("select * from membertab where id=#{id}")

public DataDto selectDataById(String id);

@Insert("Insert into membertab values(#{id},#{name},#{passwd},sysdate)")

public int insertData(DataDto dto);

@Update("update membertab set name=#{name} where id=#{id}")

public int updateData(DataDto dto);

@Delete("delete from emebertab where id=#{id}")

public int deleteData(String id);

}

=======================================================================================================

DataDto.java...

db.properties...

파일 등 생략