java sql

[phoniex05]

/*
Show all records from Dept Table
*/

import java.sql.*;

class sq1
{
public static void main(String args[])
{
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con = DriverManager.getConnection("jdbcdbc:dsn");
Statement st = con.createStatement();
ResultSet rs = st.executeQuery("Select * from student1");
while(rs.next())
{
System.out.println(rs.getString(1));
System.out.println(rs.getString(2));
}
con.close();
}catch(Exception ex)
{
System.out.println("sq1 : " + ex);
}
}
}