· 8 years ago · Mar 08, 2018, 09:54 AM
1SQLTableCreator creator = new SQLTableCreator("tablename", false, true);
2SQLColumn randomColumn1 = new SQLIntColumn("randCol1");
3randomColumn1.setAutoIncrement(true);
4randomColumn1.setNotNull(true);
5SQLColumn randomColumn2 = new SQLVarCharColumn("randCol2");
6randomColumn2.setNotNull(true);
7randomColumn2.setTypeCount(45);
8creator.addColumn(randomColumn1);
9creator.addColumn(randomColumn2);
10creator.setPrimaryAs(randomColumn1);
11
12...
13
14System.out.println(creator.getCreationQuery());
15
16...
17
18CREATE TABLE IF NOT EXISTS `tablename`(
19 `randCol1` INT NOT NULL AUTO_INCREMENT ,
20 `randCol2` VARCHAR(45) NOT NULL ,
21 PRIMARY KEY(`randCol1`)
22 );