JAVA DATABASE PROGRAMMING - Introduction to Java Programming: Comprehensive Version - page 1203

L ISTING 32.5

TestDatabaseMetaData.java
1 import java.sql.*;
2
3 public class TestDatabaseMetaData {
4 public static void main(String[] args)
5 throws SQLException, ClassNotFoundException {
6 // Load the JDBC driver
7 Class.forName( "com.mysql.jdbc.Driver" );
8 System.out.println( "Driver loaded" );
9
10 // Connect to a database
11 Connection connection = DriverManager.getConnection
12 ( "jdbc:mysql://localhost/javabook" , "scott" , "tiger" );
13 System.out.println( "Database connected" );
14
15 DatabaseMetaData dbMetaData = connection.getMetaData();
16 System.out.println( "database URL: " + dbMetaData.getURL());
17 System.out.println( "database username: " +
18 dbMetaData.getUserName());
19 System.out.println( "database product name: " +
20 dbMetaData.getDatabaseProductName());
21 System.out.println( "database product version: " +
22 dbMetaData.getDatabaseProductVersion());
23 System.out.println( "JDBC driver name: " +
24 dbMetaData.getDriverName());
25 System.out.println( "JDBC driver version: " +
26 dbMetaData.getDriverVersion());
27 System.out.println( "JDBC driver major version: " +
28 dbMetaData.getDriverMajorVersion());
29 System.out.println( "JDBC driver minor version: " +
30 dbMetaData.getDriverMinorVersion());
31 System.out.println( "Max number of connections: " +
32 dbMetaData.getMaxConnections());
33 System.out.println( "MaxTableNameLength: " +
34 dbMetaData.getMaxTableNameLength());
35 System.out.println( "MaxColumnsInTable: " +
36 dbMetaData.getMaxColumnsInTable());
37
38 // Close the connection
39 connection.close();
40 }
41 }

load driver

connect database

database metadata
get metadata

F IGURE 32.24

The DatabaseMetaData interface enables you to obtain database information.