Example: Creating a database

This example demonstrates how to create a file system database store in a Java SE Java environment. The Configuration object is used to create the database. Once created, a Connection object is returned. To create tables, the schemaUpdateBegin method is invoked to start changes to the underlying schema and the schemaUpdateComplete method completes changing the schema.

♦ To run the CreateDb.java example

Change to the following directory: samples-dir\UltraLiteJ.

For information about the default location of samples-dir, see Samples directory.
Run the CreateDb example:
rundemo CreateDb

Use the following command to run this example (the command is case sensitive):

rundemo CreateDb

Notes

Tables in UltraLiteJ do not have owners and are identified only by name.
The Domain interface defines constants to denote the various data types supported in a column in an UltraLiteJ table.
The primary index (createPrimaryIndex) is guaranteed to be unique.

// *****************************************************
// Copyright (c) 2006-2010 iAnywhere Solutions, Inc.
// Portions copyright (c) 2006-2010 Sybase, Inc.
// All rights reserved. All unpublished rights reserved.
// *****************************************************
// This sample code is provided AS IS, without warranty or liability
// of any kind.
//
// You may use, reproduce, modify and distribute this sample code
// without limitation, on the condition that you retain the foregoing
// copyright notice and disclaimer as to the original iAnywhere code.
//
// *********************************************************************
package com.ianywhere.ultralitej.demo;

import com.ianywhere.ultralitej12.*;

/**
 * CreateDb: sample program to demonstrate Database creation.
 */
public class CreateDb
{
    /**
     * mainline for program.
     *
     * @param args command-line arguments
     *
     */
     
    public static void main
	( String[] args )
    {
	try {
	    Configuration config = DatabaseManager.createConfigurationFile( "Demo1.ulj" );
	    Connection conn = DatabaseManager.createDatabase( config );

	    executeSql( conn
		      , "CREATE TABLE department\n"
		       +"( dept_no INT NOT NULL PRIMARY KEY\n"
		       +", name VARCHAR(50)\n"
		       +")"
		      );

	    executeSql( conn
		      , "CREATE TABLE Employee\n"
		       +"( number INT NOT NULL PRIMARY KEY\n"
		       +", last_name VARCHAR(32)\n"
		       +", first_name VARCHAR(32)\n"
		       +", age INT\n"
		       +", dept_no INT\n"
		       +", FOREIGN KEY fk_emp_to_dept( dept_no ) REFERENCES department( dept_no )"
		       +")"
		      );

	    Demo.display( "\nCreateDb completed successfully" );

	} catch( ULjException exc ) {
	    Demo.displayException( exc );
	}
    }

    /** Execute a SQL statement.
     * @param conn connection to current database
     * @param stmt SQL statement to be executed
     */
    private static void executeSql( Connection conn, String stmt )
    	throws ULjException
    {
	Demo.display( "\nExecuting:\n", stmt );
	PreparedStatement ps = conn.prepareStatement( stmt );
	ps.execute();
	ps.close();
    }
}

Discuter à propos de cette page dans DocCommentXchange.