TableUpdater

A framework of creating or updating mysql table

usage:

allprojects {
repositories {
...
maven { url 'https://jitpack.io' }
}
}

Maven:


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

<dependency>
   <groupId>com.github.FlyingYu-Z</groupId>
   <artifactId>TableUpdater</artifactId>
   <version>tag</version>
</dependency>

Gradle:
dependencies {
	        implementation 'com.github.FlyingYu-Z:TableUpdater:Tag'
	        implementation 'mysql:mysql-connector-java:8.0.23'
	}

import cn.beingyi.mysql.annotation.Column;
import cn.beingyi.mysql.annotation.Table;
import lombok.Getter;
import lombok.Setter;

import java.util.Date;

@Getter
@Setter
@Table(name = "user")

//@Table(name = "user",sql = "SET sql_mode=(SELECT REPLACE(@@sql_mode,'ONLY_FULL_GROUP_BY',''));")
public class User {
    @Column(name = "uid",type = "int(11)",autoGen = false,isKey = true,defaultValue = "0")
    private Integer uid;


    @Column(name = "username",type = "varchar(20)")
    private Integer username;

    @Column(name = "password",type = "varchar(20)")
    private String acceptOrderSum;

    @Column(name = "SignTime",type = "datetime")
    private Date SignTime;


}

Ready ready = new Ready();
        ready.setDbUrl("jdbc:mysql://127.0.0.1:3306/test?useUnicode=true&characterEncoding=UTF-8&&useSSL=true&serverTimezone=Asia/Shanghai");
        ready.setUserName("root");
        ready.setPassWord("123456");
        ready.setCharacterSet("utf8mb4");
        ready.setCollation("utf8mb4_general_ci");
        try {
            ReadyCore.init(ready)
            .initTable(
                    User.class
            );
        } catch (Exception e) {
            e.printStackTrace();
        }

It will create table automatically.