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+":");
        int avt=1;
        rs= cg.con.getMetaData().getSchemas();
        while(rs.next()){
            System.out.println(rs.getString(avt));
            avt++;
        } //that's the code wrong i think, what do i have to write?
        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-m...ableName.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 ;)