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.ResultSetMetaData;
import java.sql.SQLException;
import java.sql.Statement;

public class Main {

    public static void main(String[] args) throws Exception {
        String driver = "sun.jdbc.odbc.JdbcOdbcDriver";

        Connection con;
        Statement stmt;
        ResultSet uprs;

        try {
            Class.forName(driver);
            con = DriverManager.getConnection("jdbc:odbc:RainForestDSN", "student", "student");
            stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);
            uprs = stmt.executeQuery("SELECT * FROM Records");

            // Check the column count
            ResultSetMetaData md = uprs.getMetaData();
            System.out.println("Resultset has " + md.getColumnCount() + " cols.");

            int rowNum = uprs.getRow();
            System.out.println("row1 " + rowNum);
            uprs.absolute(1);
            rowNum = uprs.getRow();
            System.out.println("row2 " + rowNum);
            uprs.next();
            uprs.moveToInsertRow();
            uprs.updateInt(1, 150);
            uprs.updateString(2, "Madonna");
            uprs.updateString(3, "Dummy");
            uprs.updateString(4, "Jazz");
            uprs.updateString(5, "Image");
            uprs.updateInt(6, 5);
            uprs.updateDouble(7, 5);
            uprs.updateInt(8, 15);
            uprs.insertRow();
            uprs.close();
            stmt.close();
            con.close();
        } catch (SQLException ex) {
            System.err.println("SQLException: " + ex.getMessage());
        }
    }
}