ssm框架事物配置

项目源码传送门：http://download.youkuaiyun.com/download/six_666666/9991144

项目框架 数据库表

代码块

UserController.java

package yw;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

import org.springframework.context.support.ClassPathXmlApplicationContext;

import org.springframework.stereotype.Controller;

import org.springframework.web.bind.annotation.RequestMapping;

import org.springframework.web.servlet.ModelAndView;

@Controller

public class UserController {

//不用注解就要在spring中获取bean创建的对象去调用

ClassPathXmlApplicationContext ctx = new ClassPathXmlApplicationContext("ywxml/ApplicationContext.xml");

private UserImpl ui =(UserImpl) ctx.getBean("user");

@RequestMapping(value="/hello.do")

public void find(HttpServletRequest request){

String out_id = request.getParameter("out_id");

String in_id = request.getParameter("in_id");

String money = request.getParameter("money");

try {

ui.testTx(money, out_id, in_id);

} catch (Exception e) {

// TODO Auto-generated catch block

e.printStackTrace();

}

//ui.updateMoney2();

//Map map=ui.findById(id);

/* System.out.println(map);

ModelAndView mv = new ModelAndView();

//这里使用ModelAndView对象可以向前台传值，

mv.addObject("map",map);

//设置键值对json

mv.setViewName("hello");

//向hello页面返回一个mv对象的值

return mv;*/

}

}

UserImpl.java

package yw;

import java.util.HashMap;

import java.util.Map;

import org.mybatis.spring.SqlSessionTemplate;

import org.springframework.transaction.annotation.Transactional;

public class UserImpl {

// 注入以后就可以直接使用sqlsession

private SqlSessionTemplate sqlsession;

public void setSqlsession(SqlSessionTemplate sqlsession) {

this.sqlsession = sqlsession;

}

public Map findById(String id) {

Map map = sqlsession.selectOne("UserMapper.findById", id);

System.out.println(map);// 获取到数据map集合

return map;

}

@Transactional

// 也可以去配置另外的属性，写法：

// @Transactional(propagation=Propagation.REQUIRED,isolation=Isolation.DEFAULT)

// 传播详情 propagation 隔离级别 isolation

public void testTx(String money, String out_id, String in_id) throws Exception {

Map map1 = new HashMap();

map1.put("money", money);

map1.put("out_id", out_id);

Map map2 = new HashMap();

map2.put("money", money);

map2.put("in_id", in_id);

sqlsession.selectOne("UserMapper.updateMoney2", map1);

// int i = 1/0;

sqlsession.selectOne("UserMapper.updateMoney1", map2);

}

}

UserMapper.xml

<?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="UserMapper">

<select id="findById" parameterType="String" resultType="java.util.Map">

select * from d_user WHERE id=#{id}

</select>

<select id="updateMoney2" parameterType="Map" >

UPDATE d_user set money=money-#{money} where id=#{out_id};

</select>

<select id="updateMoney1" parameterType="String" >

UPDATE d_user set money=money+#{money} where id=#{in_id};

</select>

</mapper>

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:p="http://www.springframework.org/schema/p"

xmlns:context="http://www.springframework.org/schema/context"

xmlns:aop="http://www.springframework.org/schema/aop"

xmlns:mvc="http://www.springframework.org/schema/mvc"

xmlns:tx="http://www.springframework.org/schema/tx"

xmlns:jdbc="http://www.springframework.org/schema/jdbc"

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.0.xsd

http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-3.0.xsd

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

<!-- 1. 数据源 : DriverManagerDataSource -->

<bean id="dataSource"

class="org.springframework.jdbc.datasource.DriverManagerDataSource">

<property name="driverClassName" value="com.mysql.jdbc.Driver" />

<property name="url" value="jdbc:mysql://localhost:3306/zdy" />

<property name="username" value="root" />

<property name="password" value="root" />

</bean>

<!-- 获取会话工厂，并注入Mybatis，和dateSource数据库链接 -->

<bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">

<property name="dataSource" ref="dataSource"></property>

<property name="configLocation" value="classpath:ywxml/mybatis-config.xml"></property>

</bean>

<!-- 在会话工厂中取出SqlSessionTemplate这个对象 -->

<bean id="sqlsessionTemplate" class="org.mybatis.spring.SqlSessionTemplate">

<constructor-arg index="0" ref="sqlSessionFactory" />

</bean>

<!-- 把sqlsessionTemplate注入到UserImpl中去。UserImpl才能对数据进行操作 -->

<bean id="user" class="yw.UserImpl">

<property name="sqlsession" ref="sqlsessionTemplate">

</property>

</bean>

<!-- 事务管理器 -->

<bean name="transactionManager"

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">

<property name="dataSource" ref="dataSource"></property>

</bean>

<!-- 将事务管理器交给spring。proxy-target-class=true： 底层强制使用cglib代理-->

<tx:annotation-driven transaction-manager="transactionManager"

proxy-target-class="true"/>

</beans>

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD SQL Map Config 3.0//EN"

"http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>

<mappers>

<mapper resource="yw/UserMapper.xml" />

<!-- 连接配置文件 -->

</mappers>

</configuration>

spring-mvc.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"

xmlns:mvc="http://www.springframework.org/schema/mvc"

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

http://www.springframework.org/schema/mvc

http://www.springframework.org/schema/mvc/spring-mvc-4.0.xsd">

<!-- 注解扫描包 -->

<context:component-scan base-package="yw" />

<!-- 开启注解 -->

<mvc:annotation-driven />

<!-- 定义跳转的文件的前后缀 ，视图模式配置-->

<bean id="viewResolver"

class="org.springframework.web.servlet.view.InternalResourceViewResolver">

<!-- 这里的配置我的理解是自动给后面action的方法return的字符串加上前缀和后缀，变成一个 可用的url地址 -->

<property name="prefix" value="/" />

<property name="suffix" value=".jsp" />

</bean>

</beans>

测试结果