This section describes how to insert new data rows into MS Access database through the JDBC-ODBC 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:
/**
* OdbcAccessInsertRows.java
* Copyright (c) 2007 by Dr. Herong Yang. All rights reserved.
*/
import java.sql.*;
public class OdbcAccessInsertRows {
public static void main(String [] args) {
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
con = DriverManager.getConnection("jdbc:odbc:HY_ACCESS");
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());
}
}
}
