<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:aop="http://www.springframework.org/schema/aop"
xmlns:tx="http://www.springframework.org/schema/tx"
xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans-3.1.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context-3.1.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx-3.1.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-2.5.xsd">
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocations">
<list>
<value>classpath*:dal/sqlmap-config.xml</value>
</list>
</property>
<property name="dataSource" ref="mysqlTddlDataSource"/>
</bean>
<context:component-scan base-package="com.zhongan.xman.dao">
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Service"/>
</context:component-scan>
<import resource="classpath:test-config/persistence.xml"/>
<import resource="classpath:test-config/spring-dao.xml"/>
</beans>
package com.zhongan.xman.dao.base;
import com.ibatis.sqlmap.client.SqlMapClient;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import javax.annotation.PostConstruct;
import javax.annotation.Resource;
/**
* Created by lisulong on 2016/10/10.
*/
public class BaseDAO extends SqlMapClientDaoSupport {
@Resource
private SqlMapClient sqlMapClient;
@PostConstruct
public void initSqlMapClient(){
super.setSqlMapClient(sqlMapClient);
}
}
package com.zhongan.xman.dao.impl;
import com.ibatis.sqlmap.client.SqlMapClient;
import com.zhongan.xman.dao.DirectSaleThreeyearInfoDAO;
import com.zhongan.xman.dao.base.BaseDAO;
import com.zhongan.xman.dataobject.DirectSaleThreeyearInfoDO;
import java.util.List;
import org.springframework.dao.DataAccessException;
import org.springframework.orm.ibatis.support.SqlMapClientDaoSupport;
import org.springframework.stereotype.Component;
import org.springframework.stereotype.Service;
import javax.annotation.PostConstruct;
import javax.annotation.Resource;
/**
* 数据访问对象实现类
* @since 2016-10-10
* @author lisulong
*/
@Component
public class DirectSaleThreeyearInfoDAOImpl extends BaseDAO implements DirectSaleThreeyearInfoDAO {
/**
* 获取对象列表
* @param mobileNo
* @return 对象列表
*/
@SuppressWarnings("unchecked")
public List<DirectSaleThreeyearInfoDO> findListByExample(Long mobileNo) throws DataAccessException {
List<DirectSaleThreeyearInfoDO> list = getSqlMapClientTemplate().queryForList("DirectSaleThreeyearInfo.findListByDO", mobileNo);
return list;
}
}