Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- import oracle.jdbc.OracleTypes;
- import java.util.*;
- import oracle.jdbc.OracleType;
- public class SQL
- {
- /**
- * Constructor for objects of class ConectaDB
- */
- public SQL()
- {
- }
- public static void main(String[] args)
- {
- SQL cb = new SQL();
- Scanner cs = new Scanner(System.in);
- System.out.println("Ingrese Rut de Persona a Buscar");
- String vRut = cs.nextLine();
- cb.BuscarPersona(vRut);
- }
- public void BuscarPersona(String RUT)
- {
- try {
- Class.forName("oracle.jdbc.driver.OracleDriver");
- Connection conexion = DriverManager.getConnection("jdbc:oracle:thin:@srvOracle.exind.cl:7715:xe","lab13d","lab13d");
- String strQuery = "{call PKG_WK_OBTIENE_DATOS.PERSONAS(?,?)}";
- CallableStatement cs = conexion.prepareCall(strQuery);
- // Registramos los parametro de entrada IN
- cs.setString(1, RUT);
- // Registramos los parametro de salida OUT
- cs.registerOutParameter(2, OracleTypes.CURSOR);
- // Ejecutamos
- cs.execute();
- // Obtenemos los parametros de salida OUT
- ResultSet rs = (ResultSet) cs.getObject(2); // Nuestro cursor, convertido en ResultSet
- while (rs.next()) {
- System.out.println("APELLIDO: " + rs.getString(1));
- System.out.println("DIRECCION: " + rs.getString(2));
- // System.out.println("Calle : " + rs.getString(6));
- //System.out.println(" ");
- }
- rs.close();
- cs.close();
- conexion.close();
- } catch (Exception ex) {
- System.out.println("Error, " + ex);
- }
- }
- }
- //package rentacar;
- //public class SQL {
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement