adminbbsbm.asp

一对一校友录多班级而且非常漂亮http://free.cnyys.com/my/yhe/DEFAULT.ASP

<!--#include file="conn.asp"-->
<style type="text/css">
<!--
body,td,th {
	color: #000000;
	font-size: 12px;
}
body {
	margin-left: 0px;
	margin-top: 0px;
}
a {
	font-size: 12px;
	color: #000000;
}
a:link {
	text-decoration: none;
}
a:visited {
	text-decoration: none;
	color: #000000;
}
a:hover {
	text-decoration: underline;
}
a:active {
	text-decoration: none;
}
-->
</style>
<table width="778" border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td> <%dim username,sql,type2,ad
ad=request.querystring("ad")
type2=request.queryString("type2")
use=request.querystring("use")
	if Session("chong")<>4 then
Response.Write("兄弟，你的权力不够啊！快来给我送点礼吧")
	Response.Write("<br>")
	Response.Write("<a href='javascript:history.go(-1)'><font color=red size=2>哎，回去吧</font></a>")
	else
Select Case type2
  Case "saveedit":
		Call saveedit
		 Case "del":
		Call del
	Case Else:
		 call show
End Select
 End If
sub show
set rs=conn.execute ("select * from bbsbm")%>
<BR>
<table width="100%"  border="1" cellpadding="0">
<%while not rs.eof%><form name="form1" method="post" action="?type2=saveedit">
  <tr>
    <td>ID：
      <input name="bmid" type="text" value=<%=rs("bmid")%> size="6">      
      名：
        <input type="text" name="bmname" value=<%=rs("bmname")%>>        
        排序：
        <input name="bmpx" type="text" value=<%=rs("bmpx")%> size="7">
		类别
        <input name="lbid" type="text" value=<%=rs("lbid")%> size="7">
        版主
        <input type="text" name="bmadmin" value=<%=rs("bmadmin")%>>
   </td>
  </tr>
  <tr>
    <td>
     
      <input name="bmsm" type="text" value=<%=rs("bmsm")%> size="120">
	  <input type="submit" name="Submit" value="提交">
      <a href=?type2=del&bmid=<%=rs("bmid")%>>删除</a></td>
  </tr>
</form><%rs.movenext
  Wend%>
</table>
 
<%end sub
  sub saveedit
dim bmid,bmsm,bmpx,bmadmin,bmname,lbid
bmid=request.form("bmid")
bmsm=request.form("bmsm")
bmpx=request.form("bmpx")
bmadmin=request.form("bmadmin")
bmname=request.form("bmname")
lbid=request.form("lbid")
  set rs=Server.CreateObject("Adodb.Recordset")
	rs.open "select * from bbsbm where bmid="&bmid&"",conn,1,3
		rs("bmsm")=bmsm
		rs("bmpx")=bmpx
		rs("bmadmin")=bmadmin
		rs("bmname")=bmname
		rs("lbid")=lbid
	Rs.Update
	conn.execute "update user set bbsjob='论坛版主' where username='"&bmadmin&"'"
	Response.Write("<br>")
	Response.redirect "adminbbsbm.asp"
	end sub
	 sub del
dim bmid
bmid=request.QueryString("bmid")
	conn.execute "delete * from bbsbm where bmid="&bmid&""
	Response.redirect "adminbbsbm.asp"
	end sub%>
</td>
  </tr>
</table></BODY></HTML>