Java connects Oracle with JDBC

1  PackageOracle;2 3 Importjava.sql.Connection;4 ImportJava.sql.DriverManager;5 ImportJava.sql.ResultSet;6 Importjava.sql.Statement;7 8 //Connect to Oracle using JDBC9 Ten  Public classtestoracle { One  A      Public Static voidMain (string[] args) { -         //TODO auto-generated Method Stub -  the         Try { -             //1. Load Driver -Class.forName ("Oracle.jdbc.driver.OracleDriver"); -             //2. Get Connected +Connection conn= drivermanager.getconnection ("jdbc:oracle:thin:@127.0.0.1:1521:oracle12c", "Sys as SYSDBA", " fairy6280 ");  -              +Statement SM =(Statement) conn.createstatement (); AString sql = "SELECT * FROM Student"; atString SQL1 = "SELECT * from" (Select A1.*,rownum rowIndex from (SELECT * from Student Order by salary) A1 where RowNum &lt ; 5) where RowIndex > 1 "; -ResultSet RSet =sm.executequery (SQL1); -              while(Rset.next ()) -             { -System.out.println ("Name:" + rset.getstring (2)); -             } in              -             //Join transaction Processing toConn.setautocommit (false); +String sql3= "Update student set salary=salary-100 where sname= ' Smith '"; -String SQL4 = "Update student Set salary = salary +100 where sname= ' Bill '"; the sm.executeupdate (SQL3); * sm.executeupdate (SQL4); $ conn.commit ();Panax Notoginseng              -             //Close Resource the rset.close (); + sm.close (); A conn.close (); the}Catch(Exception e) { +             //Todo:handle Exception - e.printstacktrace (); $         } $System.out.println ("----------"); -     } -  the}

Note: To add JDBC Driver-Ojdbc7.jar to your project

Java connects Oracle with JDBC