iBatis结合Spring的用法
下面是整个过程举的一些例子，里面需要的部分可以粘贴出来用：

sqlMapConfig.xml

<?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><sqlMap resource="com/itmg/crawler/server/dao/masterdb/config/Area.xml"/></sqlMapConfig>

<?xml version="1.0" encoding="UTF-8" ?><!DOCTYPE sqlMap          PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"          "http://ibatis.apache.org/dtd/sql-map-2.dtd"><sqlMap namespace="Area">  <typeAlias alias="area" type="com.itmg.crawler.server.remote.model.dao.AreaModel"/>  <select id="getAllArea" resultparameterresultname="code">package com.itmg.crawler.server.dao.masterdb.impl;import java.util.ArrayList;import java.util.List;import com.itmg.crawler.server.dao.masterdb.AreaDAO;import com.itmg.crawler.server.exception.DAOException;import com.itmg.crawler.server.remote.model.dao.AreaModel;public class AreaDAOImpl extends BaseDAO implements AreaDAO {public AreaDAOImpl() {// TODO Auto-generated constructor stub}/* * 获得t_area表的数据 * @see com.itmg.crawler.server.dao.masterdb.AreaDAO#getAllArea() */public List<AreaModel> getAllArea() throws Exception {List<AreaModel> list = new ArrayList<AreaModel>();list = getSqlMapClientTemplate().queryForList("getAllArea");return list;}/* * 通过AreaModel里的id获得list * @see com.itmg.crawler.server.dao.masterdb.AreaDAO#getAreaBySimple(com.itmg.crawler.server.remote.model.dao.AreaModel) */public List<AreaModel> getAreaBySimple(AreaModel areaModel)throws Exception {List<AreaModel> list = new ArrayList<AreaModel>();list = getSqlMapClientTemplate().queryForList("getAllAreaByID",areaModel);return list;}}

package com.itmg.crawler.server.dao.masterdb.impl;import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;public class BaseDAO extends SqlMapClientDaoSupport{public BaseDAO() {// TODO Auto-generated constructor stub}}

<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE beans PUBLIC "-//SPRING//DTD BEAN//EN" "http://www.springframework.org/dtd/spring-beans.dtd"><beans><bean id="dataSource_master" destroy-method="close"><property name="driverClass" value="com.mysql.jdbc.Driver" /><property name="jdbcUrl" value="jdbc:mysql://127.0.0.1/masterdb_server" /><property name="user" value="root" /><property name="password" value="xuehaipeng" /><property name="maxPoolSize" value="20" /><property name="minPoolSize" value="5" /><property name="initialPoolSize" value="5" /><property name="maxIdleTime" value="20" /></bean><bean id="transactionManager_master" ref="dataSource_master" /><property name="configLocation"><value>classpath:/com/itmg/crawler/server/dao/masterdb/config/sqlMapConfigMaster.xml</value></property></bean><!-- MasterDB DAO configure --><bean id="daoTemplateMaster" abstract="true"><property name="sqlMapClient" ref="sqlMapClient_master"/></bean><bean id="areaDAO" parent="daoTemplateMaster"/></beans>