搭建SSM框架

第一章 搭建SSM框架 1、创建数据库表

CREATE TABLE `t_book` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `bookName` varchar(255) DEFAULT NULL,
  `publish` varchar(255) DEFAULT NULL,
  `addDate` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

2、新建Maven webapp工程 3、pom.xml

    UTF-8
    1.8
    1.8
    5.3.10
    2.13.1



    
    
      junit
      junit
      4.11
    
    
    
      javax.servlet
      jstl
      1.2
    
    
      javax.servlet
      javax.servlet-api
      3.1.0
    
    
      javax.servlet
      servlet-api
      2.5
    
    
    
      mysql
      mysql-connector-java
      5.1.38
    
    
    
      org.mybatis
      mybatis
      3.5.1
    
    
    
      org.mybatis
      mybatis-spring
      1.3.2
    
    
    
      org.springframework
      spring-webmvc
      ${spring-version}
    
    
      org.springframework
      spring-jdbc
      ${spring-version}
    
    
    
      org.springframework
      spring-tx
      5.2.11.RELEASE
    
    
    
      com.alibaba
      druid
      1.1.12
    
    
    
      com.fasterxml.jackson.core
      jackson-core
      ${jackson.version}
    
    
      com.fasterxml.jackson.core
      jackson-databind
      ${jackson.version}
    
    
    
      com.github.pagehelper
      pagehelper
      4.1.6
    

4、创建包

java：

cn.test.entity

cn.test.mapper

cn.test.service

cn.test.controller

resources：

cntestmapper

5、applicationContext.xml

resources：

applicationContext.xml

    
    
    
    
    
    
        
            
                
                    
                        application/json;charset=utf-8
                    
                
            
        
    
    
    
        
        
        
        
    
    
    
        
        
            
                
                    
                        dialect=mysql
                        reasonable=true
                    
                
            
        
    
    
    
        
    
    
    
        
    
    
    
        
        
    

6、web.xml

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

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

7、创建entity实体类

package cn.test.entity;

public class Book {
    private Integer id;
    private String bookName;
    private String publish;
    private String addDate;

    public Integer getId() {
        return id;
    }

    public void setId(Integer id) {
        this.id = id;
    }

    public String getBookName() {
        return bookName;
    }

    public void setBookName(String bookName) {
        this.bookName = bookName;
    }

    public String getPublish() {
        return publish;
    }

    public void setPublish(String publish) {
        this.publish = publish;
    }

    public String getAddDate() {
        return addDate;
    }

    public void setAddDate(String addDate) {
        this.addDate = addDate;
    }
}

8、创建mapper接口

package cn.test.mapper;

import cn.test.entity.Book;

import java.util.List;

public interface BookMapper {
    //添加一本书
    public Integer addBook(Book book);
    //删除一本书
    public Integer delBook(Integer id);
    //更新一本书
    public Integer updateBook(Book book);
    //查看一本书
    public Book findBook(Integer id);
    //查看所有书,模糊查询
    public List findAllBook(String bookName);
}

9、创建mapper映射xml

    
        insert into t_book (bookName,publish,addDate)
        values (#{bookName},#{publish},#{addDate})
    

    
        delete from t_book where id = #{id}
    

    
        update t_book set bookName = #{bookName},publish = #{publish}
        where id = #{id}
    

    
        select * from t_book where id = #{id}
    

    
        select * from t_book where 1 = 1
        and bookName like concat('%',#{bookName},'%')
    

10、创建service接口

package cn.test.service;

import cn.test.entity.Book;
import com.github.pagehelper.PageInfo;

public interface BookService {
    //添加一本书
    public Integer addBook(Book book);
    //删除一本书
    public Integer delBook(Integer id);
    //更新一本书
    public Integer updateBook(Book book);
    //查看一本书
    public Book findBook(Integer id);
    //查看所有书，分页+模糊查询
    public PageInfo findAllBook(Integer pageNo,String bookName);
}

11、创建service实现类

package cn.test.service;

import cn.test.entity.Book;
import cn.test.mapper.BookMapper;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;

import javax.annotation.Resource;

@Service
@Transactional
public class BookServiceImpl implements BookService {
    @Resource
    private BookMapper bookMapper;

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

    @Override
    public Integer delBook(Integer id) {
        return bookMapper.delBook(id);
    }

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

    @Override
    public Book findBook(Integer id) {
        return bookMapper.findBook(id);
    }

    @Override
    public PageInfo findAllBook(Integer pageNo, String bookName) {
        PageHelper.startPage(pageNo,5);
        return new PageInfo<>(bookMapper.findAllBook(bookName));
    }
}

12、创建controller类

package cn.test.controller;

import cn.test.entity.Book;
import cn.test.service.BookService;
import com.github.pagehelper.PageInfo;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;
import java.text.SimpleDateFormat;
import java.util.Date;

@RestController
public class BookController {
    @Resource
    private BookService bookService;

    //添加一本书
    @RequestMapping("/addBook.do")
    public String addBook(Book book){
        String addDate = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date());
        book.setAddDate(addDate);
        
        bookService.addBook(book);
        return "ok";
    }

    //删除一本书
    @RequestMapping("/delBook.do")
    public String delBook(Integer id){
        bookService.delBook(id);
        return "ok";
    }

    //更新一本书
    @RequestMapping("/updateBook.do")
    public String updateBook(Book book){
        bookService.updateBook(book);
        return "ok";
    }

    //查看一本书
    @RequestMapping("/findBook.do")
    public Book findBook(Integer id){
        Book book = bookService.findBook(id);
        return book;
    }

    //查看所有书，分页+模糊查询
    @RequestMapping("/findAllBook.do")
    public PageInfo findAllBook(@RequestParam(defaultValue = "1") Integer pageNo,@RequestParam(defaultValue = "") String bookName){
        PageInfo list = bookService.findAllBook(pageNo, bookName);
        return list;
    }

}

13、创建tomcat服务器 14、postman测试接口 15、前端页面测试 1、list.html

    
    
    
    



    

        

            
书名
            

            

            

            

        
        

            
编号
            
书名
            
出版社
            
添加时间
            
操作
        
    
    

2、add.html

    
    
    
    



    

        

            
书名
            

        
        

            
出版社
            

        
        

            

            

        
    

3、update.html

    
    
    
    



    

        

            
书名
            

        
        

            
出版社