mybatis与spring整合

整合方法一：SqlSessionTemplate

<?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:p="http://www.springframework.org/schema/p"
		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.2.xsd
		http://www.springframework.org/schema/aop
		http://www.springframework.org/schema/aop/spring-aop-3.2.xsd
		http://www.springframework.org/schema/tx
		http://www.springframework.org/schema/tx/spring-tx-3.2.xsd ">
	<!-- 配置数据源 -->
	<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource"
		destroy-method="close">
		<property name="driverClassName" value="com.mysql.jdbc.Driver" />
		<!-- <property name="url">
			<value><![CDATA[jdbc:mysql://127.0.0.1:3306/smbms?
					useUnicode=true&characterEncoding=utf-8]]></value>
		</property> -->
		<property name="url" value="jdbc:mysql://localhost:3306/smbms?
						useUnicode=true&amp;characterEncoding=utf-8" />
		<property name="username" value="root" />
		<property name="password" value="root" />
	</bean>

	<!-- 配置SqlSessionFactoryBean -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 引用数据源组件 -->
		<property name="dataSource" ref="dataSource" />
		<!-- 引用MyBatis配置文件中的配置 -->
		<property name="configLocation" value="classpath:mybatis-config.xml" />
		<!-- 配置SQL映射文件信息 -->
		<property name="mapperLocations">
			<list>
				<!-- 配置SQL映射文件路径 -->
				<value>classpath:com/bdqn/dao/*.xml</value>
			</list>
		</property>
	</bean>
	<!-- 配置SqlSessionTemplate -->
	<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg name="sqlSessionFactory" ref="sqlSessionFactory" />
	</bean>
	<!-- 配置DAO -->
	<bean id="userDao" class="com.bdqn.dao.impl.UserDaoImpl">
		<property name="sqlSession" ref="sqlSessionTemplate" />
	</bean> 
	<!-- 配置业务Bean -->
	<bean id="userService" class="com.bdqn.service.impl.UserServiceImpl">
		<property name="userDao" ref="userDao" />
	</bean>
</beans>
2. DAO实现：
private SqlSession sqlSession;
public SqlSession getSqlSession() {
	return sqlSession;
}
public void setSqlSession(SqlSession sqlSession) {
	this.sqlSession = sqlSession;
}
3. Service实现
private UserDao userDao;
public UserDao getUserDao() {
	return userDao;
}
public void setUserDao(UserDao userDao) {
	this.userDao = userDao;
}

整合方法二：SqlSessionDaoSupport

<!-- 配置DAO -->
    <bean id="userDao" class="com.bdqn.dao.impl.UserDaoImpl">
        <property name="sqlSessionFactory" ref="sqlSessionFactory" />
    </bean> 
2.public class UserDaoImpl extends SqlSessionDaoSupport implements  UserDao{	
	public List<User> getUserList(User user) {
		return this.getSqlSession().getMapper(UserDao.class).getUserList(user);
	}
}

整合方法三：MapperFactoryBean

<!-- 配置DAO -->
    <bean id="userDao" class="org.mybatis.spring.mapper.MapperFactoryBean">
    	<property name="mapperInterface" value="com.bdqn.dao.UserDao" />
        <property name="sqlSessionFactory" ref="sqlSessionFactory" />
    </bean> 
2. 删除DAO实现

整合方法四：MapperScannerConfigurer

<!-- 配置DAO -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.bdqn.dao"></property>
    </bean>
2. 删除DAO实现

整合方法五：使用注解+MapperScannerConfigurer

<!-- 配置DAO -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.bdqn.dao"></property>
    </bean>
    <!-- 配置业务Bean -->
    <context:component-scan base-package="com.bdqn.service" />
2. 删除DAO实现
3. Service层：删除Setter访问器
@Service("userService")
public class UserServiceImpl implements UserService {
	@Autowired
	private UserDao userDao;

事务：XML

<!-- 定义事务管理器 -->
<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
    <property name="dataSource" ref="dataSource"></property>
</bean>
<tx:advice id="txAdvice">
    <tx:attributes>
        <tx:method name="get*" propagation="SUPPORTS" />
        <tx:method name="add*" propagation="REQUIRED" />
        <tx:method name="del*" propagation="REQUIRED" />
        <tx:method name="update*" propagation="REQUIRED" />
        <tx:method name="*" propagation="REQUIRED" />
    </tx:attributes>
</tx:advice>
<!-- 定义切面 -->
<aop:config>
    <aop:pointcut id="serviceMethod"
        expression="execution(* com.bdqn.service..*.*(..))" />
    <aop:advisor advice-ref="txAdvice" pointcut-ref="serviceMethod" />
</aop:config>