Top Most Step By Step Java DataBase Connection for Type 1

Type1 Driver Connection :-

Connection with Type 1 Driver i.e. Jdbc Odbc Bridge (First your request will go to Jdbc Driver then it turn your request to Odbc Driver then it connect to database. Its Platform dependent so. You need to create a data source name (DSN) on operating system. Follow below steps one by one as image is given. I tried on Windows Operating System Windows 7.


Step1) Go to Control Panel To 

Step 2) Go To Administrative Tools

Step 3) Go To Data Sources (ODBC)

Ste 4) Click To MS Access Database and click on add button

Step 5) Above Step will show you MS Access Driver (*mdb, *accdb) Click on this and then click on finish

Step 6) Above Step Give you new Screen like below and provide Data Source Name and the click on select button this step will give you a new screen where you can provide your folder location where your *.mdb file or *.accdb file stored . Choose your drive and file then click ok. and close all screen by clicking ok reverse order.

Step7) write java code as below on eclipse or on your editor



package test.myapp.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

//JDBC Type 1 Driver Example
public class TestJDBCODBCWithAccess {
public static void main(String[] args) {
Connection con = null;
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

// Connect with a url string
con = DriverManager.getConnection("jdbc:odbc:mamta_db");
if (con != null) {
System.out.println("DSN Connection ok.");
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("select * from Employee");
while (rs.next()) {
System.out.println(rs.getString(1) + " " + rs.getString(2)
+ " " + rs.getString(3));

}
con.close();
}

} catch (Exception e) {
System.err.println("Exception: " + e.getMessage());
}
}
}

Step 8) Create your table on MS Access file as  below and insert some data as follows

Step 9) Run Your JDBC ODBC Program and tell me you result. I think every thing is fine. Enjoy :)