Database Connectivity program in java using MS access Database

What is Database ?

        Database is a collection of information stored and retrieve from same. Database is one of the storage of data so that it can be available to retrieve whenever need.

Types of Database?

         

1.Relational  Database

2.Object Oriented Database

3.Hierarchical Database

4.Network Database

Database Connectivity program in java using MS access Database

import java.io.*;

import java.sql.*;

class DatabaseProgram

{

public static void main(String args[])

   {

          try

{

                     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

                     Connection con=DriverManager.getConnection("jdbc:odbc:Data");

                     Statement stmt=con.createStatement();

                     System.out.println("Connection established");

                     con.close();

             }

           catch(Exception e)

           {

e.printStackTrace();

}

    }

}

How to execute Database connectivity program in java by using Ms access.

1.Copy this program in your Notepad

2.save this program in JDK/bin directory as DatabaseProgram.java

3.Create MS access Database as mentioned in post

"How to create Database by using MS Access"

 4.Go to Control panel ->Administrative tool ->Create DSN ->Give the DSN Name as: Data

5.Click on Select button to select database file .finally press OK button

6.Go to command prompt

7.Compile source program by using command

        javac DatabaseProgram.java

8.Run this program

       java DatabaseProgram

9.Output will look like:

      Connection established

How to create Database by using MS Access

1. 1 Install Microsoft office (Ignore if already installed)

                           office.microsoft.com/‎
           We are here using MS office 2007

1. 2.      Open Microsoft Office Access

  

1. 3.      Create new database file and click on create button  OK.

 
 

1. 4.      Open table in design view.

 

1. 5.      Specify column name and there data type.

 
 

1. 6.      Save the table and add the data.

 

1. 7.      Your Database is Created.

i  if you have any problem or have any question then leave your comment.