Using UPDATE with JdbcOdbcDriver : JDBC ODBC « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. JDBC ODBC

Using UPDATE with JdbcOdbcDriver

  

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.Statement;

import sun.jdbc.odbc.JdbcOdbcDriver;

public class DataUpdater {
  public static void main(String args[]) throws Exception {

    Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
    DriverManager.registerDriver(new JdbcOdbcDriver());
    String url = "jdbc:odbc:Contacts";

    Connection con = DriverManager.getConnection(url);
    Statement stmt = con.createStatement();
    String SQLCommand = "UPDATE CONTACT_INFO " + "SET STREET = '58 Broadway', ZIP = '10008' "
        + "WHERE First_Name = 'Michael' AND " + "Last_Name ='Corleone';";

    stmt.execute(SQLCommand);
    con.close();
  }
}

   
  

Related examples in the same category