Java Connection to Oracle

Importjava.sql.Connection;ImportJava.sql.DriverManager;Importjava.sql.SQLException;ImportJava.sql.ResultSet;Importjava.sql.Statement; Public classDB {Private StaticConnection con =NULL; Private StaticStatement sql =NULL; Private StaticResultSet rs =NULL;  Public Static voidMain (string[] args)throwsSQLException {intNo;       String DEP;       String Sal; Try{con= Dbconn ("Snpw1", "welcome1"); if(Con = =NULL) {System.out.print ("Connection Failed"); System.exit (0); } SQL=con.createstatement (); RS= Sql.executequery ("Select Empid, DeptID, salary from Oracle_employee"); System.out.println ("Work number" + "+" department number "+" "+" salary ");  while(Rs.next ()) {No= Rs.getint (1); DEP= Rs.getstring (2); Sal= Rs.getstring (3); System.out.println (No+ "+ dep +" "+Sal); }       } Catch(Exception e) {e.printstacktrace (); } finally{con.close (); }    }     Public StaticConnection dbconn (string name, String pass) {Connection C=NULL; Try{class.forname ("Oracle.jdbc.driver.OracleDriver"); } Catch(ClassNotFoundException e) {e.printstacktrace (); }        Try{C= Drivermanager.getconnection ("Jdbc:oracle:thin: @localhost: 1521:orcl", name, pass); } Catch(SQLException e) {e.printstacktrace (); }        returnC; }}

Note: To import the JDBC driver, right-click JRE System libray->build path->configure Build path->add External JARs, and then select the JDBC driver package that you want to import.

Java Connection to Oracle