新建SpringBoot工程

若选择https://start.spring.io下一步失败

则选择Custom，输入：Https://start.aliyun.com后下一步

添加需要的依赖

添加其他依赖，全部依赖如下：

  <dependencies>        <dependency>            <groupId>org.springframework.bootgroupId>            <artifactId>spring-boot-starter-WEBartifactId>        dependency>        <dependency>            <groupId>org.springframework.bootgroupId>            <artifactId>spring-boot-starter-testartifactId>            <scope>testscope>        dependency>        <dependency>            <groupId>org.springframework.bootgroupId>            <artifactId>spring-boot-starter-jdbcartifactId>        dependency> <dependency>            <groupId>MysqlgroupId>            <artifactId>mysql-connector-javaartifactId>            <scope>runtimescope>        dependency>        <dependency>            <groupId>org.mybatisgroupId>            <artifactId>mybatisartifactId>            <version>3.4.6version>        dependency>        <dependency>            <groupId>org.mybatis.spring.bootgroupId>            <artifactId>mybatis-spring-boot-starterartifactId>            <version>2.0.0version>        dependency>                <dependency>            <groupId>org.projectlombokgroupId>            <artifactId>lombokartifactId>            <optional>trueoptional>        dependency>  dependencies>

修改配置文件：

application.properties：改为application.yml

application.yml:

#端口号8080server:  port: 8080#数据库名：mysql，用户名root，密码123456spring:  datasource:    username: root    passWord: 123456    url: jdbc:mysql://localhost:3306/mysql?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai    driver-class-name: com.mysql.cj.jdbc.Driver    mybatis:  mapper-locations: classpath:mapping    StudentInfo getInfo(int id);        void insertInfo(StudentInfo studentInfo);        int deleteById(int id);        int updateById(StudentInfo studentInfo);    List<StudentInfo> selectAll();}

StudentService

import com.example.demo.entity.StudentInfo;import java.util.List;public interface StudentService {    StudentInfo getStudentInfo(int id);    StudentInfo insertInfo(StudentInfo studentInfo);    int deleteById(int id);    int updateById(StudentInfo studentInfo);    List<StudentInfo> selectAll();}

StudentServiceImpl

import com.example.demo.entity.StudentInfo;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;@Servicepublic class StudentServiceImpl implements StudentService {    @Autowired(required = false)    private StudentMapper studentMapper;    @Override    public StudentInfo getStudentInfo(int id){        return studentMapper.getInfo(id);    }    @Override    public StudentInfo insertInfo(StudentInfo studentInfo){        studentMapper.insertInfo(studentInfo);        return studentInfo;    }    @Override    public int deleteById(int id){        return studentMapper.deleteById(id);    }    @Override    public int updateById(StudentInfo studentInfo){        return studentMapper.updateById(studentInfo);    }    @Override    public List<StudentInfo> selectAll(){        return studentMapper.selectAll();    }}

StudentMapper.xml

DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mapper namespace="com.example.demo.mapper.StudentMapper">    <select id="getInfo" resultType="com.example.demo.entity.StudentInfo">        select *        from student        where id=#{id}    select>    <insert id="insertInfo" parameterType="com.example.demo.entity.StudentInfo">        insert into student(id,sname,classId,birthday,email)        values (#{id},#{sname},#{classId},#{birthday},#{email});    insert>    <delete id="deleteById">        delete        from student        where id=#{id}    delete>    <update id="updateById" parameterType="com.example.demo.entity.StudentInfo">        update student        set sname = #{sname},classId = #{classId},                birthday = #{birthday}, email = #{email}        where id = #{id}    update>    <select id="selectAll" resultType="com.example.demo.entity.StudentInfo">        select *        from student    select>mapper>

StudentController:

import com.example.demo.entity.StudentInfo;import com.example.demo.service.StudentService;import org.springframework.beans.factory.annotation.Autowired;import org.springframework.web.bind.annotation.PathVariable;import org.springframework.web.bind.annotation.RequestMapping;import org.springframework.web.bind.annotation.RestController;import java.util.List;@RestController@RequestMapping("/demo10")public class StudentController {    @Autowired(required = false)    private StudentService studentService;        @RequestMapping("getInfo/{id}")    public StudentInfo getInfo( @PathVariable int id){        return studentService.getStudentInfo(id);    }        @RequestMapping("/insert    @RequestMapping("/delete")    public String deleteInfo(int id){        int result = studentService.deleteById(id);        if (result >= 1) {            return "删除成功";        } else {            return "删除失败";        }    }        @RequestMapping("/update    @RequestMapping("/selectAll")    public List<StudentInfo> ListStudent(){        return studentService.selectAll();    }}

启动程序

使用postman测试

测试：查询id为1的学生信息

URL：

localhost:8080/demo10/getInfo/1

测试：插入一条学生信息

URL：

localhost:8080/demo10/insert/?id=5&sname=小明&classId=103&birthday=1231&email=5@163.com

测试：删除id为5的学生信息

URL：

localhost:8080/demo10/delete?id=5

测试：修改id为4的学生信息

URL：

localhost:8080/demo10/update/?id=4&sname=小明&classId=103&birthday=1231&email=4@163.com

测试：查询学生表中全部信息

URL：

localhost:8080/demo10/selectAll

测试完成

继续学习SpringBoot整合MybatisPlus？请移步SpringBoot整合MybatisPlus（详细）

对控制台输出效果不满意？可添加日志使内容更详细，请移步为SpringBoot项目添加日志：slf4j

来源地址：https://blog.csdn.net/m0_68681879/article/details/127276006