package testdatabase;

import java.sql.Connection;

import java.sql.DriverManager;

import java.sql.ResultSet;

import java.sql.SQLException;

import java.sql.Statement;

class TestDatabase28

{

public static void main(String args[])

{

Connection con = null;

Statement st = null;

ResultSet rs = null;

try

{

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

System.out.println("Driver Loaded");

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

System.out.println("Connected");

st = con.createStatement();

String query = "Select * from emp";

rs = st.executeQuery(query);

while (rs.next())

{

System.out.print(rs.getString(1) + "\t");

System.out.print(rs.getString(2) + "\t");

System.out.print(rs.getString(3) + "\t");

System.out.println(rs.getString(4));

}

con.close();

}

catch (ClassNotFoundException e)

{

System.out.println(e);

}

catch (SQLException e)

{

System.out.println(e);

}

}

}