📄 addperson1.asp

📁 应用程序利用ＡＳＰ做的一个可以实现登陆
💻 ASP
字号:
<!--#include file="conn.asp"-->
<!--#include file="../getlevel.asp"-->
<HTML>
   <HEAD>     
     <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<style type="text/css">
<!--
.text {
	font-family: "宋体";
	font-size: 12px;
	color: #ffffff;
}
-->
</style>
</head>	  
<body bgcolor="#567D30">
  <% '取得表单数据
   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")
   rbirth_year=request.form("birth_year")
   rbirth_month=request.form("birth_month")
   rbirth_date=request.form("birth_date")
   renrollyear=request.form("enrollyear")
   renrollmonth=request.form("enrollmonth")
   rremark=request.form("remark")
   rtableid="4"
   if rbirth_year<>"" and rbirth_month<>"" and rbirth_date<>"" then
   rbirthdate=rbirth_year+"-"+rbirth_month+"-"+rbirth_date
   else 
   rbirthdate=""
  end if
   if renrollyear<>"" and renrollmonth<>"" then
   renrolldate=renrollyear+"-"+renrollmonth
  else
   renrolldate=""
   end if
   'response.Write(rbirthdate)
   'response.end()
 %>
 <%
  
   person="'"&rname&_
     "','"&rposi&_
	 "','"&rrank&_ 
	 "','"&rmajor&_ 
	 "','"&redulevel&_ 
	 "','"&rgraduschool&_ 
	 "','"&rnativeplace&_ 
	 "','"&rmark&_ 
	 "','"&rynt1&_ 
	 "','"&rynt2&_ 
	 "','"&rsort&_
	 "','"&rptype&_ 
	 "','"&rptype1&_ 
	 "','"&rptype2&_ 
	 "','"&rptype3&_ 
	 "','"&rptype4&_ 
	 "','"&rbirthdate&_ 
	 "','"&renrolldate&_ 
	 "','"&rremark&_ 
	 "','"&level1&_ 
	 "','"&level2&_ 
	 "','"&level3&_ 
	 "','"&level4&_
         "','"&rtableid&_  
	 "'"
	 
	sql="insert into mp_ersonnel (name,posi,rank,major,edulevel,graduschool,nativeplace,mark,ynt1,ynt2,sort,ptype,ptype1,ptype2,ptype3,ptype4,birthdate,enrolldate,remark,level1,level2,level3,level4,tableid)values("&person&")"
      '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 + -