<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="emp">

  	<typeAlias alias="emp" type="com.oracleclub.study.mvc.model.Emp"/>  	

 	<select id="selectEmpList" resultClass="emp"  >
		SELECT empno, ename, job, sal, NVL(mgr,0) mgr
		FROM  emp 
 	</select> 	

	<insert id="insertEmp"  parameterClass="emp"  >
 	    INSERT INTO emp (empno, ename, job, sal, mgr,  hiredate, deptno)
        VALUES (#empno#, #ename#, #job#, #sal#, 0, #hiredate#, #deptno#)
    </insert>

</sqlMap>

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
    "http://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>
	<settings
		cacheModelsEnabled="true"
		enhancementEnabled="true"
		lazyLoadingEnabled="true"		
		useStatementNamespaces="true"
	/>
	
	<sqlMap resource="sqlmap/Emp.xml"/> 
	
</sqlMapConfig> 

package com.oracleclub.study.mvc.dao;

import java.util.List;

import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.springframework.stereotype.Repository;

import com.oracleclub.study.mvc.model.Emp;

/**
 * 사원정보를 관리하는 DAO
 * 
 * @author : oramaster
 * 
 */
@Repository
public class EmpDAO extends SqlMapClientDaoSupport {

    private static final String NAMESPACE = "emp.";

    public void insertEmp(Emp emp) {
        getSqlMapClientTemplate().insert(NAMESPACE + "insertEmp", emp);
    }

    @SuppressWarnings("unchecked")
    public List<Emp> selectEmpList() {
        return getSqlMapClientTemplate().queryForList(NAMESPACE + "selectEmpList");
    }
}

package com.oracleclub.study.mvc.dao;

import org.junit.Assert;
import org.junit.Before;
import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;
import org.springframework.transaction.annotation.Transactional;

import com.ibatis.sqlmap.client.SqlMapClient;
import com.oracleclub.study.mvc.model.Emp;

/**
 * Class 내용 기술
 * 
 * @author : oramaster
 * 
 */
@RunWith(SpringJUnit4ClassRunner.class)
@Transactional
@ContextConfiguration(locations = { "classpath:spring/applicationContext-datasource.xml" })
public class EmpDAOTest {

    @Autowired
    private SqlMapClient sqlMapClient;

    private EmpDAO empDAO;

    @Before
    public void setUp() {
        empDAO = new EmpDAO();
        empDAO.setSqlMapClient(sqlMapClient);
    }

    @Test
    public void testSelectEmpList() {
        Assert.assertTrue(empDAO.selectEmpList().size() > 0);
    }

    @Test
    public void testInsertEmp() {
        Emp emp = new Emp();
        emp.setEmpno(1298);
        emp.setEname("tester");
        emp.setSal(1200);
        emp.setDeptno(10);

        empDAO.insertEmp(emp);
    }
}