Using MySQL Table Names for Combo Box

Thread view:

christopher_board@yahoo.co.uk - 14 Jun 2007 23:37 GMT

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.

Reply to this Message

wisccal@googlemail.com - 15 Jun 2007 11:51 GMT

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
[quoted text clipped - 4 lines]
>
> 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

Reply to this Message

Using MySQL Table Names for Combo Box

Free Magazines