vlambda
2022-04-09

SSM三大框架集成（Spring+SpringMVC+Mybatis）

SSM项目结构：
1 原始方式集成SSM

1.1 环境搭建

1.1.1 创建数据库、表
1.1.2 创建Maven工程
1.1.3 导入Maven坐标
1.1.4 编写实体类
1.1.6 编写Mapper接口
1.1.7 编写Service接口
1.1.8 编写Service接口实现
1.1.9 编写Controller
1.1.10 webapp下编写添加页面
1.1.10 编写返回展示页面

1.2 编写相应配置文件

1.2.1 数据库连接信息文件：jdbc.properties
1.2.2 日志文件：log4j.xml
1.2.3 MyBatis映射文件：AccountMapper.xml
1.2.4 MyBatis核心文件：sqlMapConfig.xml
1.2.5 Spring配置文件：applicationContext.xml
1.2.6 SprngMVC配置文件：spring-mvc.xml
1.2.7 Web.xml文件：web.xml

1.3 编写逻辑代码

2 Spring整合MyBatis

2.1 整合思路
2.2 将SqlSessionFactory配置到Spring容器中

SSM项目结构：

1 原始方式集成SSM

1.1 环境搭建

1.1.1 创建数据库、表

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

1.1.2 创建Maven工程

1.1.3 导入Maven坐标

<?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>lifeilin</groupId>
    <artifactId>lifeilin_ssm</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>war</packaging>

    <name>lifeilin Maven ssm</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.7</maven.compiler.source>
        <maven.compiler.target>1.7</maven.compiler.target>
    </properties>

    <dependencies>
        <!--spring相关-->
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-context</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.aspectj</groupId>
            <artifactId>aspectjweaver</artifactId>
            <version>1.8.7</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-jdbc</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-tx</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-test</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>
        <dependency>
            <groupId>org.springframework</groupId>
            <artifactId>spring-webmvc</artifactId>
            <version>5.0.5.RELEASE</version>
        </dependency>

        <!--servlet和jsp-->
        <dependency>
            <groupId>javax.servlet</groupId>
            <artifactId>servlet-api</artifactId>
            <version>2.5</version>
        </dependency>
        <dependency>
            <groupId>javax.servlet.jsp</groupId>
            <artifactId>jsp-api</artifactId>
            <version>2.0</version>
        </dependency>

        <!--mybatis相关-->
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis</artifactId>
            <version>3.4.5</version>
        </dependency>
        <dependency>
            <groupId>org.mybatis</groupId>
            <artifactId>mybatis-spring</artifactId>
            <version>1.3.1</version>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.25</version>
        </dependency>
        <dependency>
            <groupId>c3p0</groupId>
            <artifactId>c3p0</artifactId>
            <version>0.9.1.2</version>
        </dependency>

        <dependency>
            <groupId>junit</groupId>
            <artifactId>junit</artifactId>
            <version>4.12</version>
        </dependency>
        <dependency>
            <groupId>jstl</groupId>
            <artifactId>jstl</artifactId>
            <version>1.2</version>
        </dependency>

    </dependencies>

    <build>
        <finalName>itheima_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>

1.1.4 编写实体类

package lifeilin.domain;

public class Account {
    private Integer id;
    private String name;
    private Double money;

    sett/gett...
}

1.1.6 编写Mapper接口

package lifeilin.mapper;

import lifeilin.domain.Account;

import java.util.List;

public interface AccountMapper {
    public void save(Account account);
    public List<Account> findAll();
}

1.1.7 编写Service接口

package lifeilin.service;

import lifeilin.domain.Account;

import java.util.List;

public interface AccountService {
    public void save(Account account);

    public List<Account> findAll();
}

1.1.8 编写Service接口实现

package lifeilin.service.impl;

import lifeilin.domain.Account;
import lifeilin.service.AccountService;

import java.util.List;

public class AccountServiceImpl implements AccountService {

    @Override
    public void save(Account account) {
        
    }

    @Override
    public List<Account> findAll() {
        return null;
    }
}

1.1.9 编写Controller

package lifeilin.controller;

import lifeilin.domain.Account;
import org.springframework.web.servlet.ModelAndView;

public class AccountControl {
    //保存
    public String save(Account account) {
        return null;
    }

    //查询
    public ModelAndView findAll() {
        return null;
    }
}

1.1.10 webapp下编写添加页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<h2>添加账号信息:</h2>
<form name="accountForm" action="${pageContext.request.contextPath}/account/save" method="post">
    账号名称：<input type="text" name="name"><br>
    账号金额：<input type="text" name="money"><br>
    <input type="submit" value="保存"><br>
</form>
</body>
</html>

1.1.10 编写返回展示页面

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<html>
<head>
    <title>返回显示</title>
</head>
<body>
<h1>数据列表</h1>
<table border="1">
    <tr>
        <th>账号id</th>
        <th>账号名称</th>
        <th>账号金额</th>
    </tr>
    <c:forEach items="${accountList}" var="account">
        <tr>
            <td>${account.id}</td>
            <td>${account.name}</td>
            <td>${account.money}</td>
        </tr>
    </c:forEach>
</table>
</body>
</html>

1.2 编写相应配置文件

1.2.1 数据库连接信息文件：jdbc.properties

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

1.2.2 日志文件：log4j.xml

### direct log messages to stdout ###
log4j.appender.stdout=org.apache.log4j.ConsoleAppender
log4j.appender.stdout.Target=System.out
log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
log4j.appender.stdout.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### direct messages to file mylog.log ###
log4j.appender.file=org.apache.log4j.FileAppender
log4j.appender.file.File=c:/mylog.log
log4j.appender.file.layout=org.apache.log4j.PatternLayout
log4j.appender.file.layout.ConversionPattern=%d{ABSOLUTE} %5p %c{1}:%L - %m%n

### set log levels - for more verbose logging change 'info' to 'debug' ###

log4j.rootLogger=all, stdout

1.2.3 MyBatis映射文件：AccountMapper.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="lifeilin.mapper.AccountMapper">
    <insert id="save" parameterType="account">
        insert into account
        values (#{id}, #{name}, #{money})
    </insert>
    <select id="findAll" resultType="account">
        select *
        from account
    </select>
</mapper>

1.2.4 MyBatis核心文件：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>
    <!-- 1 加载properties配置文件-->
    <properties resource="jdbc.properties"></properties>

    <!-- 2 定义别名-->
    <typeAliases>
        <!-- 该包下所有实体都会有别名-->
        <package name="lifeilin.domain"/>
    </typeAliases>

    <!-- 3 数据源环境-->
    <environments default="development">
        <environment id="development">
            <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>

    <!-- 4 加载映射文件-->
    <mappers>
        <package name="lifeilin/mapper"/>
    </mappers>
</configuration>

1.2.5 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:aop="http://www.springframework.org/schema/aop"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xmlns:context="http://www.springframework.org/schema/context"
 xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.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
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">

    <!-- 1 组件扫描 扫描service和mapper，排除controller层-->
    <context:component-scan base-package="lifeilin">
        <!-- 排除controller层-->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
</beans>

1.2.6 SprngMVC配置文件：spring-mvc.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">

    <!-- 1 组件扫描，扫描controller-->
    <context:component-scan base-package="lifeilin.controller"></context:component-scan>
    
    <!-- 2 配置mvc的注解驱动-->
    <mvc:annotation-driven></mvc:annotation-driven>
    
    <!-- 3 内部资源视图解析器-->
    <bean id="resourceViewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/pages/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>
    
    <!-- 4 开放静态资源访问权限-->
    <mvc:default-servlet-handler></mvc:default-servlet-handler>
</beans>

1.2.7 Web.xml文件：web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
 xmlns="http://java.sun.com/xml/ns/javaee"
 xsi:schemaLocation="http://java.sun.com/xml/ns/javaee http://java.sun.com/xml/ns/javaee/web-app_2_5.xsd"
 id="WebApp_ID" version="2.5">
    
    <!-- 1 spring监听器-->
    <context-param>
        <param-name>contextConfigLocation</param-name>
        <param-value>classpath:applicationContext.xml</param-value>
    </context-param>
    <listener>
        <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
    </listener>

    <!-- 2 springMVC的前端控制器-->
    <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:spring-mvc.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>

    <!-- 3 乱码过滤器-->
    <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>

1.3 编写逻辑代码

1）controller层：

@Controller
@RequestMapping("/account")
public class AccountControl {
    @Autowired
    private AccountService accountService;

    //保存
    @RequestMapping(value = "/save", produces = "text/html;charset=UTF-8")
    @ResponseBody   //通过@ResponseBody注解告知SpringMVC框架，方法返回的字符串不是跳转是直接在http响应体中返回。
    public String save(Account account) throws IOException {
        accountService.save(account);
        return "保存成功！！！";
    }

    //查询
    @RequestMapping("/findAll")
    public ModelAndView findAll() throws IOException {
        ModelAndView modelAndView = new ModelAndView();
        List<Account> accountList = accountService.findAll();
        modelAndView.addObject("accountList", accountList);
        modelAndView.setViewName("accountList");
        return modelAndView;
    }
}

2）service层：

@Service("accountService")
public class AccountServiceImpl implements AccountService {

    @Override
    public void save(Account account) throws IOException {
        InputStream resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
        SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
        SqlSession sqlSession = sqlSessionFactory.openSession();
        AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);
        mapper.save(account);
        sqlSession.commit();
        sqlSession.close();
    }

    @Override
    public List<Account> findAll() {
        InputStream resourceAsStream = null;
        try {
            resourceAsStream = Resources.getResourceAsStream("sqlMapConfig.xml");
            SqlSessionFactory sqlSessionFactory = new SqlSessionFactoryBuilder().build(resourceAsStream);
            SqlSession sqlSession = sqlSessionFactory.openSession();
            AccountMapper mapper = sqlSession.getMapper(AccountMapper.class);
            List<Account> accountList = mapper.findAll();
            sqlSession.commit();
            sqlSession.close();
            return accountList;
        } catch (IOException e) {
            e.printStackTrace();
        }
        return null;
    }
}

3）mapper层：

public interface AccountMapper {
    public void save(Account account);
    public List<Account> findAll();
}

2 Spring整合MyBatis

使用原始方式的整合存在的缺点在于service层，每次使用mybatis都要写重复代码：

2.1 整合思路

2.2 将SqlSessionFactory配置到Spring容器中

将【sqlMapConfig.xml】文件中的部分配置转移到【applicationContext.xml】文件中
新的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:aop="http://www.springframework.org/schema/aop"
 xmlns:tx="http://www.springframework.org/schema/tx"
 xmlns:context="http://www.springframework.org/schema/context"
 xsi:schemaLocation="http://www.springframework.org/schema/beans
http://www.springframework.org/schema/beans/spring-beans.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
http://www.springframework.org/schema/context
http://www.springframework.org/schema/context/spring-context.xsd">

    <!-- 1 组件扫描 扫描service和mapper，排除controller层-->
    <context:component-scan base-package="lifeilin">
        <!-- 排除controller层-->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!-- 加载properties配置文件-->
    <context:property-placeholder location="classpath:jdbc.properties"></context:property-placeholder>

    <!-- 配置数据源-->
    <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
        <property name="driverClass" value="${jdbc.driver}"/>
        <property name="jdbcUrl" value="${jdbc.url}"/>
        <property name="user" value="${jdbc.username}"/>
        <property name="password" value="${jdbc.password}"/>
    </bean>

    <!-- 配置sessionFactory-->
    <bean id="sqlSessionFactoryBean" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <!-- 加载mybatis核心文件-->
        <property name="configLocation" value="classpath:sqlMapConfig-spring.xml"></property>
    </bean>

    <!-- 扫描mapper所在的包 为mapper创建实现类-->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="lifeilin.mapper"></property>
    </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="*"/>
        </tx:attributes>
    </tx:advice>
    <!-- 事务的AOP织入-->
    <aop:config>
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* lifeilin.service.impl.*.*(..))"></aop:advisor>
    </aop:config>
</beans>

新的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>
    <!-- 定义别名-->
    <typeAliases>
        <!-- 该包下所有实体都会有别名-->
        <package name="lifeilin.domain"/>
    </typeAliases>

</configuration>

业务层简化的方法：

@Service("accountService")
public class AccountServiceImpl implements AccountService {
    // 直接注入mapper
    @Autowired
    private AccountMapper accountMapper;

    @Override
    public void save(Account account) {
        accountMapper.save(account);
    }

    @Override
    public List<Account> findAll() {
        return accountMapper.findAll();
    }
}

vlambda博客
学习文章列表

SSM三大框架集成（Spring+SpringMVC+Mybatis）

SSM项目结构：

1 原始方式集成SSM

1.1 环境搭建

1.1.1 创建数据库、表

1.1.2 创建Maven工程

1.1.3 导入Maven坐标

1.1.4 编写实体类

1.1.6 编写Mapper接口

1.1.7 编写Service接口

1.1.8 编写Service接口实现

1.1.9 编写Controller

1.1.10 webapp下编写添加页面

1.1.10 编写返回展示页面

1.2 编写相应配置文件

1.2.1 数据库连接信息文件：jdbc.properties

1.2.2 日志文件：log4j.xml

1.2.3 MyBatis映射文件：AccountMapper.xml

1.2.4 MyBatis核心文件：sqlMapConfig.xml

1.2.5 Spring配置文件：applicationContext.xml

1.2.6 SprngMVC配置文件：spring-mvc.xml

1.2.7 Web.xml文件：web.xml

1.3 编写逻辑代码

2 Spring整合MyBatis

2.1 整合思路

2.2 将SqlSessionFactory配置到Spring容器中

标签:

推荐阅读

相关文章

vlambda博客 学习文章列表

SSM三大框架集成（Spring+SpringMVC+Mybatis）

SSM项目结构：

1 原始方式集成SSM

1.1 环境搭建

1.1.1 创建数据库、表

1.1.2 创建Maven工程

1.1.3 导入Maven坐标

1.1.4 编写实体类

1.1.6 编写Mapper接口

1.1.7 编写Service接口

1.1.8 编写Service接口实现

1.1.9 编写Controller

1.1.10 webapp下编写添加页面

1.1.10 编写返回展示页面

1.2 编写相应配置文件

1.2.1 数据库连接信息文件：jdbc.properties

1.2.2 日志文件：log4j.xml

1.2.3 MyBatis映射文件：AccountMapper.xml

1.2.4 MyBatis核心文件：sqlMapConfig.xml

1.2.5 Spring配置文件：applicationContext.xml

1.2.6 SprngMVC配置文件：spring-mvc.xml

1.2.7 Web.xml文件：web.xml

1.3 编写逻辑代码

2 Spring整合MyBatis

2.1 整合思路

2.2 将SqlSessionFactory配置到Spring容器中

标签:

推荐阅读

相关文章

vlambda博客
学习文章列表