Package JDBC;
Import java.sql.Connection;
Import Java.sql.DriverManager;
Import java.sql.SQLException;
Import java.sql.PreparedStatement;
Import Java.sql.ResultSet;
public class Testoracle {
public static void Main (string[] args) {
1. Load Driver
Connection conn = null;
PreparedStatement PS = null;
ResultSet rs = null;
try {
Class.forName ("Oracle.jdbc.OracleDriver");
2. Establish a connection
String url = "Jdbc:oracle:thin: @localhost: 1521:ORCL";
conn = drivermanager.getconnection (URL, "Scott", "Tiger");
3. Send SQL statements to get results
String sql = "SELECT * from EMP";
PS = conn.preparestatement (SQL);
rs = Ps.executequery ();
4. Processing results
while (Rs.next ()) {
System.out.println (rs.getstring ("ename"));
}
} catch (ClassNotFoundException e) {
E.printstacktrace ();
} catch (SQLException e) {
E.printstacktrace ();
} finally {
5. Releasing Resources
try {
IF (conn! = null) conn.close ();
if (PS! = null) ps.close ();
if (rs! = null) rs.close ();
} catch (Exception E2) {
E2.printstacktrace ();
}
}
}
}
JDBC and Oracle database establish connections