Spring4

1.spring配置文件（提供对事务的配置）

<?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:tx="http://www.springframework.org/schema/tx" xmlns:aop="http://www.springframework.org/schema/aop"
       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.xsd
	http://www.springframework.org/schema/tx
	http://www.springframework.org/schema/tx/spring-tx.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop.xsd">


	<!-- 配置数据源 -->
	<!--配置连接池-->
	<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="com.mysql.jdbc.Driver"/>
		<property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/smbms"/>
		<property name="user" value="root"/>
		<property name="password" value="123456"/>
	</bean>

	<!--配置SqlSessionFactory -->
	<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
		<!-- 加载数据源 -->
		<property name="dataSource" ref="dataSource"></property>

		<!-- 加载MyBatis的配置文件 -->
		<property name="configLocation" value="classpath:mybatis-config.xml"></property>

		<!--加载Mybatis的映射文件 -->
		<property name="mapperLocations">
			<!-- 通配符加载 -->
			<value>classpath:com/leisong/**/*.xml</value>
		</property>
	</bean>

	<!-- 配置sqlSessionTemplate -->
	<bean id="sqlSessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">
		<constructor-arg index="0" ref="sqlSessionFactory"></constructor-arg>
	</bean>

	<bean id="userMapper" class="com.leisong.dao.impl.UserMapperImpl">
		<property name="sqlSessionTemplate" ref="sqlSessionTemplate"></property>
	</bean>
<!--配置事务管理器-->
    <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <!--注入数据源-->
        <property name="dataSource" ref="dataSource"></property>
    </bean>
<!--配置声明式事务的规则-->
    <tx:advice id="txadvice" transaction-manager="dataSourceTransactionManager">
        <!--  配置具体的事务的策略-->
        <tx:attributes>
            <!-- method  建议动态的配置  propagation="用的策略"
            timeout事务的超时时间（单位是秒） -1代表时间无限制
            rollback-for遇到什么事务的时候进行回滚-->
            <tx:method name="find*" propagation="NOT_SUPPORTED" timeout="-1"/>
            <tx:method name="add*" propagation="REQUIRED" timeout="-1" rollback-for="SQLException"/>
            <tx:method name="update*" propagation="REQUIRED" timeout="-1" />
        </tx:attributes>
    </tx:advice>
<!--事务的增强处理-->
    <aop:config>
        <!--配置切入点-->
        <aop:pointcut id="p1" expression="execution(* com.leisong.service..*.*(..))"/>
        <!--增强处理-->
        <aop:advisor advice-ref="txadvice" pointcut-ref="p1"></aop:advisor>
    </aop:config>
	<!--配置让其自动扫码指定的包下的注解  -->
	<context:component-scan base-package="com.leisong.service.impl"></context:component-scan>
</beans>

2.数据访问层接口（UserMapper）

package com.leisong.dao;

import com.leisong.domain.User;
import org.apache.ibatis.annotations.Param;

public interface UserMapper {
    //根据用户id修改信息
    public int updateUser(@Param("id") int id, @Param("user") User user);

    //根据id删除用户
    public int deleteUser(@Param("id")int id);

    //根据id修改密码
    public int updatePwdById(@Param("id") int id,@Param("password")String pwd);
}

3.UserMapper的映射文件

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.leisong.dao.UserMapper">

    <update id="updateUser">
        update smbms_user set userName=#{user.userName} where id=#{id}
    </update>

    <delete id="deleteUser">
        delete from smbms_user where id=#{id}
    </delete>

    <update id="updatePwdById" >
        update smbms_user set userPassword=#{password} where id=#{id}
    </update>
</mapper>

4.数据访问层实现类UserMapperImpl

package com.leisong.dao.impl;

import com.leisong.dao.UserMapper;
import com.leisong.domain.User;
import org.mybatis.spring.SqlSessionTemplate;

public class UserMapperImpl implements UserMapper {

    private SqlSessionTemplate sqlSessionTemplate;

    public SqlSessionTemplate getSqlSessionTemplate() {
        return sqlSessionTemplate;
    }

    public void setSqlSessionTemplate(SqlSessionTemplate sqlSessionTemplate) {
        this.sqlSessionTemplate = sqlSessionTemplate;
    }

    @Override
    public int updateUser(int id, User user) {
        return sqlSessionTemplate.getMapper(UserMapper.class).updateUser(id,user);
    }

    @Override
    public int deleteUser(int id) {
        return sqlSessionTemplate.getMapper(UserMapper.class).deleteUser(id);
    }

    @Override
    public int updatePwdById(int id, String pwd) {
        return sqlSessionTemplate.getMapper(UserMapper.class).updatePwdById(id,pwd);
    }
}

5.业务逻辑层接口及其实现类

package com.leisong.service;

import com.leisong.domain.User;

public interface UserService {
    public boolean updateUser(int id, User user);

    public boolean delete(int id);

    public boolean updatePassword(int id, String pwd);
}



package com.leisong.service.impl;

import com.leisong.dao.UserMapper;
import com.leisong.domain.User;
import com.leisong.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

@Service("userService")
public class UserServiceImpl implements UserService {

    @Autowired
    private UserMapper userMapper;

    public UserMapper getUserMapper() {
        return userMapper;
    }

    public void setUserMapper(UserMapper userMapper) {
        this.userMapper = userMapper;
    }

    @Override
    public boolean updateUser(int id, User user) {
        return userMapper.updateUser(id,user)>0;
    }

    @Override
    public boolean delete(int id) {
        return userMapper.deleteUser(id)>0;
    }

    @Override
    public boolean updatePassword(int id, String pwd) {
        return userMapper.updatePwdById(id,pwd)>0;
    }
}

6.测试

@Test
    public void test(){
        ApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        UserService service = (UserService)context.getBean("userService");
        User user = new User();
        user.setUserName("欧文");
        service.updateUser(5,user);
    }