This section describes how to create a new table in Java DB (Derby) database through the JDBC driver.
The next test I did was to add another table in my Java DB (Derby) 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) 2007 by Dr. Herong Yang. 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 my to create tables and there was no execution errors. See the output below:
