整合SSM框架的流程

刚刚学完SSM框架的我们可能对SSM的整合不太了解，对于整合SSM繁多的流程和琐碎的配置感到无力，本文将用一个最简单的例子简洁的说明整合SSM的一个具体流程。
希望能帮到大家更好的理解SSM框架的逻辑关系。

CREATE DATABASE `ssmbuild`;

USE `ssmbuild`;

CREATE TABLE `books`(
`bookID` INT(10) NOT NULL AUTO_INCREMENT COMMENT '书id',
`bookName` VARCHAr(100) NOT NULL COMMENT '书名',
`bookCounts` INT(11) NOT NULL COMMENT '数量',
`detail` VARCHAr(200) NOT NULL COMMENT '描述',
KEY `bookID`(`bookID`)
)ENGINE=INNODB DEFAULT CHARSET=utf8;

INSERT INTO `books`(`bookID`,`bookName`,`bookCounts`,`detail`) VALUES
(1,'Java',1,'从入门到放弃'),
(2,'MySQL',10,'从删库到跑路'),
(3,'Linux',5,'从进门到进牢');

    4.0.0

    com.mao
    ssmbuild
    1.0-SNAPSHOT

    
        15
        15
    


    
        
        
            junit
            junit
            4.12
            test
        


        
            mysql
            mysql-connector-java
            8.0.29
        

        
            com.mchange
            c3p0
            0.9.5.5
        

        
            javax.servlet
            servlet-api
            2.5
        
        
            javax.servlet.jsp
            jsp-api
            2.1
        
        
            javax.servlet.jsp.jstl
            jstl-api
            1.2
        


        
            org.mybatis
            mybatis
            3.5.9
        
        
            org.mybatis
            mybatis-spring
            2.0.7
        


        
            org.springframework
            spring-webmvc
            5.3.21
        

        
            org.springframework
            spring-jdbc
            5.3.20
        

        
            org.projectlombok
            lombok
            1.18.24
        
    

    
    
        
            
                src/main/resources
                
                    ***.xml
                
                true
            
            
                src/main/java
                
                    ***.xml
                
                true
            
        
    

applicationContext.xml

mybatis-config.xml

database.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url = jdbc:mysql://localhost:3306/mybatisdb?useSSL=false&useUnicode=true&characterEncoding=UTF-8 
jdbc.username = ***
jdbc.password = ***

public interface BookMapper {
//    增加一本书
    int addBook(Books books);
//    删除一本书
    int deleteBookById(@Param("bookid") int id);
//    更新一本书
    int updateBook(Books books);
//    查询一本书
    Books queryBookById(@Param("bookid") int id);
//    查询全部的书
    List queryAllBooks();
}

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Books {
    private int bookID;
    private String bookName;
    private int bookcCounts;
    private String detail;
}

mapper绑定接口并编写增删改查(也可以直接用注解)

    
        insert into ssmbuild.books(bookName,BookCounts,detail)
        value (#{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
    

注册mapper

编写接口

public interface BookService {
    //    增加一本书
    int addBook(Books books);
    //    删除一本书
    int deleteBookById( int id);
    //    更新一本书
    int updateBook(Books books);
    //    查询一本书
    Books queryBookById( int id);
    //    查询全部的书
    List queryAllBooks();
}

编写实现类

package com.mao.service;

import com.mao.dao.BookMapper;
import com.mao.pojo.Books;

import java.util.List;


public class BookServicelmpl implements BookService{

//    service 调 dao层 组合Dao
    private BookMapper bookMapper;

    public BookServicelmpl(BookMapper bookMapper) {
        this.bookMapper = bookMapper;
    }

    @Override
    public int addBook(Books books) {
        return bookMapper.addBook(books);
    }

    @Override
    public int deleteBookById(int id) {
        return bookMapper.deleteBookById(id);
    }

    @Override
    public int updateBook(Books books) {
        return bookMapper.updateBook(books);
    }

    @Override
    public Books queryBookById(int id) {
        return bookMapper.queryBookById(id);
    }

    @Override
    public List queryAllBooks() {
        return bookMapper.queryAllBooks();
    }
}

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


    
        encodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            utf-8
        
    

    
        encodingFilter
        /*
    


    
        15
    

@Controller
@RequestMapping("/book")
public class BookController {
//    controller 层调用Service层
    @Autowired
    @Qualifier("BookServiceImpl")
    private BookService bookService;
//    查询全部书籍并返回书记展示页面
    @RequestMapping("/allBook")
    public String list(Model model){

        List books = bookService.queryAllBooks();
        model.addAttribute("list",books);
        return "allBook";
    }
}

到此，一个最简单的SSM逻辑就已经梳理完毕啦！