import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.util.*;
import lotus.domino.*;


public class BANCOLOMBIALandingZone {

    private Session ss;
    private Database db;
    private View vwEstSigXEstIni;
    private View vwPorRadicado;
    private Document docSolCredito;
    private DateTime dtmHoy;
    private IASJavaLog objLog;
    private IASJavaConexion objConexion;
    private BANCOLOMBIAAccesoParamInterno objAccesoParam;
    private MemoryUsageMetter metter;

    public BANCOLOMBIALandingZone(BANCOLOMBIAAccesoParamInterno objAccesoParam, IASJavaLog objLog) {
        String strEncabezadoError = "Error en el constructor BANCOLOMBIALandingZone. ";
        try {
            this.ss = NotesFactory.createSession();
            this.db = ss.getAgentContext().getCurrentDatabase();
            this.objAccesoParam = objAccesoParam;
            this.objLog = objLog;
            this.objConexion = new IASJavaConexion(objLog);
            this.metter = new MemoryUsageMetter(Runtime.getRuntime(), objLog);
            this.metter.check();

        } catch (Exception e) {
            objLog.setRegistroError(0, strEncabezadoError + "\n" + "Excepción: " + e.toString());
            System.out.println("Excepcion Constructor Bancolombia Landing Zone");

        }
    }

    public void GenearaReporte() {
        String strEncabezadoError = "Error en el método carga informe LZ. ";
        DocumentCollection docCol = null;
        Document docConfigGral = null;

        try {
            insertarRegistro();



        } catch (Exception e) {
            objLog.setRegistroError(0, strEncabezadoError + "\n" + "Excepción: " + e.toString());
            objConexion.desconectar();
        }
    }

    private void insertarRegistro() throws Exception {

        Connection dbConnection = null;
        PreparedStatement ps = null;
        String strNombreTabla = "TBANCOL_LZ";
        String strIdConsulta = "CLIENTE";

        String sql = "INSERT INTO " + strNombreTabla
        + "(SOLFECCRE, SOLFECAPR, SOLCODVEN, SOLUSRCRE, SOLCODAPR, SOLNROSOL, SOLVALAPR, SOLESTADO, SOLIDENT, SOLTIPOID) "
	   + "VALUES (?,?,?,?,?,?,?,?,?,?)";

        try {
               objConexion.conectar("jdbc:oracle:thin:@//192.168.1.251:1522/DBSURA",
                        "IASPIC_DLL",
                        "IASPIC_DLL",
                        "ORACLE");

                objLog.setRegistro("Realiza conexion");

                dbConnection = objConexion.con;

                objLog.setRegistro("Preparar preparestatement");

                ps = dbConnection.prepareStatement(sql.toString());

                ps.setString(1, "2017/02/01");
		ps.setString(2, "2017/02/30");
		ps.setString(3, "PRUEBA1");
		ps.setString(4, "PRUEBA2");
		ps.setString(5, "PRUEBA3");
		ps.setString(6, "PRUEBA4");
		ps.setString(7, "PRUEBA5");
		ps.setString(8, "PRUEBA6");
		ps.setString(9, "PRUEBA7");
		ps.setString(10, "PRUEBA8");

                ps.execute();
                objLog.setRegistro("Ejecuta insercción");


        } catch (SQLException e) {

            System.out.println(e.getMessage());
            objLog.setRegistro("Error: " + e.getMessage());

        } finally {

            if (ps != null) {
                ps.close();
            }

            if (dbConnection != null) {
                dbConnection.close();
            }
        }
    }
}