The DBBean Framework
Introduction
Main Objects
Batch Sql Files
Bean Generation
Basic Operations
Advanced Operations
API - JavaDocs
Download Alpha
Developers / Contact
SourceForge.net Logo
Running batch SQL files

The DB object provides a method to execute text files containing SQL commands:

DB.executeSqlFile(File myFile, String Delimiter)

For the example SQL file below, the call would look like:

DB mDB = new DB([args]);
mDB.executeSqlFile(myFile,";");

CREATE TABLE PERSON (
  PERSON_ID INT PRIMARY KEY AUTO_INCREMENT,
  FIRST_NAME VARCHAR(255) NOT NULL,
  LAST_NAME VARCHAR(255) NOT NULL,
  AGE INT NOT NULL
);


CREATE TABLE ACCOUNT (
  ACCOUNT_ID INT PRIMARY KEY AUTO_INCREMENT,
  PERSON_ID INT NOT NULL UNIQUE,
  USERNAME VARCHAR(255) NOT NULL UNIQUE,
  PASSWORD VARCHAR(255) NOT NULL,
  DATE_CREATED DATE NOT NULL
);


CREATE TABLE PURCHASE (
  PURCHASE_ID INT PRIMARY KEY AUTO_INCREMENT,
  ACCOUNT_ID INT NOT NULL,
  PRODUCT VARCHAR(255) NOT NULL,
  PRICE NUMERIC(8,2) NOT NULL
);