Spring Boot入门样例-050-Mybatis半自动化读取数据库

最新推荐文章于 2020-09-26 16:30:22 发布

huashenghn

最新推荐文章于 2020-09-26 16:30:22 发布

阅读量205

点赞数

本文链接：https://blog.csdn.net/huashenghn/article/details/102728861

版权

Spring Boot入门样例专栏收录该内容

45 篇文章 0 订阅

订阅专栏

Spring Boot入门样例-050-Mybatis半自动化读取数据库

jpa hibernate自动读取数据库对于单表操作比较方便，对于复杂的查询语句，使用jpa就比较麻烦。本demo演示如何使用mybatis半自动化操作数据库。

前言

本Spring Boot入门样例准备工作参考：

pox.xml

必要的依赖如下，具体参见该项目的pox.xml

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-data-jpa</artifactId>
        </dependency>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>

配置文件

resources/application.yml配置内容

spring:
  datasource:
    driverClassName: com.mysql.jdbc.Driver
    url: jdbc:mysql://localhost:3306/springbootdemo?useUnicode=true&characterEncoding=utf-8&useSSL=false&useAffectedRows=true
    username: root
    password: root

mybatis:
  mapper-locations: classpath*:mapper/*.xml
  configuration:
    map-underscore-to-camel-case: true

代码解析

该项目有很多目录，分别说明如下：

controller目录为控制器文件
entity目录为实体目录，对应表格中的字段
mapper目录数据存取对象
service为服务接口目录
service/impl为服务接口具体实现目录
util为工具类目录，加入分布式id雪花算法
resources/mapper/为mapper对应xml文件路径，在yml配置文件中有定义

Student.java 每个字段对应表格一个字段，需要指定@Entity和表格@Table和@Id

@Data
@Entity
@Table(name = "student")
public class Student {
    private static final long serialVersionUID = 1L;

    @Id
    private String id = String.valueOf(SnowFlake.getInstance().nextId());

    private String name;

    private Integer age;
}

StudentMapper.java 操作表格的对象方法，简单的可以用@Select，复杂的可以对应到StudentMapper.xml文件

@Mapper
public interface StudentMapper {
    @Select("SELECT * FROM student")
    List<Student> list();

    int save(@Param("student") Student student);
}

resources/mapper/StudentMapper.xml 文件对应Mapper文件，通过id关联

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.funsonli.springbootdemo050mybatis.mapperStudentMapper">
    <insert id="save">
        INSERT INTO `student` (`id`,
                                `name`,
                                `age`)
        VALUES (#{student.name},
                #{student.password},
                #{student.age})
    </insert>
</mapper>

StudentService.java 提供给controller的服务接口

public interface StudentService {
    List<Student> list();
    Integer save(Student student);
}

StudentServiceImpl.java 服务接口的具体实现，使用Dao操作数据库

@Service
public class StudentServiceImpl implements StudentService {
    @Autowired
    StudentDao studentDao;

    @Override
    public List<Student> index() {
        return studentDao.list();
    }

    @Override
    public Integer save(Student student) {
        return studentDao.save(student);
    }
}

StudentController.java 控制器，调用service操作数据库

@Slf4j
@RestController
@RequestMapping("/student")
public class StudentController {

    @Autowired
    StudentService studentService;

    @GetMapping({"", "/", "index"})
    public String index() {
        return studentService.index().toString();
    }

    @GetMapping("/add/{name}/{age}")
    public String add(HttpServletRequest request, @PathVariable String name, @PathVariable Integer age) {
        Student model = new Student();
        model.setName(name);
        model.setAge(age);

        int res = studentService.save(model);
        return String.valueOf(res);
    }
}

运行

点击运行

浏览器访问 http://localhost:8080/student/add/funson/30
浏览器访问 http://localhost:8080/student/add/zhonghua/28

浏览器访问 http://localhost:8080/student/
[Student(id=381159203135426560, name=funson, age=30), Student(id=381159203135926560, name=zhonghua, age=26)]