SSM整合案例（超详细）

小鱼儿 2022-10-30 10:19 196阅读 0赞

### SSM整合案例（超详细） ###

*  环境准备
 *   *  前提须知
     *  创建数据库和表结构
     *  创建 Maven 工程 ssm
     *  导入坐标并建立依赖
     *  编写实体类
     *  编写持久层接口
     *  编写业务层接口
     *  编写业务层实现类
     *  编写 Controller
 *  整合步骤
 *   *  保证 Spring 框架在 web 工程中独立运行
     *   *  第一步：编写 spring 配置文件并导入约束
         *  第二步：使用注解配置业务层
         *  第三步：导入log4j.properties配置文件
         *  第四步：测试 spring 能否独立运行
     *  保证 SpringMVC 在 web 工程中独立运行
     *   *  第一步：在 web.xml 中配置核心控制器（DispatcherServlet）
         *  第二步：编写 SpringMVC 的配置文件
         *  第三步：编写 Controller 和 jsp 页面
         *  第四步：部署tomcat服务器
         *  启动服务器，进行测试
     *  Spring 整合 SpringMVC 的框架
     *   *  第一步：配置监听器实现启动服务创建容器
         *  第二步：在controller中注入service对象，调用service对象的方法进行测试
     *  保证 MyBatis 框架在 web 工程中独立运行
     *   *  第一步：在web项目中编写SqlMapConfig.xml的配置文件，编写核心配置文件
         *  第二步：在AccountDao接口的方法上添加注解，编写SQL语句
         *  第三步：编写测试的方法
     *  Spring 整合 MyBatis 框架
     *   *  第一步：把SqlMapConfig.xml配置文件中的内容配置到applicationContext.xml配置文件中
         *  第二步：在applicationContext.xml配置文件中配置 spring 的事务
         *  第三步：在AccountDao接口中添加@Repository注解
         *  第四步：在service中注入dao对象
         *  第五步：修改 AccountController 代码
         *  第五步：修改 list.jsp 代码，实现显示账户信息
         *  第六步：测试查询
         *  第七步：测试保存

# 环境准备 #

## 前提须知 ##

> **在SSM整合的时候，我们是用Spring框架去整合SpringMVC框架和MyBatis框架。**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70]

## 创建数据库和表结构 ##

create database ssm;
    create table account(
    id int primary key auto_increment,
    name varchar(100),
    money double(7,2)
    );

## 创建 Maven 工程 ssm ##

**目录结构：**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 1]

## 导入坐标并建立依赖 ##

**MyBatis 和 Spring 的版本对应关系**  
![在这里插入图片描述][20210218201838401.png]  
**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.keafmd</groupId>
        <artifactId>ssm</artifactId>
        <version>1.0-SNAPSHOT</version>
        <packaging>war</packaging>
    
        <name>ssm Maven Webapp</name>
        
        <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.2.7.RELEASE</spring.version>
            <slf4j.version>1.7.6</slf4j.version>
            <log4j.version>1.2.12</log4j.version>
            <mysql.version>5.1.49</mysql.version>
            <mybatis.version>3.4.5</mybatis.version>
        </properties>
    
        <dependencies>
            
            <dependency>
                <groupId>org.aspectj</groupId>
                <artifactId>aspectjweaver</artifactId>
                <version>1.9.5</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aop</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-context</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <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>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>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-jdbc</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>4.12</version>
                <scope>compile</scope>
            </dependency>
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
            <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>
            <dependency>
                <groupId>jstl</groupId>
                <artifactId>jstl</artifactId>
                <version>1.2</version>
            </dependency>
            
            <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>
            
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis</artifactId>
                <version>${mybatis.version}</version>
            </dependency>
            <dependency>
                <groupId>org.mybatis</groupId>
                <artifactId>mybatis-spring</artifactId>
                <version>1.3.2</version>
            </dependency>
            <dependency>
                <groupId>c3p0</groupId>
                <artifactId>c3p0</artifactId>
                <version>0.9.1.1</version>
                <type>jar</type>
                <scope>compile</scope>
            </dependency>
        </dependencies>
    
        <build>
            <finalName>ssm</finalName>
            <pluginManagement>
                <plugins>
                    <plugin>
                        <artifactId>maven-clean-plugin</artifactId>
                        <version>3.1.0</version>
                    </plugin>
                    
                    <plugin>
                        <artifactId>maven-resources-plugin</artifactId>
                        <version>3.0.2</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-compiler-plugin</artifactId>
                        <version>3.8.0</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-surefire-plugin</artifactId>
                        <version>2.22.1</version>
                    </plugin>
                    <plugin>
                        <artifactId>maven-war-plugin</artifactId>
                        <version>3.2.2</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：**

package com.keafmd.domain;
    
    import java.io.Serializable;
    
    /** * Keafmd * * @ClassName: Account * @Description: 账户实体类 * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:03 */
    public class Account implements Serializable { 
    
        private Integer id;
        private String name;
        private Double money;
    
        public Integer getId() { 
            return id;
        }
    
        public void setId(Integer id) { 
            this.id = id;
        }
    
        public String getName() { 
            return name;
        }
    
        public void setName(String name) { 
            this.name = name;
        }
    
        public Double getMoney() { 
            return money;
        }
    
        public void setMoney(Double money) { 
            this.money = money;
        }
    
        @Override
        public String toString() { 
            return "Account{" +
                    "id=" + id +
                    ", name='" + name + '\'' +
                    ", money=" + money +
                    '}';
        }
    }

## 编写持久层接口 ##

package com.keafmd.dao;
    
    import com.keafmd.domain.Account;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Select;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    /** * Keafmd * * @ClassName: AccountDao * @Description: 账户dao接口 * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:05 */
    public interface AccountDao { 
    
        //查询所有账户
        public List<Account> findAll();
    
        //保存账户
        public void saveAccount(Account account);
    
    }

## 编写业务层接口 ##

package com.keafmd.service;
    import com.keafmd.domain.Account;
    import java.util.List;
    
    /** * Keafmd * * @ClassName: AccountService * @Description: * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:15 */
    
    public interface AccountService { 
    
        //查询所有账户
        public List<Account> findAll();
    
        //保存账户
        public void saveAccount(Account account);
    
    }

## 编写业务层实现类 ##

package com.keafmd.service.impl;
    
    import com.keafmd.dao.AccountDao;
    import com.keafmd.domain.Account;
    import com.keafmd.service.AccountService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    /** * Keafmd * * @ClassName: AccountServiceImpl * @Description: 账户的业务层实现类 * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:16 */
    public class AccountServiceImpl implements AccountService { 
    
        @Override
        public List<Account> findAll() { 
            System.out.println("业务层，查询所有。。。");
            return null;
        }
    
        @Override
        public void saveAccount(Account account) { 
            System.out.println("业务层，保存账户。。。");
        }
    }

## 编写 Controller ##

package com.keafmd.controller;
    
    /** * Keafmd * * @ClassName: AccountController * @Description: 账户控制器 web * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:19 */
    public class AccountController { 
    
    }

# 整合步骤 #

## 保证 Spring 框架在 web 工程中独立运行 ##

### 第一步：编写 spring 配置文件并导入约束 ###

**applicationContext.xml：**

### 第二步：使用注解配置业务层 ###

**AccountServiceImpl：**

package com.keafmd.service.impl;
    
    import com.keafmd.dao.AccountDao;
    import com.keafmd.domain.Account;
    import com.keafmd.service.AccountService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    /** * Keafmd * * @ClassName: AccountServiceImpl * @Description: 账户的业务层实现类 * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:16 */
    @Service("accountService")
    public class AccountServiceImpl implements AccountService { 
    
    
        @Override
        public List<Account> findAll() { 
            System.out.println("业务层，查询所有。。。");
            return null;
        }
    
        @Override
        public void saveAccount(Account account) { 
            System.out.println("业务层，保存账户。。。");
        }
    }

### 第三步：导入log4j.properties配置文件 ###

# Set root category priority to INFO and its only appender to CONSOLE.
    #log4j.rootCategory=INFO, CONSOLE            debug   info   warn error fatal
    log4j.rootCategory=info, CONSOLE, LOGFILE
    
    # Set the enterprise logger category to FATAL and its only appender to CONSOLE.
    log4j.logger.org.apache.axis.enterprise=FATAL, CONSOLE
    
    # CONSOLE is set to be a ConsoleAppender using a PatternLayout.
    log4j.appender.CONSOLE=org.apache.log4j.ConsoleAppender
    log4j.appender.CONSOLE.layout=org.apache.log4j.PatternLayout
    log4j.appender.CONSOLE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n
    
    # LOGFILE is set to be a File appender using a PatternLayout.
    log4j.appender.LOGFILE=org.apache.log4j.FileAppender
    log4j.appender.LOGFILE.File=d:\axis.log
    log4j.appender.LOGFILE.Append=true
    log4j.appender.LOGFILE.layout=org.apache.log4j.PatternLayout
    log4j.appender.LOGFILE.layout.ConversionPattern=%d{ISO8601} %-6r [%15.15t] %-5p %30.30c %x - %m\n

### 第四步：测试 spring 能否独立运行 ###

**测试代码：**

package com.keafmd.test;
    
    import com.keafmd.service.AccountService;
    import org.junit.Test;
    import org.springframework.context.ApplicationContext;
    import org.springframework.context.support.ClassPathXmlApplicationContext;
    
    /** * Keafmd * * @ClassName: TestSpring * @Description: 测试类 * @author: 牛哄哄的柯南 * @date: 2021-02-17 22:37 */
    public class TestSpring { 
    
        @Test
        public void run1(){ 
            //加载配置文件
            ApplicationContext ac = new ClassPathXmlApplicationContext("classpath:applicationContext.xml");
            //获取对象
            AccountService as = (AccountService)ac.getBean("accountService");
            //调用方法
            as.findAll();
    
        }
    }

**运行结果：**

业务层，查询所有。。。
    
    Process finished with exit code 0

## 保证 SpringMVC 在 web 工程中独立运行 ##

### 第一步：在 web.xml 中配置核心控制器（DispatcherServlet） ###

**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>
    
        
        <servlet>
            <servlet-name>dispatcherServlet</servlet-name>
            <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
            
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:springmvc.xml</param-value>
            </init-param>
            
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>dispatcherServlet</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    
        
        <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>
    
    </web-app>

### 第二步：编写 SpringMVC 的配置文件 ###

**springmvc.xml：**

<?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">
    
        
        <context:component-scan base-package="com.keafmd">
            <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
        
        <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            
            <property name="prefix" value="/WEB-INF/pages/"/>
            
            <property name="suffix" value=".jsp"/>
        </bean>
    
        
        <mvc:resources location="/css/" mapping="/css/**"/>
        <mvc:resources location="/images/" mapping="/images/**"/>
        <mvc:resources location="/js/" mapping="/js/**"/>
    
        
        <mvc:annotation-driven/>
    
    </beans>

### 第三步：编写 Controller 和 jsp 页面 ###

**index.jsp：**

**AccountController：**

**list.jsp：**

### 第四步：部署tomcat服务器 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 2]

### 启动服务器，进行测试 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 3]  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 4]  
**控制台输出：**

表现层，查询所有账户信息。。。

## Spring 整合 SpringMVC 的框架 ##

> **目的：在controller中能成功的调用service对象中的方法。**

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 5]

### 第一步：配置监听器实现启动服务创建容器 ###

**在web.xml添加监听器：**

<listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>
    
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>

**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>
    
        
        <listener>
            <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
        </listener>
        
        <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>
            
            <init-param>
                <param-name>contextConfigLocation</param-name>
                <param-value>classpath:springmvc.xml</param-value>
            </init-param>
            
            <load-on-startup>1</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>dispatcherServlet</servlet-name>
            <url-pattern>/</url-pattern>
        </servlet-mapping>
    
        
        <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>
    
    </web-app>

### 第二步：在controller中注入service对象，调用service对象的方法进行测试 ###

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 3]  
**运行结果：**  
**控制台输出：**

表现层，查询所有账户信息。。。
    业务层，查询所有。。。

## 保证 MyBatis 框架在 web 工程中独立运行 ##

### 第一步：在web项目中编写SqlMapConfig.xml的配置文件，编写核心配置文件 ###

**SqlMapConfig.xml：**

<?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>
        
        <properties resource="jdbcConfig.properties"></properties>
        
        <environments default="mysql">
            <environment id="mysql">
                
                <transactionManager type="JDBC"></transactionManager>
                <dataSource type="pooled">
                    <property name="driver" value="${jdbc.driver}"/>
                    <property name="url" value="${jdbc.url}"/>
                    <property name="username" value="${jdbc.username}"/>
                    <property name="password" value="${jdbc.password}"/>
                </dataSource>
            </environment>
        </environments>
    
        
        <mappers>
            
            <package name="com.keafmd.dao"/>
        </mappers>
    </configuration>

**jdbcConfig.properties：**

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/ssm
    jdbc.username=root
    jdbc.password=root

### 第二步：在AccountDao接口的方法上添加注解，编写SQL语句 ###

package com.keafmd.dao;
    
    import com.keafmd.domain.Account;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Select;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    /** * Keafmd * * @ClassName: AccountDao * @Description: 账户dao接口 * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:05 */
    public interface AccountDao { 
    
        //查询所有账户
        @Select("select * from account")
        public List<Account> findAll();
    
        //保存账户
        @Insert("insert into account(name,money) values(#{name},#{money})")
        public void saveAccount(Account account);
    
    }

### 第三步：编写测试的方法 ###

**TestMybatis：**

package com.keafmd.test;
    
    import com.keafmd.dao.AccountDao;
    import com.keafmd.domain.Account;
    import org.apache.ibatis.io.Resources;
    import org.apache.ibatis.session.SqlSession;
    import org.apache.ibatis.session.SqlSessionFactory;
    import org.apache.ibatis.session.SqlSessionFactoryBuilder;
    import org.junit.After;
    import org.junit.Before;
    import org.junit.Test;
    
    import java.io.InputStream;
    import java.util.List;
    
    
    /** * Keafmd * * @ClassName: TestMybatis * @Description: 测试Mybatis * @author: 牛哄哄的柯南 * @date: 2021-02-18 16:37 */
    public class TestMybatis { 
    
        private InputStream in;
        private SqlSessionFactory factory;
        private SqlSession session;
        private AccountDao accountDao;
    
        @Before
        public void init() throws Exception{ 
            //加载配置文件
            in = Resources.getResourceAsStream("SqlMapConfig.xml");
            //创建SqlSessionFactory对象
            factory = new SqlSessionFactoryBuilder().build(in);
            //创建SqlSession对象
            session = factory.openSession();
            //获取到代理对象
            accountDao = session.getMapper(AccountDao.class);
        }
    
        @After
        public void destory() throws Exception{ 
            session.commit();
            session.close();
            in.close();
        }
    
        /** * 查询所有 */
        @Test
        public void run1(){ 
            List<Account> accounts = accountDao.findAll();
            for (Account account : accounts) { 
                System.out.println(account);
            }
        }
    
        /** * 测试保存 */
        @Test
        public void saveAccount(){ 
            Account account = new Account();
            account.setName("毛利小五郎");
            account.setMoney(800.00);
    // account.setMoney(800d);
    
            accountDao.saveAccount(account);
        }
    }

**运行run1()：**

Account{ id=1, name='keafmd', money=9000.0}
    Account{ id=2, name='小兰', money=8000.0}
    Account{ id=3, name='新一', money=8000.0}
    Account{ id=4, name='毛利小五郎', money=800.0}
    Account{ id=5, name='怪盗基德', money=660.0}
    Account{ id=6, name='某某', money=290.0}
    
    Process finished with exit code 0

## Spring 整合 MyBatis 框架 ##

> **整合思路：把 mybatis 配置文件（SqlMapConfig.xml）中内容配置到 spring 配置文件中同时，把 mybatis 配置文件的内容清掉。**

### 第一步：把SqlMapConfig.xml配置文件中的内容配置到applicationContext.xml配置文件中 ###

**把以下内容添加到applicationContext.xml配置文件中：**

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="com.mysql.jdbc.Driver"/>
        <property name="jdbcUrl" value="jdbc:mysql:///ssm"/>
        <property name="user" value="root"/>
        <property name="password" value="root"/>
    </bean>
    
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"/>
    </bean>
    
    <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.keafmd.dao"/>
    </bean>

> **SqlMapConfig.xml和jdbcConfig.properties可以删除了。**

### 第二步：在applicationContext.xml配置文件中配置 spring 的事务 ###

**把以下内容添加到applicationContext.xml配置文件中：**

<bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    
    <tx:advice id="txAdvice" transaction-manager="transactionManager">
        <tx:attributes>
            <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
            <tx:method name="*" isolation="DEFAULT"/>
        </tx:attributes>
    </tx:advice>
    
    <aop:config>
        
        
        <aop:pointcut expression="execution(* com.keafmd.service.impl.*.*(..))" id="pt1"/>
        
        <aop:advisor advice-ref="txAdvice" pointcut-ref="pt1"/>
    </aop:config>

**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">
    
        
        <context:component-scan base-package="com.keafmd">
            
            <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
        </context:component-scan>
    
        
        
        <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
            <property name="driverClass" value="com.mysql.jdbc.Driver"/>
            <property name="jdbcUrl" value="jdbc:mysql:///ssm"/>
            <property name="user" value="root"/>
            <property name="password" value="18044229"/>
        </bean>
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            <property name="dataSource" ref="dataSource"/>
        </bean>
        
        <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.keafmd.dao"/>
        </bean>
    
        
    
        
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            <property name="dataSource" ref="dataSource"></property>
        </bean>
        
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                <tx:method name="find*" propagation="SUPPORTS" read-only="true"/>
                <tx:method name="*" isolation="DEFAULT"/>
            </tx:attributes>
        </tx:advice>
        
        <aop:config>
            
            
            <aop:pointcut expression="execution(* com.keafmd.service.impl.*.*(..))" id="pt1"/>
            
            <aop:advisor advice-ref="txAdvice" pointcut-ref="pt1"/>
        </aop:config>
    
    
    </beans>

### 第三步：在AccountDao接口中添加@Repository注解 ###

**AccountDao：**

package com.keafmd.dao;
    
    import com.keafmd.domain.Account;
    import org.apache.ibatis.annotations.Insert;
    import org.apache.ibatis.annotations.Select;
    import org.springframework.stereotype.Repository;
    
    import java.util.List;
    
    /** * Keafmd * * @ClassName: AccountDao * @Description: 账户dao接口 * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:05 */
    @Repository
    public interface AccountDao { 
    
        //查询所有账户
        @Select("select * from account")
        public List<Account> findAll();
    
        //保存账户
        @Insert("insert into account(name,money) values(#{name},#{money})")
        public void saveAccount(Account account);
    
    }

### 第四步：在service中注入dao对象 ###

**AccountServiceImpl：**

package com.keafmd.service.impl;
    
    import com.keafmd.dao.AccountDao;
    import com.keafmd.domain.Account;
    import com.keafmd.service.AccountService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import java.util.List;
    
    /** * Keafmd * * @ClassName: AccountServiceImpl * @Description: 账户的业务层实现类 * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:16 */
    @Service("accountService")
    public class AccountServiceImpl implements AccountService { 
    
        @Autowired
        private AccountDao accountDao;
    
        @Override
        public List<Account> findAll() { 
            System.out.println("业务层，查询所有。。。");
            return accountDao.findAll();
        }
    
        @Override
        public void saveAccount(Account account) { 
            System.out.println("业务层，保存账户。。。");
            accountDao.saveAccount(account);
        }
    }

### 第五步：修改 AccountController 代码 ###

package com.keafmd.controller;
    
    import com.keafmd.domain.Account;
    import com.keafmd.service.AccountService;
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Controller;
    import org.springframework.ui.Model;
    import org.springframework.web.bind.annotation.RequestMapping;
    
    import javax.servlet.http.HttpServletRequest;
    import javax.servlet.http.HttpServletResponse;
    import java.io.IOException;
    import java.util.List;
    
    /** * Keafmd * * @ClassName: AccountController * @Description: 账户控制器 web * @author: 牛哄哄的柯南 * @date: 2021-02-17 21:19 */
    @Controller
    @RequestMapping("/account")
    public class AccountController { 
    
        @Autowired
        private AccountService accountService;
    
        /** * 查询所有 * @param model * @return */
        @RequestMapping("/findAll")
        public String findAll(Model model){ 
            System.out.println("表现层，查询所有账户信息。。。");
            //调用service的方法
            List<Account> list = accountService.findAll();
            model.addAttribute("list",list);
            return "list";
        }
    
        /** * 保存 * @param account * @param request * @param response * @throws IOException */
        @RequestMapping("/save")
        public void save(Account account, HttpServletRequest request, HttpServletResponse response) throws IOException { 
            accountService.saveAccount(account);
            response.sendRedirect(request.getContextPath()+"/account/findAll");
            return;
        }
    }

### 第五步：修改 list.jsp 代码，实现显示账户信息 ###

<%--
      Created by IntelliJ IDEA.
      User: Keafmd
      Date: 2021/2/18
      Time: 15:50
      To change this template use File | Settings | File Templates.
    --%>
    <%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
    <%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
    <html>
    <head>
        <title>Title</title>
    </head>
    <body>
    
        <h1>查询所有的账户</h1>
        <%--${ list}--%>
    
        <c:forEach items="${list}" var="account">
            ${ account.name}
            ${ account.money}
        </c:forEach>
    
    </body>
    </html>

### 第六步：测试查询 ###

### 第七步：测试保存 ###

**修改index.jsp代码，添加测试保存的代码：**

<%--
      Created by IntelliJ IDEA.
      User: Keafmd
      Date: 2021/2/17
      Time: 23:20
      To change this template use File | Settings | File Templates.
    --%>
    <%@ page contentType="text/html;charset=UTF-8" language="java" %>
    <html>
    <head>
        <title>Title</title>
    </head>
    <body>
    
        <a href="account/findAll">测试查询</a>
    
        <h1>测试保存</h1>
        <form action="account/save" method="post">
            姓名：<input type="text" name="name" /><br/>
            金额：<input type="text" name="money" /><br/>
            <input type="submit" value="保存">
        </form>
    
    </body>
    </html>

**修改 AccountController 代码，添加save方法：**

**测试结果：**  
![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 7]

![在这里插入图片描述][watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 8]

> **以上就是SSM整合案例（超详细）的全部内容。**

**看完如果对你有帮助，感谢点赞支持！  
如果你是电脑端的话，看到右下角的 “一键三连” 了吗，没错点它\[哈哈\]**  
![在这里插入图片描述][20210115230629703.gif_pic_center]

**加油！**

**共同努力！**

**Keafmd**

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70]: /images/20221024/80efaae9688046f6aa4a0274d02d1b5d.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 1]: /images/20221024/e9c1e4e680ca4df89f91cb6ecd279440.png
[20210218201838401.png]: /images/20221024/24f8f3fac20e4ec487e1afc89907bccd.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 2]: /images/20221024/5f62fd0f8cc34f279f0ccf12222d9cc9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 3]: /images/20221024/6902cd4cdd794325a50c8b92b7dd73ab.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 4]: /images/20221024/cfa68d173ed54345987df27bb08d9520.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 5]: /images/20221024/54b76fc9f25f488c80eeca95cf00a638.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 6]: /images/20221024/1907055003ae4d1690e01c2fcf40e9f8.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 7]: /images/20221024/3b2bdb83e03646c8a3b6068599f07dce.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80Mzg4MzkxNw_size_16_color_FFFFFF_t_70 8]: /images/20221024/2caa6246eba54a239a9d5b713b20dfec.png
[20210115230629703.gif_pic_center]: /images/20221024/a6fc89a5d1844cb18d566514af624d96.png