【ssm】配置地狱ssm整合

搭建数据库导入依赖静态资源导出连接数据库创建包与核心配置文件编写实体类Mapper接口Servise接口完善数据库配置修改web.xml配置文件将所有的spring的xml导入到总配置中

环境：

IDEA 2021.2.4MySQL 8.0.22Tomcat 8.5.73Maven 3.8.4

CREATE DATAbase `ssmbuild`;
USE `ssmbuild`;
DROp TABLE IF EXISTS `books`;
CREATE 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`,`bookName`,`bookCounts`,`detail`)VALUES
(1,'JAVA',1,'SUN公司开发的一种面向对象语言'),
(2,'MySQL',1,'热门的关系型数据库'),
(3,'Linux',1,'轻量级电脑系统');

Junit
数据库驱动
连接池
servlet
jsp
MyBatis
mybatis-spring
spring

    
        junit
        junit
        4.12
        test
    
    
        mysql
        mysql-connector-java
        8.0.22
    
    
        javax.servlet
        servlet-api
        2.5
    
    
        javax.servlet.jsp
        jsp-api
        2.2
    
    
        javax.servlet
        jstl
        1.2
    
    
        org.mybatis
        mybatis
        3.5.6
    
    
        org.mybatis
        mybatis-spring
        2.0.6
    
    
        org.springframework
        spring-webmvc
        5.3.3
    
    
        org.springframework
        spring-jdbc
        5.3.3
    
    
        com.mchange
        c3p0
        0.9.5.2
    
        
            org.projectlombok
            lombok
            1.18.16
        

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

包结构如下：

applicationContext.xml（作为整合配置文件的总文件）

mybatis-config.xml（作为Mybatis的配置文件）

database.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=true&useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
jdbc.username=root
jdbc.password=

Books.java

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

BookMapper.java

public interface BookMapper {
    //增加一本书
    int addBook(Books books);
    //删除一本书
    int deleteBookById(@Param("bookID") int id);
    //更新一本书
    int updateBook(Books books);
    //查询一本书
    Books queryById(@Param("bookID") int id);
    //查询全部书
    List queryAllBook();
}

实现BookMapper借接口

BookMapper.xml

    
        insert into ssmbuild.books(bookName, bookCounts, detail)
        values (#{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;
    

注册接口

mybatis-config.xml

BookService.java

public interface BookService {
    //增加一本书
    int addBook(Books books);
    //删除一本书
    int deleteBookById(int id);
    //更新一本书
    int updateBook(Books books);
    //查询一本书
    Books queryById(int id);
    //查询全部书
    List queryAllBook();
}

实现service接口

BookServiceImpl.java

package com.paramaki.service;

import com.paramaki.dao.BookMapper;
import com.paramaki.pojo.Book;

import java.util.List;

public class BookServiceImpl implements BookService{

    // service层调dao层
    private BookMapper bookMapper;

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

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

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

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

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

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

spring-mapper.xml

spring-service.xml

然后添加web支持

web.xml

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

spring-mvc.xml

ApplicationContext.xml

到这里，就整合结束了，还是比较折磨人的