30-08-2011, 12:26 PM
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));
}
}