前言：笔记是参考B站up主遇见狂神说，图片、代码都是哦。因为最近特别喜欢他教的课程，所以就一边跟着学习，一边在blog写笔记~（图片、代码来源狂神说Java，侵权必删！）
狂神说Java学习路线B站网站：https://www.bilibili.com/read/cv5702420

SSM整合：Mybatis层（Model） 1.创建一张表

2.创建maven项目在pom.xml中导入依赖

    4.0.0

    com.ckm
    ssmStudy
    1.0-SNAPSHOT

    
    
        
        
            junit
            junit
            4.12
        
        
        
            mysql
            mysql-connector-java
            5.1.47
        

        
        
            com.mchange
            c3p0
            0.9.5.5
        

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

        
        
            org.mybatis
            mybatis-spring
            2.0.3
        
        
            org.mybatis
            mybatis
            3.5.3
        

        
        
            org.springframework
            spring-webmvc
            5.3.4
        
        
            org.springframework
            spring-jdbc
            5.3.4
        

        
        
            org.projectlombok
            lombok
            1.18.18
        
    

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

3.编写mybatis-config.xml

4.编写applicationContext.xml

5.编写database.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone-Asia/Shanghai
jdbc.username=root
jdbc.password=123456

6.编写pojo实体类Books

package com.ckm.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Books {
    private int bootID;
    private String bookName;
    private int bookCounts;
    private String detail;
}

7.编写dao层

BookMapper接口

package com.ckm.dao;

import com.ckm.pojo.Books;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface BookMapper {
    //增加一本书
    int addBook(Books books);

    //删除一本书
    int deleteBookById(@Param("bookId") int id);

    //更新一本书
    int updateBook(Books books);

    //查询一本书
    Books queryBookById(@Param("bookId")int id);

    //查询全部书
    List queryAllBook();
}

BookMapper.xml

    
        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;
    

8.编写Service层

BookService接口

package com.ckm.service;
import com.ckm.pojo.Books;
import java.util.List;

public interface BookService {
    //增加一本书
    int addBook(Books books);

    //删除一本书
    int deleteBookById(int id);

    //更新一本书
    int updateBook(Books books);

    //查询一本书
    Books queryBookById(int id);

    //查询全部书
    List queryAllBook();
}

BookServiceImpl实现类

package com.ckm.service;

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

import java.util.List;

public class BookServiceImpl implements BookService{

    //service层调用dao层 ： 组合dao
    private BookMapper bookMapper;

    public void setBookMapper(BookMapper bookMapper) {
        this.bookMapper = bookMapper;
    }

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

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

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

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

    public List queryAllBook() {
        return bookMapper.queryAllBook();
    }
}

SSM整合：Spring层 1.编写spring-dao.xml

2.编写spring-service.xml

SSM：SpringMVC层 1.生成web项目

2.编写web.xml

    
    
        springmvc
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:applicationContext.xml
        
        1
    
    
        springmvc
        /
    
    
    
    
        encoding
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            utf-8
        
    
    
        encoding
        /*
    


    
    
        15
    

3.编写spring-mvc.xml

4.在WEB-INF下创建jsp包

以上就完成了SSM三层的整合！！！ SSM：查询书籍功能 1.编写controller

package com.ckm.controller;

import com.ckm.pojo.Books;
import com.ckm.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.List;

@Controller
@RequestMapping("/book")
public class BookController {
    //controller调service层
    @Autowired
    @Qualifier("BookServiceImpl")
    private BookService bookService;

    //查询全部的书籍，并返回到页面
    @RequestMapping("/allBook")
    public String list(Model model){
        List list = bookService.queryAllBook();
        model.addAttribute("list",list);
        return "allBook";
    }
}

2.编写index.jsp、allBook.jsp

index.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>

  
    
    
  
  

  

<%--    进入书籍页面--%>
    进入书籍页面
  

  

allBook.jsp

<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    


书籍展示
${list}

整个项目结构