帮帮我啊   我 不 怎么会 JSP啊  谢谢大家了!

解决方案 »

  1.   

    这是我的类文件 YDRegAdInfo.asp  大家帮我看下
    <%function YDRegAdInfo(YDIndex){
    this.YDIndex=YDIndex;
    this.getProperties=YDRegAdInfo_getProperties;
    this.dele=YDRegAdInfo_dele;
    this.Confirm=YDRegAdInfo_Confirm;
    }
    function YDRegAdInfo_getProperties(){
    var rs=new ActiveXObject("Adodb.Recordset");
    rs.open("select YDRegAdInfo.UserIndex,YDRegAdInfo.AdIndex,YDRegAdInfo.UserAnswer,YDRegAdInfo.UserAnwserDate,YDRegAdInfo.AdminAnswer,YDRegAdInfo.AdminAnswerTime,YDRegAdInfo.Status,YDMember.UserName,YDRegAd.ADName,cstr(YDRegAd.Cash),cstr(YDMember.Cash),YDRegAdInfo.IP from YDRegAdInfo,YDRegAD,YDMember  where YDRegAdInfo.UserIndex=YDMember.YDIndex and YDRegAdInfo.ADIndex=YDRegAD.YDIndex and YDRegAdInfo.YDIndex="+this.YDIndex,conn,2,2);
    this.UserAnswer=rs(2).value;
    this.UserAnwserDate=rs(3).value;
    this.AdminAnswer=rs(4).value;
    this.AdminAnswerTime=rs(5).value;
    this.Status=rs(6).value;
    this.Ad=new YDRegAd(rs(1).value);
    this.Member=new YDMember(rs(0).value);
    this.Member.UserName=String(rs(7).value);
    this.Ad.ADName=String(rs(8).value);
    this.Ad.Cash=parseFloat(rs(9).value);
    this.Member.Cash=parseFloat(rs(10).value);
    this.IP=String(rs(11).value);
    rs.close();
    }function YDRegAdInfo_dele(){
    conn.execute("delete from YDRegAdInfo where YDIndex="+this.YDIndex);
    }function YDRegAdInfo_Confirm(AdminAnswer,Status){
    this.AdminAnswer=AdminAnswer;
    this.AdminAnswerTime=new Date();
    this.Status=Status;
    conn.execute("update YDRegAdInfo set AdminAnswer=\'"+AdminAnswer.replace(/\'/g,"''")+"\',AdminAnswerTime=now,Status="+Status+" where YDIndex="+this.YDIndex);
    }
    function YDRegAdInfo_Add(PUser,Ad,UserAnswer,IP){
    conn.execute("insert into YDRegAdInfo(UserIndex,AdIndex,UserAnswer,UserAnwserDate,Status,IP)values("+PUser.YDIndex+","+Ad.YDIndex+",\'"+UserAnswer.replace(/'/g,"''")+"\',now,0,\'"+IP+"\')");
    }
    YDRegAdInfo.Add=YDRegAdInfo_Add;
    function YDRegAdInfo_List(Condition){
    var AdInfos=new Array();
    var rs=new ActiveXObject("Adodb.Recordset");
    rs.open("select YDRegAdInfo.YDIndex,YDRegAdInfo.UserIndex,YDRegAdInfo.AdIndex,YDRegAdInfo.UserAnswer,YDRegAdInfo.UserAnwserDate,YDRegAdInfo.AdminAnswer,YDRegAdInfo.AdminAnswerTime,YDRegAdInfo.Status,YDMember.UserName,YDRegAd.ADName,cstr(YDRegAd.Cash),YDRegAdInfo.IP from YDRegAdInfo,YDMember,YDRegAd where YDRegAdInfo.AdIndex=YDRegAd.YDIndex and YDRegAdInfo.UserIndex=YDMember.YDIndex"+((Condition!=null)?(" and "+Condition):""),conn,2,2);
    var iCounter=0;
    while(!rs.eof){
    AdInfos[iCounter]=new YDRegAdInfo(rs(0).value);
    AdInfos[iCounter].UserAnswer=String(rs(3).value);
    AdInfos[iCounter].UserAnwserDate=new Date(rs(4).value);
    AdInfos[iCounter].AdminAnswer=String(rs(5).value);
    AdInfos[iCounter].AdminAnswerTime=new Date(rs(6).value);
    AdInfos[iCounter].Status=parseInt(rs(7).value);
    AdInfos[iCounter].Member=new YDMember(rs(1).value)
    AdInfos[iCounter].Ad=new YDRegAd(rs(2).value)
    AdInfos[iCounter].Member.UserName=String(rs(8).value);
    AdInfos[iCounter].Ad.ADName=String(rs(9).value);
    AdInfos[iCounter].Ad.Cash=parseFloat(rs(10).value);
    AdInfos[iCounter].IP=String(rs(11).value);
    rs.movenext();
    iCounter++;
    }
    rs.close();
    return AdInfos;
    }
    YDRegAdInfo.List=YDRegAdInfo_List;function YDRegAdInfo_Count(Condition){
    var AdInfos=new Array();
    var rs=new ActiveXObject("Adodb.Recordset");
    rs.open("select count(*) from YDRegAdInfo,YDMember,YDRegAd where YDRegAdInfo.AdIndex=YDRegAd.YDIndex and YDRegAdInfo.UserIndex=YDMember.YDIndex"+((Condition!=null)?(" and "+Condition):""),conn,2,2);
    var retVal=rs(0).value;
    rs.close();
    return retVal;
    }
    YDRegAdInfo.Count=YDRegAdInfo_Count;
    %>
      

  2.   

    我好不容易 找到个JSP论坛  大家帮帮我啊!