Springboot对mysql数据库进行增删改查操作

一、创建Springboot项目并创建包、class、interface。如图所示

1.1各个class和interface文件中的代码
User:

package com.example.demo.entity
import lombok.Data;
import org.hibernate.annotations.CreationTimestamp;
import org.springframework.format.annotation.DateTimeFormat;
import javax.persistence.*;
import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;


@Table(name ="company")
@Entity
@Data
public class User implements Serializable {
   
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Integer id;
    private String company_code;
    private Boolean monitor_type;
    private String sys_name;
    private Integer   equipment_type_id;
    private String equipment_type_name;
    private Integer sensor_type_id;
    private String sensor_type_name;
    private Integer technology_type_id;
    private String technology_type_name;
    private String department;
    private String sensor_code;
    private String location;
    private String storage_material;
    private BigDecimal level_alarm_high;
    private BigDecimal secondary_alarm_high;
    private BigDecimal level_alarm_low;
    private BigDecimal secondary_alarm_low;
    private Integer operate_id;
    private String operate_username;

    @CreationTimestamp
    @Column(name="create_time")
    @DateTimeFormat(pattern = "yyyy-mm-dd")
    private Date create_time;
    @CreationTimestamp
    @Column(name="update_time")
    @DateTimeFormat(pattern = "yyyy-mm-dd")
    private Date update_time;
  }
}

UserDao:

package com.example.demo.dao;

import com.example.demo.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;

import java.util.List;

public interface UserDao extends JpaRepository<User,Integer> {
   
    List<User> findById(int id);

UserService:

package com.example.demo.service;

import com.example.demo.entity.User;


import java.util.List;

public interface UserService {
   
    /**
     * 根据查询用户
     * @return
     */
   // List<User> queryByTypeid(int typed);

    /**
     * 保存用户
     * @param user
     * @return
     */
    User save(User user);

    /**
     * 根据主键删除用户
     * @param id
     */
    void deletUserById(int id);

    /**
     * 根据主键查询
     * @param id
     * @return
     */
    User queryById(int id);
}

UserController:

package com.example.demo.controller;

import com.example.demo.entity.User;
import com.example.demo.service.RedisService;
import com.example.demo.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

@RestController
@RequestMapping("user")
public class UserController {
   

    @Autowired
    private UserService userService;

    @Autowired
    private RedisService redisService;

    @GetMapping(