Metadata
is the data that describes about data. Database metadata describes
about specific characteristic of each data item in the database.
For
example, Database metadata describes about tables, columns in each
table, views in database, information about stored procedures.
JDBC
provides below interfaces, to deal with database metadata.
DatabaseMetaData
interface: provides information about the database
ResultSetMetaData
interface: provides information about the columns of a ResultSet
object
ParameterMetaData
interface: provides information about the parameters to
PreparedStatement commands
As
you observe above image, the database 'world' has tables city,
country, countrylanguage. Will retrieve the same information using
jdbc.
/* Step 1: Import sql package */ import java.sql.*; public class SampleApp { /* Update username, password and driver details here */ static Connection getConnection() throws ClassNotFoundException, SQLException{ /* Step 2: Load Driver */ System.out.println("Loading/Registering driver"); Class.forName("com.mysql.jdbc.Driver"); /* Step 3: Open connection to database */ System.out.println("Connecting to database"); String url = "jdbc:mysql://localhost/world"; String userName = "root"; String pasword = "tiger"; return DriverManager.getConnection(url, userName, pasword); } public static void main(String args[]) throws SQLException, ClassNotFoundException{ Connection conn = getConnection(); ResultSet rs = null; /* Create table employee */ String query = "CREATE TABLE employee (id int, name varchar(30), PRIMARY KEY(id))"; DatabaseMetaData meta = conn.getMetaData(); if(meta == null){ System.out.println("No Support"); } else{ rs = meta.getTables(null, null, "%", null); while(rs.next()){ System.out.println(rs.getString(3)); } } rs.close(); conn.close(); } }
Output
Loading/Registering driver
Connecting to database
city
country
countrylanguage
String
url = "jdbc:mysql://localhost/world";
Above
url is used to connect to database 'world'.
DatabaseMetaData
meta = conn.getMetaData();
Retrieves
a DatabaseMetaData object that contains metadata about the database
to which this Connection object represents a connection.
No comments:
Post a Comment