add1.asp

一个人事管理系统

<!--#include file="data.asp"-->
<%
if request.form("name")="" then
  ' Request.Form("name")
   'response.redirect"index.asp"
   response.write"请填写您的大名!!<a href=""javascript:history.go(-1)"">返回重输</a>"
   response.end
end if
if request.form("notes")="" then
  ' Request.Form("notes")
   'response.redirect"index.asp"
   response.write"任职情况不能为空，请重输入<a href=""javascript:history.go(-1)"">返回重输</a>"
   response.end
end if
name=Request.Form("name")
notes=Request.Form("notes")
sql="Select * from 学会 Where 姓名='"&name&"'"
Set rs = conn.Execute( sql )
If RS. EOF AND rs.BOF Then
	str="Insert Into 学会(姓名,任职) Values('"&name&"','"&notes&"')"
	conn.execute(str)

%>
<script language="javaScript">
alert ("<%=name%>\n\n加入成功！")
location.href="xuehui.asp"
</script>
<%end if %>
  <script language="javaScript">
alert ("<%=name%>\n\n错误！数据库中以有同名问题。")
	location.href = "xuehui.asp"
</script>