创建数据库

CREATE DATABASE ssmbuild

USE ssmbuild
CREATE TABLE books ( 
bookID INT(10) NOT NULL AUTO_INCREMENT,
bookName VARCHAR(100) NOT NULL,
bookCounts INT(11) NOT NULL, 
detail VARCHAR(200) NOT NULL, 
KEY bookID (bookID) 
  )ENGINE=INNODB DEFAULT CHARSET=utf8
  
INSERT INTO books(bookID,bookName,bookCounts,detail) VALUES 
(2,'MySQL',10,'从删库到跑路'),(3,'Linux',5,'从进门到进牢');

连接数据库

编写实体类

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

编写Dao接口

public interface BookMapper {
    //增加一个Book
    int add(Books books);

    //根据id删除一个book
    int deleteBook ( int id);

    //更新BOOK
    int updateBook (Books books);

    //根据ID查询，返回一个Book
    Books selectBooks(int id);

    //查询全部Book，返回list集合
    List AllBooks();
}

编写Daomapper.xml配置文件

<?xml version="1.0" encoding="UTF-8" ?>


    
    
        insert into ssmbuild.books
            (bookID, bookName, bookCounts, detail)
        values (#{bookID}, #{bookName}, #{bookCounts}, #{detail})

    
    
    
        delete
        from ssmbuild.books
        where bookID = #{bookID}
    

    
    
        update ssmbuild.books
        set bookCounts=#{bookCounts},bookName=#{bookName},detail=#{detail}
        where bookID = #{bookID}
    

    
    
        select *
        from ssmbuild.books
        where bookID = #{bookID}

    

    
    
        select *
        from ssmbuild.books
    

serivce接口

package com.Google.service;

import com.Google.pojo.Books;

import java.util.List;

public interface BookService {

    //增加一个Book
    int add(Books books);

    //根据id删除一个book
    int deleteBook ( int id);

    //更新BOOK
    int updateBook (Books books);

    //根据ID查询，返回一个Book
    Books selectBooks(int id);

    //查询全部Book，返回list集合
    List AllBooks();

}

service实现

package com.Google.service;

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

import java.util.List;

public class BookServiceImpl implements BookService {
    private BookMapper bookMapper;
    //调用Dao层的操作
    public void setBookMapper(BookMapper bookMapper) {
        this.bookMapper = bookMapper;
    }

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

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

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

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

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

配置Mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>



    
        
    

    
        
    

编写database.properties

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&useUnicode=true&characterEncoding=utf8
jdbc.username=xxx
jdbc.password=xxx

将dao层注入到Spring中(创建一个spring-dao.xml)

<?xml version="1.0" encoding="UTF-8"?>


    
    
    

    
    
    
        
        
        
        
        

        
        
        
        
        
        
        
        
        
    

    
    
        
        
        
        
    

    
    
    
        
        
        
        
    

将service层注入到Spring中(创建一个spring-service.xml)

<?xml version="1.0" encoding="UTF-8"?>


    
    

    
        
    

    
    
        
        
    

添加WEB框架

配置web.xml

<?xml version="1.0" encoding="UTF-8"?>

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

配置spring-mvc.xml

<?xml version="1.0" encoding="UTF-8"?>

    
    
    
    
    
    
    
    
        
        
    

将所有spring整合到一个applicationContext.xml中

<?xml version="1.0" encoding="UTF-8"?>

    
    
    

到这里所有的配置全部都已经完成

编写Controller

@Controller
@RequestMapping("/book")
public class bookController {

    //Controller需要调用serivce层
    @Autowired
    @Qualifier("BookServiceImpl")
    private BookService bookService;
    //展示所有书籍
    @RequestMapping("allBook")
···