// write a program of JDBC ODBC connectivity through ms access which prints the record one by one.

CODE

import java.sql.*;

class Database

{

public static void main(String args[])throws

Exception

{

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

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

Statement st=con.createStatement();

ResultSet res=st.executeQuery("select * from Student");

while(res.next())

{

System.out.println(res.getInt(1)+" "+res.getString(2)+" "+res.getString(3)+" "+res.getString(4));

}

}

}

OUTPUT DISPLAY

Posted in: Java programs