HelloMySQLJDBC.java Source code

Introduction

Here is the source code for HelloMySQLJDBC.java

Source

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

public class HelloMySQLJDBC {
    Connection connection;

    private void displaySQLErrors(SQLException e) {
        System.out.println("SQLException: " + e.getMessage());
        System.out.println("SQLState:     " + e.getSQLState());
        System.out.println("VendorError:  " + e.getErrorCode());
    }

    public HelloMySQLJDBC() {
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
        } catch (Exception e) {
            System.err.println("Unable to find and load driver");
            System.exit(1);
        }
    }

    public void connectToDB() {
        try {
            connection = DriverManager
                    .getConnection("jdbc:mysql://192.168.1.25/accounts?user=spider&password=spider");
        } catch (SQLException e) {
            displaySQLErrors(e);
        }
    }

    public void executeSQL() {
        try {
            Statement statement = connection.createStatement();

            ResultSet rs = statement.executeQuery("SELECT * FROM bool");

            while (rs.next()) {
                System.out.println(rs.getString("a") + " " + rs.getBoolean("a"));
                System.out.println(rs.getString("b") + " " + rs.getBoolean("b"));
                System.out.println(rs.getString("c") + " " + rs.getBoolean("c"));
                System.out.println(rs.getString("d") + " " + rs.getBoolean("d"));
            }

            rs.close();
            statement.close();
            connection.close();
        } catch (SQLException e) {
            displaySQLErrors(e);
        }
    }

    public static void main(String[] args) {
        HelloMySQLJDBC hello = new HelloMySQLJDBC();

        hello.connectToDB();
        hello.executeSQL();
    }
}