美文网首页
SSM(Spring+SpringMVC+MyBatis)整合记

SSM(Spring+SpringMVC+MyBatis)整合记

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

    项目结构

    项目结构

    依赖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(Spring+SpringMVC+MyBatis)整合记

          本文链接:https://www.haomeiwen.com/subject/jroapttx.html