Show table list of a database in java

[drkwzrd]

Hi, i have to print in java a list of all tables in a selected database. Here some code:

public String elegirtabla() throws SQLException{
        cg.scanner();
        System.out.println("Listado de base de datos del servidor "+cg.server+":");
        rs= cg.con.getMetaData().getCatalogs();
        while(rs.next()){
           System.out.println(rs.getString("TABLE_CAT"));
        }
        System.out.println("Introduce la base a la que conectarte:");
        cg.bd= cg.sc.next();
        cg.con.setCatalog(cg.bd);
        System.out.println("Listado de tablas en la base de datos "+cg.bd+":");
        [B]int avt=1;[/B]
        [B]rs= cg.con.getMetaData().getSchemas();[/B]
        [B]while(rs.next()){[/B]
            [B]System.out.println(rs.getString(avt));[/B]
            [B]avt++;[/B]
        [B]}[/B] [U]//that's the code wrong i think, what do i have to write?[/U]
        System.out.println("Introduce el nombre de la tabla");
        tabla= cg.sc.next();
        return tabla;
    }

[PreethiGowri]

This might help you:)

http://www.roseindia.net/jdbc/jdbc-mysql/AllTableName.shtml

[Luuk]

I wonder why this question was moved.
The answer from PreethiGowri was pretty,
and was goog enough for /me to give the results.
It even was more complete than the question asked....

But (sorry) i was not asking the question ;)