SSM整合

环境要求

IDEA
MySQL 8.0.12
TomCat9
Maven 3.6

基本环境搭建

配置阿里云Maven镜像

    nexus-aliyun
    central
    Nexus aliyun
    http://maven.aliyun.com/nexus/content/groups/public

创建一个Maven项目

添加JavaWeb的框架支持

pom.xml添加依赖

<?xml version="1.0" encoding="UTF-8"?>

    4.0.0

    groupId
    SpringMvc
    pom
    1.0-SNAPSHOT
    
        
        SpringMvc_03_annotation
        SpringMvc_04_Json
        mzysz
        SSM
    
    
        
            junit
            junit
            4.12
            test
        
        
            org.springframework
            spring-webmvc
            5.1.9.RELEASE
        
        
            javax.servlet
            servlet-api
            2.5
        
        
        
            javax.servlet
            javax.servlet-api
            4.0.1
        
        
            javax.servlet.jsp
            jsp-api
            2.2
        
        
            commons-beanutils
            commons-beanutils
            1.7.0
        
        
            com.google.code.gson
            gson
            2.8.1
        
        
            org.projectlombok
            lombok
            1.16.10
        
        
            org.springframework
            spring-jdbc
            5.1.9.RELEASE
        

        
        
            mysql
            mysql-connector-java
            8.0.21
        

        
        
            com.mchange
            c3p0
            0.9.5.2
        
        
        
            org.mybatis
            mybatis
            3.5.2
        
        
            org.mybatis
            mybatis-spring
            2.0.2
        
        
            javax.servlet
            jstl
            1.2
        
        
            commons-fileupload
            commons-fileupload
            1.4
        
    
    
        
            
                src/main/java
                
                    **/*.properties
                    **/*.xml
                
                false
            
            
                src/main/resources
                
                    **/*.properties
                    **/*.xml
                
                false
            
        
    

MyBatis层

添加数据库配置文件

使用8.0以上的mysql需要添加时区支持
database.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://IP地址/数据库名称?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone=Asia/Shanghai
jdbc.username=数据库用户名
jdbc.password=数据库密码

添加mybatis-config.xml文件

<?xml version="1.0" encoding="UTF-8" ?>


    
    
        
    
    
    
        
    
    
    
        
    

BookMapper.xml编写

<?xml version="1.0" encoding="UTF-8" ?>


    
        insert into ssmbuild.books(bookName,bookCounts,detail)
        values (#{bookName},#{bookCounts},#{detail});
    
    
        delete from ssmbuild.books where bookID = #{bookID}
    

    
        update ssmbuild.books set bookName = #{bookName},bookCounts = #{bookCounts},detail = #{detail}
        where bookID = #{bookID}
    

    

        select * from ssmbuild.books where bookID = #{bookID}
    

    
        select * from ssmbuild.books
    

    
        
        select * from ssmbuild.books where bookName like #{pattern};
    

Spring层

SpringDao层的编写

<?xml version="1.0" encoding="UTF-8"?>

    
    
    
    
        
        
        
        

        
        
        
        
        
        
    
    
    
        
        
    


    
        
        
    

Service层

<?xml version="1.0" encoding="UTF-8"?>


    
    

    
    
    
        
    

    
    
        
        
    

applicationContext.xml编写

<?xml version="1.0" encoding="UTF-8"?>


    
    
    
    
    
    
    
    
    
    
    
    
        
        
    

SpringMVC层

web.xml编写

<?xml version="1.0" encoding="UTF-8"?>

    
    
        springmvc
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:applicationContext.xml
        
        1
    
    
        springmvc
        /
    

    
    
        encodingFliter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            utf-8
        
    
    
        encodingFliter
        /*
    

    
    
        30
    

拦截器

spring-interspector.xml编写

<?xml version="1.0" encoding="UTF-8"?>

    
        
            
            
            
            
            
            
        
    

参考文档
【狂神说Java】SSM框架最新整合教学IDEA版