JDBC Tutorials - Herong's Tutorial Examples - v3.14, by Herong Yang
Derby (Java DB) - Creating New Tables
This section describes how to create a new table in Derby (Java DB) database through the JDBC driver.
The next test I did was to add another table in my Derby (Java DB) database. This was done by running the CREATE TABLE statement with the executeUpdate() method. Here is the sample program I used to create a new table called, HY_Address:
/* DerbyCreateTable.java * Copyright (c) HerongYang.com. All Rights Reserved. */ import java.sql.*; public class DerbyCreateTable { public static void main(String [] args) { Connection con = null; try { con = DriverManager.getConnection("jdbc:derby://localhost/TestDB"); // Creating a database table Statement sta = con.createStatement(); int count = sta.executeUpdate( "CREATE TABLE HY_Address (ID INT, StreetName VARCHAR(20)," + " City VARCHAR(20))"); System.out.println("Table created."); sta.close(); con.close(); } catch (Exception e) { System.err.println("Exception: "+e.getMessage()); } } }
The Derby JDBC driver allowed me to create tables and there was no execution errors. See the output below:
herong> java -cp %DERBY_HOME%\lib\derbyclient.jar DerbyCreateTable.java herong> java -cp $DERBY_HOME/lib/derbyclient.jar DerbyCreateTable.java Table created.
Table of Contents
JDBC (Java Database Connectivity) Introduction
Installing and Running Derby (Java DB)
Derby (Java DB) Driver Features
Loading Derby JDBC Driver Classes
Creating Connections to Derby (Java DB) Network Server
Derby (Java DB) Network Server and JDBC Driver Info
►Derby (Java DB) - Creating New Tables
Derby (Java DB) - Inserting Data Rows to Existing Tables
Derby (Java DB) - Running SELECT Queries
Derby (Java DB) JDBC DataSource Objects
Derby (Java DB) - DML Statements
Derby (Java DB) - ResultSet Objects of Queries
Derby (Java DB) - PreparedStatement
Summary of JDBC Drivers and Database Servers