Re: Using MySQL Table Names for Combo Box

From:

wisccal@googlemail.com

Newsgroups:

comp.lang.java.programmer

Date:

Fri, 15 Jun 2007 03:51:08 -0700

Message-ID:

<1181904668.077236.279020@k79g2000hse.googlegroups.com>

On Jun 14, 6:37 pm, christopher_bo...@yahoo.co.uk wrote:

Hi all. I am trying to write a program where it has to connect to a
MySQL Database. Within the program there will be a drop down box that
will show class room names. In the datbase there is going to be a
table for each class room. I would like to add every table name within
a datbase into the drop down box if the java program. How would I go
about doing this.

Any help would be appreciated in this matter.

How about something like this?

try {
  Connection con = getConnection(); //Get you Connection object
  DatabaseMetaData meta = con.getMetaData();
  ResultSet rs = meta.getTables(null, null, "%", new String[]
{"Table"}); //Get only tables (no views, etc). You can adjust the 3rd
parameter to match only certain names.

  while(rs.next()) {
    String table = rs.getString(3);
    System.out.println(table);
  }
  con.close();
  } catch(Exception e) {
    System.err.println("Exception: " + e.getMessage());
  }

Regards,
Steve
------------------
www.stkomp.com