Schema operations

Perform schema operations by following these general tasks:

Construct a SQL statement in a String variable.
Create a PreparedStatement object by passing the String variable to the Connection.prepareStatement method.
Call the PreparedStatement.execute method to perform the operation on the database.
Close the PreparedStatement object to free resources.

Example

The code referenced in this example is part of a complete sample that illustrates how to perform basic schema and data management operations using the UltraLiteJ API. See Example: Managing database operations on an Android smartphone.

Individual CREATE TABLE and CREATE INDEX statements are constructed and passed to a custom method named ExecuteSQLStatement to perform all necessary schema operations:

String[] stmt = new String[3];

stmt[0] = "CREATE TABLE Department("
    + "dept_no INT PRIMARY KEY, "
    + "name CHAR(50) NOT NULL)";

stmt[1] = "CREATE TABLE Employee("
    + "id INT PRIMARY KEY, "
    + "last_name CHAR(50) NOT NULL, "
    + "first_name CHAR(50) NOT NULL, "
    + "dept_id INT NOT NULL, "
    + "NOT NULL FOREIGN KEY(dept_id) "
    + "REFERENCES Department(dept_no))";

stmt[2] = "CREATE INDEX ON Employee(last_name, first_name)";
        
for(int i = 0; i< stmt.length; i++) {
    ExecuteSQLStatement(stmt[i]);
}

The ExecuteSQLStatement method consists of the following code:

public void ExecuteSQLStatement(String strSQLstmt) {
    PreparedStatement ps;
    try {
        ps = _conn.prepareStatement(strSQLstmt);
        ps.execute();
        ps.close();
        PrintText("Successfully executed: " + strSQLstmt);
    } catch (ULjException e) {
        HandleError(e);
    }
}

Schema operations

Example

See also