SpringBoot-MyBatis

pom.xml文件

    
        org.springframework.boot
        spring-boot-starter-web
    
    
        org.mybatis.spring.boot
        mybatis-spring-boot-starter
        2.1.2
    

    
        mysql
        mysql-connector-java
        8.0.13
    
    
        org.projectlombok
        lombok
        true
    
    
        org.springframework.boot
        spring-boot-starter-test
        test
        
            
                org.junit.vintage
                junit-vintage-engine
            
        
    

    
    
    
        io.springfox
        springfox-swagger2
        2.7.0
    
    
        io.springfox
        springfox-swagger-ui
        2.7.0
    

    
    
        com.github.pagehelper
        pagehelper-spring-boot-starter
        1.2.3
    



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

application.yml

# 数据源
spring:
  application:
    name: springboot-mybatis
  datasource:
    driver-class-name: com.mysql.cj.jdbc.Driver
    url: jdbc:mysql://localhost:3306/studentdb?characterEncoding=utf-8&useUnicode=true&serverTimezone=UTC
    username: root
    password: root
server:
  port: 8080

# mybatis配置
mybatis:
  # 对应的实体类的包的位置
  type-aliases-package: com.changan.entity
  # mapper.xml的路径
  mapper-locations: classpath:mapper/*.xml

# 打印日志
logging:
  level:
    com.changan.springbootmybatis.dao.*: debug

# 配置分页插件
pagehelper:
  helper-dialect: mysql
  reasonable: true
  support-methods-arguments: true
  params: count=countsql
  
# 配置视图解析器(jsp的内容)

依次创建entity、dao、service、controller包

StudentDao.java

@Mapper
public interface StudentDao {
    
}

或者

@SpringBootApplication
@MapperScan("com.changan.springbootmybatis.dao")
public class SpringbootMybatisApplication {

    public static void main(String[] args) {
        SpringApplication.run(SpringbootMybatisApplication.class, args);
    }
}

StudentDao.xml

application.yml

#配置jsp视图解析器
spring:
  mvc:
    view:
      prefix: /WEB-INF/pages/
      suffix: .jsp

添加一个依赖

    org.apache.tomcat.embed
    tomcat-embed-jasper
    provided




    javax.servlet
    jstl

添加一个webapp文件夹

注意:可能需要手动编译

StudentController.java

@Controller
public class StudentController {

    @Autowired
    private StudentService studentService;

    @RequestMapping("/findAll")
    public String findAll(@RequestParam(required = false) Integer pageNum,@RequestParam(required = false) Integer pageSize,Model model){
        if(pageNum==null){
            pageNum = 1;
        }
        if(pageSize==null){
            pageSize = 2;
        }
        PageInfo pageInfo = studentService.findByPage(pageNum, pageSize);
        model.addAttribute("pageInfo",pageInfo);
        return "index";
    }
}

index.jsp

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


    


    
            

        

            
编号
            
姓名
            
性别
            
年级
            
操作
        
        

                
${student.id}
                
${student.name}
                
${student.sex}
                
${student.gradeId}
                

                    编辑
                    删除