Mybatis层 一.导入依赖

    4.0.0

    org.example
    ssm
    1.0-SNAPSHOT
    
    
        
            junit
            junit
            4.13.2
        
        
            mysql
            mysql-connector-java
            5.1.47
        
       
            com.alibaba
            druid
            1.2.8
        
        
            javax.servlet
            javax.servlet-api
            4.0.1
        
        
            javax.servlet.jsp
            jsp-api
            2.2.1-b03
        
        
            jstl
            jstl
            1.2
        
        
            org.mybatis
            mybatis
            3.5.7
        
        
            org.mybatis
            mybatis-spring
            2.0.6
        
        
            org.springframework
            spring-webmvc
            5.2.17.RELEASE
        
        
            org.springframework
            spring-jdbc
            5.2.17.RELEASE
        
    

    
    
        
            
                src/main/resource
                
                    ***.xml
                
                true
            
            
                src/main/java
                
                    ***.xml
                
                true
            
        
    

二.建立基本结构和配置文件

1.com.wyp.mapper        com.wyp.service        com.wyp.pojo        com.wyp.controller

2.applicationcontext.xml

 mybatis-config.xml

三. 编写pojo实体类Book，编写mapper接口BookMapper，编写配置文件BookMapper.xml，mybatis-config中起别名和添加mappers。

Book

package com.wyp.pojo;

public class Book {
    private int bookID;
    private String bookName;
    private  int bookCounts;
    private String detail;

    public Book() {
    }

    public Book(int bookID, String bookName, int bookCounts, String detail) {
        this.bookID = bookID;
        this.bookName = bookName;
        this.bookCounts = bookCounts;
        this.detail = detail;
    }

    public int getBookID() {
        return bookID;
    }

    public void setBookID(int bookID) {
        this.bookID = bookID;
    }

    public String getBookName() {
        return bookName;
    }

    public void setBookName(String bookName) {
        this.bookName = bookName;
    }

    public int getBookCounts() {
        return bookCounts;
    }

    public void setBookCounts(int bookCounts) {
        this.bookCounts = bookCounts;
    }

    public String getDetail() {
        return detail;
    }

    public void setDetail(String detail) {
        this.detail = detail;
    }

    @Override
    public String toString() {
        return "Books{" +
                "bookID=" + bookID +
                ", bookName='" + bookName + ''' +
                ", bookCounts=" + bookCounts +
                ", detail='" + detail + ''' +
                '}';
    }
}

 BookMapper

package com.wyp.mapper;

import com.wyp.pojo.Book;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface BookMapper {
    int addBook(Book book);
    int deleteBookById(@Param("bookID") int id);
    int updateBook(Book book);
    Book queryBookById(@Param("bookID") int id);
    List queryAllBook();
}

  BookMapper.xml

    
    insert into books (bookName,bookCounts,detail) values (#{bookName},#{bookCounts},#{detail});
    
    
        delete from books where bookID = #{bookID};
    
    
        update books set bookName=#{bookName},booksCounts=#{bookCounts},detail=#{detail} where bookID=#{bookID};
    
    
        select * from books where bookID=#{bookID};
    
    
        select * from books;
    

 四.编写Service层，BookService 和 BookServiceImpl，BookServiceImpl组合Mapper层。

BookService

package com.wyp.service;

import com.wyp.pojo.Book;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface BookService {
    int addBook(Book book);

    int deleteBookById(int id);

    int updateBook(Book book);

    Book queryBookById(int id);

    List queryAllBook();
}

BookServiceImpl

package com.wyp.service;

import com.wyp.mapper.BookMapper;
import com.wyp.pojo.Book;

import java.util.List;

public class BookServiceImpl implements BookService {
    private BookMapper bookMapper;

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

    public int addBook(Book book) {
        return bookMapper.addBook(book);
    }

    public int deleteBookById(int id) {
        return bookMapper.deleteBookById(id);
    }

    public int updateBook(Book book) {
        return bookMapper.updateBook(book);
    }

    public Book queryBookById(int id) {
        return bookMapper.queryBookById(id);
    }

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

Spring层 一.编写druid配置文件druid.properties，编写spring-dao.xml配置文件

druid.properties

driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/login?useUnicode=true&characterEncoding=utf8
username=root
password=123456
initialSize=5
maxActive=10
maxWait=3000
wait_timeout=2147483
interactive_timeout=2147483

spring-dao.xml

二.编写spring-service.xml配置文件，applicationcontext总配置文件导入spring-service和spring-dao。

spring-service.xml

applicationcontext.xml

SpringMVC层 一.将项目设置为web项目，lib包中导入jar包。 二.配置web.xml

    
        DispatchServlet
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:spring-mvc.xml
        
        1
    
    
        DispatchServlet
        /
    

    
    
        CharacterEncodingFilter
        org.springframework.web.filter.CharacterEncodingFilter
        
            encoding
            UTF-8
        
    
    
        CharacterEncodingFilter
        /*
    

    
        15
    

三.配置spring-mvc.xml，总配置文件引入spring-mvc.xml

ssm整合完毕