Home > Generator > SQL DDL to Java Entity Converter

Other Tools

SQL DDL to Gorm Model ConverterQR Code GeneratorBatch QR Code GeneratorUUID GeneratorMorse Code ConverterCron Expression GeneratorPassword Generator

SQL DDL to Java Entity Converter

Convert SQL DDL statements to Java entity classes with JPA, Lombok, and validation annotations support

Data Type Mapping
String Types
  • VARCHAR, CHAR, TEXT → String
  • LONGTEXT, MEDIUMTEXT → String
  • ENUM → String
Number Types
  • INT, INTEGER → Integer
  • BIGINT → Long
  • SMALLINT → Short
  • TINYINT → Byte
  • DECIMAL, NUMERIC → BigDecimal
  • FLOAT, DOUBLE → Double
Time Types
  • DATETIME, TIMESTAMP → LocalDateTime
  • DATE → LocalDate
  • TIME → LocalTime
Other Types
  • BOOLEAN, BOOL → Boolean
  • BLOB, BINARY → byte[]
  • JSON → String
Naming Convention
CamelCase:user_name → userNameaccess_date → accessDate
Underscore:user_name → user_nameaccess_date → access_date
Time Type Mapping
Time Objects Enabled:DATETIME → LocalDateTimeDATE → LocalDateTIME → LocalTime
Time Objects Disabled:DATETIME → StringDATE → StringTIME → String