mybatis15--mybatis和spring整合开发原始dao接口

1、applicationContext.xml

<?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"
	xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans.xsd
		http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-4.0.xsd">
<!-- 配置数据源 -->
<context:property-placeholder location="classpath:db.properties"/>
<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.driver}"></property>
<property name="url" value="${jdbc.url}"></property>
<property name="username" value="${jdbc.user}"></property>
<property name="password" value="${jdbc.password}"></property>
<property name="maxActive" value="10"></property>
<property name="maxIdle" value="5"></property>
</bean>
<!--配置 SqlSessionFactory -->
<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="classpath:SqlMapConfig.xml"/>
</bean>
<!--配置dao  -->
<bean id="userDao" class="sjzc.gong.xiao.dao.UserDaoImpl">
<property name="sqlSessionFactory" ref="sqlSessionFactory"></property>
</bean>
</beans>

2、UserDao接口

public interface UserDao {
	public User findUserById(int id) throws Exception;

}

3、UserDao的实现类：UserDaoImpl

这里让实现类继承了SqlSessionDaoSupport。因为SqlSessionDaoSupport中有成员变量：sqlSessionFactory、sqlSession

操作起来更方便

public class UserDaoImpl extends SqlSessionDaoSupport implements UserDao {
	

	@Override
	public User findUserById(int id) throws Exception {
		SqlSession sqlSession=this.getSqlSession();
		User user=sqlSession.selectOne("findUserById", id);
		return user;
	}

}

4、测试

ublic class UserDaoImplTest {
	private ApplicationContext applicationContext;

	@Before
	public void setUp() throws Exception {
		applicationContext=new ClassPathXmlApplicationContext("applicationContext.xml");
	}

	@Test
	public void testFindUserById() throws Exception {
		UserDao userDao=(UserDao) applicationContext.getBean("userDao");
		User user = userDao.findUserById(1);
		System.out.println(user);
	}

}