driverClassName: "com.mysql.jdbc.Driver"(6.0.x以下)                 "com.mysql.cj.jdbc.Driver"(6.0.x及以上,需要JDK1.8及以上)dbUrl: "jdbc:mysql://127.0.0.1:3306/test"

driverClassName: "oracle.jdbc.OracleDriver"dbUrl: "jdbc:oracle:thin:@//127.0.0.1:1521/orcl"

driverClassName: "com.microsoft.sqlserver.jdbc.SQLServerDriver"（2005版本及以后）                 "com.microsoft.jdbc.sqlserver.SQLServerDriver"（2000版本）dbUrl: "jdbc:sqlserver://127.0.0.1:1433;databasename=test"(databasename=XXX需放在最后)

driverClassName: "org.postgresql.Driver"dbUrl: "jdbc:postgresql://127.0.0.1:5432/test"

<dependency>    <groupId>wiki.xsx</groupId>    <artifactId>JG-All</artifactId>    <version>1.2.1</version></dependency>

import wiki.xsx.jg.main.Generator;/** * 测试 */public class Test {    public static void main(String[] args) throws Exception{        // 数据库驱动名称        final String driverClassName = "com.mysql.jdbc.Driver";        // 数据库地址        final String dbUrl = "jdbc:mysql://127.0.0.1:3306/test?zeroDateTimeBehavior=convertToNull&autoReconnect=true&useUnicode=true&characterEncoding=utf-8";        // 数据库用户名        final String userName = "root";        // 数据库用户密码        final String password = "root";        // 包所在的根路径        final String rootPath = "F:\\Test";        // Java类所在的完整包名        final String packageName = "com.xsx.test";        // 需要生成的Java类所对应的数据表名称        final String tableNames = "test1,test2,test3";        // 需要生成的数据表所对应的Java类名称        final String classNames = "Test1,Test2,Test3";        // 按照数据表生成Java文件        Generator.createFiles(tableNames, driverClassName, dbUrl, userName, password, rootPath, packageName);        // 按照数据库中所有表生成Java文件        Generator.createFiles(driverClassName, dbUrl, userName, password, rootPath, packageName);        // 按照Java类生成数据表        Generator.createTables(classNames, driverClassName, dbUrl, userName, password, rootPath, packageName);        // 按照包下所有Java类生成数据表        Generator.createTables(driverClassName, dbUrl, userName, password, rootPath, packageName);    }}

import wiki.xsx.jg.annotation.Id;import wiki.xsx.jg.annotation.Ignore;import wiki.xsx.jg.annotation.IsNotNull;import java.util.Date;/** * 测试简单Java类 */public class Test1 {    @Id //主键注解    private Integer id;    @IsNotNull //不为空注解    private String name;    private Integer age;    private String address;    private String phoneNumber;    private Double salary;    @Ignore //忽略注解(忽略此属性，不创建该字段；可用于类，当用于类时，忽略此类，不创建数据表)    private String description;    private Date createTime;    ......}

数据库类型                                                                            Java类型CHAR|VARCHAR                                                                         StringTINYINT|SMALLINT|MEDIUMINT|INT|INTEGER|YEAR                                          IntegerBIGINT                                                                               LongFLOAT                                                                                FloatDOUBLE                                                                               DoubleDECIMAL                                                                              BigDecimalDATE|DATETIME|TIMESTAMP                                                              DateTIME                                                                                 TimeBINARY|VARBINARY|TINYBLOB|BLOB|MEDIUMBLOB|LONGBLOB                                   byte[]Others                                                                               Object

Java类型                                                                             数据库类型 String                                                                               VARCHAR    Integer                                                                              INTLong                                                                                 BIGINTFloat                                                                                FLOATDouble                                                                               DoubleBigDecimal                                                                           DECIMALDate                                                                                 TIMESTAMPTime                                                                                 TIMEbyte[]                                                                               BLOBOthers                                                                               VARCHAR

数据库类型                                                                            Java类型CHAR|VARCHAR2|LONG                                                                   StringNUMBER(x), 2<=x<=9                                                                   IntegerNUMBER(x), 10<=x<=18                                                                 LongNUMBER(x,y), y=1                                                                     FloatNUMBER(x,y), y>=2                                                                    DoubleNUMBER(x), x>=19                                                                     BigDecimalDATE|TIME|TIMESTAMP                                                                  DateBLOB                                                                                 BlobCLOB                                                                                 ClobOthers                                                                               Object

Java类型                                                                             数据库类型 String                                                                               VARCHARInteger|Long|Float|Double|BigDecimal|Boolean|Byte|Short                              NUMBERDate|Time                                                                            DATETimestamp                                                                            TIMESTAMPBlob                                                                                 BLOBClob                                                                                 CLOBbyte[]                                                                               RAWOthers                                                                               VARCHAR

数据库类型                                                                            Java类型CHAR|NCHAR|VARCHAR|NVARCHAR|TEXT|NTEXT|UNIQUEIDENTIFIER|XML                          StringINT                                                                                  IntegerSMALLINT|TINYINT                                                                     ShortBIGINT                                                                               LongREAL                                                                                 FloatFLOAT                                                                                DoubleDECIMAL|NUMERIC|SMALLMONEY|MONEY                                                     BigDecimalDATE|TIME|DATETIME|DATETIME2|SMALLDATETIME|DATETIMEOFFSET                            DateTIMESTAMP|BINARY|IMAGE|VARBINARY                                                     byte[]BIT                                                                                  BooleanOthers                                                                               Object

Java类型                                                                             数据库类型 String                                                                               NVARCHARInteger                                                                              INTFloat                                                                                REALDouble                                                                               FLOATLong                                                                                 BIGINTShort                                                                                SMALLINTBigDecimal                                                                           DECIMALDate|Time|Timestamp                                                                  DATETIMEBoolean                                                                              BITbyte[]                                                                               VARBINARYOthers                                                                               NVARCHAR

数据库类型                                                                            Java类型CHAR|VARCHAR|TEXT                                                                    StringINT4|SERIAL4|INTERVAL                                                                IntegerINT2|SERIAL2                                                                         ShortINT8|SERIAL8                                                                         LongFLOAT4                                                                               FloatFLOAT8|MONEY                                                                         DoubleDECIMAL                                                                              BigDecimalDATE|TIME|TIMETZ|TIMESTAMP|TIMESTAMPTZ                                               DateBOOL                                                                                 BooleanOthers                                                                               Object

Java类型                                                                             数据库类型 String                                                                               VARCHARInteger                                                                              INT4Float                                                                                FLOAT4Double                                                                               FLOAT8Long                                                                                 INT8Short                                                                                INT2BigDecimal                                                                           DECIMALDate                                                                                 DATETimestamp                                                                            TIMESTAMPTime                                                                                 TIMEBoolean                                                                              BOOLOthers                                                                               VARCHAR