import java.sql.*;

class test1
{
 public static void main(String [] args)
 {
    try
    {
        Class.forName("oracle.jdbc.OracleDriver");

        System.out.println("Driver loaded successfully");
    }
    catch(ClassNotFoundException ex)
    {
        System.out.println("Could not load "+ex.getMessage());
        System.exit(0);
    }
    Connection con=null;
    try
    {
        con=DriverManager.getConnection("jdbc:oracle:thin:@//Apoorv-PC:1521/orcl","scott","tiger");
        Statement st=con.createStatement();
        //st.setMaxRows(2);
        //System.out.println(st.getMaxRows());
        ResultSet rs=st.executeQuery("Select park_space from park_available where area='M.P.Nagar'");

        while(rs.next())
        {
            String p=rs.getString(1);
            System.out.println(" "+p);
        }
        con.close();
        System.out.println("Connection closed!");
    }
    catch(SQLException e)
    {
        System.out.println("Error in database"+e.getMessage());
    }
    if(con!=null)
    {
        System.out.println("Successful!");
    }
 }
}