Main.java Source code

Introduction

Here is the source code for Main.java

Source

import java.sql.CallableStatement;
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 {

        CallableStatement cs = conn.prepareCall("{call StoreProcedureName}");
        ResultSet rs = cs.executeQuery();

        while (rs.next()) {
            System.out.println("Defunct user: " + rs.getString("user"));
        }
    }

    static Connection conn;

    static Statement st;

    public static void setup() {
        try {
            // Step 1: Load the JDBC driver.
            Class.forName("org.hsqldb.jdbcDriver");
            System.out.println("Driver Loaded.");
            // Step 2: Establish the connection to the database.
            String url = "jdbc:hsqldb:data/tutorial";

            conn = DriverManager.getConnection(url, "sa", "");
            System.out.println("Got Connection.");

            st = conn.createStatement();
        } catch (Exception e) {
            System.err.println("Got an exception! ");
            e.printStackTrace();
            System.exit(0);
        }
    }
}