📄 adminbanjipowersave.asp

📁 该系统测试用户信息主要由数据库直接输入

💻 ASP

字号:

<!--#include file="conn.asp"-->
 <%
  if session("adminname")="" then
  response.redirect "relogin.asp"
  end if

%>
<%


nianji=trim(request("nianji"))
banji=trim(request("banji"))

power=trim(request("power"))
 
            
 
   Set rs1=Server.CreateObject("Adodb.RecordSet")
 sql1="select * from tbnianji where nianji='"&nianji&"'"
   rs1.open sql1,conn,1,3
 
    Set rs2=Server.CreateObject("Adodb.RecordSet")
 sql2="select * from tbbanji where banji='"&banji&"'"
   rs2.open sql2,conn,1,3
 

   Set rs=Server.CreateObject("Adodb.RecordSet")
 sql="select * from tbpower where nianjiid="&rs1("nianjiid")&" and banjiid="&rs2("banjiid")
   rs.open sql,conn,1,3
 
 if power="" then 
 power="0"
 end if
 
   rs("power")=power 

   rs.update
 

   Response.Redirect "adminbanjipoweredit.asp?powerid="&rs("id")


%>


<html>

<head>
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>新建网页 1</title>
</head>

<body>

</body>

</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -