EnumTesting.java Source code

Introduction

Here is the source code for EnumTesting.java

Source

/*
    
MySQL and Java Developer's Guide
    
Mark Matthews, Jim Cole, Joseph D. Gradecki
Publisher Wiley,
Published February 2003, 
ISBN 0471269239
    
*/

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

public class EnumTesting {
    Connection connection;

    Statement statement;

    public EnumTesting() {
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            connection = DriverManager.getConnection("jdbc:mysql://192.168.1.25/test?user=spider&password=spider");
        } catch (Exception e) {
            System.err.println("Unable to find and load driver");
            System.exit(1);
        }
    }

    public void doWork() {
        try {
            statement = connection.createStatement();
            ResultSet rs = statement.executeQuery("SHOW COLUMNS FROM enumtest LIKE 'status'");

            rs.next();
            String enums = rs.getString("Type");
            System.out.println(enums);
            int position = 0, count = 0;
            String[] availableEnums = new String[10];

            while ((position = enums.indexOf("'", position)) > 0) {
                int secondPosition = enums.indexOf("'", position + 1);
                availableEnums[count++] = enums.substring(position + 1, secondPosition);

                position = secondPosition + 1;
                System.out.println(availableEnums[count - 1]);
            }

            rs.close();
            statement.close();
            connection.close();
        } catch (Exception e) {
            e.printStackTrace();
        }
    }

    public static void main(String[] args) {
        Enum e = new Enum();
        e.doWork();
    }
}