<?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:tx="http://www.springframework.org/schema/tx"
? ? ? xmlns:aop="http://www.springframework.org/schema/aop"
? ? ? 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/tx
http://www.springframework.org/schema/tx/spring-tx-3.0.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop-3.0.xsd
http://www.springframework.org/schema/context
? ? ? https://www.springframework.org/schema/context/spring-context.xsd">
<!--配置數(shù)據(jù)庫-->
? ? <context:property-placeholder location="jdbc.properties"/>
<bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
<property name="driverClassName" value="${jdbc.dataSource}"/>
<property name="url" value="${jdbc.url}"/>
<property name="username" value="${jdbc.username}"/>
<property name="password" value="${jdbc.password}"/>
</bean>
<!--事務(wù)管理器，依賴于數(shù)據(jù)源-->
? ? <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property>
</bean>
<!--配置mybatis-->
? ? <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
<property name="dataSource" ref="dataSource"></property>
<property name="configLocation" value="mybatis-config.xml"/>
</bean>
<!--實例化Dao 整合Mybatis-->
? ? <bean id="userDao" class="DaoImpl.UserDaoImpl2">
<property name="sqlSessionFactory" ref="sqlSessionFactory" />
</bean>
<bean id="userServers" class="Servers.UserServers">
</bean>
</beans>
需要實現(xiàn)接口并繼承SqlSessionDaoSupport
public class UserDaoImpl2 extends SqlSessionDaoSupport? implements UserDao {
@Override
? ? public List getUserList() {
return null;
}
@Override
? ? public User getUser(int id) {
return getSqlSession().getMapper(UserDao.class).getUser(id);
}
@Override
? ? public int insertUser(User user) {
return 0;
}
}
測試：
