• 环境配置
• 数据库环境
• 基本环境搭建
• Mybatis层编写
• • 数据库配置文件database.properties
  • 编写Mybatis核心配置文件Mybatis-config.xml
  • 编写数据库对应的实体类com.pag.pojo.Books
  • 编写Mapper接口com.pag.mapper.BookMapper.interface
  • 编写对应的Mapper.xml文件BookMapper.xml
  • 编写Service层的接口和实现类com.pag.service
  • • BookService.interface
    • BookServiceImpl.java
• Spring层
• • 编写Spring整合Mybatis的相关的配置文件； spring-mapper.xml
  • Spring整合service层
• SpringMVC层
• • web.xml
  • spring-mvc.xml
  • Spring配置整合文件，applicationContext.xml
• Controller和视图层编写
• • 查询所有书籍
  • 添加书籍
  • 修改书籍
  • 删除书籍
  • 查询书籍功能
  • 额外的条件判断

• IDEA
• MySQL 8
• Tomcat 9
• JDK 16
• Maven 3.6

CREATE DATAbase ssmbuild;

USE ssmbuild;

DROp TABLE IF EXISTS books;

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 '细节',
PRIMARY KEY (bookId)
)ENGINE=INNODB DEFAULT CHARSET=utf8

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

    
    
        junit
        junit
        4.13.2
    
    
    
        mysql
        mysql-connector-java
        8.0.26
    
    
    
        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
        3.5.7
    
    
        org.mybatis
        mybatis-spring
        2.0.6
    
    
    
        org.springframework
        spring-webmvc
        5.3.10
    
    
        org.springframework
        spring-jdbc
        5.3.10
    
    
    
        org.projectlombok
        lombok
        1.18.20
    

Maven静态资源过滤设置：

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

jdbc.drive=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8&serverTimezone=UTC
jdbc.username=root
jdbc.password=123456

package com.pag.pojo;

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

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

package com.pag.mapper;

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

import java.util.List;

public interface BookMapper {
    //增加一个Book
    int addBook(Books books);
    //根据id删除一个Book
    int deleteBook(@Param("bookId") int id);
    //更新Book
    int updateBook(Books books);
    //根据id查询,返回一个Book
    Books queryBookById(@Param("bookId") int id);
    //查询全部Book,返回list集合
    List queryAllBook();
    //根据名字查询，返回一个Book
    Books queryBookByName(@Param("bookName") String bookName);
}

    
    
        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 = #{bookName}
    

 
编写Service层的接口和实现类com.pag.service 
BookService.interface 
package com.pag.service;

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

import java.util.List;

//BookService:底下需要去实现,调用mapper层
public interface BookService {
    //增加一个Book
    int addBook(Books books);
    //根据id删除一个Book
    int deleteBook(int id);
    //更新Book
    int updateBook(Books books);
    //根据id查询,返回一个Book
    Books queryBookById(int id);
    //查询全部Book,返回list集合
    List queryAllBook();
    //根据Name查询，返回一个Book
    Books queryBookByName(String name);
}

 
BookServiceImpl.java 
package com.pag.service;

import com.pag.mapper.BookMapper;
import com.pag.pojo.Books;

import java.util.List;

public class BookServiceImpl implements BookService{

    //调用mapper层的操作，设置一个set接口，方便Spring管理
    private BookMapper bookMapper;

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

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

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

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

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

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

    @Override
    public Books queryBookByName(String name) {
        return bookMapper.queryBookByName(name);
    }
}

 
Spring层 
配置Spring整合MyBatis，我们这里数据源使用c3p0连接池；
 
编写Spring整合Mybatis的相关的配置文件； spring-mapper.xml 



    
    
    

    
    
    
        
        
        
        
        

        
        
        
        
        
        
        
        
        
    

    
    
        
        
        
        
    

    
    
    
        
        
        
        
    

 
Spring整合service层 



    
    

    
    
        
    

    
    
        
        
    
    

 
SpringMVC层 
web.xml 


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

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

    
    
        15
    

 
spring-mvc.xml 



    
    
    
    
    
    
    
    
    
        
        
    

 
Spring配置整合文件，applicationContext.xml 



	
	
	

 
Controller和视图层编写 
查询所有书籍 
BookController 类编写
 
@Controller
@RequestMapping("/book")
public class BookController {
    @Autowired
    @Qualifier("BookServiceImpl")
    private BookService bookService;
    @RequestMapping("/allBook")
    public String list(Model model) {
        List list = bookService.queryAllBook();
        model.addAttribute("list", list);
        return "allBook";
    }
}
 
编写首页 index.jsp
 
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>



    
    



    点击进入列表页



 
书籍列表页面 allbook.jsp
 
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    
    
    
    



    

        

            

                

                    书籍列表 —— 显示所有书籍
                
            
        
    
    

        

            新增
        
    
    

        

            
                    

                

                

                    
书籍编号
                    
书籍名字
                    
书籍数量
                    
书籍详情
                    
操作
                
                
                

                

                        
${book.getBookID()}
                        
${book.getBookName()}
                        
${book.getBookCounts()}
                        
${book.getDetail()}
                        

                            更改 |
                            删除
                        
                    
                
                
            
        
    

 
添加书籍 
BookController 类编写
 
@RequestMapping("/toAddBook")
public String toAddPaper() {
    return "addBook";
}
@RequestMapping("/addBook")
public String addPaper(Books books) {
    System.out.println(books);
    bookService.addBook(books);
    return "redirect:/book/allBook";
}
 
添加书籍页面：addBook.jsp
 
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>


    
    
    
    



    

        

            

                

                    新增书籍
                
            
        
    
    

        书籍名称：



        书籍数量：



        书籍详情：