本文共 14776 字，大约阅读时间需要 49 分钟。

SSM集成开发书籍查询

开发工具：IDEA-maven 、jdk1.8、Tomcat

一、开发环境的搭建及依赖的导入

   
       
    
     4.0.0
        
    
     org.example
        
    
     ssmbuild
        
    
     1.0-SNAPSHOT
        
        
            
             
                 
      
       junit
                  
      
       junit
                  
      
       4.13
              
             
             
                 
      
       com.mchange
                  
      
       c3p0
                  
      
       0.9.5.5
              
             
             
                 
      
       mysql
                  
      
       mysql-connector-java
                  
      
       8.0.20
              
             
             
                 
      
       javax.servlet
                  
      
       servlet-api
                  
      
       2.5
              
             
             
                 
      
       org.mybatis
                  
      
       mybatis
                  
      
       3.4.5
              
             
             
                 
      
       org.mybatis
                  
      
       mybatis-spring
                  
      
       2.0.6
              
             
             
                 
      
       org.springframework
                  
      
       spring-webmvc
                  
      
       5.3.1
              
             
             
                 
      
       org.springframework
                  
      
       spring-jdbc
                  
      
       5.3.3
              
             
                 
      
       org.projectlombok
                  
      
       lombok
                  
      
       1.18.16
              
             
                 
      
       com.alibaba
                  
      
       fastjson
                  
      
       1.2.75
              
         
        
        
            
                 
                      
       
        src/main/java
                       
                           
        
         **/*.properties
                            
        
         **/*.xml
                        
                       
       
        false
                   
                  
                      
       
        src/main/resources
                       
                           
        
         **/*.properties
                            
        
         **/*.xml
                        
                       
       
        false
                   
              
         
    
   

二、maven项目增加web的支持

三、创建MVC的三层架构

3.1、controller层

package com.example.controller;import com.example.pojo.Books;import com.example.service.BookService;import com.sun.org.apache.xpath.internal.operations.Mod;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.RequestBody;import org.springframework.web.bind.annotation.RequestMapping;import java.awt.print.Book;import java.util.List;@Controller@RequestMapping("/book")public class BookController {    //controller 调 service层    @Autowired    @Qualifier("BookServiceImp")    private BookService bookService;    //查询全部的书籍 并且返回到一个书籍展示页面    @RequestMapping("/allBook")//    @RequestBody("")    public String list(Model model){        List
   
     list = bookService.queryAllBook();        for (Books  listquery: list) {            System.out.println(listquery);        }//        System.out.println(list);        model.addAttribute("list",list);        return "allBook";    }    //跳转到增加页面    @RequestMapping("/toAddBook")    public String toAddBook(){        return "addBook";    }    //添加书籍的请求    //业务层调service层    @RequestMapping("/addBook")    public String addBook(Books books){        System.out.println("addBook"+books);        bookService.addBook(books);        return "redirect:/book/allBook"; //重定向到allBook请求    }    //跳转到修改页面    @RequestMapping("/toUpdateBook")    public String toUpdateBook(int id,Model model){        Books books = bookService.queryBookById(id);//        System.out.println("toUpdateBook"+books);        model.addAttribute("qBooks",books); //封装并传到前端        return "updateBook";    }    //修改书籍    @RequestMapping("/updateBook")    public String updateBook(Books books){//        System.out.println("updateBook"+books);        bookService.updateBook(books);        return "redirect:/book/allBook";    }    @RequestMapping("/toDeleteBook")    public String toDeleteBook(int id,Model model){        Books books = bookService.queryBookById(id);        model.addAttribute("dBooks",books);        return "deleteBook";    }    //删除书籍    @RequestMapping("/deleteBook")    public String toDeleteBookById(int id, Model model){        bookService.deleteBookById(id);        return "redirect:/book/allBook"; //重定向到查询所有书籍页面    }    //查询书籍    @RequestMapping("/queryBook")    public String queryBook(String queryBookName,Model model){//        System.out.println("queryBookName:"+queryBookName);        List
    
      books = bookService.queryBook(queryBookName);        model.addAttribute("queryBookName",books);//封装并传到前端//        System.out.println("s==>>>"+books);        return "queryBook";   //跳转到queryBook页面    }}
    
   

3.2、Dao层（查询数据库 注解实现）

package com.example.dao;import com.example.pojo.Books;import org.apache.ibatis.annotations.*;import java.util.List;public interface BookMapper {    @Insert("insert  into ssmbuild.books(bookID,bookName,bookCounts,detail) values(#{books.bookID},#{books.bookName},#{books.bookCounts},#{books.detail})")    int addBook(@Param("books")Books books);    @Select("select * from ssmbuild.books where books.bookName = #{books.queryBookName}")    List
   
     queryBook(String queryBook);    @Delete("delete from ssmbuild.books where books.bookID = #{id}")    int deleteBookById(@Param("id")int id);    @Update("update ssmbuild.books set books.bookID=#{books.bookID},bookName = #{books.bookName},bookCounts = #{books.bookCounts},detail = #{books.detail} where books.bookID = #{books.bookID}" )    int updateBook(@Param("books")Books books);    @Select("select * from ssmbuild.books where books.bookID = #{id}")    Books queryBookById(@Param("id")int id);    @Select("select * from ssmbuild.books")    List
    
      queryAllBook();}
    
   

3.2.1、实体类

package com.example.pojo;import lombok.AllArgsConstructor;//全参构造import lombok.Data;//geter/setter方法import lombok.NoArgsConstructor;//无参构造@Data@AllArgsConstructor@NoArgsConstructorpublic class Books {    private int bookID;    private String bookName;    private int bookCounts;    private String detail;}

3.3、service层

package com.example.service;import com.example.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
   
     queryBook(String queryBook);    List
    
      queryAllBook();}
    
   

3.3.1、service层接口实现

package com.example.service;import com.example.dao.BookMapper;import com.example.pojo.Books;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.stereotype.Service;import java.util.List;@Servicepublic class BookServiceImp  implements BookService {    //service层调用dao层  组合Dao//    @Autowired    private BookMapper bookMapper;    public void setBookMapper(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
   
     queryBook(String queryBook) {        return bookMapper.queryBook(queryBook);    }    @Override    public List
    
      queryAllBook() {        return bookMapper.queryAllBook();    }}
    
   

四、SSM配置的xml文件

4.1、Spring的配置

4.2、Mybatis的配置

   jdbc.driver=com.mysql.cj.jdbc.Driverjdbc.url=jdbc:mysql://localhost:3306/test?serverTimezone=UTCjdbc.username=rootjdbc.password=root

4.3、SpringMVC的三层架构

五、web支持配置

5.1、首页设计

<%--  Created by IntelliJ IDEA.  User: 19175  Date: 2021/1/21  Time: 16:20  To change this template use File | Settings | File Templates.--%><%@ page contentType="text/html;charset=UTF-8" language="java" %>              
   
  
    
    查询书籍  
   
  

5.2、增删改查页面

   <%--  Created by IntelliJ IDEA.  User: 19175  Date: 2021/1/24  Time: 16:44  To change this template use File | Settings | File Templates.--%><%@ page contentType="text/html;charset=UTF-8" language="java" %><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>    
           <%--    
   --%>    
   
   
    
    
        
     
            
      
                
       
                    新增书籍                
            
      
        
     
        
     
      <%--            
      
       --%><%--                
       书籍编号：--%><%--                
       --%><%--            
      
--%>            
      
                
       书籍编号：                
                   
      
            
      
                
       书籍名称：                
                   
      
            
      
                
       书籍数量：                
                   
      
            
      
                
       书籍描述：                
                   
      
            
      
                
                   
      
        
     
    
    
   

   <%--
   --%><%@ page contentType="text/html;charset=UTF-8" language="java" %><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>    
           <%--    
   --%>    
   
   
    
    
        
     
            
      
                
       
                    修改书籍                
            
      
        
     
        
     
                  <%--            
      
       --%>            <%--                
       书籍编号：--%>            <%--                
       --%>            <%--            
      
--%>            
      
                
       书籍编号：                
                   
      
            
      
                
       书籍名称：                
                   
      
            
      
                
       书籍数量：                
                   
      
            
      
                
       书籍描述：                
                   
      
            
      
                
                   
      
        
     
    
    
   

   <%@ page contentType="text/html;charset=UTF-8" language="java" %><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>    
           <%--    
   --%>    
   
   
    
    
        
     
            
      
                
       
                    修改书籍                
            
      
        
     
        
     
                  <%--            
      
       --%>            <%--                
       书籍编号：--%>            <%--                
       --%>            <%--            
      
--%>            
      
                
       书籍编号：                
                   
      
            
      
                
       书籍名称：                
                   
      
            
      
                
       书籍数量：                
                   
      
            
      
                
       书籍描述：                
                   
      
            
      
                
                   
      
        
     
    
    
   

   <%--  Created by IntelliJ IDEA.  User: 19175  Date: 2021/1/21  Time: 16:35  To change this template use File | Settings | File Templates.--%><%--<%@ page contentType="text/html;charset=GBK" %>--%><%--<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>--%><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><%@ page contentType="text/html;charset=UTF-8" language="java" %>    
           <%--    
   --%>    <%--    
   --%>    　　
   
   
   
    
    
        
     
            
      
                
       
                    书籍查询信息                
            
      
        
     
        
     
            
      
                
       新增信息            
      
            
      
                       <%--               查询书籍--%>                
       
                     
                           
       
            
      
        
     
    
    
    
    
        
     
            
                          
      
      
                       
                        
          
书籍编号
          
书籍名称
          
书籍数量
          
书籍详情
         
                       
                                              
                        
          
${book.bookID}
          
${book.bookName}
          
${book.bookCounts}
          
${book.detail}
          
 修改  |  删除 
         
                                       
                  
        
     
    
    
   

   <%--  Created by IntelliJ IDEA.  User: 19175  Date: 2021/1/21  Time: 16:35  To change this template use File | Settings | File Templates.--%><%--<%@ page contentType="text/html;charset=GBK" %>--%><%--<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>--%><%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %><%@ page contentType="text/html;charset=UTF-8" language="java" %>    
       <%--    
   --%><%--    
   --%>    　　
   
   
    
    
        
     
            
      
                
       
                    书籍列表----显示所有书籍                
            
      
        
     
        
     
            
      
                
       新增信息            
      
            
      
       <%--               查询书籍--%>                 
       
                     
                            
       
            
      
        
     
    
    
    
    
        
     
            
                          
      
      
                       
                        
          
书籍编号
          
书籍名称
          
书籍数量
          
书籍详情
         
                       
                                              
                        
          
${book.bookID}
          
${book.bookName}
          
${book.bookCounts}
          
${book.detail}
          
 修改  |  删除 
         
                                       
                  
        
     
    
    
   

六、页面展示