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

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 {

    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';";



Related examples in the same category

1.jdbc:odbc bridge
2.JdbcOdbc Connect
3.jdbc odbc bridge connection string
4.Simple example of JDBC-ODBC functionality
5.Using a PreparedStatement through sun.jdbc.odbc.JdbcOdbcDriver
6.Creating and using a stored procedure with sun.jdbc.odbc.JdbcOdbcDriver
7.Retrieving a ResultSet from JdbcOdbcDriver
8.Getting an output parameter from a stored procedure
9.Opening an updatable ResultSet
10.Using ResultSetMetaData from jdbc:odbc
11.Creating a table using JdbcOdbcDriver
12.Using INSERT with JdbcOdbcDriver
13.Creating and dropping indexes
14.Using DSN-less connection