整合SSM的CRUD

1.创建数据库表

建表代码

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(100) NOT NULL COMMENT '描述',
	INDEX `bookID` (`bookID`)
)
COLLATE='utf8_general_ci'
ENGINE=InnoDB
AUTO_INCREMENT=7;

向表中添加相应数据

2.导入依赖pom.xml文件



    4.0.0

    com.yy
    Myssm
    1.0-SNAPSHOT
    
        
        
            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
        
        
        
            org.projectlombok
            lombok
            1.16.10
            provided
        

    

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

3.配置mybatis层

mybatis-config.xml

连接数据库日志文件

database.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=

一个applicationContext.xml文件来关联所有spring

在引用lombok依赖的情况下创建一个pojo类Books

Pojo层

package com.yy.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;
}

Dao层

创建mapper接口 (CRUD)

package com.yy.dao;

import com.yy.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(int id);

    List queryAllBook();

    Books queryBookByName(@Param("bookName")String bookName);
}

创建mapper.xml(CRUD)





    
        insert into myssm.books (bookName,bookCounts,detail)
        values (#{bookName},#{bookCounts},#{detail});
    

    
        delete from myssm.books where bookID=#{bookId};
    
    
    
        update myssm.books
        set bookName = #{bookName},bookCounts =#{bookCounts},detail =#{detail}
        where bookID=#{bookID};
    

    
        select * from myssm.books

Service层

service接口(Service 调 Dao)

package com.yy.service;

import com.yy.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();

    Books queryBookByName(String bookName);
}

Serviceimpl

package com.yy.service;

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

import java.util.List;

public class BookServiceImpl implements BookService {

    //service 调 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();
    }

    public Books queryBookByName(String bookName) {
        return bookMapper.queryBookByName(bookName);
    }
}

4.配置spring层

整合Dao层

整合Service层

5.配置spring-mvc层

web.xml
设置DispathchServlet，乱码过滤。




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

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

    
        15

然后配置web.xml的配置文件spring-mvc.xml

联合applicationContext.xml

6.业务

创建controller层（CRUD）

package com.yy.controller;
import com.yy.pojo.Books;
import com.yy.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.ArrayList;
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 books = bookService.queryAllBook();
        model.addAttribute("list",books);
        return "allBook";

    }


    //跳转导书籍页面
    @RequestMapping("/toAddBook")
    public String toAddpaper(){
        return "addBook";

    }
    //添加书籍请求
    @RequestMapping("/addBook")
    public String addBook(Books books){
        System.out.println("addBook=>"+books);
        bookService.addBook(books);
        return "redirect:/book/allBook";//重定向
    }


    //跳转到修改页面
    @RequestMapping("/toUpdateBook")
    public String toUpdatePaper(int id,Model model){
        Books books = bookService.queryBookById(id);
        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("/deleteBook")
    public String deleteBook(int id){
        bookService.deleteBookById(id);
        return "redirect:/book/allBook";
    }
    //查询书籍
    @RequestMapping("/queryBook")
    public  String queryBook(String queryBookName, Model model){
        Books books = bookService.queryBookByName(queryBookName);
        List list= new ArrayList();
        list.add(books);
        if (books==null){list=bookService.queryAllBook();
        model.addAttribute("error","未查到");
        }
        model.addAttribute("list",list);
        return "allBook";
    }
}

优化页面
allBook.jsp

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


    
    书籍展示
    




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

         
        
        
            
                新增书籍
                显示书籍
            
            
               
                   ${error}
                   
                   
               
            
        
    

    
        
            
                <%--书籍从数据库查询出来，从list中便利出来：foreach--%>
                
                        
                
                
                    书籍编号
                    书籍名称
                    书籍数量
                    书籍详情
                    操作

                
                

                    
                            ${book.bookID}
                            ${book.bookName}
                            ${book.bookCounts}
                            ${book.detail}
                            
                                修改
                                 | 
                                删除

书籍编号	书籍名称	书籍数量	书籍详情	操作
${book.bookID}	${book.bookName}	${book.bookCounts}	${book.detail}	修改 \| 删除

addBook.jsp

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


    添加书籍
    




    
        
            
                
                    书籍列表——————新增书籍
                
            
        

    
    
        
            书籍名称
            
        
        
            书籍数量
            
        
        
            书籍详情

updateBook.jsp

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


    修改书籍
    




    
        
            
                
                    书籍列表——————修改书籍
                
            
        

    
    

        

        
            书籍名称
            
        
        
            书籍数量
            
        
        
            书籍详情

index.jsp

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

  
    首页
    
      a{
        text-decoration: none;
        color: brown;
        font-size: 18px;
      }
      h3{
        width: 180px;
        height: 38px;
        text-align: center;
        background: chartreuse;
        margin: 100px auto;
      }
    
  
  
  
    进入书籍页面
  
  
    进入t1

7.项目展示

首页

显示书籍

添加书籍

书名单一查询

修改书籍

文件分布图

8.结语

这个项目是我照着视频一步一步做的，虽然很少但收获不少，也希望自己不懂的部分能慢慢啃下来，自我加油吧哈哈哈。
学习视频链接: ssm整合视频
希望自己慢慢进步
完结撒花~

整合SSM的CRUD

Java相关栏目本月热门文章