[DB] iBatis CommonDAO

DAO에 SqlMapClient Bean 주입

<dependency>

<groupId>org.apache.ibatis</groupId>

<artifactId>ibatis-sqlmap</artifactId>

<version>2.3.0</version>

</dependency>

<dependency>

<groupId>org.springframework</groupId>

<artifactId>spring-orm</artifactId>

<version>3.0.2.RELEASE</version>

</dependency>

ibatisDao.java

package web.common.dao;

import java.util.List;

import java.util.Map;

import org.springframework.dao.DataAccessException;

import com.ibatis.sqlmap.client.SqlMapClient;

import com.ibatis.sqlmap.client.event.RowHandler;

public interface ibatisDao {

public Object insert(String statement) throws DataAccessException;

public Object insert(String statement, Object parameterObject)

throws DataAccessException;

public int update(String statement) throws DataAccessException;

public int update(String statement, Object parameterObject)

throws DataAccessException;

public int delete(String statement) throws DataAccessException;

public int delete(String statement, Object parameterObject)

throws DataAccessException;

public Object queryForObject(String statement) throws DataAccessException;

public Object queryForObject(String statement, Object parameterObject)

throws DataAccessException;

@SuppressWarnings("unchecked")

public List queryForList(String statement) throws DataAccessException;

@SuppressWarnings("unchecked")

public List queryForList(String statement, Object parameterObject)

throws DataAccessException;

@SuppressWarnings("unchecked")

public List queryForList(String statement, Object parameterObject,

int start, int end) throws DataAccessException;

@SuppressWarnings("unchecked")

public List queryForList(String statement, int start, int end)

throws DataAccessException;

@SuppressWarnings("unchecked")

public Map queryForMap(String statement, Object parameterObject, String key)

throws DataAccessException;

@SuppressWarnings("unchecked")

public Map queryForMap(String statement, Object parameterObject,

String key, String value) throws DataAccessException;

@SuppressWarnings("unchecked")

public void batchUpdate(String statement, List list)

throws DataAccessException;

@SuppressWarnings("unchecked")

public void batchInsert(String statement, List list)

throws DataAccessException;

@SuppressWarnings("unchecked")

public void batchDelete(String statement, List list)

throws DataAccessException;

public SqlMapClient getSqlMapClientForTransaction();

public void queryWithRowHandler(String statement, Object paramerterObject,

RowHandler rowHandler) throws DataAccessException;

}

CommonDao.java

package web.common.dao;

import java.sql.SQLException;

import java.util.Iterator;

import java.util.List;

import java.util.Map;

import javax.annotation.Resource;

import org.springframework.dao.DataAccessException;

import org.springframework.orm.ibatis.SqlMapClientCallback;

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

import org.springframework.stereotype.Repository;

import com.ibatis.sqlmap.client.SqlMapClient;

import com.ibatis.sqlmap.client.SqlMapExecutor;

import com.ibatis.sqlmap.client.event.RowHandler;

@Repository

public class CommonDao extends SqlMapClientDaoSupport implements ibatisDao{

@Resource(name = "sqlMapClient")

public void init(SqlMapClient sqlMapClient){

setSqlMapClient(sqlMapClient);

}

public Object insert(String statement) throws DataAccessException {

return super.getSqlMapClientTemplate().insert(statement);

}

public int update(String statement) throws DataAccessException {

return super.getSqlMapClientTemplate().update(statement);

}

public int delete(String statement) throws DataAccessException {

return super.getSqlMapClientTemplate().delete(statement);

}

public Object queryForObject(String statement) throws DataAccessException {

return super.getSqlMapClientTemplate().queryForObject(statement);

}

public Object insert(String statement, Object parameterObject)

throws DataAccessException {

return super.getSqlMapClientTemplate().insert(statement,

parameterObject);

}

public int update(String statement, Object parameterObject)

throws DataAccessException {

return super.getSqlMapClientTemplate().update(statement,

parameterObject);

}

public int delete(String statement, Object parameterObject)

throws DataAccessException {

return super.getSqlMapClientTemplate().delete(statement,

parameterObject);

}

public Object queryForObject(String statement, Object parameterObject)

throws DataAccessException {

return super.getSqlMapClientTemplate().queryForObject(statement,

parameterObject);

}

@SuppressWarnings("unchecked")

public List queryForList(String statement) throws DataAccessException

{

return super.getSqlMapClientTemplate().queryForList(statement);

}

@SuppressWarnings("rawtypes")

public List queryForList(String statement, Object parameterObject)

throws DataAccessException {

return super.getSqlMapClientTemplate().queryForList(statement,

parameterObject);

}

@SuppressWarnings("unchecked")

public List queryForList(String statement, Object parameterObject, int start, int end)

throws DataAccessException

{

return super.getSqlMapClientTemplate().queryForList(statement, parameterObject, start, end);

}

@SuppressWarnings("unchecked")

@Override

public List queryForList(String statement, int start, int end) throws DataAccessException

{

return super.getSqlMapClientTemplate().queryForList(statement, start, end);

}

@SuppressWarnings({ "rawtypes", "unchecked" })

public void batchUpdate(final String statement, final List list)

throws DataAccessException {

super.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {

public Object doInSqlMapClient(SqlMapExecutor executor)

throws SQLException {

executor.startBatch();

for (Iterator iter = list.iterator(); iter.hasNext();) {

executor.update(statement, iter.next());

}

executor.executeBatch();

return null;

}

});

}

@SuppressWarnings({ "rawtypes", "unchecked" })

public void batchDelete(final String statement, final List list)

throws DataAccessException {

super.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {

public Object doInSqlMapClient(SqlMapExecutor executor)

throws SQLException {

executor.startBatch();

for (Iterator iter = list.iterator(); iter.hasNext();) {

executor.delete(statement, iter.next());

}

executor.executeBatch();

return null;

}

});

}

@SuppressWarnings({ "rawtypes", "unchecked" })

public void batchInsert(final String statement, final List list)

throws DataAccessException {

super.getSqlMapClientTemplate().execute(new SqlMapClientCallback() {

public Object doInSqlMapClient(SqlMapExecutor executor)

throws SQLException {

executor.startBatch();

for (Iterator iter = list.iterator(); iter.hasNext();) {

executor.insert(statement, iter.next());

}

executor.executeBatch();

return null;

}

});

}

public void queryWithRowHandler(String statement, Object paramerterObject,

RowHandler rowHandler) throws DataAccessException {

super.getSqlMapClientTemplate().queryWithRowHandler(statement,

paramerterObject, rowHandler);

}

public SqlMapClient getSqlMapClientForTransaction() {

return super.getSqlMapClient();

}

@SuppressWarnings("unchecked")

public Map queryForMap(String statement, Object parameterObject, String key) throws DataAccessException

{

return super.getSqlMapClientTemplate().queryForMap(statement, parameterObject, key);

}

@SuppressWarnings("unchecked")

public Map queryForMap(String statement, Object parameterObject, String key, String value)

throws DataAccessException

{

return super.getSqlMapClientTemplate().queryForMap(statement, parameterObject, key, value);

}

}

@Autowired

private SqlMapClient sqlMapClient;

를 사용했을 경우는 sqlMapClient.queryForObject(""); 형태이지만

CommonDao를 상속하여 사용하므로 queryForObject(""); 가 된다.