DataUpdater.java Source code

Java tutorial

Introduction

Here is the source code for DataUpdater.java

Source

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