Accessing Databases Using Java and JDBC

This article will show how a Java Application can access database and then list tables in it.

Accessing Database using Java and JDBC


Accessing Database using Java and JDBC

Database plays an important role in storing large amount of data in a pattern. Here we are going develop and example to access the database using Java and JDBC. For this, firstly we need to establish a connection between database and java file with the help of various types of APIs, interfaces and methods. We are using MySQL database.

Connection: This  interface specifies connection with specific databases like: MySQL, Ms-Access, Oracle etc and java files. The SQL statements are executed within the context of this interface.

Class.forName(String driver): It loads the driver.

DriverManager: This class controls a set of JDBC drivers. Each driver has to be register with this class.

getConnection(String url, String userName, String password): This method establishes a connection to specified database url. It is having three arguments:
  url: - Database url where stored or created your database
  username: - User name of MySQL
  password: -Password of MySQL 

Here is the video tutorial of accessing the database from Java program:

getMetaData(): This is a method of Connection interface. It retrieves the metadata of the database.

DataBaseMetaData: This interface gives information about the database like number of tables in the database, columns of the table etc.

getTables(null, null, "%", null): This method provides the description of the tables available in the given catalog. As we have set other parameters null, so it will provide only table names.

Here is the code:

import java.sql.*;

public class AccessDatabases {
  public static void main(String[] args) {
  try {
  Connection con = DriverManager.getConnection(
  Statement st = con.createStatement();
  DatabaseMetaData meta = con.getMetaData();
  ResultSet rs = meta.getTables(null, null, "%"null);
  String tableNames = "";
  while ( {
  tableNames = rs.getString(3);
  catch (Exception e) {

In this section we studies how to connect to database and then list all the tables in the database. We have used MySQL database server.

Next: Check more tutorials of JDBC Programming using MySQL.

Share on Google+Share on Google+

Accessing Databases Using Java and JDBC

Posted on: August 28, 2010 If you enjoyed this post then why not add us on Google+? Add us to your Circles



Discuss: Accessing Databases Using Java and JDBC  

Post your Comment

Your Name (*) :
Your Email :
Subject (*):
Your Comment (*):
  Reload Image
April 13, 2011

what is the meaning of "jdbc:mysql://localhost:3306/test", "root", "root")" and how to upload the to the server?
April 13, 2011

I want access data from oracle(Window XP)? my DSN is "DEMO". My table name is "student". I am using servlet program,then tell me JDBC connection program for servlet.
June 23, 2011

Its very useful for freshers to develop our programming knowledge. for now i need the procedure of how to connect netbeans with mysql.if any one know that procedure please tell me.
December 27, 2011
Thanks this Tutorial

I am very happy for this Tutorial which help me to understand more about how to access a database using Java and JDBC. I need more Tutorial for how to build a Web Application using Java. Thank You.
March 15, 2012

how to access database using java and jdbc