Product Documentation

FairCom JDBC

Previous Topic

Next Topic

Define

Define() establishes specific data definitions. This involves defining columns/fields and creating the tables/files with optional indexes.

Below is the code for Define():

//

// Define()

//

// Create the table for containing a list of existing customers

//

private static void Define ()

{

System.out.println("DEFINE");

try

{

stmt.executeUpdate("DROP TABLE ordritem");

}

catch (SQLException e)

{

}

try

{

stmt.executeUpdate("DROP TABLE custordr");

}

catch (SQLException e)

{

}

try

{

stmt.executeUpdate("DROP TABLE itemmast");

}

catch (SQLException e)

{

}

try

{

stmt.executeUpdate("DROP TABLE custmast");

}

catch (SQLException e)

{

}

try

{

// create table

System.out.println("\tCreate table...");

stmt.executeUpdate("CREATE TABLE custmast (" +

"cm_custnumb CHAR(4), " +

"cm_custzipc CHAR(9), " +

"cm_custstat CHAR(2), " +

"cm_custrtng CHAR(1), " +

"cm_custname VARCHAR(47), " +

"cm_custaddr VARCHAR(47), " +

"cm_custcity VARCHAR(47))"

);

}

catch (SQLException e)

{

Handle_Exception(e);

}

}

TOCIndex