ssm整合笔记

5、Spring MVC整合Mybatis 5.1开始

1.创建数据库

2.创建普通maven项目，添加web服务

3.导入包（pom.xml)

4.连接数据库

5.创建目录结构

6.配置所有的xml文件

7.pojo实体类

8.dao层的数据库操作（两个文件,文件名：bookMapper（接口）bookMapper.xml)

9.Service层（两个文件,文件名：bookService（接口）bookServiceImpl.xml )：Service层调用Dao层

10.Controller层（bookController（class类）控制与前端交互）

11.连接Tomcat，检查环境，增加lib目录，

12.进行测试

熟练后的正常ssm框架整合顺序：

Mybatis{

1.实体类

2.dao层Mapper接口主要定义增删查改之类的方法

3.dao层Mapper.xml主要实现增删查改，SQL语句

4.配置文件：applicationContext.xml（暂时不用，后边整合时用来导入 dao层service层mvc的配置文件）

database.properties（数据库配置文件）

mybatis-config.xml

5.service层Service接口和ServiceImpl类，业务层调用dao层

}

spring整合dao层：spring-dao.xml

spring整合service层：spring-service.xml

spring mvc{

1.添加Web支持

2.配置Web.xml

3.配置spring-mvc.xml

}

5.2 pom.xml

其中包括：junit,mysql,c3p0,mybatis,

mybatis-spring,servlet-api,

jsp-api,jstl,spring-jdbc



    4.0.0

    org.example
    Lei_xiaoFan
    1.0-SNAPSHOT
    
        
            junit
            junit
            4.13.2
            test
        
        
            mysql
            mysql-connector-java
            8.0.23
        
        
            com.mchange
            c3p0
            0.9.5.5
        

        
            org.mybatis
            mybatis
            3.5.2
        
        
        
            javax.servlet
            servlet-api
            2.5
        
        
        
            javax.servlet.jsp
            jsp-api
            2.2
        
        
        
            javax.servlet
            jstl
            1.2
        
        
            org.springframework
            spring-webmvc
            5.3.5
        
        
            org.springframework
            spring-jdbc
            5.3.5
        
        
            org.mybatis
            mybatis-spring
            2.0.6
        
        
            org.projectlombok
            lombok
            1.18.20
            provided
        
    
    
        
            
                src/main/resources
                
                    ***.xml
                
                true
            

            
                src/main/java
                
                    ***.xml
                
                false

5.3目录结构

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-YzeSiGAg-1636269743677)(C:UsersleiAppDataRoamingTyporatypora-user-imagesimage-20210904113831008.png)][外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-SDHBKCHL-1636269743681)(C:UsersleiAppDataRoamingTyporatypora-user-imagesimage-20210904113905959.png)]

5.4 配置文件

applicationContext.xml

mybatis-config.xml

database.properties

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

spring-dao.xml

spring-mvc.xml

spring-serivce.xml

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

5.5实体类

pojo（class类）

package com.kuang.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.6Dao层文件

bookMapper（接口）

package com.kuang.dao;

import com.kuang.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();

    Books queryBookByName(@Param("bookName") String bookName);
}

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

5.7Service层

BookService（接口）

package com.kuang.service;

import com.kuang.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();

        Books queryBookByName(String bookName);
}

BookServiceImol类实现BookService接口

package com.kuang.service;

import com.kuang.dao.BookMapper;
import com.kuang.pojo.Books;
import org.apache.ibatis.annotations.Param;

import java.util.List;

public class BookServiceImpl implements BookService{

    private BookMapper bookMapper;
    //业务层调用dao层，且可以增加一些操作
    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();
    }

    public Books queryBookByName(String bookName){
        return bookMapper.queryBookByName(bookName);
    }
}

5.8Controller层

package com.kuang.controller;

import com.kuang.pojo.Books;
import com.kuang.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.PathVariable;
import org.springframework.web.bind.annotation.RequestMapping;

import java.util.ArrayList;
import java.util.List;

@Controller
@RequestMapping("/book")
//controller调用service层
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";
    }

    @RequestMapping("/toAddBook")
    public String toAddPaper(){
        return "AddBook";
    }

    @RequestMapping("/addBook")
    public String addBook(Books books){
        System.out.println("addBook->"+books);
        bookService.addBook(books);
        return "redirect:/book/allBook";
    }

    @RequestMapping("/delBook/{bookId}")
    public String delBook(@PathVariable("bookId") int id){
        System.out.println("delBook->"+id);
        bookService.deleteBookById(id);
        return "redirect:/book/allBook";
    }

    @RequestMapping("/toUpdateBook")
    public String toUpdateBook(int id,Model model){
        System.out.println("toUpdateBook->"+id);
        Books books = bookService.queryBookById(id);
        model.addAttribute("Qbook",books);
        System.out.println(books);
        return "UpdateBook";
    }

    @RequestMapping("/updateBook")
    public String updateBook(Books books){
        System.out.println("updateBook->"+books);
        bookService.updateBook(books);
        return "redirect:/book/allBook";
    }

    @RequestMapping("/queryBook")
    public  String queryBook(String queryBookName,Model model){
        Books books = bookService.queryBookByName(queryBookName);

        List list = new ArrayList();
        if(books!=null) list.add(books);
        model.addAttribute("list",list);
        return "AllBook";
    }
}

5.9测试

主要为了测试tomact是否连接成功以及程序是否能正常运行

浏览器中http://localhost:8080/hello测试

package com.kuang.controller;

import com.kuang.pojo.Books;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.ResponseBody;

import java.util.List;

@Controller

public class LController {
    @RequestMapping("/hello")
    @ResponseBody
    public String Hello(){
        return "hello";
    }

}

5.10可能出现的错误 1.由于lib目录的jar包问题

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-GjmzhEWz-1636269743684)(C:UsersleiAppDataRoamingTyporatypora-user-imagesimage-20210904113436483.png)]

2. jsp问题

.jsp文件放在/WEB-INF/jsp下

但是有时候会出现访问不到404错误

可能的原因是out文件夹没有更新,有些时候这里会没有jsp的文件夹，请上百度，

其中一种解决方案：[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-bt9Cc773-1636269743687)(C:UsersleiAppDataRoamingTyporatypora-user-imagesimage-20210904113540549.png)]

如果实在解决不了，可以将下边的jsp文件夹直接复制到这里，也是可以运行的。

[外链图片转存失败,源站可能有防盗链机制,建议将图片保存下来直接上传(img-1YoL7PKG-1636269743689)(C:UsersleiAppDataRoamingTyporatypora-user-imagesimage-20210904113644386.png)]

3. SQL问题

遇到错误可以使用Test测试是否是SQL语句的问题。

例子：

当我进行删除一本书的操作时出现了错误，说book ID找不到

但是再此之前的所有页面都可以进入，于是我进行了test测试

import com.kuang.pojo.Books;
import com.kuang.service.BookService;
import org.junit.Test;
import org.springframework.context.support.ClassPathXmlApplicationContext;

public class MyTest {
    @Test
    public void test(){
        ClassPathXmlApplicationContext context = new ClassPathXmlApplicationContext("applicationContext.xml");
        BookService bookServiceImpl = (BookService) context.getBean("BookServiceImpl");
        bookServiceImpl.deleteBookById(3);
    }
}

还是出错，可以确定时SQL语句那里的问题

(img-1YoL7PKG-1636269743689)]