Logging.java Source code

Introduction

Here is the source code for Logging.java

Source

import java.io.FileOutputStream;
import java.io.PrintStream;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.GregorianCalendar;

public class Logging {
    public static void main(String args[]) throws Exception {
        FileOutputStream errors = new FileOutputStream("StdErr.txt", true);
        PrintStream stderr = new PrintStream(errors);
        PrintWriter errLog = new PrintWriter(errors, true);
        System.setErr(stderr);

        String query = "SELECT Name,Description,Qty,Cost,Sell_Price FROM Stock";

        try {
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            Connection con = DriverManager.getConnection("jdbc:odbc:Inventory");
            Statement stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(query);
            while (rs.next()) {
                String name = rs.getString("Name");
                String desc = rs.getString("Description");
                int qty = rs.getInt("Qty");
                float cost = rs.getFloat("Cost");
            }
        } catch (ClassNotFoundException e) {
            e.printStackTrace(errLog);
        } catch (SQLException e) {
            System.err.println((new GregorianCalendar()).getTime());
            System.err.println("Thread: " + Thread.currentThread());
            System.err.println("ErrorCode: " + e.getErrorCode());
            System.err.println("SQLState:  " + e.getSQLState());
            System.err.println("Message:   " + e.getMessage());
            System.err.println("NextException: " + e.getNextException());
            e.printStackTrace(errLog);
            System.err.println();
        }
        stderr.close();
    }
}