JDBC-ODBC - Inserting Data Rows to MS Access Database

JDBC for SQL Server - Herong's Tutorial Examples

∟JDBC-ODBC - Inserting Data Rows to MS Access Database

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) HerongYang.com. 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());
    }
  }
}

The program worked nicely. It gives this output:

herong> progra~1\java\jdk1.7.0_45\bin\javac
   OdbcAccessInsertRows.java

herong> progra~1\java\jdk1.7.0_45\bin\java OdbcAccessInsertRows

Number of rows inserted: 3