getallcategorytmodel.java

OpenWeb-UDDI是UDDI V2标准的实现

/*
 * Created on 2005-10-18
 *
 * TODO To change the template for this generated file go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
package org.huihoo.openweb.uddiserver.inquiry;

import java.io.ByteArrayInputStream;
import java.io.IOException;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Enumeration;

import org.huihoo.openweb.uddi.CategoryBag;
import org.huihoo.openweb.uddi.CheckQualifiers;
import org.huihoo.openweb.uddi.DispositionReport;
import org.huihoo.openweb.uddi.FindQualifiers;
import org.huihoo.openweb.uddi.Get_TModelDetail;
import org.huihoo.openweb.uddi.IdentifierBag;
import org.huihoo.openweb.uddi.KeyedReference;
import org.huihoo.openweb.uddi.OverviewDoc;
import org.huihoo.openweb.uddi.Result;
import org.huihoo.openweb.uddi.TModel;
import org.huihoo.openweb.uddi.TModelDetail;
import org.huihoo.openweb.uddi.TModelInfo;
import org.huihoo.openweb.uddi.TModelInfos;
import org.huihoo.openweb.uddi.TModelKey;
import org.huihoo.openweb.uddi.TModelList;
import org.huihoo.openweb.uddi.UDDIXmlException;
import org.huihoo.openweb.uddi.UddiObject;

/**
 * @author sky1
 *
 * TODO To change the template for this generated type comment go to
 * Window - Preferences - Java - Code Style - Code Templates
 */
public class GetAllCategoryTModel {
    Connection con;

    public GetAllCategoryTModel(Connection c)
    {
        con = c;
    }
    
    public UddiObject getData()
    throws SQLException, IOException, UDDIXmlException, ClassNotFoundException
	{
	    String detail = "<tModelList generic=\"1.0\" xmlns=\"urn:uddi-org:api\" operator=\"www.huihoo.com\" truncated=\"false\"></tModelList>";
	    ByteArrayInputStream bas = new ByteArrayInputStream(detail.getBytes());
	    TModelList tmodellist = new TModelList(bas);
	    TModelInfos tmodelinfos = new TModelInfos();
	    Statement stmt = con.createStatement();
	    ResultSet rs = stmt.executeQuery("SELECT Keys FROM CategoryBag Where Keyvalue='categorization' and tmodelkey='uuid:c1acf26d-9672-4404-9d70-39b756e62ab4'");
	    TModelInfo tmodelinfo;
	    while(rs.next()){
	    	String categoryTModelkey =rs.getString("Keys");
	    	System.out.println("Keys:"+categoryTModelkey);
	    	Statement stmt1=con.createStatement();
	    	ResultSet rs1 = stmt1.executeQuery("select * from TModelDetails where tmodelkey='"+categoryTModelkey+"'");
		    while(rs1.next()){
		        String tmodelkey = rs1.getString("tmodelkey");
		        System.out.println("tmodelkey:"+tmodelkey);
		        tmodelinfo = new TModelInfo(tmodelkey);
		        String tmodelname = rs1.getString("keyname");
		        System.out.println("tmodelname:"+tmodelname);
		        
		        UddiObject obj = new UddiObject("name");
		        obj.setValue(tmodelname);
		        tmodelinfo.addElement(obj);
		        System.out.println("GetAllCategoryTModel: "+tmodelinfo);
		        tmodelinfos.addElement(tmodelinfo);
		    }
		    rs1.close();
		    stmt1.close();
	    }
	    rs.close();
	    stmt.close();
	    
	    tmodellist.addElement(tmodelinfos);
	    System.out.println("GetAllCategoryTModel: "+tmodellist);
	    return tmodellist;
	}
	
	public UddiObject errorOccured(Result result)
	{
	    DispositionReport pr = new DispositionReport();
	    pr.setResult(result);
	    return pr;
	}
}