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.PreparedStatement;

public class Main {
    private static final String DB_DRIVER = "oracle.jdbc.driver.OracleDriver";
    private static final String DB_CONNECTION = "jdbc:oracle:thin:@localhost:1521:YourDatabase";
    private static final String DB_USER = "user";
    private static final String DB_PASSWORD = "password";

    public static void main(String[] argv) throws Exception {
        Class.forName(DB_DRIVER);
        Connection dbConnection = DriverManager.getConnection(DB_CONNECTION, DB_USER, DB_PASSWORD);

        PreparedStatement preparedStatementInsert = null;
        PreparedStatement preparedStatementUpdate = null;

        String insertTableSQL = "INSERT INTO Person" + "(USER_ID, USERNAME, CREATED_BY, CREATED_DATE) VALUES"
                + "(?,?,?,?)";

        String updateTableSQL = "UPDATE Person SET USERNAME =? " + "WHERE USER_ID = ?";

        java.util.Date today = new java.util.Date();
        dbConnection.setAutoCommit(false);

        preparedStatementInsert = dbConnection.prepareStatement(insertTableSQL);
        preparedStatementInsert.setInt(1, 9);
        preparedStatementInsert.setString(2, "101");
        preparedStatementInsert.setString(3, "system");
        preparedStatementInsert.setTimestamp(4, new java.sql.Timestamp(today.getTime()));
        preparedStatementInsert.executeUpdate();

        preparedStatementUpdate = dbConnection.prepareStatement(updateTableSQL);
        preparedStatementUpdate.setString(1, "new string");
        preparedStatementUpdate.setInt(2, 999);
        preparedStatementUpdate.executeUpdate();

        dbConnection.commit();
        dbConnection.close();
    }
}