This section describes how to insert new data rows into Java DB (Derby) 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) 2007 by Dr. Herong Yang. 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:
C:\>java -cp .;\local\javadb\lib\derbyclient.jar DerbyInsertRows
Number of rows inserted: 3
