Derby (Java DB) - Inserting Data Rows to Existing Tables

JDBC Tutorials - Herong's Tutorial Examples

∟Derby (Java DB) - Inserting Data Rows to Existing Tables

This section describes how to insert new data rows into Derby (Java DB) database tables through the JDBC driver.

Now I ready to insert some rows into the HY_Address table. This can be done by running the INSERT INTO statement with the executeUpdate() method. The sample program below inserts 3 rows into HY_Address:

/* DerbyInsertRows.java
 * Copyright (c) HerongYang.com. All Rights Reserved.
 */
import java.sql.*;
public class DerbyInsertRows {
  public static void main(String [] args) {
    Connection con = null;
    try {
      con = DriverManager.getConnection("jdbc:derby://localhost/TestDB");
      Statement sta = con.createStatement();

// insert 3 rows
      int count = 0;
      int c = sta.executeUpdate("INSERT INTO HY_Address"
        + " (ID, StreetName, City)"
        + " VALUES (1, '5 Baker Road', 'Bellevue')");
      count = count + c;

      c = sta.executeUpdate("INSERT INTO HY_Address"
        + " (ID, StreetName, City)"
        + " VALUES (2, '25 Bay St.', 'Hull')");
      count = count + c;

      c = sta.executeUpdate("INSERT INTO HY_Address"
        + " (ID, StreetName, City)"
        + " VALUES (3, '251 Main St.', 'W. York')");
      count = count + c;
      System.out.println("Number of rows inserted: "+count);

      sta.close();
      con.close();
    } catch (Exception e) {
      System.err.println("Exception: "+e.getMessage());
    }
  }
}

The program worked nicely. It gives this output:

herong> java -cp %DERBY_HOME%\lib\derbyclient.jar DerbyInsertRows.java
herong> java -cp $DERBY_HOME/lib/derbyclient.jar DerbyInsertRows.java

Number of rows inserted: 3