📄 modify1.asp

📁 应用程序利用ＡＳＰ做的一个可以实现登陆
💻 ASP
字号:
<%@ Language=VBScript %>
 
<!--#include file="conn.asp"-->
<!--#include file="../getlevel.asp"-->


<HTML>
   <HEAD>
      <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=gb2312"/>
      <STYLE type=text/css>BODY {
        	FONT-FAMILY: "宋体"; FONT-SIZE: 10pt
            }
          TABLE {
	         FONT-FAMILY: "宋体"; FONT-SIZE: 10pt
            }
      </STYLE>
      <TITLE>人员信息修改</TITLE>
  
</head>

<body bgcolor="#567D30">
 
<%
'取得各个表单的录入数据
       
  ' response.Write(id)
   'response.End()    
        
 
   rid=Request.Form("id")
   'response.write(rid)
   'response.end()
   rname=Request.Form("name")
   rposi=Request.Form("posi")
	rrank=Request.Form("rank")
    rmajor=Request.Form("major")
    redulevel=Request.Form("edulevel")
   rgraduschool=Request.Form("graduschool")
    rnativeplace=Request.Form("nativeplace")
    rmark=Request.Form("mark")
    rynt1=Request.Form("ynt1")
	rynt2=Request.Form("ynt2")
    rsort=Request.Form("sort")
	rptype=request.form("ptype")
	rptype1=request.form("ptype1")
	rptype2=request.form("ptype2")
	rptype3=request.form("ptype3")
	rptype4=request.form("ptype4")
	rbirthdate=request.form("birthdate")
    renrolldate=request.form("enrolldate")
    rremark=request.form("remark")
  
  
%>

   
<%
    sql="update mp_ersonnel set"
    sql=sql+" name='"&rname&"',"
	sql=sql+" posi='"&rposi&"',"
    sql=sql+" rank='"&rrank&"',"
    sql=sql+" major='"&rmajor&"',"
    sql=sql+" edulevel='"&redulevel&"',"
    sql=sql+"graduschool='"&rgraduschool&"',"
    sql=sql+" nativeplace='"&rnativeplace&"',"
    sql=sql+" mark='"&rmark&"',"
	sql=sql+" ynt1='"&rynt1&"',"
    sql=sql+" ynt2='"&rynt2&"',"
	sql=sql+" sort='"&rsort&"',"
	sql=sql+" ptype='"&rptype&"',"
	sql=sql+" ptype1='"&rptype1&"',"
	sql=sql+" ptype2='"&rptype2&"',"
	sql=sql+" ptype3='"&rptype3&"',"
	sql=sql+" ptype4='"&rptype4&"',"
	sql=sql+" birthdate='"&rbirthdate&"',"
    sql=sql+" enrolldate='"&renrolldate&"',"
    sql=sql+" remark='"&rremark&"'"
	sql=sql+" "&condition&" and id="&rid
   'response.write(sql)
   'response.end()
	conn.Execute(sql)
    conn.Close
%> 
 
     <%
     response.write "<script language='javascript'>" 
	    response.write "alert('修改成功!');" 
			 response.write "history.go(-1);"
		        response.write "</script>"
     response.end
   conn.close
%> 
  
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -