准备工作-建表
 

USE tlias;

CREATE TABLE dept (
                      id int unsigned PRIMARY KEY AUTO_INCREMENT COMMENT 'ID, 主键',
                      name varchar(10) NOT NULL UNIQUE COMMENT '部门名称',
                      create_time datetime DEFAULT NULL COMMENT '创建时间',
                      update_time datetime DEFAULT NULL COMMENT '修改时间'
) COMMENT '部门表';

INSERT INTO dept VALUES (1,'学工部','2024-09-25 09:47:40','2024-09-25 09:47:40'),
                        (2,'教研部','2024-09-25 09:47:40','2024-09-09 15:17:04'),
                        (3,'咨询部','2024-09-25 09:47:40','2024-09-30 21:26:24'),
                        (4,'就业部','2024-09-25 09:47:40','2024-09-25 09:47:40'),
                        (5,'人事部','2024-09-25 09:47:40','2024-09-25 09:47:40'),
                        (6,'行政部','2024-11-30 20:56:37','2024-09-30 20:56:37');

applications.yml配置文件

#配置连接信息
spring:
  application:
    name:project02
  
  # 数据库配置信息
  datasource:
    url=jdbc:mysql://localhost:3306/tlias
    driver-class-name=com.mysql.cj.jdbc.Driver
    username=root
    password=123456
  #配置
  mybatis:
    configuration:
      log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
    mapper-locations: classpath:mapper/*.xml

package com.itheima.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.time.LocalDateTime;

@Data
@NoArgsConstructor
@AllArgsConstructor
public class Dept {
    private Integer id;
    private String name;
    private LocalDateTime createTime;
    private LocalDateTime updateTime;
}

dept,java与result.java

package com.itheima.pojo;

import lombok.Data;

import java.io.Serializable;

/**
 * 后端统一返回结果
 */
@Data
public class Result {

    private Integer code; //编码：1成功，0为失败
    private String msg; //错误信息
    private Object data; //数据

    public static Result success() {
        Result result = new Result();
        result.code = 1;
        result.msg = "success";
        return result;
    }

    public static Result success(Object object) {
        Result result = new Result();
        result.data = object;
        result.code = 1;
        result.msg = "success";
        return result;
    }

    public static Result error(String msg) {
        Result result = new Result();
        result.msg = msg;
        result.code = 0;
        return result;
    }

}