O codigo que estou usando é o seguinte: import java.sql.*; public class JDBCExample { public static void main(String args[]) throws SQLException { DriverManager.registerDriver(new oracle.jdbc.driver.OracleDriver()); Connection conn=DriverManager.getConnection("jdbc:oracle:oci8:@localhost:1521:master.world","scott", "tiger"); Statement stmt = conn.createStatement(); ResultSet rs =stmt.executeQuery("select ename, empno, sal from emp"); while(rs.next()){ String name= rs.getString(1); int number = rs.getInt(2); double salary = rs.getDouble(3); System.out.println(name+" "+number+" "+salary); } rs.close(); conn.close(); } }
|