SSM(SpringMVC+Spring+MyBatis)框架的整合

一、SSM框架的整合

需求:借助SSM框架从数据库中查询出所有信息,并将这些信息转发给jsp页面展示
1.创建数据库表

CREATE DATABASE ssm;
USE ssm; 
CREATE TABLE account( 
   id INT PRIMARY KEY AUTO_INCREMENT, 
   NAME VARCHAR(20),  
   money DOUBLE 
)

2.创建maven项目,导入pom依赖

<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>
  <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 -->
  <dependency>
    <groupId>org.aspectj</groupId>
    <artifactId>aspectjweaver</artifactId>
    <version>1.6.8</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>

  <!-- 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 -->
  <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.0</version>
  </dependency>

  <dependency>
    <groupId>c3p0</groupId>
    <artifactId>c3p0</artifactId>
    <version>0.9.1.2</version>
    <type>jar</type>
    <scope>compile</scope>
  </dependency>
  <dependency>
    <groupId>org.projectlombok</groupId>
    <artifactId>lombok</artifactId>
    <version>1.18.12</version>
    <scope>compile</scope>
  </dependency>

3.分别编写pojo实体类、dao接口、service接口和实现类

pojo实体类

package com.bianyiit.pojo;

import lombok.Data;

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

dao接口

package com.bianyiit.dao;

import com.bianyiit.pojo.Account;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface AccountDao {
    /*查询所有用户*/
    @Select("select * from account")
    List<Account> findAll();

    /*新增用户*/
    @Insert("insert into account(name,money) values(#{name},#{money})")
    void saveAccount(Account account);
}

service接口

package com.bianyiit.service;

import com.bianyiit.pojo.Account;

import java.util.List;

public interface AccountService {
    List<Account> findAll();
    void saveAccount(Account account);
}

service实现类

package com.bianyiit.service.impl;

import com.bianyiit.dao.AccountDao;
import com.bianyiit.pojo.Account;
import com.bianyiit.service.AccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class AccountServiceImpl implements AccountService {

    @Autowired
    private AccountDao accountDao;

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

    @Override
    public void saveAccount(Account account) {

    }
}

4.搭建spring环境,在resources下面添加一个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.bianyiit">
        <!--配置哪些注解不扫描-->
        <context:exclude-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>
    <!--配置连接池数据源-->
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql:///ssm" />
        <property name="username" value="root" />
        <property name="password" value="123" />
    </bean>
    <!--配置平台事务管理器-->
    <bean id="dataSourceTransactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
        <property name="dataSource" ref="dataSource"></property>
    </bean>
    <!--使用aop增强开启声明式事务-->
    <tx:advice id="txAdvice" transaction-manager="dataSourceTransactionManager">
        <tx:attributes>
            <!--只读事务-->
            <tx:method name="findAll" read-only="true"/>
            <tx:method name="*" isolation="DEFAULT"></tx:method>
        </tx:attributes>
    </tx:advice>
    <aop:config>
        <aop:advisor advice-ref="txAdvice" pointcut="execution(* com.bianyiit.service.impl.AccountServiceImpl.saveAccount(..))"></aop:advisor>
    </aop:config>
    <!--spring整合mybatis只需要配置数据源、sqlsession工厂、配置dao扫描-->
    <!-- 配置SqlSession的工厂 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <!--通过连接池构建Session工厂-->
        <property name="dataSource" ref="dataSource" />
    </bean>
    <!-- 配置扫描dao的包 -->
    <bean id="mapperScanner" class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="basePackage" value="com.bianyiit.dao"/>
    </bean>
</beans>

5.搭建springmvc环境,在resources下创建springmvc.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.xsd http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc.xsd">
    <!-- 扫描controller的注解,别的不扫描 -->
    <context:component-scan base-package="com.bianyiit">
        <context:include-filter type="annotation" expression="org.springframework.stereotype.Controller"/>
    </context:component-scan>

    <!-- 配置视图解析器 -->
    <bean id="viewResolver" class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <!-- JSP文件所在的目录 -->
        <property name="prefix" value="/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/**" />
    <!-- 开启对SpringMVC注解的支持 -->
    <mvc:annotation-driven/>
</beans>

6.在webapp/WEB-INF/web.xml中配置前端控制器,初始化Spring的IOC容器

<!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>
  <!-- 配置加载类路径的配置文件 -->
  <context-param>
    <param-name>contextConfigLocation</param-name>
    <param-value>classpath:applicationContext.xml</param-value>
  </context-param>
  <!-- 配置Spring的监听器:ContextLoaderListener监听器的作用就是启动Web容器时,自动装配ApplicationContext的配置信息-->
  <listener>
    <listener-class>org.springframework.web.context.ContextLoaderListener</listener-class>
  </listener>
  <!-- 配置前端控制器:服务器启动必须加载,需要加载springmvc.xml配置文件 -->
  <servlet>
    <servlet-name>dispatcherServlet</servlet-name>
    <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
    <!-- 配置初始化参数,创建完DispatcherServlet对象,加载springmvc.xml配置文件 -->
    <init-param>
      <param-name>contextConfigLocation</param-name>
      <param-value>classpath:springmvc.xml</param-value>
    </init-param>
    <!-- 服务器启动的时候,让DispatcherServlet对象创建 -->
    <load-on-startup>1</load-on-startup>
  </servlet>
  <servlet-mapping>
    <servlet-name>dispatcherServlet</servlet-name>
    <url-pattern>/</url-pattern>
  </servlet-mapping>
</web-app>

7.在web层创建AccountController

package com.bianyiit.web;

import com.bianyiit.pojo.Account;
import com.bianyiit.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 java.util.List;

@Controller
@RequestMapping("/account")
public class AccountController {

    @Autowired
    private AccountService accountService;

    @RequestMapping("/findAll")
    public String findAll(Model model){
        List<Account> list = accountService.findAll();
        model.addAttribute("list",list);
        return "list";
    }
}

8.在webapp目录下创建index.jsp,记住要开启对EL表达式的支持

<%@ page contentType="text/html;charset=UTF-8" language="java" isELIgnored="false" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
    <a href="/account/findAll">查询所有用户信息</a>
</body>
</html>

9.在webapp目录下创建一个pages目录,在该目录下创建list.jsp界面

<%@ 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>
    <c:forEach var="list" items="${list}">
        ${list.id}
        ${list.name}
        ${list.money}<br>
    </c:forEach>
</body>
</html>

10.在tomcat上部署该SSM框架项目,查询出所有数据并显示在list.jsp界面中



二、SSM框架加载过程的解析

1.Tomcat加载SSM框架的过程解析

1.启动Tomcat之后,Tomcat会读取webapp/WEB-INF目录下的web.xml配置文件   
	注意:web.xml的加载顺序是:[context-param -> listener -> filter -> servlet ->spring]
2.首先Tomcat会读取web.xml中两个节点<context-param></context-param>和<listener></listener>
3.接着Tomcat会创建一个ServletContext,WEB项目的任意位置都会共享这个ServeltContext(通过ServletContext可以获取项目的虚拟路径、项目发布到tomcat中的磁盘路径、获取文件的MIME类型)
4.然后Tomcat将读取的<context-param></context-param>中的param-name和param-value转换成键值对contextConfigLocation:classpath:applicationContext.xml,然后存放在ServletContext中
5.接着Tomcat会创建<listener></listener>中类的实例,也就是创建监听器对象ContextLoaderListener,这时执行ContextLoaderListener中的初始化方法contextInitialized(),在这个方法里面有一个初始化SpringIOC容器的方法initWebApplicationContext()最后返回一个WebApplicationContext对象

6.接着Tomcat会加载filter标签,在filter中我们配置了编码过滤器CharacterEncodingFilter,并配置了一些参数,其中encoding用来指定编码格式,forceEncoding表示是否强制response的编码格式也是encoding格式

7.接着Tomcat会加载servlet标签,在servlet标签中我们配置了前端控制器DispatcherServlet,并配置初始化参数,创建完DispatcherServlet对象,并载入springmvc.xml配置文件
	注意:ContextLoaderListener载入的是除DispatcherServlet之外的其他的上下文配置文件,而Spring MVC的配置文件是在DispatcherServlet中设置的。
	
8.web.xml配置文件已经走完了,由于加载的顺序是先加载spring的配置文件,然后再加载springmvc的配置文件,因此springmvc的配置的@Controller也是应该属于spring容器管理,所以我们先去applicationContext.xml中查看springIOC容器都配置了一些什么
9.进入applicationContext.xml配置文件中,context:component-scan先开启service,dao包扫描,exclude-filter不开启@Controller注解标识的web包下的类之外的包的注解支持,因为Controller是由springmvc管理的
10.在applicationContext.xml中配置连接池数据源dataSource、配置平台事务管理器dataSourceTransactionManager、配置spring的aop开启声明式事务

11.由于spring需要整合mybatis,所以需要先配置SqlSessionFactoryBean,在这个类中通过sqlsessionFactoryBuilder.build(configuration)得到一个SqlSessionFactoryBean对象
12.然后继续配置MapperScannerConfigurer扫描所有的mybatis里面的mapper接口,然后在MapperScannerConfigurer里面的SqlsessionTemplate中根据传入的SqsessionFactory得到一个sqlsession对象,然后调用内部的getMapper(...)得到mapper接口的具体代理对象,在这之后我们已经不用手写mybatis的启动代码了,直接可以使用对应mapper接口的具体代理对象


13.此时所有applicationContext.xml已经走完,这时已经开启了spring的注解支持,service和dao都可以通过@Service和@Repository注解标识,并且都交给了spring容器管理,而且此时已经启动了mybatis,并且得到了dao包下所有接口的代理对象
14.打开springmvc.xml,打开注解对于Controller的支持,然后在这个配置文件中配置视图解析器,设置静态资源不过滤

2.模拟用户在浏览器中点击“查看所有用户列表”,从数据库取出数据之后放入jsp界面显示的全过程

三、Ajax异步请求结合SSM框架完成对数据的添加操作,然后反馈信息给前端进行界面局部刷新

1.基本的项目框架搭建和上述第一部分的SSM框架的项目环境搭建一致
2.前端html页面如下所示

<html>
<head>
    <title>Title</title>
    <script src="js/jquery-1.11.0.min.js"></script>
    <script>
        $(function () {
            $("#btn_submit").click(function () {
                $.ajax({
                    url:"/account/saveAccount",
                    dataType:"json",
                    type:"post",
                    data:$("#regisForm").serialize(),
                    success:function (data) {
                        $("#MessageStates").html("")
                        for (var i = 0; i < data.data.length ; i++) {
                            var div_msg=data.data[i].id+" "+data.data[i].name+" "+data.data[i].money+"<br>"
                            $("#MessageStates").append(div_msg)
                        }
                    }
                })
            })
        })
    </script>
</head>
<body>
    <a href="/account/findAll">查询所有用户信息</a>
    <form id="regisForm">
        姓名:<input type="text" name="name" id="name">
        金钱:<input type="text" name="money" id="money">
    </form>
    <button id="btn_submit">提交</button>
    <%--添加之后查询数据库的数据显示在下述div中--%>
    <div id="MessageStates"></div>
</body>
</html>

2.后台AccountController

package com.bianyiit.web;

import com.bianyiit.pojo.Account;
import com.bianyiit.pojo.ResultInfo;
import com.bianyiit.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 org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

@Controller
@RequestMapping("/account")
public class AccountController {

    @Autowired
    private AccountService accountService;

    @Autowired
    private ResultInfo resultInfo;

    @RequestMapping(path = "/saveAccount")
    public @ResponseBody ResultInfo saveAccount(Account account){
        Integer add_int = accountService.saveAccount(account);
        if(add_int>0){
            List<Account> accountList = accountService.findAll();
            resultInfo.setFlag(true);
            resultInfo.setData(accountList);
        }else{
            resultInfo.setFlag(false);
            resultInfo.setErrorMsg("添加用户失败");
        }
        return resultInfo;
    }
}

3.resultInfo实体类用来封装操作完成之后的信息

package com.bianyiit.pojo;

import lombok.Data;
import org.springframework.stereotype.Component;

import java.io.Serializable;
/**
 * 用于封装后端返回前端数据对象
 */
@Component
@Data
public class ResultInfo implements Serializable {
    private boolean flag;//后端返回结果正常为true,发生异常返回false
    private Object data;//后端返回结果数据对象
    private String errorMsg;//发生异常的错误消息
}

4.AccountService

package com.bianyiit.service.impl;

import com.bianyiit.dao.AccountDao;
import com.bianyiit.pojo.Account;
import com.bianyiit.service.AccountService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class AccountServiceImpl implements AccountService {

    @Autowired
    private AccountDao accountDao;

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

    @Override
    public Integer saveAccount(Account account) {
        return accountDao.saveAccount(account);
    }
}

5.AccountDao

package com.bianyiit.dao;

import com.bianyiit.pojo.Account;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import java.util.List;

@Repository
public interface AccountDao {
    /*查询所有用户*/
    @Select("select * from account")
    List<Account> findAll();

    /*新增用户*/
    @Insert("insert into account(id,name,money) values(#{id},#{name},#{money})")
    Integer saveAccount(Account account);
}

6.界面结果展示

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值