[SOLVED] CS SQL database Java package ed.inf.adbs.lightdb;

package ed.inf.adbs.lightdb;

import java.io.FileReader;

import net.sf.jsqlparser.parser.CCJSqlParserUtil;
import net.sf.jsqlparser.statement.Statement;
import net.sf.jsqlparser.statement.select.Select;

/**
* Lightweight in-memory database system
*
*/
public class LightDB {

public static void main(String[] args) {

if (args.length != 3) {
System.err.println(Usage: LightDB database_dir input_file output_file);
return;
}

String databaseDir = args[0];
String inputFile = args[1];
String outputFile = args[2];

parsingExample(inputFile);
}

/**
* Example method for getting started with JSQLParser. Reads SQL statement from
* a file and prints it to screen; then extracts SelectBody from the query and
* prints it to screen.
*/

public static void parsingExample(String filename) {
try {
Statement statement = CCJSqlParserUtil.parse(new FileReader(filename));
//Statement statement = CCJSqlParserUtil.parse(SELECT * FROM Boats);
if (statement != null) {
System.out.println(Read statement: + statement);
Select select = (Select) statement;
System.out.println(Select body is + select.getSelectBody());
}
} catch (Exception e) {
System.err.println(Exception occurred during parsing);
e.printStackTrace();
}
}
}