Enumeration Type JDBC

package matthews.mark;
 
/*
 
 MySQL and Java Developer's Guide
 
 Mark Matthews, Jim Cole, Joseph D. Gradecki
 Publisher Wiley,
 Published February 2003, 
 ISBN 0471269239
 
 */
//Modified by Code Panda, http://java.exampleshow.com
 
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://localhost/exampleshow?user=root&password=123321");
	} 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 pet LIKE 'name'");
 
	    rs.next();
	    String enums = rs.getString("Type");
	    System.out.println("Type="+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) {
	EnumTesting e = new EnumTesting();
	e.doWork();
    }
}