使用 Mybatis 向 Postgresql 插入 UUID 字段

数据库

id 字段设置为 character varying

User 对象

id 设置为 String 类型

package com.example.springsecurity.entity;

import org.springframework.security.core.GrantedAuthority;
import org.springframework.security.core.userdetails.UserDetails;

import java.util.Collection;
import java.util.Date;
import java.util.List;
import java.util.UUID;

public class User implements UserDetails {

    private String id; 

    private String userName;

    private String password;

    //返回用户的角色列表，有助于管理权限
    @Override
    public Collection<? extends GrantedAuthority> getAuthorities() {
        return List.of();
    }

    @Override
    public String getPassword() {
        return password;
    }

    @Override
    public String getUsername() {
        return userName;
    }

    @Override
    public boolean isAccountNonExpired() {
        return true;
    }

    @Override
    public boolean isAccountNonLocked() {
        return true;
    }

    @Override
    public boolean isCredentialsNonExpired() {
        return true;
    }

    @Override
    public boolean isEnabled() {
        return true;
    }


    public String getId() {
        return id;
    }

    public void setId(String id) {
        this.id = id;
    }


    public void setUserName(String userName) {
        this.userName = userName;
    }

    public void setPassword(String password) {
        this.password = password;
    }

}

创建 User 对象

public User signup(RegisterUserDto input) {
    User user = new User();
    //将 UUID 转换成字符串格式，将破折号替换为空格
    user.setId(UUID.randomUUID().toString().replace("-", ""));
    user.setUserName(input.getUserName());
    user.setPassword(passwordEncoder.encode(input.getPassword()));
    userMapper.insertUser(user);
    //返回当前用户
    return userMapper.findByUserName(user.getUsername()).get();
}

UserMapper 声明插入方法

@Mapper
public interface UserMapper{
    Optional<User> findByUserName(String userName);

    void insertUser(User user);
}

user-mapper.xml

<insert id="insertUser" parameterType="com.example.springsecurity.entity.User">
    insert into user_acc (user_name, password)
    values(#{id}, #{userName}, #{password})
</insert>