SSM整合案例

╰半夏微凉° 2022-07-13 13:54 176阅读 0赞

# SSM整合案例 #

@(Spring)\[spring, springmvc, mybatis, ssm整合, Spring\]

*  SSM整合案例
    
     *  导入依赖
     *  创建MyBatis配置文件
     *  创建Spring Dao配置文件
     *  提供数据库配置文件
     *  提供日志配置文件
     *  创建Spring Service配置文件
     *  创建Spring Transaction配置文件
     *  配置webxml
     *  创建Spring MVC配置文件
     *  测试环境是否搭建成功
        
         *  使用MyBatis生成器生成Mapper和POJO
         *  UserService
         *  UserServiceImpl
         *  UserController
         *  listjsp

## 导入依赖 ##

这里使用Maven导入Jar包。

<properties>
            <spring.version>4.2.4.RELEASE</spring.version>
            <mysql.version>5.1.32</mysql.version>
            <dbcp.version>1.4</dbcp.version>
            <mybatis.version>3.3.0</mybatis.version>
            <mybatis-spring.version>1.2.3</mybatis-spring.version>
            <slf4j.version>1.7.5</slf4j.version>
            <javassist.version>3.16.1-GA</javassist.version>
            <cglib.version>2.2.2</cglib.version>
            <junit.version>4.10</junit.version>
            <servlet.version>2.5</servlet.version>
            <jsp.version>2.0</jsp.version>
            <jstl.version>1.2</jstl.version>
        </properties>
        <dependencies>
            
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-webmvc</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-aspects</artifactId>
                <version>${spring.version}</version>
            </dependency>
            <dependency>
                <groupId>org.springframework</groupId>
                <artifactId>spring-orm</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-context-support</artifactId>
                <version>${spring.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>mysql</groupId>
                <artifactId>mysql-connector-java</artifactId>
                <version>${mysql.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>commons-dbcp</groupId>
                <artifactId>commons-dbcp</artifactId>
                <version>${dbcp.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>${mybatis-spring.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.javassist</groupId>
                <artifactId>javassist</artifactId>
                <version>${javassist.version}</version>
            </dependency>
            <dependency>
                <groupId>cglib</groupId>
                <artifactId>cglib</artifactId>
                <version>${cglib.version}</version>
            </dependency>
    
            
            <dependency>
                <groupId>junit</groupId>
                <artifactId>junit</artifactId>
                <version>${junit.version}</version>
                <scope>test</scope>
            </dependency>
    
            
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>servlet-api</artifactId>
                <version>${servlet.version}</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jsp-api</artifactId>
                <version>${jsp.version}</version>
                <scope>provided</scope>
            </dependency>
            <dependency>
                <groupId>javax.servlet</groupId>
                <artifactId>jstl</artifactId>
                <version>${jstl.version}</version>
            </dependency>
        </dependencies>

## 创建MyBatis配置文件 ##

文件放在classpath目录下，文件名为：`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>
        
    </configuration>

## 创建Spring Dao配置文件 ##

文件放在classpath目录下，文件名为：`applicationContext_dao.xml`

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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/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:property-placeholder location="classpath:db.properties" />
        
        <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
            <property name="driverClassName" value="${jdbc.driver}" />
            <property name="url" value="${jdbc.url}" />
            <property name="username" value="${jdbc.username}" />
            <property name="password" value="${jdbc.password}" />
            <property name="maxActive" value="10" />
            <property name="maxIdle" value="5" />
        </bean>
    
        
        
        <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
            
            <property name="dataSource" ref="dataSource" />
            
            <property name="configLocation" value="classpath:SqlMapConfig.xml" />
        </bean>
    
        
        
        <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
            <property name="basePackage" value="com.pc.ssm.dao" />
        </bean>
    </beans>

## 提供数据库配置文件 ##

文件放在classpath目录下，文件名为：`db.properties`

jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost/myssm?useUnicode=true&characterEncoding=utf8
    jdbc.username=root
    jdbc.password=123456

## 提供日志配置文件 ##

文件放在classpath目录下，文件名为：`log4j.properties`

# Global logging configuration
    log4j.rootLogger=DEBUG, stdout
    # Console output...
    log4j.appender.stdout=org.apache.log4j.ConsoleAppender
    log4j.appender.stdout.layout=org.apache.log4j.PatternLayout
    log4j.appender.stdout.layout.ConversionPattern=%5p [%t] - %m%n

## 创建Spring Service配置文件 ##

文件放在classpath目录下，文件名为：`applicationContext_service.xml`

## 创建Spring Transaction配置文件 ##

文件放在classpath目录下，文件名为：`applicationContext_transaction.xml`

<?xml version="1.0" encoding="UTF-8"?>
    <beans xmlns="http://www.springframework.org/schema/beans" xmlns:context="http://www.springframework.org/schema/context" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" 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/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">
    
        
        <bean id="transactionManager" class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
            
            <property name="dataSource" ref="dataSource" />
        </bean>
    
        
        <tx:advice id="txAdvice" transaction-manager="transactionManager">
            <tx:attributes>
                
                <tx:method name="save*" propagation="REQUIRED" />
                <tx:method name="insert*" propagation="REQUIRED" />
                <tx:method name="delete*" propagation="REQUIRED" />
                <tx:method name="update*" propagation="REQUIRED" />
                <tx:method name="find*" propagation="SUPPORTS" read-only="true" />
                <tx:method name="get*" propagation="SUPPORTS" read-only="true" />
            </tx:attributes>
        </tx:advice>
    
        
        <aop:config>
            <aop:pointcut expression="execution(* com.pc.ssm.service.*.*(..))" id="txPointcut"/>
            <aop:advisor advice-ref="txAdvice" pointcut-ref="txPointcut" />
        </aop:config>
    </beans>

## 配置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" version="2.5">
        <display-name>SSMIntegrationDemo</display-name>
        <welcome-file-list>
            <welcome-file>index.jsp</welcome-file>
            <welcome-file>index.html</welcome-file>
        </welcome-file-list>
        
        <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>
    
        
        <servlet>
            <servlet-name>springmvc</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>10</load-on-startup>
        </servlet>
        <servlet-mapping>
            <servlet-name>springmvc</servlet-name>
            <url-pattern>*.action</url-pattern>
        </servlet-mapping>
    </web-app>

## 创建Spring MVC配置文件 ##

<?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/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.pc.ssm.web.controller" />
    
        
        <mvc:annotation-driven />
    
        
        <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
            
            <property name="viewClass" value="org.springframework.web.servlet.view.JstlView" />
            
            <property name="prefix" value="/WEB-INF/jsp/" />
            
            <property name="suffix" value=".jsp" />
        </bean>
    </beans>

## 测试环境是否搭建成功 ##

### 使用MyBatis生成器生成Mapper和POJO ###

使用`mybatis-generator-core.jar`生成`UserMapper.java`、`UserMapper.xml`、`User.java`、`UserExample.java`。

PS：怎么生成Mapper和POJO可以自行搜索。

### UserService ###

package com.pc.ssm.service;
    
    import java.util.List;
    
    import com.pc.ssm.pojo.User;
    
    /** * 用户Service层接口 * * @author Switch * @data 2017年1月11日 * @version V1.0 */
    public interface UserService { 
        /** * 获取所有用户信息 * * @return */
        List<User> findAllUser();
    }

### UserServiceImpl ###

package com.pc.ssm.service.impl;
    
    import java.util.List;
    
    import org.springframework.beans.factory.annotation.Autowired;
    import org.springframework.stereotype.Service;
    
    import com.pc.ssm.dao.UserMapper;
    import com.pc.ssm.pojo.User;
    import com.pc.ssm.service.UserService;
    
    /** * 用户Service层接口实现类 * * @author Switch * @data 2017年1月11日 * @version V1.0 */
    @Service
    public class UserServiceImpl implements UserService { 
    
        // 注入用户Mapper
        @Autowired
        private UserMapper userMapper;
    
        @Override
        public List<User> findAllUser() {
            return userMapper.selectByExample(null);
        }
    
    }

### UserController ###

package com.pc.ssm.web.controller;
    
    import java.util.List;
    
    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 com.pc.ssm.pojo.User;
    import com.pc.ssm.service.UserService;
    
    
    /** * 用户控制器 * * @author Switch * @data 2017年1月11日 * @version V1.0 */
    @Controller
    @RequestMapping("/user")
    public class UserController { 
        // 注入用户Service
        @Autowired
        private UserService userService;
    
        @RequestMapping("/list")
        public String list(Model model) {
            List<User> users = userService.findAllUser();
            model.addAttribute("users", users);
            return "list";
        }
    }

### list.jsp ###

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c" %>
    <%@ taglib uri="http://java.sun.com/jsp/jstl/fmt" prefix="fmt"%>
    <!DOCTYPE html>
    <html>
        <head>
            <meta charset="UTF-8">
            <title>用户列表</title>
        </head>
        <body style="margin: 0 auto; width: 800px;"> 
            <form action="${pageContext.request.contextPath}/user/findByCriteria.action" method="post">
                <table width="100%" border=1>
                    <caption>查询条件</caption>
                    <tr>
                        <td><input type="submit" value="查询"/></td>
                    </tr>
                </table>
            </form>
            <table style="width: 88%;" border=1>
                <caption>用户列表</caption>
                <tr>
                    <td>用户编号</td>
                    <td>用户名</td>
                    <td>生日</td>
                    <td>性别</td>
                    <td>地址</td>
                    <td>操作</td>
                </tr>
                <c:forEach items="${users}" var="user">
                    <tr>
                        <td>${user.id}</td>
                        <td>${user.username}</td>
                        <td><fmt:formatDate value="${user.birthday}" pattern="yyyy-MM-dd HH:mm:ss"/></td>
                        <td>
                            <c:choose>
                                <c:when test="${user.sex == 1}">男</c:when>
                                <c:when test="${user.sex == 2}">女</c:when>
                            </c:choose>
                        </td>
                        <td>${user.address}</td>
                        <td><a href="${pageContext.request.contextPath}/user/showEdit.action?id=${user.id}">修改</a></td>
                    </tr>
                </c:forEach>
            </table>
        </body>
    </html>

输入`http://localhost:8080/SSMIntegrationDemo/user/list.action`，如下显示：  
![这里写图片描述][SouthEast]

GitHub：[SSMIntegrationDemo][]

[SouthEast]: /images/20220713/fe947864722a41cdac24f90a0817641f.png
[SSMIntegrationDemo]: https://github.com/Switch-vov/SSMIntegrationDemo/