package pruebasSQL;

import java.sql.*;

public class DBMetaData01 {
	final static String bd = "liga";
	final static String login = "root";
	final static String password = "";
	final static String url = "jdbc:mysql://localhost/" + bd;
	Connection conn;
	Statement stmt;

	public DBMetaData01() throws SQLException, ClassNotFoundException {
		Class.forName("com.mysql.jdbc.Driver");
		conn = DriverManager.getConnection(url, login, password);
		stmt = conn.createStatement();
	}

	public void desplegarMetaDatosBD() throws SQLException {
		DatabaseMetaData dbmd = conn.getMetaData();
		System.out.println("URL de la BD: " + dbmd.getURL());
		System.out.println("Usuario de la BD: " + dbmd.getUserName());
		System.out.println("Nombre del driver de la BD: "
				+ dbmd.getDriverName());
		ResultSet tablas = dbmd.getTables(null, null, null, null);
		System.out.print("Tablas de la BD: ");
		while (tablas.next()) {
			System.out.print(tablas.getString("TABLE_NAME") + "  ");
		}
		stmt.close();
		conn.close();
	}
	public static void main(String[]args) throws ClassNotFoundException, SQLException{
		DBMetaData01 dbmd = new DBMetaData01();
		dbmd.desplegarMetaDatosBD();
	}
}