JDBC index Java source code

[giri]

Code:

import java.sql.*;
import java.io.*;

public class JDBCindex
{
public static void main(String args[])throws Exception
{

  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 MAX(stmarks),MIN(stmarks) from student");
  rs.next();
  System.out.print("Max Marks :"+rs.getInt(1));
  System.out.print("MINmarks:"+rs.getInt(2));  
}
}