SSM（Spring+SpringMVC+MyBatis）整合记

作者: lunatic_z | 来源:发表于2016-11-29 15:36 被阅读0次

SSM框架整合
Spring+Springmvc+Mybatis整合详细教程
项目开发笔记<2>：SSM框架整合
十年架构师，带你初识SSM框架结构，深入开发Java就在今天
SSM(框架集)
SSM（Spring+SpringMVC+MyBatis）整合记
基于SSM实现高并发秒杀Web项目（一）
被华为、阿里等知名4位一线技术专家联手吹爆的SSM实战文档
Spring+SpringMVC+Mybatis整合开发思路及配
学习ssm框架

项目结构

依赖jar包

mybatis 相关

mybatis-3.4.1.jar
mybatis-spring-1.3.0.jar

数据库相关

mysql-connector-java-5.1.18-bin.jar

Spring相关

这里可以全部导入，不做具体描述

JSTL相关

jstl-1.2.jar
standard-1.1.2.jar

日志相关

commons-logging-1.1.1.jar
log4j-1.2.17.jar

整合Spring与MyBatis

创建数据库及相关数据表

create database mybatis;
use mybatis;CREATE TABLE users(
id INT PRIMARY KEY AUTO_INCREMENT, 
NAME VARCHAR(20), 
age INT);
INSERT INTO users(NAME, age) VALUES('Tom', 12);
INSERT INTO users(NAME, age) VALUES('Jack', 11);

编写数据表所对应的实体类User

package entities;

public class User {

    private int id;
    private String name;
    private int age;

    public User() {
        super();
    }

    public User(int id, String name, int age) {
        super();
        this.id = id;
        this.name = name;
        this.age = age;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public int getAge() {
        return age;
    }

    public void setAge(int age) {
        this.age = age;
    }

    @Override
    public String toString() {
        return "User [id=" + id + ", name=" + name + ", age=" + age + "]";
    }

}

编写DAO接口UserDAO

package dao;

import org.springframework.stereotype.Repository;

import entities.User;

@Repository
public interface UserDAO {

    /**
     * 根据用户ID查询用户
     * 
     * @param id
     * @return
     */
    public User getUser(int id);

}

编写映射文件userMapper.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="dao.UserDAO">
    <!-- 
        id: 标识SQL语句
        parameterType: 输入的查询参数的类型
        resultType: 结果类型
     -->
    <select id="getUser" parameterType="int" 
        resultType="User">
        select * from users where id=#{id}
    </select>
</mapper>

编写userService

package service;

import entities.User;

public interface UserService {

    /**
     * 根据id查找用户
     * 
     * @param id
     * @return
     */
    public User getUserByID(int id);

}

编写UserServiceImpl

package service.impl;

import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import dao.UserDAO;
import entities.User;
import service.UserService;

@Service("userService")
public class UserServiceImpl implements UserService {

    @Autowired
    private UserDAO userDao;

    @Override
    public User getUserByID(int id) {
        return this.userDao.getUser(id);
    }

}

编写数据库配置文件db.properties

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

编写配置文件spring-mybatis.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-4.3.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">

    <!-- 配置自动扫描的包 -->
    <context:component-scan base-package="dao,service"></context:component-scan>

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

    <!-- 配置数据源 -->  
    <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource">
        <property name="driverClassName" value="${jdbc.driver}"></property>
        <property name="url" value="${jdbc.url}"></property>
        <property name="username" value="${jdbc.username}"></property>
        <property name="password" value="${jdbc.password}"></property>
    </bean>

    <!-- 配置SQLSessionFactory对象 -->
    <bean id="sqlSessionFactory" class="org.mybatis.spring.SqlSessionFactoryBean">
        <property name="dataSource" ref="dataSource"></property>
        <property name="typeAliasesPackage" value="entities"></property>
        <property name="mapperLocations" value="classpath:mapper/*.xml"></property>
    </bean>
    
    <!-- 配置扫描Dao接口包 -->
    <bean class="org.mybatis.spring.mapper.MapperScannerConfigurer">
        <property name="sqlSessionFactoryBeanName" value="sqlSessionFactory"></property>
        <property name="basePackage" value="dao"></property>
    </bean>

</beans>

编写log4j.properties

log4j.rootLogger=info, console, log, error

###Console ###
log4j.appender.console = org.apache.log4j.ConsoleAppender
log4j.appender.console.Target = System.out
log4j.appender.console.layout = org.apache.log4j.PatternLayout
log4j.appender.console.layout.ConversionPattern = %d %p[%C:%L]- %m%n

### log ###
log4j.appender.log = org.apache.log4j.DailyRollingFileAppender
log4j.appender.log.File = ${catalina.base}/logs/debug.log
log4j.appender.log.Append = true
log4j.appender.log.Threshold = DEBUG
log4j.appender.log.DatePattern='.'yyyy-MM-dd
log4j.appender.log.layout = org.apache.log4j.PatternLayout
log4j.appender.log.layout.ConversionPattern = %d %p[%c:%L] - %m%n


### Error ###
log4j.appender.error = org.apache.log4j.DailyRollingFileAppender
log4j.appender.error.File = ${catalina.base}/logs/error.log
log4j.appender.error.Append = true
log4j.appender.error.Threshold = ERROR 
log4j.appender.error.DatePattern='.'yyyy-MM-dd
log4j.appender.error.layout = org.apache.log4j.PatternLayout
log4j.appender.error.layout.ConversionPattern =%d %p[%c:%L] - %m%n

###\u8F93\u51FASQL
log4j.logger.com.ibatis=DEBUG
log4j.logger.com.ibatis.common.jdbc.SimpleDataSource=DEBUG
log4j.logger.com.ibatis.common.jdbc.ScriptRunner=DEBUG
log4j.logger.com.ibatis.sqlmap.engine.impl.SqlMapClientDelegate=DEBUG
log4j.logger.java.sql.Connection=DEBUG
log4j.logger.java.sql.Statement=DEBUG
log4j.logger.java.sql.PreparedStatement=DEBUG

Spring与MyBatis整合结束，编写测试类

package test;

import org.junit.Test;
import org.junit.runner.RunWith;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.test.context.ContextConfiguration;
import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import entities.User;
import service.UserService;

@RunWith(SpringJUnit4ClassRunner.class)
@ContextConfiguration(locations = { "classpath:resources/spring-mybatis.xml" })
public class SMTest {

    @Autowired
    private UserService userService;

    @Test
    public void test() {
        User user = userService.getUserByID(1);
        System.out.println(user);
    }

}

测试截图

测试Sping整合MyBatis的结果

继续整合SpringMVC

编写控制器UserController

package controller;

import java.util.Map;

import org.apache.ibatis.annotations.Param;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;

import entities.User;
import service.UserService;

@RequestMapping("/")
@Controller
public class UserController {

    private static final String SUCCESS = "success";

    @Autowired
    private UserService userService;

    @RequestMapping(value = "user", method = RequestMethod.GET)
    public String showUser(@Param(value = "id") Integer id, Map<String, Object> map) {
        User user = userService.getUserByID(id);
        map.put("user", user);
        return SUCCESS;
    }
}

编写配置文件spring-mvc.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:c="http://www.springframework.org/schema/c"
    xmlns:context="http://www.springframework.org/schema/context"
    xmlns:mvc="http://www.springframework.org/schema/mvc"
    xmlns:p="http://www.springframework.org/schema/p"
    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-4.3.xsd
        http://www.springframework.org/schema/mvc http://www.springframework.org/schema/mvc/spring-mvc-4.3.xsd">

    <!-- 配置自动扫描的包 -->
    <context:component-scan base-package="controller"></context:component-scan>
    
    <!-- 配置视图解析器 -->
    <bean class="org.springframework.web.servlet.view.InternalResourceViewResolver">
        <property name="prefix" value="/WEB-INF/views/"></property>
        <property name="suffix" value=".jsp"></property>
    </bean>

</beans>

编写web.xml

<?xml version="1.0" encoding="UTF-8"?>
<web-app xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://xmlns.jcp.org/xml/ns/javaee" xsi:schemaLocation="http://xmlns.jcp.org/xml/ns/javaee http://xmlns.jcp.org/xml/ns/javaee/web-app_3_1.xsd" id="WebApp_ID" version="3.1">
    
    <!-- 配置文件 -->
    <context-param>  
        <param-name>contextConfigLocation</param-name>  
        <param-value>classpath:resources/spring-*.xml</param-value>  
    </context-param>
    
    <!--Spring的ApplicationContext 载入：Spring的监听器 -->

    <listener>
        <listener-class>
            org.springframework.web.context.ContextLoaderListener
        </listener-class>
    </listener>

    <!-- 编码过滤器 -->
    <filter>  
        <filter-name>encodingFilter</filter-name>  
        <filter-class>org.springframework.web.filter.CharacterEncodingFilter</filter-class>  
        <async-supported>true</async-supported>  
        <init-param>  
            <param-name>encoding</param-name>  
            <param-value>UTF-8</param-value>  
        </init-param>  
    </filter>  
    <filter-mapping>  
        <filter-name>encodingFilter</filter-name>  
        <url-pattern>/*</url-pattern>  
    </filter-mapping>

    <!-- The front controller of this Spring Web application, responsible for handling all application requests -->
    <servlet>
        <servlet-name>springDispatcherServlet</servlet-name>
        <servlet-class>org.springframework.web.servlet.DispatcherServlet</servlet-class>
        <init-param>
            <param-name>contextConfigLocation</param-name>
            <param-value>classpath:resources/spring-mvc.xml</param-value>
        </init-param>
        <load-on-startup>1</load-on-startup>
    </servlet>

    <!-- Map all requests to the DispatcherServlet for handling -->
    <servlet-mapping>
        <servlet-name>springDispatcherServlet</servlet-name>
        <url-pattern>/</url-pattern>
    </servlet-mapping>
  
</web-app>

编写测试页面index.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title>Index</title>
    </head>
    <body>
        <form action="<%=request.getContextPath()%>/user" method="get"> 
            id: <input type="text" name="id" />
            <input type="submit" value="Search" />
        </form>
    </body>
</html>

编写结果显示页面success.jsp

<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<!DOCTYPE html>
<html>
    <head>
        <meta charset="UTF-8">
        <title>Insert title here</title>
    </head>
    <body>
        <c:if test="${user == null }">
            <h4>没有该用户</h4>
        </c:if>
        <c:if test="${user != null }">
            <h4>用户信息</h4>
            <p>ID: ${user.id }</p>
            <p>Name: ${user.name }</p>
            <p>Age: ${user.age }</p>
        </c:if>
    </body>
</html>

测试结果截图

测试界面1

测试界面2

至此，基本的SSM框架整合完毕

SSM框架整合
SSM框架整合 SSM（Spring+SpringMVC+MyBatis）框架集由Spring、MyBatis两个...
Spring+Springmvc+Mybatis整合详细教程
比较详细的一篇SSM整合文章Spring+Springmvc+Mybatis整合详细教程[https://www....
项目开发笔记<2>：SSM框架整合
优秀文章博客：shu_lin > SSM框架——详细整合教程（Spring+SpringMVC+MyBatis）...
十年架构师，带你初识SSM框架结构，深入开发Java就在今天
SSM（Spring+SpringMVC+MyBatis）框架集由Spring、MyBatis两个开源框架整合而成...
SSM(框架集)
SSM（Spring+SpringMVC+MyBatis）框架集由Spring、MyBatis两个开源框架整合而成...
SSM（Spring+SpringMVC+MyBatis）整合记
项目结构依赖jar包 mybatis 相关 mybatis-3.4.1.jar mybatis-spring-1...
基于SSM实现高并发秒杀Web项目（一）
整合运用SSM框架，做一个基于Spring+SpringMVC+Mybatis实现的高并发秒杀项目，后面采用red...
被华为、阿里等知名4位一线技术专家联手吹爆的SSM实战文档
SSM简介： SSM（Spring+SpringMVC+MyBatis）框架集由Spring、SpringMVC、...
Spring+SpringMVC+Mybatis整合开发思路及配
前言说起来还是比较有意思的，最近一个同学问我SSM（Spring+SpringMVC+Mybatis）整合开发，...
学习ssm框架
一、什么是ssm框架 SSM全称是Spring+SpringMVC+MyBatis。 SSM框架集由Spring、...