SQL API

SQL sql = new SQL("database", "ip", "username", "password");

sql.setTable("table name");

sql.execute(statement);

// this example gets an integer from the database, in a table called Users where the username is Steve
SelectStatement<Integer> statement = new SelectStatement<Integer>("gems", new Clause("Username", "'Steve'"), 0);
int value = sql.execute(statement);

// this example sets the integer in the Users table for when the Username is Steve
UpdateStatement statement = new UpdateStatement(new Clause("Username", "'Steve'"), new Clause("gems", "100", "SET"));
sql.execute(statement);

// this example deletes the row where the Username is Steve
DeleteStatement statement = new DeleteStatement(new Clause("Username", "'Steve'"));
sql.execute(statement);

// this code inserts a record for the Username Steve with 100 gems
InsertStatement statement = new InsertStatement("'Steve', 100");
sql.execute(statement);

// this code counts the number of rows with 100 as the gems value
CountStatement statement = new CountStatement(new Clause("gems", "100"));
int number = sql.execute(statement);

// this example prints the all the usernames in the given table
ReadTableStatement statement = new ReadTableStatement("Username");
sql.execute(statement);

CreateTableStatement statement = new CreateTableStatement(new TableArgument("Username", "VARCHAR(18)", "UNIQUE NOT NULL"), new TableArgument("gems", "INT(255)"));
sql.execute(statement);