Day 46 - iBatis/MyBatis (데이터베이스 연동을 위한 ORM 시스템)

pom.xml (라이브러리 추가)

		<!-- https://mvnrepository.com/artifact/org.apache.ibatis/ibatis-sqlmap -->
		<dependency>
		    <groupId>org.apache.ibatis</groupId>
		    <artifactId>ibatis-sqlmap</artifactId>
		    <version>2.3.4.726</version>
		</dependency>
		<!-- https://mvnrepository.com/artifact/org.springframework/spring-ibatis -->
		<dependency>
		    <groupId>org.springframework</groupId>
		    <artifactId>spring-ibatis</artifactId>
		    <version>2.0.8</version>
		    <scope>provided</scope>
		</dependency>

sqlMapConfig

https://ibatis.apache.org/dtd/

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

<!DOCTYPE sqlMapConfig 
	PUBLIC "-//iBATIS.com//DTD SQL Map Config 2.0//EN"
    "https://ibatis.apache.org/dtd/sql-map-config-2.dtd">

<sqlMapConfig>

	<sqlMap resource="mapper/empMapper.xml"></sqlMap>
    
</sqlMapConfig>

empMapper.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
	PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
	"https://ibatis.apache.org/dtd/sql-map-2.dtd">
	
<sqlMap>
	<select id="empList" resultClass="com.gimhae.emp.model.EmpVo">
		select * from emp38 order by empno desc
	</select>
</sqlMap>

EmpDaoIbatis

package com.gimhae.mvc.model;

public class EmpDaoIbatis extends SqlMapClientDaoSupport implements EmpDao {

	@Override
	public List<EmpVo> pullList() {
		return getSqlMapClientTemplate().queryForList("empList");
	}

	@Override
	public void addList(String ename, int pay) {
		// TODO Auto-generated method stub

	}

	@Override
	public EmpVo getList(int empno) {
		// TODO Auto-generated method stub
		return null;
	}

	@Override
	public int setList(EmpVo bean) {
		// TODO Auto-generated method stub
		return 0;
	}

	@Override
	public int rmList(int empno) {
		// TODO Auto-generated method stub
		return 0;
	}

}