addusersave.asp

来自「网佳网络办公系统（以下简称OA）是一套基于B/S模式的无纸化办公系统。[显著特点」· ASP 代码 · 共 49 行

<!--#include file="bkconn.asp"-->
<% 
'获取数据
stel=request.form("name")
	     scost=request.form("dj")
         sdw=request.form("dw")	    
 n=Year(date())
	    y=Month(date())
r=Day(date())
s=Hour(time())
f=Minute(time())
m=Second(time())
if len(y)=1 then y="0" & y
if len(r)=1 then r="0" & r
if len(s)=1 then s="0" & s
if len(f)=1 then f="0" & f
if len(m)=1 then m="0" & m
ssj=n & "年" & y & "月" & r & "日" & s & ":" & f & ":" & m

'检验数据合法性
if stel="" or scost="" then
%>
<script language=vbscript> 
MsgBox "错误：输入不能有空！"
location.href = "useradd.asp"
</script>
<%else
set   tablelist=conn.execute("select  * from  user where guestname='" &stel &"'")
if not(tablelist.eof and tablelist.bof) then
%>
<script language=vbscript> 
MsgBox "错误：数据库中已经存在此授权用户，禁止重复提交！"
location.href = "useradd.asp"
</script>
<%else

'写入记录	     
conn.execute("insert into user(guestname,ljl_pwd,grad,add,sj)  values('" &stel &"','" &stel &"','" &scost &"','" &sdw &"','" &ssj &"')")
%>
<script language=vbscript> 
MsgBox "系统提示：提交成功，按此返回！"
location.href = "useradd.asp"
</script>

<%end if
conn.close
set conn=nothing
end if
%>