springboot-jpa通过表完成分布式id 生成， @GeneratedValue和@TableGenerator用法

pom文件

    4.0.0

    com.dkp
    springboot-jpa
    1.0.0

    
        org.springframework.boot
        spring-boot-starter-parent
        2.0.6.RELEASE
    

    

        
            org.springframework.boot
            spring-boot-starter-web
        

        
            mysql
            mysql-connector-java
        

        
            org.springframework.boot
            spring-boot-starter-data-jpa
        


        
            org.springframework.boot
            spring-boot-starter-test
            test
        
    

    
        
            
                org.springframework.boot
                spring-boot-maven-plugin
            
        
    

创建表

-- mysql
create table id_gen (GEN_KEY varchar(255) not null, GEN_VALUE bigint, primary key (GEN_KEY));

准备实体

package com.dkp.entity;

import javax.persistence.*;

@Entity
@Table(name = "t_user")
public class User {

    
    @Id
    @GeneratedValue(strategy = GenerationType.TABLE, generator = "userGen")
    @TableGenerator(name = "userGen",
            table = "ID_GEN",
            pkColumnName = "GEN_KEY",
            valueColumnName = "GEN_VALUE",
            pkColumnValue = "t_user"
    )
    private Long id;

    private Integer age;

    private String uname;

    private String note;

    public Long getId() {
        return id;
    }

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

    public Integer getAge() {
        return age;
    }

    public void setAge(Integer age) {
        this.age = age;
    }

    public String getUname() {
        return uname;
    }

    public void setUname(String uname) {
        this.uname = uname;
    }

    public String getNote() {
        return note;
    }

    public void setNote(String note) {
        this.note = note;
    }

    @Override
    public String toString() {
        return "User{" +
                "id=" + id +
                ", age=" + age +
                ", uname='" + uname + ''' +
                ", note='" + note + ''' +
                '}';
    }
}

准备dao

package com.dkp.dao;

import com.dkp.entity.User;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import java.util.List;
import java.util.Map;


public interface UserDao extends JpaRepository {

    @Query(value = "select uname from t_user where id = :id" ,nativeQuery = true)
    List> getUser(@Param("id") Long id);
}

准备 启动类

package com.dkp;


import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

@SpringBootApplication
public class App {
    public static void main(String[] args) {
        SpringApplication.run(App.class,args);
    }
}

创建test类测试

@RunWith(SpringRunner.class)
@SpringBootTest
public class AppTest {


    @Autowired
    private UserDao userDao;

   @Test
    public void test01(){
        User user = new User();
        user.setNote("我是笔记1");
        user.setUname("hq1");
        user.setAge(32);
        User tuser = userDao.save(user);
        System.out.println(tuser);
    }
}

git 项目地址：https://gitee.com/dukangping/springboot-jpa