ssm框架整合----Mybatis

提示：开发环境iead， tomcat 8,maven3.6,mysql5.7

一.基本环境搭建 1.数据库创建（表）

代码如下（示例）：
REATE 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,bookNhelp_topic``help_topicame,bookCounts,detail)VALUES
(1,‘Java’,1,‘从入门到放弃’),
(2,‘MySQL’,10,‘从删库到跑路’),
(3,‘Linux’,5,‘从进门到进牢’);```

2.创建简单maven项目

提示：以下maven项目结构，下面案例可供参考

提示：项目结构中目录颜色正常显示表示项目新建成功

1.pom.xml中y引入Junit,mysql,mybatis,mybatis-spring驱动(注意各jar包的版本)

代码如下（示例）：

    
    
        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
    

    

2maven资源过滤引入

代码如下（示例）：

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

    
    

3.maven项目结构中查看pom.xml引入导入的驱动报

代码如下（示例）：

提示：列表有显示则提示驱动导入成功，按照此方法导入所需jar包即可

二、IEAD手动配置mysql数据库 步骤 1 view–tool Windows–Database:

提示：点击“+”进行添加
Data Sours-mysql:

3、建立项目基本结构和配置框架：

1.项目基本结构：
com.cn.pojo
com.cn.dao
com.cn.service
com.cn.controller
2.配置框架:
2.1Mybatis配置文件mybatis-config.xml：

2.2Spring 配置文件application.xm：

4.Mytabis编写

1、数据库配置文件 database.properties：

jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=123456

 ...
 1.实体类的编写：生成set,get,tostring,有参方法，无参方法等
 package com.kuang.pojo;
public class Books {

private int bookID;
private String bookName;
private int bookCounts;
protected String detall;

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

    public Books() {
    }

    public Books(int bookID, String name, int bookCounts, String detall) {
        this.bookID = bookID;
        bookName = bookName;
        this.bookCounts = bookCounts;
        this.detall = detall;
    }

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

    public void setName(String name) {
        bookName = name;
    }

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

    public void setDetall(String detall) {
        this.detall = detall;
    }

    public int getBookID() {
        return bookID;
    }

    public String getName() {
        return bookName;
    }

    public int getBookCounts() {
        return bookCounts;
    }

    public String getDetall() {
        return detall;
    }
}
2.dao层接口编写：

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();
}
3.daoMapper编写：


    
    
    

    

    
     

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


    
     delete from ssmbuild.books where bookID=#(bookID)

    


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

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

    
    
        SELECT * from ssmbuild.books
    



4.service接口编写（dao层=service层）：
package com.kuang.service;

import com.kuang.pojo.Books;

import java.util.List;

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

5.serviceImpl层编写：


public class BookServiceImpl implements  BookService {
    //dao和service进行组合
    private BookMapper bookMapper;

    public BookMapper getBookMapper() {
        return 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();
    }

}
6.mybatis配置文件mybatis-config.xml中加载接口信息配置：