managergbook.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:   ManagerGbook.java

package myshop.gbook_sys;

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

public class ManagerGbook
{

    Handle handle;
    DBconn dbconn;

    public ManagerGbook()
        throws Exception
    {
        dbconn = new DBconn();
        handle = new Handle();
    }

    public void AddWords(String s, HttpServletRequest httpservletrequest)
        throws Exception
    {
        String s1 = handle.GBK2ISO(httpservletrequest.getParameter("author"));
        String s2 = handle.GBK2ISO(httpservletrequest.getParameter("content"));
        int i = handle.getInt(httpservletrequest, "Pid");
        int j = handle.getInt(httpservletrequest, "level");
        String s3 = "INSERT INTO " + s + "(product_id,author,content,level,date_time) VALUES(" + i + ",'" + s1 + "','" + s2 + "'," + j + ",sysdate())";
        dbconn.ExeUpdate(s3);
        dbconn.CloseConn();
    }

    public void DelWord(String s, HttpServletRequest httpservletrequest)
        throws Exception
    {
        int i = handle.getInt(httpservletrequest, "Gid");
        if(i != 0)
        {
            String s1 = "DELETE FROM " + s + " WHERE id=" + i;
            dbconn.ExeUpdate(s1);
            dbconn.CloseConn();
        }
    }

    public String Id2Name(String s, int i)
        throws Exception
    {
        String s2 = "";
        try
        {
            String s1 = "SELECT * FROM " + s + " WHERE id=" + i;
            ResultSet resultset = dbconn.ExeQuery(s1);
            resultset.next();
            s2 = resultset.getString("name");
            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return s2;
    }

    public String Num2Star(int i)
    {
        String s = "";
        for(int j = 0; j < i; j++)
            s = s + "★";

        return s;
    }

    public Hashtable ReadDataAdmin(String s, int i, String s1, String s2, String s3, String s4, String s5)
        throws Exception
    {
        String s7 = "";
        int j = 0;
        float f = 0.0F;
        boolean flag = false;
        Hashtable hashtable = new Hashtable();
        Hashtable hashtable1 = new Hashtable();
        try
        {
            s2 = handle.GBK2ISO(s2);
            String s6;
            if(s3.equals("author"))
                s6 = "SELECT * FROM " + s4 + " WHERE author LIKE '%" + s2 + "%' ORDER BY id DESC";
            else
            if(s3.equals("content"))
                s6 = "SELECT * FROM " + s4 + " WHERE content LIKE '%" + s2 + "%' ORDER BY id DESC";
            else
                s6 = "SELECT * FROM " + s4 + " ORDER BY id DESC";
            ResultSet resultset = dbconn.ExeQuery(s6);
            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");
                String s9;
                if(f / 2.0F == (float)(int)(f / 2.0F))
                    s9 = "f1f1f1";
                else
                    s9 = "ffffff";
                s7 = s7 + "  <tr align=center valign=middle bgcolor=" + s9 + "> ";
                s7 = s7 + "    <td>" + (int)f + "-" + j1 + "</td>";
                s7 = s7 + "    <td>" + resultset.getString("author") + "</td>";
                s7 = s7 + "    <td>" + resultset.getString("content") + "</td>";
                s7 = s7 + "    <td><font color=red>" + Num2Star(resultset.getInt("level")) + "</font></td>";
                s7 = s7 + "    <td>" + Id2Name(s5, resultset.getInt("product_id")) + "</td>";
                s7 = s7 + "    <td>" + resultset.getString("date_time") + "</td>";
                s7 = s7 + "    <td><a href=Control.jsp?action=del&Gid=" + j1 + " onclick=\"return (AlertDel('" + resultset.getString("author") + "'));\"><font color=red>删除</font></a></td>";
                s7 = s7 + "  </tr>";
                if(!resultset.next())
                    break;
            }

            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        String s8 = search_turn(hashtable, s1, s2, s3);
        hashtable1.put("RecordCount", String.valueOf(j));
        hashtable1.put("HtmlStr", s7);
        hashtable1.put("TurpageStr", s8);
        return hashtable1;
    }

    public String ShowWords(String s, HttpServletRequest httpservletrequest, int i)
        throws Exception
    {
        String s2 = "";
        int j = 0;
        int k = handle.getInt(httpservletrequest, "Pid");
        try
        {
            String s1 = "SELECT * FROM " + s + " WHERE product_id=" + k + " ORDER BY id DESC";
            for(ResultSet resultset = dbconn.ExeQuery(s1); resultset.next();)
            {
                j++;
                s2 = s2 + "<table width=100% border=0 cellspacing=1 cellpadding=3>";
                s2 = s2 + "\t<tr bgcolor=#FFFFFF> ";
                s2 = s2 + "\t\t<td width=4% align=center valign=middle>" + j + "</td>";
                s2 = s2 + "\t\t<td width=8% align=center bgcolor=eeeeee>作者：</td>";
                s2 = s2 + "\t\t<td width=29%>" + resultset.getString("author") + "</td>";
                s2 = s2 + "\t\t<td width=13% align=center valign=middle bgcolor=eeeeee>发表时间：</td>";
                s2 = s2 + "\t\t<td width=24% align=center valign=middle>" + resultset.getString("date_time") + "</td>";
                s2 = s2 + "\t\t<td width=8% align=center valign=middle bgcolor=eeeeee>评分：</td>";
                s2 = s2 + "\t\t<td width=14% align=center valign=middle><font color=#FF0000>" + Num2Star(resultset.getInt("level")) + "</font></td>";
                s2 = s2 + "\t</tr>";
                s2 = s2 + "\t<tr bgcolor=#FFFFFF> ";
                s2 = s2 + "\t\t<td colspan=7>评论：" + resultset.getString("content") + "</td>";
                s2 = s2 + "\t</tr>";
                s2 = s2 + "</table>";
                if(j == i)
                    break;
            }

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

    public String search_turn(Hashtable hashtable, String s, String s1, String s2)
        throws Exception
    {
        String s3 = "";
        int k = Integer.parseInt(String.valueOf(hashtable.get("nextpage")));
        int l = Integer.parseInt(String.valueOf(hashtable.get("prevpage")));
        int i1 = Integer.parseInt(String.valueOf(hashtable.get("pagesize")));
        int j1 = Integer.parseInt(String.valueOf(hashtable.get("pagecount")));
        int k1 = Integer.parseInt(String.valueOf(hashtable.get("pagecount2")));
        int l1 = Integer.parseInt(String.valueOf(hashtable.get("page1")));
        int i2 = Integer.parseInt(String.valueOf(hashtable.get("page2")));
        s1 = handle.ISO2GBK(s1);
        s3 = s3 + "<form name=form1 method=post action=" + s + ">";
        s3 = s3 + "<table width=100% border=0 cellspacing=0 cellpadding=0 align=center>";
        s3 = s3 + "  <tr> ";
        s3 = s3 + "    <td bgcolor=#999999> ";
        s3 = s3 + "    <table width=100% border=0 cellspacing=1 cellpadding=3>";
        s3 = s3 + "  <tr bgcolor=f1f1f1>";
        s3 = s3 + "\t  <td align=center valign=middle width=50%>关键词： ";
        s3 = s3 + "      <input type=text name=keywords value=" + s1 + ">";
        s3 = s3 + " ";
        s3 = s3 + "<select name=type>";
        s3 = s3 + "  <option selected>选择类别</option>";
        s3 = s3 + "  <option value=author>作 者</option>";
        s3 = s3 + "  <option value=content>评 价</option>";
        s3 = s3 + "</select>";
        s3 = s3 + "      <input type=submit name=Submit value=搜索>";
        s3 = s3 + "    </td>";
        s3 = s3 + "\t  <td align=center valign=middle width=50%>";
        s3 = s3 + "      <table><tr><td align=center valign=middle width=30%>";
        s3 = s3 + "        <SELECT onchange=\"var jmpURL1=this.options[this.selectedIndex].value; if(jmpURL1!='') {self.location=jmpURL1;} else {this.selectedIndex=0;}\" size=1 name=select>";
        s3 = s3 + "          <option value=''>选择翻页</option>";
        for(int i = 0; i < j1; i++)
        {
            int j = i + 1;
            s3 = s3 + "         <option value=" + s + "?CurrentPage=" + i + "&keywords=" + s1 + "&type=" + s2 + ">第 " + j + " 页</option>";
        }

        s3 = s3 + "        </select>";
        s3 = s3 + "     </td>";
        s3 = s3 + "     <td align=center valign=middle width=20%>";
        s3 = s3 + "       当前页：" + i2 + "/" + j1;
        s3 = s3 + "      </td>";
        s3 = s3 + "     <td align=center valign=middle width=40% style='font-family:Webdings'>";
        if(j1 != 0)
            s3 = s3 + "<a href=" + s + "?CurrentPage=0&keywords=" + s1 + "&type=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">7</a>&nbsp;&nbsp;";
        else
            s3 = s3 + "7&nbsp;&nbsp;";
        if(l1 != 0)
            s3 = s3 + "<a href=" + s + "?CurrentPage=" + l + "&keywords=" + s1 + "&type=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">3</a>";
        else
            s3 = s3 + "3";
        if(l1 != k1 && j1 != 0)
            s3 = s3 + "&nbsp;&nbsp;&nbsp;&nbsp;<a href=" + s + "?CurrentPage=" + k + "&keywords=" + s1 + "&type=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">4</a>&nbsp;&nbsp;";
        else
            s3 = s3 + "&nbsp;&nbsp;&nbsp;&nbsp;4&nbsp;&nbsp;";
        int j2 = j1 - 1;
        if(j1 != 0)
            s3 = s3 + "<a href=" + s + "?CurrentPage=" + j2 + "&keywords=" + s1 + "&type=" + s2 + " onMouseOver=\"this.style.color='red'\" onMouseOut=\"this.style.color='black'\">8</a>";
        else
            s3 = s3 + "8";
        s3 = s3 + "</td></tr></table>";
        s3 = s3 + "\t  </td>";
        s3 = s3 + "        </tr>";
        s3 = s3 + "      </table>";
        s3 = s3 + "    </td>";
        s3 = s3 + "  </tr>";
        s3 = s3 + "</table>";
        return s3;
    }

    public Hashtable turn_page(String s, int i, int j)
    {
        int i1 = 0;
        Hashtable hashtable = new Hashtable();
        if(!s.equals(""))
            i1 = Integer.parseInt(s);
        int k = j / i;
        if(i * k < j)
            k++;
        if(Integer.parseInt(s) > k)
            i1 = k - 1;
        else
        if(Integer.parseInt(s) < 0)
            i1 = 0;
        int l = k - 1;
        int j1 = i1 + 1;
        int k1 = i1 * i;
        int l1 = k1 + i;
        int i2 = i1 + 1;
        int j2 = i1 - 1;
        hashtable.put("pt_st", new Integer(k1));
        hashtable.put("pt_en", new Integer(l1));
        hashtable.put("nextpage", new Integer(i2));
        hashtable.put("prevpage", new Integer(j2));
        hashtable.put("pagesize", new Integer(i));
        hashtable.put("pagecount", new Integer(k));
        hashtable.put("pagecount2", new Integer(l));
        hashtable.put("page1", new Integer(i1));
        hashtable.put("page2", new Integer(j1));
        return hashtable;
    }
}