managercatalog.java

对学习 VC有所帮助的几个例子

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

package myshop.catalog_sys;

import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import javax.servlet.http.HttpServletRequest;
import myshop.DBconn;
import myshop.Handle;

public class ManagerCatalog
{

    Handle handle;
    DBconn dbconn;
    String SystemURL;

    public ManagerCatalog()
        throws Exception
    {
        dbconn = new DBconn();
        handle = new Handle();
        SystemURL = handle.SystemURL;
    }

    public void AddCatalog(String s, HttpServletRequest httpservletrequest)
        throws Exception
    {
        String s1 = handle.getString(httpservletrequest, "title");
        int i = handle.getInt(httpservletrequest, "parentid");
        s1 = handle.GBK2ISO(s1);
        String s2 = "INSERT INTO " + s + "(title,parentid) VALUES('" + s1 + "'," + i + ")";
        dbconn.ExeUpdate(s2);
        dbconn.CloseConn();
    }

    public String CheckPareid(String s)
        throws Exception
    {
        String s1 = "";
        Object obj = null;
        try
        {
            String s2 = "SELECT * FROM " + s;
            ResultSet resultset = dbconn.ExeQuery(s2);
            s1 = s1 + "function CheckParentid(Cid) {\n";
            int i;
            int j;
            for(s1 = s1 + "\tvar ParentId;\n"; resultset.next(); s1 = s1 + "if (Cid == " + i + ") ParentId = " + j + ";\n")
            {
                i = resultset.getInt("id");
                j = resultset.getInt("parentid");
            }

            s1 = s1 + "\tif (ParentId == 0) alert('不能把商品归类到主类货架，请归类到子类货架！');\n";
            s1 = s1 + "}\n";
            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return s1;
    }

    public void DelCatalog(String s, String s1, HttpServletRequest httpservletrequest)
        throws Exception
    {
        int i = handle.getInt(httpservletrequest, "catalog_id");
        String s2 = "DELETE FROM " + s + " WHERE id=" + i;
        dbconn.ExeUpdate(s2);
        try
        {
            s2 = "SELECT * FROM " + s1 + " WHERE catalog_id=" + i;
            for(ResultSet resultset = dbconn.ExeQuery(s2); resultset.next(); handle.Del(httpservletrequest, "..\\..\\" + resultset.getString("img_path")));
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        s2 = "DELETE FROM " + s1 + " WHERE catalog_id=" + i;
        dbconn.ExeUpdate(s2);
        dbconn.CloseConn();
    }

    public String ListCatalog(String s)
        throws Exception
    {
        Object obj = null;
        Object obj1 = null;
        String s3 = "";
        try
        {
            String s1 = "SELECT * FROM " + s + " WHERE parentid=0 ORDER BY id DESC";
            for(ResultSet resultset = dbconn.ExeQuery(s1); resultset.next();)
            {
                int i = resultset.getInt("id");
                s3 = s3 + "<option value=" + i + ">" + resultset.getString("title") + "</option>\n";
                String s2 = "SELECT * FROM " + s + " WHERE parentid=" + i + " ORDER BY id DESC";
                for(ResultSet resultset1 = dbconn.ExeQuery(s2); resultset1.next();)
                    s3 = s3 + "<option value=" + resultset1.getInt("id") + "> ├" + resultset1.getString("title") + "</option>\n";

            }

            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return s3;
    }

    public String ListCatalog(String s, int i)
        throws Exception
    {
        Object obj = null;
        Object obj1 = null;
        String s3 = "";
        try
        {
            String s1 = "SELECT * FROM " + s + " WHERE parentid=0 ORDER BY id DESC";
            for(ResultSet resultset = dbconn.ExeQuery(s1); resultset.next();)
            {
                int j = resultset.getInt("id");
                s3 = s3 + "<option value=" + j + ">" + resultset.getString("title") + "</option>\n";
                String s2 = "SELECT * FROM " + s + " WHERE parentid=" + j + " ORDER BY id DESC";
                for(ResultSet resultset1 = dbconn.ExeQuery(s2); resultset1.next();)
                    if(resultset1.getInt("id") == i)
                        s3 = s3 + "<option value=" + resultset1.getInt("id") + " selected> ├" + resultset1.getString("title") + "</option>\n";
                    else
                        s3 = s3 + "<option value=" + resultset1.getInt("id") + "> ├" + resultset1.getString("title") + "</option>\n";

            }

            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return s3;
    }

    public String ListDetailType(HttpServletRequest httpservletrequest, String s, String s1)
        throws Exception
    {
        int i = 0;
        float f = 0.0F;
        String s5 = "";
        String s9 = handle.getString(httpservletrequest, "catalogName");
        String s6 = s9;
        s9 = handle.GBK2ISO(s9);
        try
        {
            String s2 = "SELECT * FROM " + s + " WHERE title = '" + s9 + "'";
            ResultSet resultset = dbconn.ExeQuery(s2);
            if(resultset.next())
                i = resultset.getInt("id");
            String s3 = "SELECT * FROM " + s + " WHERE parentid = " + i + " ORDER BY id DESC";
            for(ResultSet resultset1 = dbconn.ExeQuery(s3); resultset1.next();)
            {
                int j = resultset1.getInt("id");
                String s7 = resultset1.getString("title");
                s5 = s5 + "<table width=97% border=0 cellspacing=0 cellpadding=4>\n";
                s5 = s5 + "<tr>\n";
                s5 = s5 + "<td colspan=2 bgcolor=ccccff class=line1>" + s6 + " -&gt; <a href=../product_sys/DetailCatalog.jsp?Cid=" + j + "&Catalog_f=" + s6 + "&Catalog_s=" + s7 + ">" + s7 + "</a></td>\n";
                s5 = s5 + "</tr>\n";
                String s4 = "SELECT * FROM " + s1 + " WHERE catalog_id = " + j + " ORDER BY id DESC";
                for(ResultSet resultset2 = dbconn.ExeQuery(s4); resultset2.next();)
                {
                    String s8 = resultset2.getString("name");
                    float f1 = resultset2.getFloat("price");
                    int k = resultset2.getInt("id");
                    s5 = s5 + "<tr bgcolor=eeeeee>\n";
                    s5 = s5 + "<td width=80%><a href=../../DetailProInfo.jsp?Pid=" + k + ">" + s8 + "</a></td><td width=20% align=center valign=middle>" + f1 + "</td>\n";
                    s5 = s5 + "</tr>\n";
                }

                s5 = s5 + "</table>\n";
                s5 = s5 + "<br>\n";
            }

            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return s5;
    }

    public String ListMainCatalog(String s)
        throws Exception
    {
        String s2 = "";
        try
        {
            String s1 = "SELECT * FROM " + s + " WHERE parentid=0 ORDER BY id DESC";
            for(ResultSet resultset = dbconn.ExeQuery(s1); resultset.next();)
                s2 = s2 + "<option value=" + resultset.getInt("id") + ">" + resultset.getString("title") + "</option>\n";

            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return s2;
    }

    public void ModCatalog(String s, HttpServletRequest httpservletrequest)
        throws Exception
    {
        String s1 = handle.getString(httpservletrequest, "title");
        int i = handle.getInt(httpservletrequest, "catalog_id");
        s1 = handle.GBK2ISO(s1);
        String s2 = "UPDATE " + s + " SET title='" + s1 + "' WHERE id=" + i;
        dbconn.ExeUpdate(s2);
        dbconn.CloseConn();
    }

    public String ShowMainCatalog(String s)
        throws Exception
    {
        String s3 = "";
        float f = 0.0F;
        try
        {
            String s1 = "SELECT * FROM " + s + " WHERE parentid=0 ORDER BY id DESC";
            ResultSet resultset = dbconn.ExeQuery(s1);
            for(s3 = s3 + "<table width=100% border=0 cellspacing=0 cellpadding=3>"; resultset.next(); s3 = s3 + "</td></tr>")
            {
                s3 = s3 + "<tr>";
                int i = resultset.getInt("id");
                s3 = s3 + "<td width=100%>" + resultset.getString("title") + "</td>";
                s3 = s3 + "</tr>";
                String s2 = "SELECT * FROM " + s + " WHERE parentid=" + i + " ORDER BY id DESC";
                ResultSet resultset1 = dbconn.ExeQuery(s2);
                for(s3 = s3 + "<tr><td width=100% style=\"word-break:break-all;\">"; resultset1.next(); s3 = s3 + "<a href=" + SystemURL + "admin/product_sys/DetailCatalog.jsp?Cid=" + resultset1.getInt("id") + "&Catalog_f=" + resultset.getString("title") + "&Catalog_s=" + resultset1.getString("title") + ">" + resultset1.getString("title") + "</a> ");
            }

            s3 = s3 + "</table>";
            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return s3;
    }
}