sql2java

# 下载源码
git clone https://gitee.com/l0km/sql2java.git
cd sql2java 
# 编译全部
mvn install 

# 指定 JDBC driver,告诉sql2java如何连接数据
jdbc.driver=com.mysql.jdbc.Driver
# 对于 mysql 数据库，如果 useInformationSchema=false 或没指定,则无法获取表中的注释信息
jdbc.url=jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useInformationSchema=true
jdbc.username=root
jdbc.password=
jdbc.schema=test

# 定义生成代码的包名
codewriter.package=sql2java.test

$ mvn com.gitee.l0km:sql2java-maven-plugin:generate \
	-Dsql2java.classpath=lib/mysql-connector-java-5.1.43-bin.jar \
	-Dsql2java.propfile=mysql2java.properties

[INFO] Scanning for projects...
[INFO] 
[INFO] ------------------------------------------------------------------------
[INFO] Building sql2java test 0.0.0-SNAPSHOT
[INFO] ------------------------------------------------------------------------
[INFO] 
[INFO] --- sql2java-maven-plugin:1.0.6-SNAPSHOT:generate (default-cli) @ sql2java-test ---
        database properties initialization
[INFO] classpath: [file:/D:/j/sql2java.test/lib/mysql-connector-java-5.1.43-bin.jar]
Connecting to root on jdbc:mysql://localhost:3306/test?characterEncoding=utf8&useInformationSchema=true ...
    Connected.
    Database server :MySQL.
Loading table list according to pattern t_% ...
    table t_book found
    table t_user found
samePrefix = [t_]
Loading columns ...
        t_book.id INT  default value: null
        t_book.name VARCHAR  default value: null
        t_book.borrower INT  default value: null
    t_book found 3 columns
        t_user.id INT AUTOINCREMENT default value: null
        t_user.name VARCHAR  default value: null
        t_user.birthdate DATE  default value: null
        t_user.phone VARCHAR  default value: null
        t_user.address VARCHAR  default value: null
    t_user found 5 columns
Database::loadPrimaryKeys
Found primary key (seq,name) (1,id) for table 't_book'
Found primary key (seq,name) (1,id) for table 't_user'
Loading imported keys ...
    t_book.id -> t_user.id found seq:1 foreign key name:fk_id
    UPDATE_RULE:NO_ACTION    DELETE_RULE:RESTRICT
Loading indexes ...
  Found interesting index phone_UNIQUE on phone for table t_user
Loading procedures ...
Generating template /templates/velocity/java5g/perschema/constant.java.vm
 .... writing to src/main\java\sql2java\test\Constant.java
    java\sql2java\test\Constant.java done.
Generating template /templates/velocity/java5g/perschema/database.properties.vm
 .... writing to src/main\resources/conf\database.properties
    resources/conf\database.properties done.
Generating template /templates/velocity/java5g/perschema/gu.sql2java.irowmetadata.vm
 .... writing to src/main\resources/META-INF/services\gu.sql2java.IRowMetaData
    resources/META-INF/services\gu.sql2java.IRowMetaData done.
Generating template /templates/velocity/java5g/pertable/bean.java.vm
 .... writing to src/main\java\sql2java\test\BookBean.java
    java\sql2java\test\BookBean.java done.
Generating template /templates/velocity/java5g/pertable/manager.interface.java.vm
 .... writing to src/main\java\sql2java\test\IBookManager.java
    java\sql2java\test\IBookManager.java done.
Generating template /templates/velocity/java5g/pertable/metadata.java.vm
 .... writing to src/main\java\sql2java\test\BookMetaData.java
    java\sql2java\test\BookMetaData.java done.
Generating template /templates/velocity/java5g/pertable/bean.java.vm
 .... writing to src/main\java\sql2java\test\UserBean.java
    java\sql2java\test\UserBean.java done.
Generating template /templates/velocity/java5g/pertable/manager.interface.java.vm
 .... writing to src/main\java\sql2java\test\IUserManager.java
    java\sql2java\test\IUserManager.java done.
Generating template /templates/velocity/java5g/pertable/metadata.java.vm
 .... writing to src/main\java\sql2java\test\UserMetaData.java
    java\sql2java\test\UserMetaData.java done.
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 1.248 s
[INFO] Finished at: 2019-12-16T13:51:20+08:00
[INFO] Final Memory: 13M/308M
[INFO] ------------------------------------------------------------------------

mvn com.gitee.l0km:sql2java-maven-plugin:help

$ mvn com.gitee.l0km:sql2java-maven-plugin:help -Dsql2java.output=my.properties
[INFO] Scanning for projects...
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building sql2java test 1.0.2
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- sql2java-maven-plugin:1.0.2:help (default-cli) @ sql2java-test ---
[INFO] OUTPUT PROPRETIES TO J:\sql2java.test\my.properties
[INFO] ------------------------------------------------------------------------
[INFO] BUILD SUCCESS
[INFO] ------------------------------------------------------------------------
[INFO] Total time: 0.495 s
[INFO] Finished at: 2019-11-20T15:25:27+08:00
[INFO] Final Memory: 10M/308M
[INFO] ------------------------------------------------------------------------

#______________________________________________
#
# (1/8) 数据库访问配置(必填)
#______________________________________________
# JDBC驱动类名
#jdbc.driver=org.hsqldb.jdbcDriver
# 数据库访问的URL
#jdbc.url=jdbc:hsqldb:hsql://localhost
# 访问数据库的用户名
#jdbc.username=sa
# 访问数据库的密码
#jdbc.password=
# 访问的数据库名
#jdbc.schema=null
#______________________________________________
#
# (2/8) 配置自增长键的检索方式(可选)
#______________________________________________
# 此部分配置用于在插入记录时获取自增长键的值
# 对于JDBC 3.0以上支持PreparedStatement.getGeneratedKeys方法
# (DatabaseMetaData.supportsGetGeneratedKeys()返回true)的JDBC 驱动不需要配置此部分
#
# generatedkey.retrieve 可选值:
#
# auto - [默认值]getGeneratedKeys方法自动获取，当使用JDBC 3.0 driver时适用.
#
# before - 在插入(insert)记录之前获取自增长键值
#
# after - 在插入(insert)记录之后获取自增长键值
#
# generatedkey.statement用于定义获取自增长键值的SQL语句
# If you set it to before or after you also need to configure the
# autogeneratedkey.statement properties.
# <TABLE> 占位符用于取代当前表名
# <KEY> 占位符用于取代当前自增长键字段名
#
#generatedkey.retrieve=auto
#generatedkey.statement=

#______________________________________________
#
# (3/8) 生成代码配置(可选)
#______________________________________________

# 生成java代码的包名
codewriter.package=gu.sql2java.demo

# 生成java代码的文件夹
codewriter.destdir=src/main
# 生成扩展java代码的文件夹
#codewriter.destdir.extension=
# 生成扩展java代码的包名
#codewriter.package.extension=

# 定义被bean.converter.utils.java.vm 模板忽略的字段名
#general.beanconverter.tonative.ignore=create_time,update_time

# 生成的java bean是否支持facebook/swift 注释(annotation)
#swift.annotation.bean = true 
#　生成的java bean是否支持swagger 注释(annotation)
#swagger.annotation.bean = true 

# 对于有primitive 类型(Integer,Long,Double...)的字段是否生成primitive类型的setter方法 
codewriter.bean.primitiveSetter = true
# generate Long setter for Date type
# 对于 java.util.Date 类型的字段是否生成 Long类型的setter方法
codewriter.bean.dateLongSetter = true

# Date 类型的JSON 序列化类型 :
# Long 系统时间(毫秒)
# String ISO8601 时间日期格式的字符串
# 当指定了 swift或jackon注解时有效
codewriter.bean.dateSerializeType = Long

# 当 dateSerializeType 为 String 的日期格式,默认为IS8601 格式
codewriter.bean.dateStringFormat=yyyy-MM-dd'T'HH:mm:ss.SSSZ

# modified,initialized 字段的类型(不要修改)
bitstate.type = int

# 字节数对应的java类型：
#  byte[]
#  java.nio.ByteBuffer
# default byte[] if not specialized
#binary.type = byte[]

# add @JsonRawValue @JsonDeserialize annotation for JSON field 
#json.jackson.rawvalue = false
#set properties file name for database 
database.properties.env=config_folder
database.properties.isdebug=false
database.properties.dir=resources/conf
database.properties=database.properties
#flag for compatible with axis2
#bean.compatible_axis2=true
# Property file to use when initializing Velocity
#codewriter.velocityprops=somefile

# 默认加载模板的路径(不要修改)
velocity.templates.loadingpath=/templates/velocity/includes

# 为每张表(pertable)和每个方案(perschema)加载子模板的加载起始路径(不要修改)
velocity.templates=/templates/velocity/

############ 扩展模板 ###############
# 用户可以通过下面的扩展模板参数，指定自己定义的模板(.vm)文件的位置
# sql2java generator会根据指定的参数执行扩展模板生成代码 
# 扩展模板的加载路径
#velocity.templates.loadingpath.extension=
# 为每张表(pertable)和每个方案(perschema)加载扩展模板的加载起始路径	
#velocity.templates.extension =

# sets a prefix to prepend to all generated classes
# useful if you are worried about namespace collision with reserved words
# or java.lang classes
codewriter.classprefix=

# 是否为字段生成默认值
codewriter.generate.defaultvalue=true

#______________________________________________
#
# (4/8) 表和模板过滤配置(可选)
#______________________________________________
#
# 通过表类型过滤
# 用于指定需要生成代码的表类型(用逗号分隔的表类型列表)
# 表类型定义为：TABLE, VIEW, SYSTEM TABLE, SYNONYM
jdbc.tabletypes=TABLE, VIEW

# 通过表名过滤
# 使用通配%来过滤需要生成代码的表名
# 你可以指定一个逗号分割的通配符过滤列表
# 比如 %_name,ul_% 只对后缀为_name,或前缀为ul_的表名生成代码
# 默认对schema中所有的表生成代码
jdbc.tablenamepattern=%

# 表名白名单/名单过滤(此特性暂未启用)
# 白名单
# 空格分隔的表名列表，只在此名单中的表才会被生成代码
# 黑名单
# 空格分隔的表名列表，在此名单中的表不会被生成代码
# 白名单和黑名单只能定义一个，如果同时指定了白名单和黑名单则忽略黑名单  
# 白名单过滤
tables.include=
# 黑名单过滤
tables.exclude=

# 模板文件夹名白名单/名单过滤
# 白名单
# 空格分隔的表名列表，只在此名单中的模板文件夹中的模板才会被生成代码
# 黑名单
# 空格分隔的表名列表，在此名单中的模板文件夹中的模板不会被生成代码
# 白名单和黑名单只能定义一个，如果同时指定了白名单和黑名单则忽略黑名单  
template.folder.exclude=
template.folder.include=java5g   
# java5g : general bean & manager templates for java5

# (6/8) WHAT SHOULD BE DISPLAYED/NOT DISPLAYED ON THE FRONTEND ?
#        empty means all fields
#______________________________________________
# 逗号分割的字段名列表定义只能本地可见的字段
# A comma separated list of field names in a specified table that can only be accessed locally
# Equivalent to defining in the annotation of a field: ' SCOPE@LOCAL@EPOSC '
# Example:
#  table.user_info.scope.local=private_time,password
# 逗号分割的字段名列表定义THRIFT可见的字段
# A comma separated list of field names in a specified table that can be transmitted by RPC 
# in addition to being accessible locally
# Equivalent to defining in the annotation of a field: ' SCOPE@THRIFT@EPOSC '
# Example:
#  table.user_info.scope.thrift=password
# 逗号分割的字段名列表定义JSON可见的字段
# A comma separated list of field names in a specified table that can be serialized by JSON 
# in addition to being accessible locally
# Equivalent to defining in the annotation of a field: ' SCOPE@JSON@EPOSC '
# Example:
#  table.user_info.scope.json=private_time,password

# jdbc TIME类型映射的java类型，可选值：
#  java.sql.Time
#  java.util.Date
jdbc2java.time=java.util.Date

# jdbc TIMESTAMP类型映射的java类型，可选值：
#  java.sql.Timestamp
#  java.util.Date
jdbc2java.timestamp=java.util.Date

#______________________________________________
#
# (8/8) 乐观锁配置(可选)
#______________________________________________
# optimisticlock.type 有两个可选项值:
# none - 乐观锁机制未启用(default).
# timestamp - 乐观锁字段包含 System.currentTimeMillis() 值.
#
# optimisticlock.column 定义乐观锁的字段名，如果字段名不存在则乐观锁机制不会启用
# 乐观锁的字段类型可以是java.lang.Long or java.lang.String.
optimisticlock.type=timestamp
optimisticlock.column=version_time

CREATE TABLE IF NOT EXISTS dc_device_channel (
    `device_id`     int         NOT NULL COMMENT 'X@NAME:设备ID@X',
    `sid`           int         NOT NULL DEFAULT 0 COMMENT 'X@NAME:物理屏幕ID@x',
    `area`          varchar(32) NOT NULL COMMENT 'X@NAME:显示区域ID@x',
    `rect`          varchar(256) DEFAULT NULL COMMENT 'ANN@gu.sql2java.annotations.ColumnCodecConfig(net.facelib.eam.interpreter.sql2java.EamPlayColumnCodec.class)@NNATYPE@net.facelib.eam.interpreter.Rectangle@EPYTX@NAME:显示区域坐标@x,对应EamPlayer的defineChannel语法',
    `channel`       varchar(32) NOT NULL COMMENT 'X@NAME:频道ID@x,显示区域对应的频道',
    `run_tasks`     text DEFAULT NULL COMMENT 'X@NAME:播放任务@X描述,设备实际播放的任务描述,由设备端写入,对应EamPlayer的definePlanTask和defineTrigger语法',
    PRIMARY KEY(`device_id`,`sid`,`area`),
    FOREIGN KEY (device_id)  REFERENCES dc_device(id) ON DELETE CASCADE,
    INDEX (channel)
)COMMENT 'X@NAME:设备显示区域频道记录@X' DEFAULT CHARSET=utf8;

    /** comments:X@NAME:显示区域坐标@x,对应EamPlayer的defineChannel语法 */
    @ApiModelProperty(value = "X@NAME:显示区域坐标@x,对应EamPlayer的defineChannel语法"  ,dataType="Rectangle")
    @CodegenLength(max=256)@CodegenInvalidValue
    @ExcelColumn(sort=4)
    @gu.sql2java.annotations.ColumnCodecConfig(net.facelib.eam.interpreter.sql2java.EamPlayColumnCodec.class)
    private net.facelib.eam.interpreter.Rectangle rect;

    @ThriftField(value=7)
    @JsonProperty("rect")
    public net.facelib.eam.interpreter.Rectangle getRect(){
        return rect;
    }

    @ThriftField(name="rect")
    @JsonProperty("rect")
    public void setRect(net.facelib.eam.interpreter.Rectangle newVal)
    {
        modified |= DC_DEVICE_CHANNEL_ID_RECT_MASK;
        initialized |= DC_DEVICE_CHANNEL_ID_RECT_MASK;

        if (Objects.equals(newVal, rect)) {
            return;
        }
        rect = newVal;
    }

    public String readRect(){
        return metaData.columnCodecs[DC_DEVICE_CHANNEL_ID_RECT].serialize(rect,String.class);
    }

    public void writeRect(String newVal){
        modified |= DC_DEVICE_CHANNEL_ID_RECT_MASK;
        initialized |= DC_DEVICE_CHANNEL_ID_RECT_MASK;
        rect = metaData.columnCodecs[DC_DEVICE_CHANNEL_ID_RECT].deserialize(newVal,metaData.fieldOf(DC_DEVICE_CHANNEL_ID_RECT).getGenericType());
    }

SCOPE@(LOCAL|JSON|THRIFT)@EPOSC

CREATE TABLE IF NOT EXISTS dc_device (
  `id`             int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT 'X@NAME:设备id@X',
  `name`           varchar(32) DEFAULT NULL COMMENT 'X@NAME:设备名称@X,用户指定',
  `physical_address` varchar(32) NOT NULL UNIQUE COMMENT '设备X@NAME:物理地址@X,MAC地址,IMEI或其他设备识别码',
  `private_time`     bigint DEFAULT 0 COMMENT 'SCOPE@LOCAL@EPOSC设备令牌创建的时间戳(毫秒),每次创建设备令牌都会修改此字段',
  `os_arch`        varchar(64) DEFAULT NULL COMMENT 'X@NAME:操作系统平台@X,操作系统名称及版本及硬件架构名称,例如:Windows-x86_64,Linux-x86_64,Android-arm...'
) COMMENT 'X@NAME:前端设备记录@X,前端设备基本信息' DEFAULT CHARSET=utf8;

    /** comments:设备令牌创建的时间戳(毫秒),每次创建设备令牌都会修改此字段 */
    @ApiModelProperty(value = "设备令牌创建的时间戳(毫秒),每次创建设备令牌都会修改此字段"  ,dataType="Long")
    @CodegenDefaultvalue("0")@CodegenInvalidValue("-1")
    @ExcelColumn(sort=9)
    @com.alibaba.fastjson.annotation.JSONField(serialize = false,deserialize = false)
    @com.fasterxml.jackson.annotation.JsonIgnore
    private Long privateTime;
    /**
     * Getter method for {@link #privateTime}.<br>
     * Meta Data Information (in progress):
     * <ul>
     * <li>full name: dc_device.private_time</li>
     * <li>comments: 设备令牌创建的时间戳(毫秒),每次创建设备令牌都会修改此字段</li>
     * <li>default value: '0'</li>
     * <li>column size: 19</li>
     * <li>JDBC type returned by the driver: Types.BIGINT</li>
     * </ul>
     *
     * @return the value of privateTime
     */
    @JsonIgnore
    public Long getPrivateTime(){
        return privateTime;
    }

struct DeviceBean {
  1: required bool _new;
  2: required i32 modified;
  3: required i32 initialized;
  4: optional i32 id;
  5: optional string name;
  6: optional string physicalAddress;
  7: optional string osArch;
}

CREATE TABLE IF NOT EXISTS dc_device (
	`id`       int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT '设备id',
    `online`   boolean DEFAULT false COMMENT '[NUM,Boolean],是否在线标记'	
);

# 
# add @JsonRawValue @JsonDeserialize annotation for JSON field 
#json.jackson.rawvalue = true

    /** comments:[JSON_STR]JSON格式的扩展字段(最大64KB),用于定义扩展信息,online_time:开机时间,offline_time:关机时间,close_time:闭站时间,operator:操作人 */
    @ApiModelProperty(value = "[JSON_STR]JSON格式的扩展字段(最大64KB),用于定义扩展信息,online_time:开机时间,offline_time:关机时间,close_time:闭站时间,operator:操作人"  ,dataType="String")
    @CodegenLength(max=65535)@CodegenInvalidValue
    @com.fasterxml.jackson.annotation.JsonRawValue
    @com.fasterxml.jackson.databind.annotation.JsonDeserialize(using = gu.sql2java.json.RawJsonDeserializer.class)
    private com.alibaba.fastjson.JSONObject props;

    @ThriftField(value=16)
    @JsonProperty("props")
    public String getProps(){
        return null == props ? null : props.toJSONString();
    }
    @ThriftField(name="props")
    @JsonProperty("props")
    public void setProps(String newVal)
    {
        modified |= DC_DEVICE_GROUP_ID_PROPS_MASK;
        initialized |= DC_DEVICE_GROUP_ID_PROPS_MASK;

        props =  com.alibaba.fastjson.JSONObject.parseObject(newVal,com.alibaba.fastjson.JSONObject.class);
    }

    /** 
     * read method for {@link #props}<br>
     * @return the JSON value of props
     */
    public com.alibaba.fastjson.JSONObject readProps(){
        return props;
    }
    /** 
     * write method for {@link #props} with JSON object.<br>
     */
    public void writeProps(com.alibaba.fastjson.JSONObject newVal){
        modified |= DC_DEVICE_GROUP_ID_PROPS_MASK;
        initialized |= DC_DEVICE_GROUP_ID_PROPS_MASK;
        if (Objects.equals(newVal, props)) {
            return;
        }
        props = newVal;
    }

{
    "modified": 0,
    "initialized": 65535,
    "new": false,
    "id": 5,
    "name": "连平客运总站",
    "address": null,
    "props": {
    	"offline_time": "22:00",
    	"online_time": "8:00",
    	"operator": "unknow"
    },
    "createTime": "2022-07-06T12:41:56.000+0800",
    "updateTime": "2022-07-06T12:41:56.000+0800"
}

# generate @ExcelSheet,@ExcelColumn annotation if true
excel.annotation.bean = true  

CREATE TABLE IF NOT EXISTS dc_device (
  `id`          int(11) NOT NULL PRIMARY KEY AUTO_INCREMENT COMMENT 'X@NAME:设备id@X',
  `group_id`    int(11) DEFAULT 1 COMMENT 'X@NAME:所属设备组id@X',
  `features`    int(11) DEFAULT 0 COMMENT 'X@NAME:设备组特性标志@X,应用层定义',
  `name`        varchar(32) DEFAULT NULL COMMENT 'X@NAME:设备名称@X,用户指定',
  `physical_address` varchar(32) NOT NULL UNIQUE COMMENT '设备X@NAME:物理地址@X,MAC地址,IMEI或其他设备识别码',
  `address_type`varchar(16) NOT NULL DEFAULT 'MAC' COMMENT '设备物理X@NAME:地址类型@X(MAC,IMEI...),默认6字节MAC地址(HEX)',
  `iot_card`    varchar(32) DEFAULT NULL UNIQUE COMMENT '设备X@NAME:物联网卡编号@X,例如联通叫iccid',
  `status`      varchar(32) NOT NULL DEFAULT 'ENABLE' COMMENT 'X@NAME:设备状态@X,X@VALUES:ENABLE:正常,DISABLE:禁用,MAINTAIN:维护,PENDING:挂起(待审核)@X',
  `private_time`  bigint DEFAULT 0 COMMENT '设备令牌创建的时间戳(毫秒),每次创建设备令牌都会修改此字段',
  `screen_info` varchar(32) DEFAULT NULL COMMENT 'X@NAME:设备屏幕信息@X,格式示例:15H1080x960--15(英)寸横屏分辨率1080x960,21V960x1080--21(英)寸横屏分辨率960x1080',
  `fixed_mode`  varchar(8) DEFAULT 'FLOOR' COMMENT '设备X@NAME:安装方式@X,X@VALUES:HANG:悬挂,FLOOR:落地@X',
  `os_arch`     varchar(64) DEFAULT NULL COMMENT 'X@NAME:操作系统平台@X,操作系统名称及版本及硬件架构名称,例如:Windows-x86_64,Linux-x86_64,Android-arm...',
  `network`     varchar(32) DEFAULT NULL COMMENT 'X@NAME:网络连接类型@X:4G,WIFI,ETHERNET',
  `version_info`varchar(32) DEFAULT NULL COMMENT '设备端应用程序的X@NAME:版本@X号,格式由应用层定义',
  `model`       varchar(32) DEFAULT NULL COMMENT 'X@NAME:设备型号@X',
  `vendor`      varchar(32) DEFAULT NULL COMMENT 'X@NAME:设备供应商@X',
  `device_detail` varchar(512) DEFAULT NULL COMMENT '[JSON_STR,obj]X@NAME:设备产品详细信息@X,以JSON格式定义设备详细信息,JSON字段:X@NAMES:device_name:产品名称,manufacturer:制造商,made_date:生产日期@X,应用层可根据需要扩展',
  `props`       text DEFAULT NULL COMMENT '[JSON_STR,obj]JSON格式的扩展字段(最大64KB),用于定义扩展信息,X@NAMES:last_active_time:上次在线时间,disk_capacity:磁盘容量,status_comment:状态变更说明@X',
  `plan_id`     varchar(64) DEFAULT NULL COMMENT 'X@NAME:当前节目ID@X',
  `target_id`   varchar(64) DEFAULT NULL COMMENT 'X@NAME:目标节目ID@X',
  `remark`      varchar(256) DEFAULT NULL COMMENT 'X@NAME:备注@X',
  `create_time` timestamp DEFAULT CURRENT_TIMESTAMP COMMENT 'X@NAME:记录创建时间@X',
  `update_time` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'X@NAME:记录修改时间@X'
) COMMENT 'X@NAME:前端设备记录@X,前端设备基本信息,X@SHEET:titleFillColor=YELLOW,hideColumns=private_time|props|device_detail@X' DEFAULT CHARSET=utf8;

/**
 * DeviceBean is a mapping of dc_device Table.
 * <br>Meta Data Information (in progress):
 * <ul>
 *    <li>comments: 前端设备记录,前端设备基本信息, </li>
 * </ul>
 * @author guyadong
*/
@ExcelSheet(sheetName="dc_device",title="前端设备记录",titleFillColor="YELLOW",hideColumns={"private_time","props","device_detail"})
public final class DeviceBean extends BaseRow
    implements Serializable,Constant
{
    private static final long serialVersionUID = -3495281739409382636L;

    /** comments:设备id */
    @ExcelColumn(sort=1,name="设备id")
    private Integer id;

    /** comments:所属设备组id */
    @ExcelColumn(sort=2,name="所属设备组id")
    private Integer groupId;

    /** comments:设备组特性标志,应用层定义 */
    @ExcelColumn(sort=3,name="设备组特性标志")
    private Integer features;

    /** comments:设备名称,用户指定 */
    @ExcelColumn(sort=4,name="设备名称")
    private String name;

    /** comments:设备物理地址,MAC地址,IMEI或其他设备识别码 */
    @ExcelColumn(sort=5,name="物理地址")
    private String physicalAddress;

    /** comments:设备物理地址类型(MAC,IMEI...),默认6字节MAC地址(HEX) */
    @ExcelColumn(sort=6,name="地址类型")
    private String addressType;

    /** comments:设备物联网卡编号,例如联通叫iccid */
    @ExcelColumn(sort=7,name="物联网卡编号")
    private String iotCard;

    /** comments:设备状态,ENABLE:正常,DISABLE:禁用,MAINTAIN:维护,PENDING:挂起(待审核) */
    @ExcelColumn(sort=8,name="设备状态",readConverterExp="ENABLE=正常, DISABLE=禁用, MAINTAIN=维护, PENDING=挂起(待审核)")
    private String status;

    /** comments:设备令牌创建的时间戳(毫秒),每次创建设备令牌都会修改此字段 */
    @ExcelColumn(sort=9)
    private Long privateTime;

    /** comments:设备屏幕信息,格式示例:15H1080x960--15(英)寸横屏分辨率1080x960,21V960x1080--21(英)寸横屏分辨率960x1080 */
    @ExcelColumn(sort=10,name="设备屏幕信息")
    private String screenInfo;

    /** comments:设备安装方式,HANG:悬挂,FLOOR:落地 */
    @ExcelColumn(sort=11,name="安装方式",readConverterExp="HANG=悬挂, FLOOR=落地")
    private String fixedMode;

    /** comments:操作系统平台,操作系统名称及版本及硬件架构名称,例如:Windows-x86_64,Linux-x86_64,Android-arm... */
    @ExcelColumn(sort=12,name="操作系统平台")
    private String osArch;

    /** comments:网络连接类型:4G,WIFI,ETHERNET */
    @ExcelColumn(sort=13,name="网络连接类型")
    private String network;

    /** comments:设备端应用程序的版本号,格式由应用层定义 */
    @ExcelColumn(sort=14,name="版本")
    private String versionInfo;

    /** comments:设备型号 */
    @ExcelColumn(sort=15,name="设备型号")
    private String model;

    /** comments:设备供应商 */
    @ExcelColumn(sort=16,name="设备供应商")
    private String vendor;

    /** comments:设备产品详细信息,以JSON格式定义设备详细信息,JSON字段:device_name:产品名称,manufacturer:制造商,made_date:生产日期,应用层可根据需要扩展 */
    @ExcelColumns({
        @ExcelColumn(sort=17,name="设备产品详细信息"),
        @ExcelColumn(sort=17,columnName="device_detail.device_name",name="产品名称"),
        @ExcelColumn(sort=17,columnName="device_detail.manufacturer",name="制造商"),
        @ExcelColumn(sort=17,columnName="device_detail.made_date",name="生产日期")
    })
    @com.fasterxml.jackson.annotation.JsonRawValue
    @com.fasterxml.jackson.databind.annotation.JsonDeserialize(using = gu.sql2java.json.RawJsonDeserializer.class)
    private com.alibaba.fastjson.JSONObject deviceDetail;

    /** comments:JSON格式的扩展字段(最大64KB),用于定义扩展信息,last_active_time:上次在线时间,disk_capacity:磁盘容量,status_comment:状态变更说明 */
    @ExcelColumns({
        @ExcelColumn(sort=18),
        @ExcelColumn(sort=18,columnName="props.last_active_time",name="上次在线时间"),
        @ExcelColumn(sort=18,columnName="props.disk_capacity",name="磁盘容量"),
        @ExcelColumn(sort=18,columnName="props.status_comment",name="状态变更说明")
    })
    @com.fasterxml.jackson.annotation.JsonRawValue
    @com.fasterxml.jackson.databind.annotation.JsonDeserialize(using = gu.sql2java.json.RawJsonDeserializer.class)
    private com.alibaba.fastjson.JSONObject props;

    /** comments:当前节目ID */
    @ExcelColumn(sort=19,name="当前节目ID")
    private String planId;

    /** comments:目标节目ID */
    @ExcelColumn(sort=20,name="目标节目ID")
    private String targetId;

    /** comments:备注 */
    @ExcelColumn(sort=21,name="备注")
    private String remark;

    /** comments:记录创建时间 */
    @ExcelColumn(sort=22,name="记录创建时间")
    private java.util.Date createTime;

    /** comments:记录修改时间 */
    @ExcelColumn(sort=23,name="记录修改时间")
    private java.util.Date updateTime;
    //////////////////////////////
    /////    。。其他代码。。    ////
    //////////////////////////////
}

CREATE TABLE dc_spot (
  `id` int(11) PRIMARY KEY AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL COMMENT '地点名称',
  `spot` point DEFAULT NULL COMMENT '经纬度点'
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

	private com.vividsolutions.jts.geom.Point spot;
	/** 将spot转为WKT字符串返回 */
	public String getSpot(){
        return null == spot ? null : spot.toText();
    }
	/** 将WKT字符串转为Point保存到spot */
	public void setSpot(String newVal){
        spot =  (null == newVal || newVal.isEmpty())? null : GeometryDataCodec.DEFAULT_INSTANCE.fromWKTUnchecked(newVal,Point.class);
    }
	/** 返回sport原始对象 */
	public com.vividsolutions.jts.geom.Point readSpot(){
        return spot;
    }
	/** 修改spot原始对象 */
	public void writeSpot(com.vividsolutions.jts.geom.Point newVal){
        spot = newVal;
    }

    @com.fasterxml.jackson.databind.annotation.JsonDeserialize(using = gu.sql2java.geometry.jackson.GeometryDeserializer.class)
    @com.fasterxml.jackson.databind.annotation.JsonSerialize(using = gu.sql2java.geometry.jackson.GeometrySerializer.class) 
     @com.alibaba.fastjson.annotation.JSONField(serializeUsing=gu.sql2java.geometry.fastjson.PointCodec.class,deserializeUsing=gu.sql2java.geometry.fastjson.PointCodec.class) 
    private com.vividsolutions.jts.geom.Point spot;
	/** 返回sport原始对象 */
	public com.vividsolutions.jts.geom.Point getSpot(){
        return spot;
    }
	/** 修改spot原始对象 */
	public void setSpot(com.vividsolutions.jts.geom.Point newVal){
        spot = newVal;
    }

    @com.fasterxml.jackson.databind.annotation.JsonDeserialize(using = gu.sql2java.geometry.jackson.GeometryDeserializer.class)
    @com.fasterxml.jackson.databind.annotation.JsonSerialize(using = gu.sql2java.geometry.jackson.GeometrySerializer.class)
    private com.vividsolutions.jts.geom.Point spot;

  	@com.alibaba.fastjson.annotation.JSONField(
        serializeUsing=gu.sql2java.geometry.fastjson.PointCodec.class,
        deserializeUsing=gu.sql2java.geometry.fastjson.PointCodec.class) 
    private com.vividsolutions.jts.geom.Point spot;

    @Test
    public void test2Fastjson() {
        try {
            GeometryInit.init();
            String wkt = "POINT (1 -1)";
            Point point = GeometryDataCodec.DEFAULT_INSTANCE.fromWKT(wkt,Point.class);
            log("point {}",JSON.toJSONString(point));
            assertTrue(wkt.equals(point.toText()));
        } catch (ParseException e) {
            e.printStackTrace();
            assertTrue(false);
        }
    }