Java SSM项目整合

CREATE DATAbase `ssmbuild`;

USE `ssmbuild`;

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','从进门到进牢');

1.新建一个maven webApp项目

2.创建需要用到的文件夹与文件

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-j5DRWzrd-1634019235132)(C:/Users/88505/AppData/Roaming/Typora/typora-user-images/image-20211005161911581.png)]

导入pom.xml中的需要的jia包

  
  
    junit
    junit
    4.13.2
    test
  
  
  
    mysql
    mysql-connector-java
    8.0.26
  
  
  
    com.mchange
    c3p0
    0.9.5.5
  
  
  
    javax.servlet
    servlet-api
    2.5
    provided
  
  
  
    javax.servlet.jsp
    jsp-api
    2.2
    provided
  
  
  
    javax.servlet
    jstl
    1.2
  
  
  
    org.mybatis
    mybatis
    3.5.7
  
  
  
    org.mybatis
    mybatis-spring
    2.0.6
  
  
  
    org.springframework
    spring-webmvc
    5.3.9
  
  
  
    org.springframework
    spring-jdbc
    5.3.9
  
    
        org.projectlombok
        lombok
        RELEASE
        compile
    
    
      com.fasterxml.jackson.core
      jackson-databind
      2.13.0
      compile
    

防止.xml无法加载的问题配置

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

编写mybatis-config.xml

编写database.properties

jdbc.driver=com.mysql.cj.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/ssmbuild?useUnicode=true&characterEncoding=utf8&useSSl=true
jdbc.username=root
jdbc.password=123456

编写pojo中Books实体类

package com.huang.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Books {
    //书id
    private int bookID;
    //书名
    private String bookName;
    //数量
    private int bookCounts;
    //描述
    private String detail;
}

编写mapper层中文件

package com.huang.mapper;

import com.huang.pojo.Books;

import java.util.List;

public interface BookMapper {
    //增加一本书
    int addBook(Books books);
    //删除一本书
    int deleteBookById(int id);
    //修改一本书
    int updateBook(Books books);
    //查询一本书
    Books queryBookById(int id);
    //查询所有书
    List queryAllBook();
}

   
      INSERT INTO `ssmbuild`.`books` (`bookID`,`bookName`,`bookCounts`,`detail`)
      VALUES (#{bookID},#{bookName},#{bookCounts},#{detail})
   
   
      DELETE FROM `ssmbuild`.`books`
      WHERe `bookID` = #{id}
   
   
      UPDATE `ssmbuild`.`books`
      SET `bookName` = #{bookName} ,`bookCounts` = #{bookCounts}, `detail` = #{detail}
      WHERe `bookID` = #{bookID}
   
   
      SELECT * FROM `ssmbuild`.`books`
      WHERe `bookID` = #{id}
   
   
      SELECT * FROM `ssmbuild`.`books`
   

编写Spring-mapper.xml

编写service业务层接口文件

package com.huang.service;

import com.huang.pojo.Books;

import java.util.List;

public interface BooksService {
    //增加一本书
    int addBook(Books books);
    //删除一本书
    int deleteBookById(int id);
    //修改一本书
    int updateBook(Books books);
    //查询一本书
    Books queryBookById(int id);
    //查询所有书
    List queryAllBook();
}

package com.huang.service;

import com.huang.mapper.BookMapper;
import com.huang.pojo.Books;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;
@Service
public class BooksServiceImpl implements BooksService {
    //业务层调mapper层
    @Autowired
    private BookMapper bookMapper;

    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-service.xml

编写controller层文件

package com.huang.controller;

import com.huang.pojo.Books;
import com.huang.service.BooksService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.annotation.Qualifier;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.List;

@Controller
@RequestMapping("/book")
public class BookController {
    //controller调用service
    @Autowired
    @Qualifier("BookServiceImpl")
    private BooksService booksService;

    //查询所有数据
    @RequestMapping("/allBook")
    public String list(Model model){
        List booksList = booksService.queryAllBook();
        model.addAttribute("booksList" , booksList);
        return "allBook";
    }
}

编写springmvc-servlet.xml

编写applicationContext.xml

编写web.xml文件

    
    
        springmvc
        org.springframework.web.servlet.DispatcherServlet
        
            contextConfigLocation
            classpath:applicationContext.xml
        
        1
    
    
        springmvc
        /
    

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

    
    
        15
    

配置Tomcat

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-KcElPlqM-1634019235136)(C:/Users/88505/AppData/Roaming/Typora/typora-user-images/image-20211005163344542.png)]

略
ter.CharacterEncodingFilter

encoding
utf-8



encoding
/*

    15

配置Tomcat

[外链图片转存中…(img-KcElPlqM-1634019235136)]

略