asp批量删除一张表的数据后,如何对另一张表的数据进行修改

jiaxinhu517 2007-12-02 11:01:34

我的批量删除代码是:

[code=C#]<%

if request("action")="" then

dim i,thisUrl

dim page,maxPerPage,myKeyword

maxPerPage=80 '每页显示的记录数

myKeyword=Request("myKeyword")

page=Request("page")

if (page="" or isempty(page)) then page=1

thisUrl="admin_j_gbook.asp?action="

session("adminOldUrl")=thisUrl&"&page="&page

set rs=server.createobject("adodb.recordset")

sql="select * from j_gbook where 1=1"

if not (myKeyword="" or isempty(myKeyword) ) then

	sql=sql&" and (title like '%"&myKeyword&"%' or content like '%"&myKeyword&"%')"

end if

sql=sql&" order by gb_id desc"

'response.write sql

'response.End

rs.open sql,conn,1,1

rs.pagesize=MaxPerPage

%>

<script language="JavaScript">

function del ()

{

　　var flag=true;

　　var temp="";

　　var tmp;

　　if((document.form1.answer.length+"")=="undefined")

    {

        tmp=1

    }

    else

    {

        tmp=document.form1.answer.length;

    }

　　if (tmp==1)

    {

　　    if (document.form1.answer.checked)

        {

　　        flag=false;

　　        temp=document.form1.answer.value;

　　    }

　　}

    else

    {

　　        for (i=0;i<document.form1.answer.length;i++)

            {

　　             if (document.form1.answer[i].checked)

                 {

　　                 if (temp=="")

                     {

　　                     flag=false;

　　                     temp=document.form1.answer[i].value;

　　                 }

                     else

                     {

　　                     flag=false;

　　                     temp = temp +","+ document.form1.answer[i].value;

　　                 }

　             　}

　        　 }

　　 }

　　if (flag)

    {

        alert("对不起，你还没有选择！")

    }

　　else

    { 

        name=document.form1.name.value;

　　//alert(name)

　　    if (confirm("确实要删除？"))

        {

　   　     window.location="delete.asp?gb_id=" + temp;

　　    }

　　}

　　return !flag;

}

</script>

<script language=Javascript>

function checkall(all)//用于判断全选记录的函数

{

　　var a = document.getElementsByName("answer");

　　for (var i=0; i<a.length; i++) a[i].checked = all.checked;

}

</script>

<script language=Javascript>

<!--

function jumpTo(i){

if(i==1){

	this.document.location="<%=thisUrl%>";}

if(i==2){

	this.document.location="<%=thisUrl%>&page=<%=page-1%>";}

if(i==3){

	this.document.location="<%=thisUrl%>&page=<%=page+1%>";}

if(i==4){

	this.document.location="<%=thisUrl%>&page=<%=rs.pageCount%>";}

}

//-->

</script>



<script language="JavaScript">

<!--

function MM_reloadPage(init) {  //reloads the window if Nav4 resized

  if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {

    document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}

  else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();

}

MM_reloadPage(true);



function jumpTo(i){

if(i==1){

	this.document.location="<%=thisUrl%>";}

if(i==2){

	this.document.location="<%=thisUrl%>&page=<%=page-1%>";}

if(i==3){

	this.document.location="<%=thisUrl%>&page=<%=page+1%>";}

if(i==4){

	this.document.location="<%=thisUrl%>&page=<%=rs.pageCount%>";}

}

//-->

</script>

</head>

<body bgcolor="#9CC7EF" text="#000000" leftmargin="0" topmargin="0">

<div align="center"><br>

</div>

<TABLE class=tableBorder cellSpacing=1 cellPadding=2 width="95%" align=center 

border=0>

<form method="POST" id=form1 name=form1>

  <TBODY>

    <TR>

      <TH align=left height=23>打分管理</TH>

    </TR>

    <TR>

      <TD><table width="100%" border="0" align="center" cellpadding="4" cellspacing="1">

        

        <tr bgcolor="#E4EDF9">

          <td width="6%" align="center" nowrap >管理</td>

          <td width="12%" nowrap>

            <div align="center"> 编号</div></td>

          <td width="8%" nowrap >

            <div align="center">打分人</div></td>

          <td width="19%" nowrap>

            <div align="center">链接地址</div></td>

          <td width="26%" nowrap >

            <div align="center">留言</div></td>   

          <td width="6%" nowrap>

            <div align="center">打分</div></td>

          <td width="10%" nowrap>

            <div align="center">日期</div></td>

          <td width="7%" nowrap>对方</td>

          

        </tr>

        <%

		dim rsID

		i=1

		if not (rs.eof or err) then rs.move (page-1)*maxPerPage

		do while not (rs.eof or err) 

		rsID=rs("gb_id")

%>

        <tr bgcolor="#F1F3F5">

           <td align="center"><input type="checkbox" name="answer" value="<%=rs("gb_id")%>" id="checkbox1"></td>

          <td>

            <div align="center"><%=rs("gb_id")%></div></td>

          <td nowrap bgcolor="#F1F3F5" ><a href="admin_user.asp?action=modify&userid=<%=rs("gb_userid")%>"><%=rs("gb_username")%></a></td>

          <td nowrap ><a href="<%=rs("gb_http")%>" target='_blank'><%=rs("gb_http")%></a></td>

          <td nowrap><%=rs("gb_content")%></td>

          <td align="center" nowrap><%=rs("gb_num")%></td>

          <td nowrap><%=rs("gb_addtime")%></td>

          <td nowrap ><a href="admin_user.asp?action=modify&userid=<%=rs("gb_to_userid")%>"><%=rs("gb_to_username")%></a></td>

	     

	    </tr>

        <%

		i=i+1

		if i>maxPerPage then exit do

		rs.moveNext

		loop

%>

     <tr>

　　       <td>

                 <input type="checkbox" name="chkall" value="on" onclick="checkall(this)" ID="Checkbox2">全选</td>　　　　　  

　　       <td>

                 <input type="button" name="btnDelete" value="删除" onclick="del(<%=rs("gb_id")%>)" ID="Button1"></td>

           <td colspan="8">

              <div align="right">				

                <a href="admin_j_gbook.asp">首页</a>

                <a href="admin_j_gbook.asp?page=<%=page-1%>">上页</a>

                <a href="admin_j_gbook.asp?page=<%=page+1%>">下页</a>

                <a href="admin_j_gbook.asp?page=<%=rs.pagecount%>">末页</a>

                <%=page%>/<%=rs.pagecount%>页

                <input type="text" name="GoPage" size="2" onkeyup="if(isNaN(this.value))this.value='<%=Page%>'" value="<%=Page%>">

                <input type="button" name="Go" value="go" onclick="go()"> 

<script language="javascript">

<!--

function go(){

page=document.all.GoPage.value;

window.open ("?page="+page,"_self");

}

//-->

</script>



	

              </div>

          </td>

        </tr>

      </table>

      </TD>

    </TR>

   </TBODY>

  </form>

  </TABLE>

我的删除代码是:
<%
dim conn
set conn=Server.CreateObject("ADODB.Connection")
conn.open "driver={SQL Server};database=dvcs121;Server=(local);uid=sa;pwd=13391220222"
gb_id=trim(request.querystring("gb_id"))
sql="delete from j_gbook where gb_id in ("&request.querystring("gb_id")&")"
conn.Execute sql
conn.close
set conn=nothing
response.write"<SCRIPT language=JavaScript>alert('删除成功！');"
response.write"javascript: history.go(-1)</SCRIPT>"
response.write"this.location.href='admin_j_gbook.asp';</SCRIPT>"
response.end
%>

我怎么做才能在批量删除后更新Dv_User表中的两个字段:usernum(计算gb_num的和),usernumhit(计算gb_num)的个数
表j_gbook表中有gb_num,gb_to_userid

其中Dv_User中的UserID 是 j_gbook中的gb_to_userid

...全文