Examples of using Java to manipulate Oracle databases
File name: Testora.javaimport java.sql.*;p ublic class Testora {public static void main (String args[]) {try {
Class.forName ("Sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = drivermanager.getconnection ("Jdbc:odbc:myorc80", "username", "password"); Statement sm=conn.createstatement ();
ResultSet rs=sm.executequery ("SELECT * from emp");
System.out.println ("number" + "+" name "+" "+" position "+" + "leader number")
+ "+" Employment Date "+" "+" salary "+" + "bonus" + "" + "department number");
while (Rs.next ()) {
System.out.print (rs.getstring (1) + "");
System.out.print (rs.getstring (2) + "");
System.out.print (rs.getstring (3) + "");
System.out.print (Rs.getstring (4) + "");
System.out.print (rs.getstring (5) + "");
System.out.print (rs.getstring (6) + "");
System.out.print (rs.getstring (7) + "");
System.out.println (rs.getstring (8));
} conn.close (); } catch (Exception e) {
E.printstacktrace ();
} }}
Java Connection to Oracle