Sql2Class 1.02

Makes data classes and data class control objects from database tables

Sql2Class is a console application which generates data objects (bean-like classes) from a TABLE which is accessible through a JDBC connection. It also provides the DataC control classes for these tables supplying an easy, low-maintenance way of interacting with a database.

usage

You can run Sql2Class straight from the command prompt. Just go to the directory you have installed it in and run:

java -jar Sql2Class.jar -c [database-driver-jar] -d [DriverClassName] -r [URLConnectionString] -u [Username] -p [Password] -t [Table]

For example:

java -Xbootclasspath/a:/usr/java/lib/ojdbc6.jar -jar Sql2Class.jar -d oracle.jdbc.driver.OracleDriver -r  jdbc:oracle:thin:@db.acme.com:1521:ora -u scott -p tiger -t EMP

To make life a little bit easier I usually put the driver, url, user, location and package in a sql2class.properties file placed in the same directory:

driver=oracle.jdbc.driver.OracleDriver
url=jdbc\:oracle\:thin\:@db.acme.com\:1521\:ora
user=scott
location=/project/AcmeApp/src
package=com.acme.app.data

and run it like this:

java -Xbootclasspath/a:/usr/java/lib/ojdbc6.jar -jar Sql2Class.jar -t EMP -p tiger

All parameters can be defined in the sql2class.properties Look for all the parameters you can define with Sql2Class at the description of Sql2ClassConsole in the javadoc

language

java jdk 8+

dependencies

• TwelBox 1.04+
• DataC 1.02+
• Squeler 1.02+
• TypeWriter 1.02+

references