SSM整合

• 1、先完成mybatis层
• 2、Spring层
• 3、SpringMVC层
• 4、增加业务

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

项目结构

创建mybatis配置文件mybatis-config.xml

创建dao层下的接口和mapper

BookMapper.java

public interface BookMapper {
    //增加一本书
    int addBook(Books books);

    //删除一本书
    int deleteBookById(@Param("bookId") int id);

    //修改一本书
    int updateBook(Books books);

    //查询一本书
    int 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},bookCounts=#{bookCounts},detail=#{detail}
        where bookID=#{bookID};
    
    
    
        select *
        from books where bookID=#{bookId};
    

    
        select *
        from books;
    

写好mapper后马上去mybatis-config.xml注册

开始service层

创建对应的接口

BookService.java

public interface BookService {
    //增加一本书
    int addBook(Books books);

    //删除一本书
    int deleteBookById( int id);

    //修改一本书
    int updateBook(Books books);

    //查询一本书
    int queryBookById(int id);

    //查询全部的书
    List queryAllBook();
}

实现类

BookServiceImpl.java

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 int queryBookById(int id) {
        return bookMapper.queryBookById(id);
    }

    public List queryAllBook() {
        return null;
    }
}

mybatis层完成

创建数据库配置文件database.properties

driver=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/mybatis?useSSl=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC
username=root
password=123456

创建Spring的核心配置文件applicationContext.xml

创建spring-dao.xml,分层开发，dao层

创建spring-service.xml，service层

• 增加web框架支持

在web.xml中配置dispatchservlet和乱码过滤器

    
    
        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

最后整合这些配置文件，在Spring的核心配置文件applicationContext.xml中导入

至此，框架整合完成，依靠Spring来整合，Spring本身就是一个大杂烩