package javaapplication2;
import java.sql.*;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.SQLException;
import java.sql.*;
import java.io.*;
import java.util.*;
import oracle.net.ns.*;
import oracle.net.ano.*;
import oracle.jdbc.*;
import oracle.jdbc.pool.*;

public class JavaApplication2 {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) throws SQLException, ClassNotFoundException  {

        Connection c = openConnection("SAM", "SAM", "10.10.1.20","1521","RIO4CG",true);
        if (c==null) {
            System.err.println("ERROR CONECTANDO");
            System.exit(1);
        }
        System.out.println("Conectado a la base");
        query(c, "SELECT * FROM AC_PRECIOS_CDS");
        c.close();


    }
    private static Connection openConnection(String strUserName, String strPassword, String ip, String port, String service, boolean encrypted) throws SQLException, ClassNotFoundException {

        Properties props = new Properties();
        try {
            props.put("user", strUserName);
            props.put("password", strPassword);
            if (encrypted){
                props.put("oracle.net.encryption_client", "requested");
                props.put("oracle.net.encryption_types_client", "( RC4_256 )");
                props.put("oracle.net.crypto_checksum_client","requested");
                props.put("oracle.net.crypto_checksum_types_client", "( MD5 )");
            }
        } catch (Exception e) {
            e.printStackTrace();
        }
        OracleDataSource ods = new OracleDataSource();
        ods.setURL("jdbc:oracle:thin:@//" + ip + ":" + port +"/" + service);
        ods.setConnectionProperties(props);
        return ods.getConnection();
    }

    private static void query(Connection c, String query) throws SQLException
    {
        Statement st = null;
        ResultSet rs = null;
        st = c.createStatement();
        rs = st.executeQuery(query);
        while (rs.next())  {
            System.out.println( rs.getString("CODIGO_AC"));
        }
        System.out.println("Terminó el result");
        rs.close();
        st.close();
      return;
    }
}