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 < ; 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