搭建ssm可先依次搭建 spring springmvc mybatis 搭建之后在依次测试 测试之后在整合再测试
搭建基础环境
先导入ssm环境的坐标pom.xml
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
<modelVersion>4.0.0</modelVersion>
<groupId>com.itcast</groupId>
<artifactId>ssm</artifactId>
<version>1.0-SNAPSHOT</version>
<packaging>war</packaging>
<name>ssm Maven Webapp</name>
<!-- FIXME change it to the project's website -->
<url>http://www.example.com</url>
<properties>
<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
<maven.compiler.source>1.8</maven.compiler.source>
<maven.compiler.target>1.8</maven.compiler.target>
<spring.version>5.0.2.RELEASE</spring.version>
<slf4j.version>1.6.6</slf4j.version>
<log4j.version>1.2.12</log4j.version>
<mysql.version>5.1.6</mysql.version>
<mybatis.version>3.4.5</mybatis.version>
</properties>
<dependencies>
<!-- spring -->
<!--aop相关技术-->
<dependency>
<groupId>org.aspectj</groupId>
<artifactId>aspectjweaver</artifactId>
<version>1.6.8</version>
</dependen
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-aop</artifactId>
<version>${spring.version}</version>
</dependency>
<!--spring容器-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-context</artifactId>
<version>${spring.version}</version>
</dependency>
<!--springmvc相关jar包-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-web</artifactId>
<version>${spring.version}</version>
</dependency>
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-webmvc</artifactId>
<version>${spring.version}</version>
</dependency>
<!--单元测试-->
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
<version>4.12</version>
<scope>compile</scope><!--全局都可以用 若用test表示只在test资源包下使用-->
</dependency>
<!--单元测试整合-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
<version>${spring.version}</version>
</dependency>
<!--事务管理-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-tx</artifactId>
<version>${spring.version}</version>
</dependency>
<!--jdbc模板技术-->
<dependency>
<groupId>org.springframework</groupId>
<artifactId>spring-jdbc</artifactId>
<version>${spring.version}</version>
</dependency>
<!--连接数据库驱动的jar包-->
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>${mysql.version}</version>
</dependency>
<!--servlet jsp-->
<dependency>
<groupId>javax.servlet</groupId>
<artifactId>servlet-api</artifactId>
<version>2.5</version>
<scope>provided</scope>
</dependency>
<dependency>
<groupId>javax.servlet.jsp</groupId>
<artifactId>jsp-api</artifactId>
<version>2.0</version>
<scope>provided</scope>
</dependency>
<!--jstl标签库-->
<dependency>
<groupId>jstl</groupId>
<artifactId>jstl</artifactId>
<version>1.2</version>
</dependency>
<!--日志-->
<!-- log start -->
<dependency>
<groupId>log4j</groupId>
<artifactId>log4j</artifactId>
<version>${log4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-api</artifactId>
<version>${slf4j.version}</version>
</dependency>
<dependency>
<groupId>org.slf4j</groupId>
<artifactId>slf4j-log4j12</artifactId>
<version>${slf4j.version}</version>
</dependency>
<!-- log end -->
<!--mybatis-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis</artifactId>
<version>${mybatis.version}</version>
</dependency>
<!--mybatis-spring整合-->
<dependency>
<groupId>org.mybatis</groupId>
<artifactId>mybatis-spring</artifactId>
<version>1.3.0</version>
</dependency>
<!--c3p0连接池技术-->
<dependency>
<groupId>c3p0</groupId>
<artifactId>c3p0</artifactId>
<version>0.9.1.2</version>
<type>jar</type>
<scope>compile</scope>
</dependency>
</dependencies>
<build>
<finalName>ssm</finalName>
<pluginManagement><!-- lock down plugins versions to avoid using Maven defaults (may be moved to parent pom) -->
<plugins>
<plugin>
<artifactId>maven-clean-plugin</artifactId>
<version>3.0.0</version>
</plugin>
<!-- see http://maven.apache.org/ref/current/maven-core/default-bindings.html#Plugin_bindings_for_war_packaging -->
<plugin>
<artifactId>maven-resources-plugin</artifactId>
<version>3.0.2</version>
</plugin>
<plugin>
<artifactId>maven-compiler-plugin</artifactId>
<version>3.7.0</version>
</plugin>
<plugin>
<artifactId>maven-surefire-plugin</artifactId>
<version>2.20.1</version>
</plugin>
<plugin>
<artifactId>maven-war-plugin</artifactId>
<version>3.2.0</version>
</plugin>
<plugin>
<artifactId>maven-install-plugin</artifactId>
<version>2.5.2</version>
</plugin>
<plugin>
<artifactId>maven-deploy-plugin</artifactId>
<version>2.8.2</version>
</plugin>
</plugins>
</pluginManagement>
</build>
</project>
Account
public class Account implements Serializable{
private Integer id;
private String name;
private float money;
AccountDao
public interface AccountDao {// 持久层只需要写接口 mybatis可以帮助生成代理对象 做实现类需要做的事情
/* 查询所有*/
public List<Account> findAccount();
/* 保存*/
public void saveAccount(Account account);
}
AccountService
public interface AccountService {
//查询所有
public List<Account> findAccount();
//保存
public void saveAccount(Account account);
}
impl.AccountServiceImpl
@Service("accountService")
public class AccountServiceImpl implements AccountService {
@Override
public List<Account> findAccount() {
System.out.println("业务层:查询所有");
return null;
}
@Override
public void saveAccount(Account account) {
System.out.println("业务层:保存账户");
}
}
AccountController
public class AccountController {}
spring搭建
搭建spring需要先创建spring的配置文件 contextApplication.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: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.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!--开启spring注解扫描-->
<context:component-scan base-package="com.itcast">
<!--这里会扫描com.itcast下的所有包 但是spring只管业务层service和持久层dao 而表现层controller不会管 交给springMvc-->
<!--type annotation 表示注解类型 Ctrl+N 查找Controller 勾上 包含非项目类选择该注解 复制全限定性类名-->
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"></context:exclude-filter>
</context:component-scan>
</beans>
给service层类上加上注解 再创建个test包开始测试 测试加载xml到容器能不能从容器中获取代理对象
@Test
public void testSpring(){
ApplicationContext ac = new ClassPathXmlApplicationContext("applicationContext.xml");
AccountService as = (AccountService) ac.getBean("accountService");
List<Account> list = as.findAccount();
}
控制台输出:业务层:查询所有
springmvc
web.xml:配置控制器 并加载springmvc配置文件 配置乱码问题
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>Archetype Created Web Application</display-name>
<!--解决中文乱码问题(浏览器传入的中文数据会乱码)-->
<filter><!--放在前面 否则标签会报红 但不影响执行-->
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/*</url-pattern><!--配置拦截所有路径 注意使 / * / 不可以 -->
</filter-mapping>
<!--配置前端控制器-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!--初始化时加载springmvc配置文件-->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc.xml</param-value>
</init-param>
<!--启动服务器,创建servlet DispatcherServlet在服务器启动时加载 -->
<load-on-startup>1</load-on-startup>
</servlet>
<!--配置拦截器的拦截路径-->
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
springmvc
<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
xmlns:mvc="http://www.springframework.org/schema/mvc"
xmlns:context="http://www.springframework.org/schema/context"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xsi:schemaLocation="
http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.xsd
http://www.springframework.org/schema/mvc
http://www.springframework.org/schema/mvc/spring-mvc.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">
<!--1.开启注解扫描-->
<context:component-scan base-package="com.itcast"><!--配置只扫描Controller注解-->
<context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!--2.配置视图解析器-->
<bean id="internalResourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
<property name="prefix" value="/WEB-INF/pages/"></property>
<property name="suffix" value=".jsp"></property>
</bean>
<!--3.不过滤静态资源 否则会被 拦截掉,静态资源在Spring中通过不了都会被拦截-->
<mvc:resources location="/css/" mapping="/css/**" />
<mvc:resources location="/images/" mapping="/images/**" />
<mvc:resources location="/js/" mapping="/js/**" />
<!--4.开启springmvc注解的支持-->
<mvc:annotation-driven/>
</beans>
Controller:
@Controller
@RequestMapping("/account")
public class AccountController {
@RequestMapping("/findAll")
public String findAll(){
System.out.println("控制器访问成功");
return "list";
}
}
编辑页面
index.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>title</title>
</head>
<body>
<a href="account/findAll">测试</a>
</body>
</html>
WEB-INF/pages/list.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>list</title>
</head>
<body>
springmvc
</body>
</html>
部署tomcat 启动 并点击页面测试
测试结果:正确访问到list.jsp页面 控制台输出控制器访问成功
整合spring-spingmvc
spring配置文件ApplicationContext.xml一直没有被加载,包中注解也无法将实现类放入容器,这样Controller中无法调用service方法(service实现类没有加载到容器中,之前测试是用ClassPathXMLApplicationContext加载进容器的),所以得先加载sping的配置文件完成整合
也是在web.xml中配置(斜体区域为添加)
<!DOCTYPE web-app PUBLIC
"-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"http://java.sun.com/dtd/web-app_2_3.dtd" >
<web-app>
<display-name>Archetype Created Web Application</display-name>
<!--解决中文乱码问题(浏览器传入的中文数据会乱码)-->
<filter><!--放在前面 否则标签会报红 但不影响执行-->
<filter-name>characterEncodingFilter</filter-name>
<filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>
<init-param>
<param-name>encoding</param-name>
<param-value>UTF-8</param-value>
</init-param>
</filter>
<filter-mapping>
<filter-name>characterEncodingFilter</filter-name>
<url-pattern>/</url-pattern><!--配置拦截所有路径-->
</filter-mapping>
*<!--配置spring的监听器 环境加载监听器?加载所有环境中WEBINF文件-->
<listener><!--ContextLoaderListener无提示 ctrl+n 查找拷贝全路径-->
<listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
</listener>
<!--设置配置文件的路径-->
<!--默认只加载WEB-INF目录下的applicationContext.xml配置文件
但是最好放在资源目录下作统一的管理 所以采用第二种方式-->将配置文件设置为环境资源?
<context-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:applicationContext.xml</param-value>
</context-param>*
<!--配置前端控制器-->
<servlet>
<servlet-name>dispatcherServlet</servlet-name>
<servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
<!--初始化时加载springmvc配置文件-->
<init-param>
<param-name>contextConfigLocation</param-name>
<param-value>classpath:springmvc.xml</param-value>
</init-param>
<!--启动服务器,创建servlet DispatcherServlet在服务器启动时加载 -->
<load-on-startup>1</load-on-startup>
</servlet>
<!--配置拦截器的拦截路径-->
<servlet-mapping>
<servlet-name>dispatcherServlet</servlet-name>
<url-pattern>/</url-pattern>
</servlet-mapping>
</web-app>
在AccountController中添加service对象调用方法在测试(直接访问页面点击 若表现层调用service层方法成功(springmvc.xml加载成功 自动注入也生效)则表示整合成功)
@Controller
@RequestMapping("/account")
public class AccountController {
@Autowired
private AccountService accountService;
@RequestMapping("/findAll")
public String findAll(){
accountService.findAccount();
System.out.println("控制器访问成功");
return "list";
}
}
测试结果:业务层:查询所有 控制器访问成功
Mybatis
SqlMapperConfig.xml 使用jdbc模板技术创建链接 配置映射文件位置
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration
PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
<environments default="mysql">
<environment id="mysql">
<transactionManager type="JDBC"></transactionManager>
<dataSource type="POOLED">
<property name="driver" value="com.mysql.jdbc.Driver"/>
<property name="url" value="jdbc:mysql:///spring"/>
<property name="username" value="root"/>
<property name="password" value="root"/>
</dataSource>
</environment>
</environments>
<!--配置映射文件位置 单个文件用配置mapper,一般都是包,用packet -->
<mappers>
<!--<mapper class="com.itcast.dao.AccountDao"></mapper>配置文件方式:resource 注解方式:class-->
<package name="com.itcast.dao"/>
</mappers>
</configuration>
AccountDao 使用ibatis注解进行操作
public interface AccountDao {// 持久层只需要写接口 mybatis可以帮助生成代理对象 做实现类需要做的事情
/* 查询所有*/
@Select("select * from account")
public List<Account> findAccount();
/* 保存*/
@Insert("insert into account (name,money) values(#{name},#{money})")
public void saveAccount(Account account);
}
测试:
@Test
public void run() throws IOException {
//加载mybatis配置文件
InputStream is = Resources.getResourceAsStream("SqlMapperConfig.xml");
//创建工厂对象
SqlSessionFactory fa = new SqlSessionFactoryBuilder().build(is);
//创建sqlSession对象
SqlSession sqlSession = fa.openSession();
//获取代理对象
AccountDao accountDao = sqlSession.getMapper(AccountDao.class);
//调用方法
List<Account> list = accountDao.findAccount();
//打印
for (Account account : list) {
System.out.println(account);
}
}
测试结果:
Account{id=1, name=‘aaa’, money=700.0}
Account{id=2, name=‘bbb’, money=1300.0}
Account{id=3, name=‘ccc’, money=1000.0}
Account{id=4, name=‘ddd’, money=1000.0}
Account{id=5, name=‘ddd’, money=2222.0}
spring-mybatis整合
同springmvc与spring整合,service实现类对象扔到了容器中可以在Controller中自动注入,这里也需要将mybatis的dao层中的接口的代理对象扔到容器中,然后再在service中进行注入就可以了(sring与springmvc其实属于类似框架 其配置文件都是在web.xml中加载)
Mybatis在spring配置文件中进行配置并整合(spring被加载Mybatis配置也被加载 可同时将Mybatis的代理对象放入容器)
核心就是将代理对象存入IOC
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"
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.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!--开启spring注解扫描-->
<context:component-scan base-package="com.itcast">
<!--这里会扫描com.itcast下的所有包 但是spring只管业务层service和持久层dao 而表现层controller不会管 交给springMvc-->
<!--type annotation 表示注解类型 Ctrl+N 查找Controller 勾上 包含非项目类选择该注解 复制全限定性类名-->
<context:exclude-filtertype="annotation"expression="org.springframework.stereotype.Controller"/>
</context:component-scan>
<!--配置mybatis 引入的都为类 用Bean标签-->
<!--1.连接池--><!--这里属性名和jdbc模板技术有差异-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql:///spring"/>
<property name="user" value="root"/>
<property name="password" value="root"/>
</bean>
<!--2.配置sqlSession工厂对象-->
<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"><!--该类路径可知是mybatis-spring整合包-->
<property name="dataSource" ref="dataSource"></property><!--引入dataSource-->
</bean><!--也就是该配置加载后创建了sqlSession对象生成了代理对象 并将代理对象放入spring容器中 -->
<!--3.配置AccountDao接口所在的包(映射扫描配置)-->
<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.itcast.dao"/>
</bean>
</beans>
配置之后就不需要单独配置mybatis配置文件了 可将sqlMapperConfig.xml删除
AccountDao
@Repository//这里不要再添加与AccountServiceImpl中的属性名一样的值,否则容器中会有俩个id为accountDao 无法注入
public interface AccountDao {// 持久层只需要写接口 mybatis可以帮助生成代理对象 做实现类需要做的事情
/* 查询所有*/
@Select("select * from account")
public List<Account> findAccount();
/* 保存*/
@Insert("insert into account (name,money) values(#{name},#{money})")
public void saveAccount(Account account);
}
AccountServiceImpl
@Service("accountService")
public class AccountServiceImpl implements AccountService {
@Autowired
private AccountDao accountDao;
@Override
public List<Account> findAccount() {
System.out.println("业务层:查询所有");
List<Account> list = accountDao.findAccount();
return list;
}
@Override
public void saveAccount(Account account) {
accountDao.saveAccount(account);
System.out.println("业务层:保存账户");
}
}
AccountController
@Controller
@RequestMapping("/account")
public class AccountController {
//查询所有
@Autowired
private AccountService accountService;
@RequestMapping("/findAll")
public String findAll(Model model){
List<Account> list = accountService.findAccount();
model.addAttribute("list",list);
System.out.println("控制器访问成功");
return "list";
}
/*保存*/
@RequestMapping("/saveAccount")
public void saveAccount(){
System.out.println("保存成功");
}
}
WEB-INF/pages.list.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %><%--默认忽略el表达式 需要手动更改--%>
<%-- 添加jstl标签库 --%>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core"%>
<html>
<head>
<title>list</title>
</head>
<body>
<h3>spring_mybatis_springMvc</h3>
<c:forEach items="${list}" var="account">
${account.name}
<br>
</c:forEach>
</body>
</html>
index.jsp
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>title</title>
</head>
<body>
<a href="account/findAll">测试</a>
</body>
</html>
Mybatis-spring 配置事务
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"
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.xsd
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd
http://www.springframework.org/schema/aop
http://www.springframework.org/schema/aop/spring-aop.xsd
http://www.springframework.org/schema/tx
http://www.springframework.org/schema/tx/spring-tx.xsd">
<!--开启spring注解扫描-->
<context:component-scan base-package="com.itcast">
<!--这里会扫描com.itcast下的所有包 但是spring只管业务层service和持久层dao 而表现层controller不会管 交给springMvc-->
<!--type annotation 表示注解类型 Ctrl+N 查找Controller 勾上 包含非项目类选择该注解 复制全限定性类名-->
<context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"></context:exclude-filter>
</context:component-scan>
<!--配置mybatis 引入的都为类 用Bean标签-->
<!--1.连接池--><!--这里属性名和jdbc模板技术有差异-->
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="com.mysql.jdbc.Driver"/>
<property name="jdbcUrl" value="jdbc:mysql:///spring"/>
<property name="user" value="root"/>
<property name="password" value="root"/>
</bean>
<!--2.配置sqlSession工厂对象-->
<bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean"><!--该类路径可知是mybatis-spring整合包-->
<property name="dataSource" ref="dataSource"></property><!--引入dataSource-->
</bean><!--也就是该配置加载后创建了sqlSession对象生成了代理对象 并将代理对象放入spring容器中 -->
<!--3.配置AccountDao接口所在的包(映射扫描配置)-->
<bean id="mapperScannerConfigurer" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
<property name="basePackage" value="com.itcast.dao"/>
</bean>
<!--配置spring框架声明式事务管理-->
<!--1.配置事务管理器-->
<bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
<property name="dataSource" ref="dataSource"></property><!--引入连接数据源-->
</bean>
<!--2.配置事务通知-->
<tx:advice id="txAdvice" transaction-manager="dataSourceTransactionManager">
<tx:attributes>
<tx:method name="find*" read-only="true"/><!--配置所有find开头的方法被通知 且为只读-->
<tx:method name="*" isolation="DEFAULT"></tx:method><!--默认隔离级别-->
</tx:attributes>
</tx:advice>
<!--3.配置AOP增强-->
<aop:config>
<!--引入通知-->
<aop:advisor advice-ref="txAdvice" pointcut="execution(* com.itcast.service.impl.*.*(..))"></aop:advisor>
</aop:config>
</beans>
AccountServiceImpl
@Service("accountService")
public class AccountServiceImpl implements AccountService {
@Autowired
private AccountDao accountDao;
@Override
public List<Account> findAccount() {
System.out.println("业务层:查询所有");
List<Account> list = accountDao.findAccount();
return list;
}
@Override
public void saveAccount(Account account) {
accountDao.saveAccount(account);
System.out.println("业务层:保存账户");
}
}
AccountController
@Controller
@RequestMapping("/account")
public class AccountController {
//查询所有
@Autowired
private AccountService accountService;
@RequestMapping("/findAll")
public String findAll(Model model){
List<Account> list = accountService.findAccount();
model.addAttribute("list",list);
System.out.println("控制器访问成功");
return "list";
}
/*保存*/
@RequestMapping("/saveAccount")
public void saveAccount(Account account, HttpServletRequest req, HttpServletResponse res) throws IOException {
accountService.saveAccount(account);
System.out.println("保存成功");
//return "list"; //直接转入list无法展示 必须要走findAll方法
res.sendRedirect(req.getContextPath()+"/account/findAll");
return;
}
}
index.xml
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
<title>title</title>
</head>
<body>
<a href="account/findAll">测试查询</a>
<h3>测试保存</h3>
<form action="/account/saveAccount" method="post">
姓名:<input type="text" name="name"/><br/>
金额:<input type="text" name="money"/><br/>
<input type="submit" value="保存"/><br/>
</form>
</body>
</html>