java对数据库的增删改查

导包
<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>


    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>
        <version>2.4.5</version>
        <relativePath/>
    </parent>

    <groupId>com.sdcet</groupId>
    <artifactId>restaurant</artifactId>
    <version>1.0-SNAPSHOT</version>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>

        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.1.3</version>
        </dependency>
    </dependencies>
</project>

---

UserController:

package com.sdcet.controller;
import com.sdcet.mapper.UserMapper;
import org.apache.ibatis.jdbc.Null;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.web.bind.annotation.*;

import java.util.Date;
import java.util.List;

public class UserController {
    @Controller
    @ResponseBody
    public class UserControlle{
        @Autowired
        private UserMapper usermapper;
        public ResponseMessage save{

        }
        @RequestMapping("/getName")
        public String getName(Long id){
            return usermapper.selectNameById(id);
        }
        @RequestMapping("/user")
        public User user(Long id){
            return usermapper.selectUserById(id);
        }
        @RequestMapping("/getUserByName")
        public List<User> getUserByName(String name){ return usermapper.selectUserByName(name); }
        @PostMapping("/save")
        public ResponseMessage save(@RequestBody User user){
            if (user.getName()== null ||"".equals(user.getName())){
                return ResponseMessage.fail("Column'password'cannot be null");
            }
            Date date = new Date();
            user .setCreateTime(date);
            user.setUpdateTime(date);
            return ResponseMessage.success(userMapper.save(user));
        }
        @PutMapping("/update")
        public int update(@RequestBody User user){ return usermapper.update(user); }

    }

}

---

UserMapper:

package com.sdcet.mapper;

import com.sdcet.controller.User;
import org.apache.ibatis.annotations.*;

import java.util.List;

@Mapper
public interface UserMapper {
    @Select("SELECT 'name' FROM user WHERE name = #{id}")
    String selectNameById(Long id);

    @Select("SELECT*FROM user WHERE name =#{id}")
    User selectUserById(Long id);

    @Select("SELECT id,'name',sex,password,phone_num,create_time,update_time FROM user WHERE 'name'=#(name)")
    List<User> selectUserByName(String name);

    @Insert("INSERT INTO user (name, sex, password, phone_num, create_time, update_time) VALUES (#{name}, #{sex}, #{password}, #{phoneNum}, #{createTime}, #{updateTime})")
    int save(User user);

    @Update("DELETE name = #{name},password = #{password},phone_num = #{phone_num}, sex = #{sex} create_time = #{createTime}, update_time = #{createTime},update_time = #{updateTime} WHERE id = #{id}")
    int update(User user);

    @Delete("DELETE FROM user WHERE id = #{id}")
    int delete(Long id);
}

---

yaml文件：

spring:
  datasource:
    url: jdbc:mysql://127.0.0.1:3306/restaurant?serverTimezone=Asia/Shanghai
    username: root
    password: ray200202162611
    driver-class-name: com.mysql.cj.jdbc.Driver

mybatis:
  configuration:
    map-underscore-to-camel-case: true
    log-impl: org.apache.ibatis.logging.stdout.StdDutImpl