savecategory.java

OpenWeb-UDDI是UDDI V2标准的实现

// 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:   SaveCategory.java

package org.huihoo.openweb.uddiserver.publish;

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

public class SaveCategory
{

    Connection con;
    CategoryBag categorybag;
    String generatedtmodelkey;
    String qtype;
    String querytype;

    public SaveCategory(CategoryBag categorybag, Connection con, String generatedtmodelkey)
    {
        querytype = "I";
        this.con = con;
        this.categorybag = categorybag;
        this.generatedtmodelkey = generatedtmodelkey;
    }

    public void save()
        throws SQLException, ClassNotFoundException
    {
        Statement stmt = con.createStatement();
        String query = "select * from CategoryBag where keys='" + generatedtmodelkey + "'";
        System.out.println(query);
        ResultSet rs = stmt.executeQuery(query);
        if(rs.next())
            querytype = "U";
        rs.close();
        stmt.close();
        System.out.println("yyyyyyyyyyyyyyyyyyyyyy");
        Enumeration keyedref = null;
        if(categorybag.getKeyedReference() != null)
            keyedref = categorybag.getKeyedReference();
        Statement stmt1;
        for(; keyedref.hasMoreElements(); stmt1.close())
        {
            KeyedReference keyedreference = (KeyedReference)keyedref.nextElement();
            String keyname = "";
            if(keyedreference.getKeyName() != null)
                keyname = keyedreference.getKeyName();
            String keyvalue = "";
            if(keyedreference.getKeyValue() != null)
                keyvalue = keyedreference.getKeyValue();
            String standardkey = "";
            if(keyedreference.getTModelKey().getValue() != null)
                standardkey = keyedreference.getTModelKey().getValue();

            stmt1 = con.createStatement();
            String insertquery1 = "insert into CategoryBag values('" + generatedtmodelkey + "','" + standardkey + "','" + keyname + "','" + keyvalue + "','0') ";
            String updatequery1 = "update CategoryBag set tmodelkey='" + standardkey + "',keyname='" + keyname + "',keyvalue='" + keyvalue + "'" + " where keys='" + generatedtmodelkey + "'";
            if(querytype.equals("I"))
            {
                System.out.println(insertquery1);
                stmt1.executeUpdate(insertquery1);
            } else
            if(querytype.equals("U"))
            {
                System.out.println("begin to execute!!!");
                System.out.println(updatequery1);
                stmt1.executeUpdate(updatequery1);
                System.out.println("executesuccess!!!");
            }
        }

        System.out.println("jjjjjjjjjjjjjjjjjjjjjjjjjjjj");
    }
}