springboot+mybatis整合项目——初学者

提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

文章目录

• 前言
• • 1.新建项目
  • 2.配置pom.xml文件
  • 3.配置application.yml文件
  • 4.bean下的student类
  • 4.mapper下的student类
  • 5.service下的student类
  • 6.service下的student实现类
  • 7.Controller层下的student类
  • 8.index.html

---

前言

提示：这里可以添加本文要记录的大概内容：

---

提示：以下是本篇文章正文内容，下面案例可供参考

1.新建项目

点击【文件】-【新建】-【项目】；

在Spring initializr中选择对应的jdk版本；

点击【下一步】，搜索依赖项，添加下图的依赖项；点击【完成】。

2.配置pom.xml文件

4.0.0
com.example
demo
0.0.1-SNAPSHOT
demo
demo

    1.8
    UTF-8
    UTF-8
    2.3.7.RELEASE



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

    
        mysql
        mysql-connector-java
        runtime
    
    
        org.springframework.boot
        spring-boot-starter-test
        test
        
            
                org.junit.vintage
                junit-vintage-engine
            
        
    



    
        
            org.springframework.boot
            spring-boot-dependencies
            ${spring-boot.version}
            pom
            import
        
    



    
        
            org.apache.maven.plugins
            maven-compiler-plugin
            3.8.1
            
                1.8
                1.8
                UTF-8
            
        
        
            org.springframework.boot
            spring-boot-maven-plugin
            2.3.7.RELEASE
            
                com.example.demo.DemoApplication
            
            
                
                    repackage
                    
                        repackage
                    
                
            
        
    

3.配置application.yml文件

将application.approperties的文件后缀改为yml；配置代码如下：
server:
port: 8080

spring:
datasource:
url: jdbc:mysql://localhost:3306/test?serverTimezone=Asia/Shanghai&characterEncoding=utf-8
username: root
password: root
driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
type-aliases-package: com.example.demo.bean

4.bean下的student类

package com.example.demo.bean;

public class student {
private Integer id;
private String name;
private String major;

public Integer getId() {
    return id;
}

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

public String getName() {
    return name;
}

public void setName(String name) {
    this.name = name;
}

public String getMajor() {
    return major;
}

public void setMajor(String major) {
    this.major = major;
}

}

4.mapper下的student类

package com.example.demo.mapper;

import com.example.demo.bean.Student;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@repository
@Mapper
public interface StudentMapper {
@Select(
{
“select”,
“id, name, major”,
“from student”
}
)
List selectAll();

}

5.service下的student类

package com.example.demo.service;

import com.example.demo.bean.Student;

import java.util.List;

public interface StudentService {
public List selectAll();
}

6.service下的student实现类

package com.example.demo.service.impl;

import com.example.demo.bean.Student;
import com.example.demo.mapper.StudentMapper;
import com.example.demo.service.StudentService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service(“studentService”)
public class StudentServiceImpl implements StudentService {
@Autowired
private StudentMapper studentMapper;

@Override
public List selectAll() {return studentMapper.selectAll();}

}

7.Controller层下的student类

package com.example.demo.controller;

import com.example.demo.bean.Student;
import com.example.demo.service.StudentService;
import com.example.demo.service.impl.StudentServiceImpl;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RequestMethod;
import org.springframework.web.bind.annotation.RestController;

import javax.annotation.Resource;

import java.util.List;

@RestController
@RequestMapping(“/index”)
public class StudentController {
@Resource
private StudentService studentService=new StudentServiceImpl();

@RequestMapping(value = "/selectAll", method= RequestMethod.GET)
public List selectAll(){
    List list=selectAll();
    return list;
}

}

8.index.html