【SSM框架整合】-01配置文件编写

• 项目框架概览
• 创建数据库
• pom依赖
• Maven资源过滤设置
• Mybatis层编写
• service接口及实现类
• spring层
• SpringMVC层

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,'从入门到放弃'),
(2,'MySQL',10,'从删库到跑路'),
(3,'Linux',5,'从进门到进牢');

    
        
            org.projectlombok
            lombok
            1.18.24
        
        
        
            junit
            junit
            4.12
        
        
        
            mysql
            mysql-connector-java
            5.1.47
        
        
        
            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.3.19
        
        
            org.springframework
            spring-jdbc
            4.3.20.RELEASE
        
        
            org.projectlombok
            lombok
            RELEASE
            compile
        
    

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

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

jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useSSL=false&useUnicode=true&characterEncoding=utf8&serverTimezone = Asia/Shanghai
jdbc.username=root
jdbc.password=123456

2.IDEA连接数据库
3.编写MyBatis核心配置文件
mybatis-config.xml

applicationContext.xml

4.编写数据库对应的实体类 com.cao.pojo.Books
使用lombok插件

package com.cao.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;
}

5.编写Dao层的 Mapper接口

package com.cao.dao;

import com.cao.pojo.Books;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface BookMapper {
    //增加一个Book
    int addBook(Books books);
    //根据id删除一个Book
    int deleteBookById(@Param("bookID") int id);
    //更新Book
    int updateBook(Books books);
    //根据id查询,返回一个Book
    Books queryBookById(@Param("bookID") int id);
    //查询全部Book,返回list集合
    List queryAllBook();

}

6.编写接口对应的 Mapper.xml 文件。
需要导入MyBatis的包

    
        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
    

7.编写Service层的接口和实现类
接口：

package com.cao.service;

import com.cao.pojo.Books;

import java.util.List;

//BookService:底下需要去实现,调用dao层
public interface BookService {
    //增加一个Book
    int addBook(Books books);
    //根据id删除一个Book
    int deleteBookById(int id);
    //更新Book
    int updateBook(Books books);
    //根据id查询,返回一个Book
    Books queryBookById(int id);
    //查询全部Book,返回list集合
    List queryAllBook();
}

实现类：
spring4.0之后不建议在字段上使用@Autowired，可以在构造方法或setter上写。甚至有构造方法的时候可以省略@Autowired也可以自动实现注入

package com.cao.service;

import com.cao.dao.BookMapper;
import com.cao.pojo.Books;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.context.annotation.Bean;
import org.springframework.stereotype.Service;

import java.util.List;
//new
@Service
public class BookServiceImpl implements BookService{

    @Autowired
    private BookMapper bookMapper;
    //new
    //使用@Autowired配合配置文件设置扫描包实现自动装配，即可不使用set
//    public void setBookMapper(BookMapper bookMapper){
//        this.bookMapper = bookMapper;
//    }
    @Override
    public int addBook(Books books) {
        return bookMapper.addBook(books);
    }

    @Override
    public int deleteBookById(int id) {

        return bookMapper.deleteBookById(id);
    }

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

    @Override
    public Books queryBookById(int id) {

        return bookMapper.queryBookById(id);
    }

    @Override
    public List queryAllBook() {

        return bookMapper.queryAllBook();
    }
}

spring-dao.xml

Spring整合service层
spring-service.xml

web.xml
DispatcherServlet和乱码过滤

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

spring-mvc.xml
1.开启SpringMVC注解驱动
2.静态资源默认servlet配置
3.配置jsp 显示ViewResolver视图解析器
4.扫描web相关的bean