功能介紹

1.支持多種資料庫的建表 sql轉java, 其中包含(pg、oracle、mysql)等資料庫; 建表語句, 建表語句, 建表語句(重要的說3遍)
2.在轉換 sql 的時候, 需要確認下是否需要切換處理類型, 暫時支持3種處理方式(normal, postgresql, oracle), 默認: normal.
3.支持自定義是否需要 lombok, 包名, 駝峰
說明: 不能在 sql 中包含注釋內容(即: -- xxx 或 # xxx); 由於此工具是通過 ; 來分割語句處理.所以 normal 狀態下可以同時處理多個建表語句; postgresql 和 oracle 由於需要解析注釋, 只支持單個建表語句.

示例

mysql 建表語句

CREATE TABLE if not exists user (
id int NOT NULL AUTO_INCREMENT,
name varchar(10) NOT NULL COMMENT '姓名',
gender tinyint NOT NULL DEFAULT 0 COMMENT '性別 0-未知 1-男 2-女',
age int NOT NULL COMMENT '年齡',
created_date datetime DEFAULT CURRENT_TIMESP,
updated_date datetime DEFAULT CURRENT_TIMESP ON UPDATE CURRENT_TIMESP,
PRIMARY KEY (id)
);

處理後

// Code generated by https://gotool.top
package com.gotool.sql2java;



public class User {

    private Integer id;

    /**
    * 姓名
    */
    private String name;

    /**
    * 性別 0-未知 1-男 2-女
    */
    private Integer gender;

    /**
    * 年齡
    */
    private Integer age;

    private Date created_date;

    private Date updated_date;

    public Integer getId() {
        return this.id;
    }

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

    public String getName() {
        return this.name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getGender() {
        return this.gender;
    }

    public void setGender(Integer gender) {
        this.gender = gender;
    }

    public Integer getAge() {
        return this.age;
    }

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

    public Date getCreated_date() {
        return this.created_date;
    }

    public void setCreated_date(Date created_date) {
        this.created_date = created_date;
    }

    public Date getUpdated_date() {
        return this.updated_date;
    }

    public void setUpdated_date(Date updated_date) {
        this.updated_date = updated_date;
    }

}

pgsql 建表語句

CREATE TABLE if not exists user (
id character varying(32) NOT NULL DEFAULT sys_guid(),
name character varying(10) NOT NULL,
gender tinyint NOT NULL,
age tinyint NOT NULL,
created_date timesp without time zone DEFAULT now(),
updated_date timesp without time zone DEFAULT now(),
CONSTRAINT user_pkey PRIMARY KEY (id)
);
COMMENT ON TABLE user IS '用戶表';
COMMENT ON COLUMN user.id IS '主鍵';
COMMENT ON COLUMN user.name IS '姓名';
COMMENT ON COLUMN user.gender IS '性別 0-未知 1-男 2-女';
COMMENT ON COLUMN user.age IS '年齡';
COMMENT ON COLUMN user.created_date IS '創建時間';
COMMENT ON COLUMN user.updated_date IS '更新時間';

處理後

// Code generated by https://gotool.top
package com.gotool.sql2java;



public class User {

    /**
    * 主鍵
    */
    private String id;

    /**
    * 姓名
    */
    private String name;

    /**
    * 性別 0-未知 1-男 2-女
    */
    private Integer gender;

    /**
    * 年齡
    */
    private Integer age;

    /**
    * 創建時間
    */
    private Integer createdDate;

    /**
    * 更新時間
    */
    private Integer updatedDate;

    public String getId() {
        return this.id;
    }

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

    public String getName() {
        return this.name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getGender() {
        return this.gender;
    }

    public void setGender(Integer gender) {
        this.gender = gender;
    }

    public Integer getAge() {
        return this.age;
    }

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

    public Integer getCreatedDate() {
        return this.createdDate;
    }

    public void setCreatedDate(Integer createdDate) {
        this.createdDate = createdDate;
    }

    public Integer getUpdatedDate() {
        return this.updatedDate;
    }

    public void setUpdatedDate(Integer updatedDate) {
        this.updatedDate = updatedDate;
    }

}

oracle 建表語句

CREATE TABLE if not exists user (
id character varying(32) NOT NULL DEFAULT sys_guid(),
name character varying(10) NOT NULL,
gender tinyint NOT NULL,
age tinyint NOT NULL,
created_date date default sysdate,,
updated_date date default sysdate,,
CONSTRAINT user_pkey PRIMARY KEY (id)
);
COMMENT ON TABLE user IS '用戶表';
COMMENT ON COLUMN user.id IS '主鍵';
COMMENT ON COLUMN user.name IS '姓名';
COMMENT ON COLUMN user.gender IS '性別 0-未知 1-男 2-女';
COMMENT ON COLUMN user.age IS '年齡';
COMMENT ON COLUMN user.created_date IS '創建時間';
COMMENT ON COLUMN user.updated_date IS '更新時間';

處理後

// Code generated by https://gotool.top
package com.gotool.sql2java;



public class User {

    /**
    * 主鍵
    */
    private String id;

    /**
    * 姓名
    */
    private String name;

    /**
    * 性別 0-未知 1-男 2-女
    */
    private Integer gender;

    /**
    * 年齡
    */
    private Integer age;

    /**
    * 創建時間
    */
    private String createdDate;

    /**
    * 更新時間
    */
    private String updatedDate;

    public String getId() {
        return this.id;
    }

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

    public String getName() {
        return this.name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public Integer getGender() {
        return this.gender;
    }

    public void setGender(Integer gender) {
        this.gender = gender;
    }

    public Integer getAge() {
        return this.age;
    }

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

    public String getCreatedDate() {
        return this.createdDate;
    }

    public void setCreatedDate(String createdDate) {
        this.createdDate = createdDate;
    }

    public String getUpdatedDate() {
        return this.updatedDate;
    }

    public void setUpdatedDate(String updatedDate) {
        this.updatedDate = updatedDate;
    }

}