Spring+SpringMVC+Mybaits整合

第二步： 在pom.xml中引入jar包

    3.5.6
    5.3.9
  
  
    
    
      org.mybatis
      mybatis
      ${mybatis-version}
    
    
    
      org.springframework
      spring-jdbc
      ${spring-version}
    

    
    
      org.springframework
      spring-context
      ${spring-version}
    
    
      mysql
      mysql-connector-java
      5.1.47
    
    
      javax.annotation
      javax.annotation-api
      1.3.2
    
    
      junit
      junit
      4.12
      test
    
    
    

    
    
      org.projectlombok
      lombok
      1.18.20
      provided
    
    
    
      com.fasterxml.jackson.core
      jackson-databind
      2.9.0
    
    
      com.fasterxml.jackson.core
      jackson-annotations
      2.9.0
    
    
      com.fasterxml.jackson.core
      jackson-core
      2.9.0
    
    
    
      com.alibaba
      druid
      1.1.21
    
    
    
      org.mybatis
      mybatis-spring
      2.0.6
    
    
      javax.servlet
      jstl
      1.2
    
    
    
      org.springframework
      spring-webmvc
      ${spring-version}
    

  

 第三步：配置applicationContext.xml,druid.properties,SpringMvc.xml

        
        
        
        
        
                
                
                
                
        
        
        
                
                
                 queryById(@PathVariable("id") Integer id) {
        return ResponseEntity.ok(this.tblQuestionService.queryById(id));
    }



    
    @RequestMapping("findAll")
    public ModelAndView  findAllQuestion(){
        ModelAndView modelAndView= new ModelAndView();
        List questionList = tblQuestionService.queryAll();
        for (TblQuestion tblQuestion : questionList) {
            System.out.println(tblQuestion.toString());
        }
        //设值
        modelAndView.addObject("questionList", questionList);
        modelAndView.setViewName("showQuestion");
        //设置跳转的页面
        return modelAndView;
    }

    
    @PostMapping
    public ResponseEntity add(TblQuestion tblQuestion) {
        return ResponseEntity.ok(this.tblQuestionService.insert(tblQuestion));
    }

    
    @PutMapping
    public ResponseEntity edit(TblQuestion tblQuestion) {
        return ResponseEntity.ok(this.tblQuestionService.update(tblQuestion));
    }

    
    @DeleteMapping
    public ResponseEntity deleteById(Integer id) {
        return ResponseEntity.ok(this.tblQuestionService.deleteById(id));
    }

}

前端页面

<%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2021/11/23
  Time: 11:37
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<%@taglib prefix="c"  uri="http://java.sun.com/jsp/jstl/core" %>


    


此处写表格数据

        

    

        
问题编号
        
问题描述
        
选项A
        
选项B
        
选项C
        
选项D
        
问题类型
        
问题状态
        
创建时间
        
创建人
        
修改时间
        
修改人
    
    

            
${question.id}
            
${question.question}
            
${question.optionA}
            
${question.optionB}
            
${question.optionC}
            
${question.optionD}
            
${question.type}
            
${question.status}
            
${question.createTime}
            
${question.creator}
            
${question.updateTime}
            
${question.updater}
        
    

由于代码量有点多，剩下的代码放到了gitee上，包括数据库等，可以直接下载，下面是项目架构图：

 项目gitee地址：SSM: spring+springmvc+Mybaits框架的整合

欢迎star!