managermember.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:   ManagerMember.java

package myshop.member_sys;

import java.io.PrintStream;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.*;
import javax.servlet.ServletRequest;
import javax.servlet.http.*;
import myshop.*;

// Referenced classes of package myshop.member_sys:
//            administratorBean

public class ManagerMember
{

    Handle handle;
    DBconn dbconn;
    Md5 md5;

    public ManagerMember()
        throws Exception
    {
        dbconn = new DBconn();
        handle = new Handle();
        md5 = new Md5();
    }

    public String CheckAccount(String s, HttpServletRequest httpservletrequest)
        throws Exception
    {
        String s2 = "";
        String s3 = handle.getString(httpservletrequest, "account");
        try
        {
            String s1 = "SELECT * FROM " + s + " WHERE account='" + s3 + "'";
            ResultSet resultset = dbconn.ExeQuery(s1);
            if(!resultset.next())
                s2 = "恭喜！！该帐号还没有人使用。";
            else
                s2 = "不好意思，该帐号已经存在！";
            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        return s2;
    }

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

    public void Login(String s, HttpServletRequest httpservletrequest, HttpSession httpsession)
        throws Exception
    {
        String s1 = "";
        String s4 = handle.getString(httpservletrequest, "account");
        String s5 = handle.getString(httpservletrequest, "pwd");
        s4 = handle.GBK2ISO(s4);
        s5 = handle.GBK2ISO(s5);
        s5 = md5.getMD5ofStr(s5);
        try
        {
            String s2 = "SELECT * FROM " + s + " WHERE account='" + s4 + "' AND pwd='" + s5 + "'";
            ResultSet resultset = dbconn.ExeQuery(s2);
            if(resultset.next())
            {
                httpsession.putValue("LoginUser", s4);
                String s3 = "UPDATE " + s + " SET log_times=log_times+1 WHERE account='" + s4 + "'";
                dbconn.ExeUpdate(s3);
            }
            dbconn.CloseConn();
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
    }

    public String LoginORInfo(String s, HttpServletRequest httpservletrequest, HttpSession httpsession)
        throws Exception
    {
        String s1 = "";
        String s2 = "";
        String s3 = "";
        String s5 = "";
        int i = 0;
        int j = 0;
        for(Enumeration enumeration = httpservletrequest.getParameterNames(); enumeration.hasMoreElements();)
        {
            String s7 = (String)enumeration.nextElement();
            s2 = s2 + s7 + "=" + httpservletrequest.getParameter(s7) + "&";
        }

        s2 = "?" + s2;
        if(httpsession.getValue("LoginUser") == null)
        {
            s1 = s1 + "  <form name=form3 method=post action=admin/member_sys/DealWithCenter.jsp?action=login&reference=../../.." + httpservletrequest.getServletPath() + s2 + ">";
            s1 = s1 + "<table width='100%' border='0' cellspacing='0' cellpadding='0'>";
            s1 = s1 + "          <tr> ";
            s1 = s1 + "            <td class='line234'><table width=100% height=138 border=0 cellpadding=0 cellspacing=0>";
            s1 = s1 + "                <tr> ";
            s1 = s1 + "                  <td height=20 colspan=2 align=center valign=middle><table width='100%' height='22' border='0' cellpadding='0' cellspacing='0'>";
            s1 = s1 + "                      <tr> ";
            s1 = s1 + "                        <td align='center' valign='middle' background='" + handle.SystemURL + "img/top_bg2.jpg'><font color=#FFFFFF>会 ";
            s1 = s1 + "                          员 登 陆</font></td>";
            s1 = s1 + "                      </tr>";
            s1 = s1 + "                    </table></td>";
            s1 = s1 + "                </tr>";
            s1 = s1 + "                <tr> ";
            s1 = s1 + "                  <td width=31% height='41' align=center valign=middle bgcolor='eeeeee'>帐号</td>";
            s1 = s1 + "                  <td width=69% align=center valign=middle bgcolor='eeeeee'><input name=account type=text size=15></td>";
            s1 = s1 + "                </tr>";
            s1 = s1 + "                <tr> ";
            s1 = s1 + "                  <td width=31% height='41' align=center valign=middle bgcolor='eeeeee'>密码</td>";
            s1 = s1 + "                  <td align=center valign=middle bgcolor='eeeeee'><input name=pwd size=15 type=password></td>";
            s1 = s1 + "                </tr>";
            s1 = s1 + "                <tr> ";
            s1 = s1 + "                  <td colspan=2 align=center valign=middle bgcolor='eeeeee'><input type=submit name=Submit2 value=登陆> ";
            s1 = s1 + "                    <input type=button name=Submit value=注册 onClick=location='admin/member_sys/regedit.jsp'> ";
            s1 = s1 + "                  </td>";
            s1 = s1 + "                </tr>";
            s1 = s1 + "                <tr align='right'> ";
            s1 = s1 + "                  <td colspan=2 valign=middle bgcolor='eeeeee'><br>";
            s1 = s1 + "                    <img src='" + handle.SystemURL + "img/buttom_line.gif' width='158' height='22'></td>";
            s1 = s1 + "                </tr>";
            s1 = s1 + "              </table></td>";
            s1 = s1 + "          </tr>";
            s1 = s1 + "</table>";
            s1 = s1 + "  </form>";
        } else
        {
            String s4 = (String)httpsession.getValue("LoginUser");
            s4 = handle.GBK2ISO(s4);
            try
            {
                String s6 = "SELECT * FROM " + s + " WHERE account='" + s4 + "'";
                ResultSet resultset = dbconn.ExeQuery(s6);
                resultset.next();
                j = resultset.getInt("log_times");
                dbconn.CloseConn();
            }
            catch(SQLException sqlexception)
            {
                System.err.println("aq.executeQuery:" + sqlexception.getMessage());
            }
            if(httpsession.getValue("Car") != null)
            {
                Vector vector = (Vector)httpsession.getValue("Car");
                i = vector.size();
            }
            s1 = s1 + "<table width=100% border=0 cellspacing=0 cellpadding=0>";
            s1 = s1 + "  <tr> ";
            s1 = s1 + "    <td align=center valign=top class=line234><table width=100% height=122 border=0 cellpadding=3 cellspacing=1>";
            s1 = s1 + "        <tr> ";
            s1 = s1 + "          <td height=20 colspan=2 align=center valign=middle background=" + handle.SystemURL + "img/top_bg2.jpg><font color=#FFFFFF>你 ";
            s1 = s1 + "            的 信 息</font></td>";
            s1 = s1 + "        </tr>";
            s1 = s1 + "        <tr> ";
            s1 = s1 + "          <td width=50% align=center valign=middle bgcolor=eeeeee>帐号：</td>";
            s1 = s1 + "          <td width=50% align=center valign=middle bgcolor=eeeeee>" + s4 + "</td>";
            s1 = s1 + "        </tr>";
            s1 = s1 + "        <tr> ";
            s1 = s1 + "          <td align=center valign=middle bgcolor=eeeeee>购物车：</td>";
            s1 = s1 + "          <td align=center valign=middle bgcolor=eeeeee>" + i + "</td>";
            s1 = s1 + "        </tr>";
            s1 = s1 + "        <tr> ";
            s1 = s1 + "          <td align=center valign=middle bgcolor=eeeeee>登陆：</td>";
            s1 = s1 + "          <td align=center valign=middle bgcolor=eeeeee>" + j + "</td>";
            s1 = s1 + "        </tr>";
            s1 = s1 + "        <tr> ";
            s1 = s1 + "          <td colspan=2 align=center valign=middle bgcolor=eeeeee><a href=admin/member_sys/modify.jsp>修改资料</a> <a href=admin/purchase_sys/my_order.jsp>查询订单</a></td>";
            s1 = s1 + "        </tr>";
            s1 = s1 + "      </table></td>";
            s1 = s1 + "  </tr>";
            s1 = s1 + "</table>";
        }
        return s1;
    }

    public Hashtable ReadData(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("address"))
                s5 = "SELECT * FROM " + s4 + " WHERE address 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");
                String s8;
                if(f / 2.0F == (float)(int)(f / 2.0F))
                    s8 = "f1f1f1";
                else
                    s8 = "ffffff";
                s6 = s6 + "  <tr align=center valign=middle bgcolor=" + s8 + "> ";
                s6 = s6 + "    <td>" + (int)f + "-" + j1 + "</td>";
                s6 = s6 + "    <td>" + resultset.getString("account") + "</td>";
                s6 = s6 + "    <td>" + resultset.getString("name") + "</td>";
                s6 = s6 + "    <td>" + resultset.getInt("sex") + "</td>";
                s6 = s6 + "    <td>" + resultset.getInt("age") + "</td>";
                s6 = s6 + "    <td>" + resultset.getString("tel") + "</td>";
                s6 = s6 + "    <td>" + resultset.getString("address") + "</td>";
                s6 = s6 + "    <td>" + resultset.getString("email") + "</td>";
                s6 = s6 + "    <td>" + resultset.getString("date_time") + "</td>";
                s6 = s6 + "    <td><a href=DealWithCenter.jsp?action=del&Mid=" + j1 + " onclick=\"return (AlertDel('" + resultset.getString("name") + "'));\"><font color=red>删除</font></a></td>";
                s6 = s6 + "  </tr>";
                if(!resultset.next())
                    break;
            }

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

    public String Regedit(String s, HttpServletRequest httpservletrequest, HttpSession httpsession)
        throws Exception
    {
        String s3 = "";
        String s4 = handle.getString(httpservletrequest, "account");
        String s5 = handle.getString(httpservletrequest, "pwd");
        String s6 = handle.getString(httpservletrequest, "name");
        String s7 = handle.getString(httpservletrequest, "tel");
        String s8 = handle.getString(httpservletrequest, "address");
        String s9 = handle.getString(httpservletrequest, "email");
        int i = handle.getInt(httpservletrequest, "age");
        int j = handle.getInt(httpservletrequest, "sex");
        s5 = handle.GBK2ISO(s5);
        s5 = md5.getMD5ofStr(s5);
        s6 = handle.GBK2ISO(s6);
        s7 = handle.GBK2ISO(s7);
        s8 = handle.GBK2ISO(s8);
        s9 = handle.GBK2ISO(s9);
        try
        {
            String s1 = "SELECT * FROM " + s + " WHERE name='" + s6 + "'";
            ResultSet resultset = dbconn.ExeQuery(s1);
            if(resultset.next())
                s3 = "帐号已经存在！<br>[<a href=javascript:history.back()>返回</a>]";
        }
        catch(SQLException sqlexception)
        {
            System.err.println("aq.executeQuery:" + sqlexception.getMessage());
        }
        if(!s3.equals(""))
        {
            return s3;
        } else
        {
            String s2 = "INSERT INTO " + s + "(account,pwd,name,age,sex,address,tel,email,date_time) VALUES('" + s4 + "','" + s5 + "','" + s6 + "'," + i + "," + j + ",'" + s8 + "','" + s7 + "','" + s9 + "',sysdate())";