Main.java Source code

Introduction

Here is the source code for Main.java

Source

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

public class Main {
    public static void main(String args[]) throws Exception {
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        Connection con = DriverManager.getConnection("jdbc:odbc:Contacts");
        Statement stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
        ResultSet rs = stmt.executeQuery("select * from employee");
        rs.moveToInsertRow();

        rs.updateInt("Contact_ID", 150);
        rs.updateString("First_Name", "Nigel");
        rs.updateString("Last_Name", "Thornebury");

        rs.insertRow();
    }
}