java database test

import java.sql.*;

import java.io.*;

public class JDBCTest

{

public static void main(String args[])

{

try{

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

Connection c=DriverManager.getConnection

("jdbc:odbc:rama;uid=scott;pwd=tiger;");

Statement st=c.createStatement();

ResultSet rs=st.executeQuery("Select stno,stname,stmarks from student");

try{

while(rs.next())

{

System.out.print(rs.getInt("stno")+" ");

System.out.print(rs.getString("stname")+" ");

System.out.println(rs.getString("stmarks"));

}

}

catch(Exception e)

{

System.out.println("inside:"+e);

}

}

catch(Exception e)

{

System.out.println(e);

}

}

}