managerproduct.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:   ManagerProduct.java

package myshop.product_sys;

import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Hashtable;
import java.util.Vector;
import javax.servlet.ServletRequest;
import javax.servlet.http.HttpServletRequest;
import myshop.DBconn;
import myshop.Handle;
import myshop.catalog_sys.ManagerCatalog;

// Referenced classes of package myshop.product_sys:
//            productBean

public class ManagerProduct
{

    Handle handle;
    DBconn dbconn;
    ManagerCatalog managercatalog;
    String SystemURL;

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

    public void AddClick(String s, int i)
        throws Exception
    {
        String s1 = "UPDATE " + s + " SET click=click+1 WHERE id=" + i;
        dbconn.ExeUpdate(s1);
        dbconn.CloseConn();
    }

    public void AddProduct(HttpServletRequest httpservletrequest, String s, String s1)
        throws Exception
    {
        String s2 = handle.GBK2ISO(httpservletrequest.getParameter("name"));
        String s3 = handle.GBK2ISO(httpservletrequest.getParameter("description"));
        String s4 = handle.GBK2ISO(httpservletrequest.getParameter("keywords"));
        s3 = handle.ConvertChar(s3);
        float f = Float.parseFloat(httpservletrequest.getParameter("price"));
        int i = Integer.parseInt(httpservletrequest.getParameter("catalog_id"));
        int j = Integer.parseInt(httpservletrequest.getParameter("show_out"));
        String s5 = "INSERT INTO " + s + "(catalog_id,name,description,keywords,img_path,show_out,price,date_time) VALUES(" + i + ",'" + s2 + "','" + s3 + "','" + s4 + "','" + s1 + "'," + j + "," + f + ",sysdate())";
        dbconn.ExeUpdate(s5);
        dbconn.CloseConn();
    }

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

    public Hashtable DetailProInfo(String s, String s1, int i)
        throws Exception
    {
        Hashtable hashtable = new Hashtable();
        try
        {
            String s2 = "SELECT * FROM " + s1 + " WHERE id=" + i;
            ResultSet resultset = dbconn.ExeQuery(s2);
            resultset.next();
            hashtable.put("name", resultset.getString("name"));
            hashtable.put("description", resultset.getString("description"));
            hashtable.put("description_txt", handle.ReturnTxt(resultset.getString("description")));
            if(resultset.getString("img_path").indexOf(".") != -1)
                hashtable.put("img_path", resultset.getString("img_path"));
            else
                hashtable.put("img_path", "img/que.gif");
            hashtable.put("price", resultset.getString("price"));
            hashtable.put("date_time", resultset.getString("date_time"));
            hashtable.put("catalog", InTheCatalog(s, resultset.getInt("catalog_id")));
            hashtable.put("catalog_id", new Integer(resultset.getInt("catalog_id")));
            hashtable.put("keywords", resultset.getString("keywords"));
            hashtable.put("absence", resultset.getString("absence"));
            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return hashtable;
    }

    public String HotSell(String s)
        throws Exception
    {
        String s2 = "";
        try
        {
            String s1 = "SELECT id,name FROM " + s + " ORDER BY purchase_num DESC";
            ResultSet resultset = dbconn.ExeQuery(s1);
            s2 = s2 + "<table width=100% border=0 cellspacing=0 cellpadding=3>";
            for(float f = 0.0F; f < 10F; f++)
            {
                if(!resultset.next())
                    break;
                int i = (int)(f + 1.0F);
                if(f / 2.0F == (float)((int)f / 2))
                    s2 = s2 + "<tr>";
                else
                    s2 = s2 + "<tr bgcolor=#ffffFF>";
                s2 = s2 + "<td width=82%><a href=" + SystemURL + "DetailProInfo.jsp?Pid=" + resultset.getInt("id") + ">" + resultset.getString("name") + "</a></td>";
                s2 = s2 + "</tr>";
            }

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

    public String InTheCatalog(String s, int i)
        throws Exception
    {
        String s2 = "";
        String s3 = "";
        String s4 = "";
        int j = 0;
        try
        {
            String s1 = "SELECT title,parentid FROM " + s + " WHERE id=" + i;
            ResultSet resultset = dbconn.ExeQuery(s1);
            if(resultset.next())
            {
                j = resultset.getInt("parentid");
                s2 = resultset.getString("title");
            }
            s1 = "SELECT title FROM " + s + " WHERE id=" + j;
            resultset = dbconn.ExeQuery(s1);
            if(resultset.next())
                s3 = resultset.getString("title");
            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        s4 = s3;
        s3 = "<a href=admin/catalog_sys/ListDetailType.jsp?catalogName=" + s3 + ">" + s3 + "</a>";
        s2 = "<a href=admin/product_sys/DetailCatalog.jsp?Cid=" + i + "&Catalog_f=" + s4 + "&Catalog_s=" + s2 + ">" + s2 + "</a>";
        return s3 + " &gt; " + s2;
    }

    public String ListProducts(String s, String s1, int i, int j, int k, int l, String s2)
        throws Exception
    {
        String s4 = "";
        String s5 = "";
        s4 = s4 + "<table width=100% border=0 cellspacing=3 cellpadding=3>\n";
        try
        {
            String s3;
            if(s2.equals("new"))
                s3 = "SELECT * FROM " + s1 + " ORDER BY id DESC";
            else
                s3 = "SELECT * FROM " + s1 + " WHERE show_out=1 ORDER BY id DESC";
            ResultSet resultset = dbconn.ExeQuery(s3);
            for(int i1 = 0; i1 < i; i1++)
            {
                s4 = s4 + "<tr>\n";
                for(int j1 = 0; j1 < j; j1++)
                {
                    if(!resultset.next())
                        break;
                    if(resultset.getString("img_path").indexOf(".") != -1)
                        s4 = s4 + "<td align=center valign=middle><a href=DetailProInfo.jsp?Pid=" + resultset.getInt("id") + "><img src=" + resultset.getString("img_path") + " border=1 width=" + k + " height=" + l + "></a></td>\n";
                    else
                        s4 = s4 + "<td align=center valign=middle><a href=DetailProInfo.jsp?Pid=" + resultset.getInt("id") + "><img src=img/que.gif border=1 width=" + k + " height=" + l + "></a></td>\n";
                    s4 = s4 + "<td align=left valign=middle>" + resultset.getString("name") + "<br><font color=red>￥ " + resultset.getFloat("price") + "</font></td>\n";
                }

                s4 = s4 + "</tr>\n";
            }

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

    public void MarkAbsence(HttpServletRequest httpservletrequest, String s)
        throws Exception
    {
        int i = handle.getInt(httpservletrequest, "Pid");
        String s1 = "UPDATE " + s + " SET absence=1 WHERE id=" + i;
        dbconn.ExeUpdate(s1);
        dbconn.CloseConn();
    }

    public void Modify(HttpServletRequest httpservletrequest, String s)
        throws Exception
    {
        String s1 = handle.GBK2ISO(httpservletrequest.getParameter("name"));
        String s2 = handle.GBK2ISO(httpservletrequest.getParameter("description"));
        String s3 = handle.GBK2ISO(httpservletrequest.getParameter("keywords"));
        s2 = handle.ConvertChar(s2);
        float f = Float.parseFloat(httpservletrequest.getParameter("price"));
        int i = Integer.parseInt(httpservletrequest.getParameter("catalog_id"));
        int j = Integer.parseInt(httpservletrequest.getParameter("Pid"));
        String s4 = "UPDATE " + s + " SET name='" + s1 + "',description='" + s2 + "',keywords='" + s3 + "',price=" + f + ",catalog_id=" + i + " WHERE id=" + j;
        dbconn.ExeUpdate(s4);
        dbconn.CloseConn();
    }

    public void MoveProducts(String s, HttpServletRequest httpservletrequest)
        throws Exception
    {
        String as[] = httpservletrequest.getParameterValues("checkbox");
        int j = handle.getInt(httpservletrequest, "catalog_id");
        for(int i = 0; i < as.length; i++)
        {
            String s1 = "UPDATE " + s + " SET catalog_id=" + j + " WHERE id=" + Integer.parseInt(as[i]);
            dbconn.ExeUpdate(s1);
            dbconn.CloseConn();
        }

    }

    public Hashtable ReadDataAdmin(String s, int i, String s1, String s2, String s3, String s4)
        throws Exception
    {
        String s6 = "";
        int j = 0;
        float f = 0.0F;
        boolean flag = false;
        Hashtable hashtable = new Hashtable();
        Hashtable hashtable1 = new Hashtable();
        try
        {
            s2 = handle.GBK2ISO(s2);
            String s5;
            if(s3.equals("name"))
                s5 = "SELECT * FROM " + s4 + " WHERE name LIKE '%" + s2 + "%' ORDER BY id DESC";
            else
            if(s3.equals("description"))
                s5 = "SELECT * FROM " + s4 + " WHERE description LIKE '%" + s2 + "%' ORDER BY id DESC";
            else
                s5 = "SELECT * FROM " + s4 + " ORDER BY id DESC";
            ResultSet resultset = dbconn.ExeQuery(s5);
            resultset.last();
            j = resultset.getRow();
            hashtable = turn_page(s, i, j);
            int l = Integer.parseInt(String.valueOf(hashtable.get("pt_st"))) + 1;
            int i1 = Integer.parseInt(String.valueOf(hashtable.get("pt_en"))) + 1;
            resultset.absolute(l);
            for(int k = l; k < i1; k++)
            {
                f++;
                int j1 = resultset.getInt("id");
                int k1 = resultset.getInt("show_out");
                int l1 = resultset.getInt("absence");
                int i2 = resultset.getInt("importance_show");
                String s8 = resultset.getString("name");
                String s9;
                if(f / 2.0F == (float)(int)(f / 2.0F))
                    s9 = "f1f1f1";
                else
                    s9 = "ffffff";
                String s10;
                if(k1 == 0)
                    s10 = " <a href=DealWithCenter.jsp?action=show_out&Pid=" + j1 + "><font color=red>推介</font></a>";
                else
                    s10 = " <a href=DealWithCenter.jsp?action=unshow_out&Pid=" + j1 + ">还原</a>";
                String s11;
                if(l1 == 0)
                    s11 = " <a href=DealWithCenter.jsp?action=mark_absence&Pid=" + j1 + "><font color=black>缺货</font></a>";
                else
                    s11 = " <a href=DealWithCenter.jsp?action=unmark_absence&Pid=" + j1 + ">有货</a>";
                String s12;
                if(i2 == 0)
                    s12 = "[<a href=DealWithCenter.jsp?action=importanceshow&Pid=" + j1 + ">重点推荐</a>]";