// Decompiled by Jad v1.5.7g. Copyright 2000 Pavel Kouznetsov.
// Jad home page: http://www.geocities.com/SiliconValley/Bridge/8617/jad.html
// Decompiler options: packimports(3) fieldsfirst ansi 
// Source File Name:   FindBinding.java

package org.huihoo.openweb.uddiserver.inquiry;

import java.io.*;
import java.sql.*;
import java.util.Enumeration;
import java.util.Vector;
import org.huihoo.openweb.uddi.*;

public class FindBinding
{

    Connection con;
    Find_Binding bindingdoc;

    public FindBinding(Find_Binding bindingdoc, Connection c)
    {
        this.bindingdoc = bindingdoc;
        con = c;
    }

    public UddiObject getData()
        throws SQLException, IOException, UDDIXmlException, ClassNotFoundException
    {
        FindQualifiers qualifiers = bindingdoc.getQualifiers();
        if(qualifiers != null)
        {
            Enumeration qualifier = qualifiers.getQualifier();
            boolean value = CheckQualifiers.check(qualifier);
            if(!value)
            {
                Result result = Result.getResult(10050, "The findQualifier value " + CheckQualifiers.qualifiervalue + " was invalid ");
                return errorOccured(result);
            }
        }
        String servicekey = bindingdoc.getServiceKey();
        TModelBag tmodelbag = bindingdoc.getTModelBag();
        String tmodelkeys = "";
        for(Enumeration enum = tmodelbag.getTModelKey(); enum.hasMoreElements();)
        {
            TModelKey keyelement = (TModelKey)enum.nextElement();
            tmodelkeys = tmodelkeys + "'" + keyelement.getValue() + "',";
        }

        int last = tmodelkeys.lastIndexOf(",");
        tmodelkeys = tmodelkeys.substring(0, last);
        System.out.println(" check " + tmodelkeys);
        String detail = "<bindingDetail generic=\"1.0\" xmlns=\"urn:uddi-org:api\" operator=\"www.huihoo.com\" truncated=\"false\"></bindingDetail>";
        ByteArrayInputStream bas = new ByteArrayInputStream(detail.getBytes());
        BindingDetail bindingdetail = new BindingDetail(bas);
        String str = "";
        Statement stmt = con.createStatement();
        ResultSet rs = stmt.executeQuery("SELECT * FROM BindingTemplate Where servicekey ='" + servicekey + "'");
        int keycheck = 0;
        BindingTemplates bindingtemplates = new BindingTemplates();
        Vector vec0 = new Vector();
        String bindingkey = null;
        String description = null;
        String accesspoint = null;
        String servicetype = null;
        Vector vec01;
        for(; rs.next(); vec0.addElement(vec01))
        {
            vec01 = new Vector();
            vec01.addElement(rs.getString("bindingkey"));
            vec01.addElement(rs.getString("description"));
            vec01.addElement(rs.getString("accesspoint"));
            vec01.addElement(rs.getString("servicetype"));
        }

        rs.close();
        stmt.close();
        BindingTemplate bindingtemplate;
        for(Enumeration enu0 = vec0.elements(); enu0.hasMoreElements(); bindingdetail.addElement(bindingtemplate))
        {
            Vector vec02 = (Vector)enu0.nextElement();
            Enumeration enu01 = vec02.elements();
            bindingkey = (String)enu01.nextElement();
            description = (String)enu01.nextElement();
            accesspoint = (String)enu01.nextElement();
            servicetype = (String)enu01.nextElement();
            bindingtemplate = new BindingTemplate(new BindingKey(bindingkey));
            bindingtemplate.setServiceKey(new ServiceKey(servicekey));
            UddiObject object = new UddiObject("description");
            object.setValue(description);
            bindingtemplate.addElement(object);
            UddiObject obj1 = new UddiObject("accessPoint");
            obj1.setValue(accesspoint);
            obj1.setAttribute("urlType", servicetype);
            bindingtemplate.addElement(obj1);
            TModelInstanceDetails tmodelinstancedetails = new TModelInstanceDetails();
            keycheck = 0;
            String query = "select * from InstanceDetails where  bindingkey='" + bindingkey + "'and tmodelkey in (" + tmodelkeys + ")";
            Statement stmt1 = con.createStatement();
            ResultSet rs1 = stmt1.executeQuery(query);
            Vector vec1 = new Vector();
            String tmodelkey = null;
            String tModInstDesc = null;
            String overViewDocDesc = null;
            String overViewUrl = null;
            String instanceParms = null;
            Vector vec11;
            for(; rs1.next(); vec1.addElement(vec11))
            {
                vec11 = new Vector();
                vec11.addElement(rs1.getString("tmodelkey"));
                vec11.addElement(rs1.getString("tModInstDesc"));
                vec11.addElement(rs1.getString("overViewDocDesc"));
                vec11.addElement(rs1.getString("overViewUrl"));
                vec11.addElement(rs1.getString("instanceParms"));
            }

            rs1.close();
            stmt1.close();
            TModelInstanceInfo tModelInstanceInfo;
            for(Enumeration enu1 = vec1.elements(); enu1.hasMoreElements(); tmodelinstancedetails.addElement(tModelInstanceInfo))
            {
                Vector vec12 = (Vector)enu1.nextElement();
                Enumeration enu11 = vec12.elements();
                tmodelkey = (String)enu11.nextElement();
                tModInstDesc = (String)enu11.nextElement();
                overViewDocDesc = (String)enu11.nextElement();
                overViewUrl = (String)enu11.nextElement();
                instanceParms = (String)enu11.nextElement();
                keycheck++;
                String key = tmodelkey;
                tModelInstanceInfo = new TModelInstanceInfo(new TModelKey(key));
                InstanceDetails instancedetails = new InstanceDetails();
                OverviewDoc overviewdoc = new OverviewDoc();
                UddiObject urlobj = new UddiObject("overviewURL");
                urlobj.setValue(overViewUrl);
                overviewdoc.addElement(urlobj);
                UddiObject desobj = new UddiObject("description");
                desobj.setValue(overViewDocDesc);
                overviewdoc.addElement(desobj);
                UddiObject instandesc = new UddiObject("tModInstDesc");
                instandesc.setValue(tModInstDesc);
                UddiObject instanceobj = new UddiObject("instanceParms");
                instanceobj.setValue(instanceParms);
                instancedetails.addElement(instandesc);
                instancedetails.addElement(instanceobj);
                instancedetails.addElement(overviewdoc);
                tModelInstanceInfo.addElement(instancedetails);
            }

            if(keycheck == 0)
                break;
            bindingtemplate.addElement(tmodelinstancedetails);
        }

        if(keycheck == 0)
        {
            Result result = Result.getResult(10210, "Key passed did not match with any of the Keys present ");
            return errorOccured(result);
        } else
        {
            System.out.println(bindingdetail);
            return bindingdetail;
        }
    }

    public UddiObject errorOccured(Result result)
    {
        DispositionReport pr = new DispositionReport();
        pr.setResult(result);
        return pr;
    }
}