ssm基本环境搭建

​ 使用idea创建maven项目

    
    
      junit
      junit
      4.12
      test
    
    
    
      mysql
      mysql-connector-java
      5.1.47
    
    
    
      com.mchange
      c3p0
      0.9.5.2
    

    
    
      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.1.9.RELEASE
    
    
      org.springframework
      spring-jdbc
      5.1.9.RELEASE
    
  

  

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

  

• com.xxx.pojo

• com.xxx.dao

• com.xxx.service

• com.xxx.controller

• mybatis-config.xml

• applicationContext.xml

jdbc.driver=com.mysql.jdbc.Driver
#mysql8.0+，需要增加时区的配置；&serverTimezone=Asia/Shanghai
jdbc.url=jdbc:mysql://localhost:3306/student?userSSL=true&useUnicode=true&characterEncoding=utf8
jdbc.username=root
jdbc.password=123456

    

    
    
        
    

    
    
        
     
3.创建实体类 
public class Books {
    private int BookID;
    private String bookName;
    private int bookCounts;
    private String detail;

    public Books() {
    }

    public Books(int bookID, String bookName, int bookCounts, String detail) {
        BookID = bookID;
        this.bookName = bookName;
        this.bookCounts = bookCounts;
        this.detail = detail;
    }

    public int getBookID() {
        return BookID;
    }

    public void setBookID(int bookID) {
        BookID = bookID;
    }

    public String getBookName() {
        return bookName;
    }

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

    public int getBookCounts() {
        return bookCounts;
    }

    public void setBookCounts(int bookCounts) {
        this.bookCounts = bookCounts;
    }

    public String getDetail() {
        return detail;
    }

    public void setDetail(String detail) {
        this.detail = detail;
    }

    @Override
    public String toString() {
        return "Books{" +
                "BookID=" + BookID +
                ", bookName='" + bookName + ''' +
                ", bookCounts=" + bookCounts +
                ", detail='" + detail + ''' +
                '}';
    }
}
 
4.创建dao层接口 
import com.srf.pojo.Books;
import org.apache.ibatis.annotations.Param;

import java.util.List;

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

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

    //更新一本书
    int updateBook(Books books);

    //查询一本书
    Books queryBookById(@Param("bookId") int id);

    //查询全部的书
    List queryAllBook();
}
 
5.创建mapper .xml并配置 




    
        insert into students.t_book (bookName,bookCounts,detail)
        values (#{bookName},#{bookCounts},#{detail})
    

    
        delete from students.t_book
        where bookID = #{bookId}
    

    
        update students.t_book
        set bookName=#{bookName},bookCounts=#{bookCounts},detail=#{detail}
        where bookID=#{bookID}
    

    
        select * from students.t_book
        where bookID = #{bookId}
    

    
        select * from students.t_book
    


 
6.创建service层接口 
import com.srf.pojo.Books;

import java.util.List;

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

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

    //更新一本书
    int updateBook(Books books);

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

    //查询全部的书
    List queryAllBook();
}
 
7.创建service层实现类 
import com.srf.dao.BookMapper;
import com.srf.pojo.Books;
import com.srf.service.BookService;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.List;


public class BookServiceImpl implements BookService {

    //Service调用dao层，组合dao
    @Autowired
    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 Books queryBookById(int id) {
        return bookMapper.queryBookById(id);
    }

    public List queryAllBook() {
        return bookMapper.queryAllBook();
    }
}
 
spring层的整合 
1.编写spring整合mybatis的相关配置文件：spring-dao.xml 



    
    
    
    
        
        
        
        

        
        
        
        
        
        
        
        
        
    

    
    
        
        
        
    

    
    
        
        
        
        
    

 
2.编写spring整合service层的相关配置文件：spring-service.xml 



    
    

    
    
        
    

    
    
        
    


 
springmvc层的整合 
1.配置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
  


 
2.配置spring-mvc.xml 



    
    

    
    

    
    

    
    
        
        
    

 
3.创建controller类 
import com.srf.pojo.Books;
import com.srf.service.BookService;
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 {

    @Autowired
    @Qualifier("BookServiceImpl")
    private BookService bookService;

    @RequestMapping("/allBook")
    public String list(Model model) {
        List list = bookService.queryAllBook();
        model.addAttribute("list", list);
        return "allBook";
    }
}