JDBC Connection to Oracle database small demo

Import java.sql.Connection;
Import Java.sql.DriverManager;
Import java.sql.PreparedStatement;
Import Java.sql.ResultSet;
Import java.sql.SQLException;




public class Javaconnectoracle
{
private static ResultSet rs = null;

private static PreparedStatement PS = null;

private static Connection conn = null;

private static String username = "Scott";

private static String password = "Tiger";


public static void Main (string[] args) throws SQLException
{
Try
{
Class.forName ("Oracle.jdbc.driver.OracleDriver"); Load Drive
}
catch (ClassNotFoundException e)
{
SYSTEM.OUT.PRINTLN ("registration failed");
}

Try
{

ORCL is the database name username is the database user password is the database user's password 1521 is the port number @localhost is the Betty host
conn = Drivermanager.getconnection ("Jdbc:oracle:thin: @localhost: 1521:orcl", Username,password);
}
catch (SQLException e)
{
SYSTEM.OUT.PRINTLN ("Establish connection failed");

}

Try
{
PS = conn.preparestatement ("SELECT * from EMP"); Note that the SQL statement here has no semicolon ...


}
catch (SQLException e)
{
E.printstacktrace ();
}


Try
{
rs = Ps.executequery ();
}

catch (Exception e)
{
System.out.println ("AAA");
}



System.out.println ("number \ t name \ t wages");

while (Rs.next ())
{
System.out.println (rs.getstring ("EMPNO") + "T" + rs.getstring ("ename") + "T" + rs.getstring ("SAL"));
}




if (null!= RS)
{
Rs.close ();
}
if (null!= PS)
{
Ps.close ();
}

if (NULL!= conn)
{
Conn.close ();
}






}

}