整合Spring+SpringMVC+MyBatis

第一步：在pom.xml中配置依赖

    
        junit
        junit
        4.12
        test
    

    
        mysql
        mysql-connector-java
        5.1.22
    

    
        com.mchange
        c3p0
        0.9.5.5
    

    
        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
    

第二步：在pom.xml中静态资源导出

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

第三步：连接数据库
选择Database–>mysql，测试连接，连接成功后，在Schemas中选择数据库
第四步：在src/java下创建dao,pojo,service,controller包，在resources下创建Mybatis-config.xml，applicationContext.xml，database.properties
Mybatis-config.xml配置文件

applicationContext.xml配置文件

database.properties数据库连接配置

driver=com.mysql.jdbc.Driver
#如果Mysql8.0+,还要添加时区配置 &serverTimezone=Asia/Shanghai
url=jdbc:mysql://localhost:3306/bookstrore?useSSL=true&;useUnicode=true&;characterEncoding=UTF-8
username=root
password=123456

第五步：
配置Mybatis-config.xml

第六步：在pojo里面写数据库对应的Books.java类，在pom.xml中加入lombok依赖

 
        org.projectlombok
        lombok
        1.18.22
    

package com.li.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层下，写BooksMapper接口

package com.li.dao;

import com.li.pojo.Books;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public interface BookMapper {
    //增加
    int addBooks(Books books);
    //删除
    int deleteBookById(@Param("bookId") int id);
    //更新
    int updateBook(Books books);
    //根据Id查
    Books queryBooksById(@Param("bookId") Books books);
    //查询全部
    List queryBooks();
}

第八步：在dao层下创建BookMapper.xml

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

第九步：将BookMapper.xml绑定到配置文件Mybatis-config.xml中

第十步：写业务层在Service下创建接口BookService.java

package com.li.service;

import com.li.pojo.Books;

import java.util.List;

public interface BookService {
    //增加
    int addBooks(Books books);
    //删除
    int deleteBookById(int id);
    //更新
    int updateBook(Books books);
    //根据Id查
    Books queryBooksById(Books books);
    //查询全部
    List queryBooks();
}

第十一步：写接口BookService.java实现类BookServiceImpl

package com.li.service;

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

import java.util.List;

public class BookServiceImpl implements BookService{
    //service层调dao层：组合dao
    private BookMapper bookMapper;

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

    public int addBooks(Books books) {
        return bookMapper.addBooks(books);
    }

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

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

    public Books queryBooksById(Books books) {
        return bookMapper.queryBooksById(books);
    }

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

至此，Mybatis结束
第一步:在resources下创建spring-dao.xml，Spring-service.xml

保证在同一个文件下

第二步：整合Spring-dao.xml

第三步：整合Spring-service.xml

整合SpringMVC
第一步：配置web.xml

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

    springmvc
    /


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

    
        15
    

第二步：创建spring-mvc.xml

第三步：在WEB-INF下创建jsp文件夹
Spring+SpringMVC+MyBatis，整合完毕