membermanager.java

用jsp,java写的在线购物系统

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

package mediastore.user;

import java.sql.*;
import java.util.ArrayList;
import java.util.List;
import mediastore.common.DBConnection;
import mediastore.dao.GoodsExportGoods;
import mediastore.web.form.MemberInfo;

public class MemberManager
{

    private String strError;

    public MemberManager()
    {
        strError = "";
    }

    public int getTotalMemberNum()
    {
        int nRet;
        nRet = 0;
        DBConnection dbc = null;
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String strSQL = null;
        try
        {
            dbc = new DBConnection();
            conn = dbc.getDBConnection();
            stmt = conn.createStatement();
            strSQL = "SELECT count(*) FROM TabMemberInfo;";
            rs = stmt.executeQuery(strSQL);
            if(!rs.next())
            {
                nRet = -1;
                throw new Exception("获得系统会员总数失败");
            }
            nRet = rs.getInt(1);
            rs.close();
            rs = null;
        }
        catch(Exception exception) { }
        finally
        {
            try
            {
                if(rs != null)
                    rs.close();
                if(stmt != null)
                    stmt.close();
                if(conn != null)
                    dbc.closeDBConnection(conn);
            }
            catch(SQLException e) { }
        }
        return nRet;
    }

    public List getMemberInfoByMemberId(int memberId)
    {
        List oneMember;
        int nRet = 0;
        DBConnection dbc = null;
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String strSQL = null;
        oneMember = new ArrayList();
        try
        {
            dbc = new DBConnection();
            conn = dbc.getDBConnection();
            stmt = conn.createStatement();
            strSQL = "SELECT * FROM TabMemberInfo WHERE MemberId=" + memberId;
            rs = stmt.executeQuery(strSQL);
            if(rs.next())
            {
                MemberInfo mi = new MemberInfo();
                mi.setMemberId(memberId);
                mi.setMemberName(rs.getString("MemberName"));
                mi.setDiscount(rs.getFloat("Discount"));
                mi.setCreateTime(rs.getString("CreateTime"));
                GoodsExportGoods geg = new GoodsExportGoods();
                mi.setTotalPayment(geg.getTotalPaymentByMemberId(memberId));
                String tmpTime = geg.getRecentBuyTimeOfMember(memberId);
                if(tmpTime == null)
                    tmpTime = "";
                mi.setRecentBuyTime(tmpTime);
                oneMember.add(mi);
            }
            rs.close();
            rs = null;
        }
        catch(Exception exception) { }
        finally
        {
            try
            {
                if(rs != null)
                    rs.close();
                if(stmt != null)
                    stmt.close();
                if(conn != null)
                    dbc.closeDBConnection(conn);
            }
            catch(SQLException e) { }
        }
        return oneMember;
    }

    public List getMemberList(String orderField)
    {
        List memberList;
        memberList = new ArrayList();
        DBConnection dbc = null;
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        String strSQL = null;
        try
        {
            dbc = new DBConnection();
            conn = dbc.getDBConnection();
            stmt = conn.createStatement();
            strSQL = "SELECT * FROM TabMemberInfo Order by " + orderField;
            MemberInfo mi;
            for(rs = stmt.executeQuery(strSQL); rs.next(); memberList.add(mi))
            {
                mi = new MemberInfo();
                mi.setMemberId(rs.getInt("MemberId"));
                mi.setMemberName(rs.getString("MemberName"));
                mi.setDiscount(rs.getFloat("Discount"));
                mi.setCreateTime(rs.getString("CreateTime"));
                GoodsExportGoods geg = new GoodsExportGoods();
                mi.setTotalPayment(geg.getTotalPaymentByMemberId(rs.getInt("MemberId")));
                String tmpTime = geg.getRecentBuyTimeOfMember(rs.getInt("MemberId"));
                if(tmpTime == null)
                    tmpTime = "";
                mi.setRecentBuyTime(tmpTime);
            }

            rs.close();
            rs = null;
        }
        catch(Exception exception) { }
        finally
        {
            try
            {
                if(rs != null)
                    rs.close();
                if(stmt != null)
                    stmt.close();
                if(conn != null)
                    dbc.closeDBConnection(conn);
            }
            catch(SQLException e) { }
        }
        return memberList;
    }
}