# SSM-Build-Instance
**Repository Path**: sukels/SSM-Build-Instance
## Basic Information
- **Project Name**: SSM-Build-Instance
- **Description**: 基于SSM的图书管理系统
- **Primary Language**: Java
- **License**: Not specified
- **Default Branch**: master
- **Homepage**: https://blog.csdn.net/qq_45037155?spm=1000.2115.3001.5343
- **GVP Project**: No
## Statistics
- **Stars**: 3
- **Forks**: 0
- **Created**: 2022-04-02
- **Last Updated**: 2024-05-18
## Categories & Tags
**Categories**: Uncategorized
**Tags**: None
## README
## 整合SSM
## 1、环境要求
### 环境:
- IDEA
- MySQL 5.7.19
- Tomcat 9
- Maven 3.6
 要求:
- 需要熟练掌握MySQL数据库,Spring,JavaWeb及MyBatis知识,简单的前端知识;
## 2、数据库环境
创建一个存放书籍数据的数据库表
```sql
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 '描述',
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,'从进门到进牢');
```
## 3、基本环境搭建
### 1、新建一Maven项目!
	ssmbuild , 添加web的支持
### 2、导入相关的pom依赖!
```xml
   
   
       junit
       junit
       4.12
   
   
   
       mysql
       mysql-connector-java
       5.1.47
   
   
   
       com.mchange
       c3p0
       0.9.5.2
   
   
   
       javax.servlet
       servlet-api
       2.5
   
   
       javax.servlet.jsp
       jsp-api
       2.2
   
   
       javax.servlet
       jstl
       1.2
   
   
   
       org.mybatis
       mybatis
       3.5.2
   
   
       org.mybatis
       mybatis-spring
       2.0.2
   
   
   
       org.springframework
       spring-webmvc
       5.1.9.RELEASE
   
   
       org.springframework
       spring-jdbc
       5.1.9.RELEASE
   
```
### 3、Maven资源过滤设置
```xml
   
       
           src/main/java
           
               **/*.properties
               **/*.xml
           
           false
       
       
           src/main/resources
           
               **/*.properties
               **/*.xml
           
           false
       
   
```
### 4、建立基本结构和配置框架!
- site.whatsblog.pojo
- site.whatsblog.dao
- site.whatsblog.service
- site.whatsblog.controller
- mybatis-config.xml
  ```xml
  
  
  
  
  
  ```
- applicationContext.xml
  ```xml
  
  
  
  
  ```
## 4、Mybatis层编写
### 1、数据库配置文件 **database.properties**
```properties
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=root
```
### 2、IDEA关联数据库
### 3、编写MyBatis的核心配置文件
```xml
   
   
       
   
   
       
   
```
### 4、编写数据库对应的实体类 site.whatsblog.pojo.Books
使用lombok插件!
```java
package site.whatsblog.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;
   
}
```
### 5、编写Dao层的 Mapper接口!
```java
package site.whatsblog.dao;
import site.whatsblog.pojo.Books;
import java.util.List;
public interface BookMapper {
   //增加一个Book
   int addBook(Books book);
   //根据id删除一个Book
   int deleteBookById(int id);
   //更新Book
   int updateBook(Books books);
   //根据id查询,返回一个Book
   Books queryBookById(int id);
   //查询全部Book,返回list集合
   List queryAllBook();
}
```
### 6、编写接口对应的 Mapper.xml 文件。需要导入MyBatis的包;
```java
   
   
      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}
   
   
   
   
   
```
### 7、编写Service层的接口和实现类
接口:
```java
package site.whatsblog.service;
import site.whatsblog.pojo.Books;
import java.util.List;
//BookService:底下需要去实现,调用dao层
public interface BookService {
   //增加一个Book
   int addBook(Books book);
   //根据id删除一个Book
   int deleteBookById(int id);
   //更新Book
   int updateBook(Books books);
   //根据id查询,返回一个Book
   Books queryBookById(int id);
   //查询全部Book,返回list集合
   List queryAllBook();
}
```
实现类:
```java
package site.whatsblog.service;
import site.whatsblog.dao.BookMapper;
import site.whatsblog.pojo.Books;
import java.util.List;
public class BookServiceImpl implements BookService {
   //调用dao层的操作,设置一个set接口,方便Spring管理
   private BookMapper bookMapper;
   public void setBookMapper(BookMapper bookMapper) {
       this.bookMapper = bookMapper;
  }
   
   public int addBook(Books book) {
       return bookMapper.addBook(book);
  }
   
   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();
  }
}
```
**OK,到此,底层需求操作编写完毕!**
## 5、Spring层
### 1、配置**Spring整合MyBatis**,我们这里数据源使用c3p0连接池;
### 2、我们去编写Spring整合Mybatis的相关的配置文件;spring-dao.xml
```xml
   
   
   
   
   
   
       
       
       
       
       
       
       
       
       
       
       
       
       
       
   
   
   
       
       
       
       
   
   
   
   
       
       
       
       
   
```
### 3、**Spring整合service层**
```xml
   
   
   
   
       
   
   
   
       
       
   
```
Spring层搞定!再次理解一下,Spring就是一个大杂烩,一个容器!对吧!
## 6、SpringMVC层
### 1、**web.xml**
```xml
   
   
       DispatcherServlet
       org.springframework.web.servlet.DispatcherServlet
       
           contextConfigLocation
             
           classpath:applicationContext.xml
       
       1
   
   
       DispatcherServlet
       /
   
   
   
       encodingFilter
       
          org.springframework.web.filter.CharacterEncodingFilter
       
       
           encoding
           utf-8
       
   
   
       encodingFilter
       /*
   
   
   
   
       15
   
   
```
### 2、**spring-mvc.xml**
```xml
   
   
   
   
   
   
   
       
       
       
   
   
   
```
### 3、**Spring配置整合文件,applicationContext.xml**
```xml
   
   
   
   
```
**配置文件,暂时结束!**
### 4、**Controller 和 视图层编写**
1、BookController 类编写 , 方法一:查询全部书籍
```java
@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";
  }
}
```
2、编写首页 **index.jsp**
```html
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8" %>
   首页
   
```
3、书籍列表页面 **allbook.jsp**
```html
<%@ 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()} | 更改 |
                           删除 | 
               
               
           
        
    
 
```
4、BookController 类编写 , 方法二:添加书籍
```java
@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";
}
```
5、添加书籍页面:**addBook.jsp**
```html
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
   新增书籍
   
   
   
```
6、BookController 类编写 , 方法三:修改书籍
```java
@RequestMapping("/toUpdateBook")
public String toUpdateBook(Model model, int id) {
   Books books = bookService.queryBookById(id);
   System.out.println(books);
   model.addAttribute("book",books );
   return "updateBook";
}
@RequestMapping("/updateBook")
public String updateBook(Model model, Books book) {
   System.out.println(book);
   bookService.updateBook(book);
   Books books = bookService.queryBookById(book.getBookID());
   model.addAttribute("books", books);
   return "redirect:/book/allBook";
}
```
7、修改书籍页面  **updateBook.jsp**
```jsp
<%@ taglib prefix="c" uri="http://java.sun.com/jsp/jstl/core" %>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
   修改信息
   
   
   
```
8、BookController 类编写 , 方法四:删除书籍
```java
@RequestMapping("/del/{bookId}")
public String deleteBook(@PathVariable("bookId") int id) {
   bookService.deleteBookById(id);
   return "redirect:/book/allBook";
}
```
**配置Tomcat,进行运行!**
到目前为止,这个SSM项目整合已经完全的OK了,可以直接运行进行测试!这个练习十分的重要,大家需要保证,不看任何东西,自己也可以完整的实现出来!
**项目结构图** 


## 7、小结及展望
这个是同学们的第一个SSM整合案例,一定要烂熟于心!
SSM框架的重要程度是不言而喻的,学到这里,大家已经可以进行基本网站的单独开发。但是这只是增删改查的基本操作。可以说学到这里,大家才算是真正的步入了后台开发的门。也就是能找一个后台相关工作的底线。
或许很多人,工作就做这些事情,但是对于个人的提高来说,还远远不够!
我们后面还要学习一些 SpringMVC 的知识!
- Ajax   和   Json
- 文件上传和下载
- 拦截器
前路漫漫,认真坚持最重要!