import java.util.*;
import java.sql.*;
class Oracle
{
	public static void main(String Ar[])throws Exception
	{
		String jdbcURL = "jdbc:oracle:thin:@10.45.8.22:1523:orclit";
		try{

		Class.forName("oracle.jdbc.OracleDriver");
			}
		catch(Exception e)
		{
			System.out.println(1+"   "+e);
		}

		Connection con=DriverManager.getConnection(jdbcURL,"scott","Tiger1234");

		Statement qry=con.createStatement();
		/*try{
		qry.executeUpdate("CREATE TABLE Persons(PersonID int,LastName varchar(255),FirstName varchar(255),Address varchar(255),City varchar(255))");
		}
		catch(Exception e){System.out.println(4+"   "+e);}*/
		//try
		//{
		//qry.executeUpdate("INSERT INTO Persons (PersonID,LastName,FirstName,Address,City)VALUES (1202,'Harsh','Mande','Cool','HYD')");
			/*ResultSet rs=*/qry.executeQuery("select * from Persons");
			//}
		//catch(Exception e){System.out.println(4+"   "+e);}
		//System.out.println(rs);
			ResultSet rs=qry.executeQuery("SELECT * FROM Persons");
			while(rs.next())
			{
				System.out.println(rs.getInt(1));
				System.out.println(rs.getString(3));
			}
	}
}
//INSERT INTO Persons (PersonID,LastName,FirstName,Address,City)VALUES (1234,'Ravi','Hari','Hyder','HYD')