Enumeration Type: JDBC : JDBC Data Type « Database SQL JDBC « Java

1. Java
2. Database SQL JDBC
3. JDBC Data Type

Enumeration Type: JDBC

 
/*

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();
  }
}

           
         
  

Related examples in the same category