add_info1.asp

一个学生管理系统 ASP+ACCE

<!--#include file="conn.asp"-->
<%
if session("admin")="" then
	response.write "<script>alert('您无此权限');document.location.href='index.asp';</script>"
	response.end
end if

%>

<%
dim user_number,user_name,user_sex,user_time,user_nation,user_identity,user_area,user_address,user_phone,user_email,user_major,user_class,user_rd,user_rp,user_info

user_number=trim(request("user_number"))
user_name=trim(request("user_name"))
user_sex=trim(request("user_sex"))
user_time=trim(request("user_time"))
user_nation=trim(request("user_nation"))
user_identity=trim(request("user_identity"))
user_area=trim(request("user_area"))
user_address=trim(request("user_address"))
user_phone=trim(request("user_phone"))
user_email=trim(request("user_email"))
user_major=trim(request("user_major"))
user_class=trim(request("user_class"))
user_collogetestach=trim(request("user_rd"))
user_rp=trim(request("user_rp"))
user_info=trim(request("user_info"))
%>

<%
set rs=server.createobject("adodb.recordset")
sql="select * from st_info where user_number='"&user_number&"'"
rs.open sql,conn,1,3

%>
<%if not rs.eof then
	response.write "学号已经存在，请更换"
	response.end
else
	rs.addnew
	rs("user_number")=user_number
	rs("user_name")=user_name
	rs("user_sex")=user_sex
	rs("user_time")=user_time
	rs("user_nation")=user_nation
	
	rs("user_identity")=user_identity
	rs("user_area")=user_area
	rs("user_address")=user_address
	
	rs("user_phone")=user_phone
	
	rs("user_email")=user_email
	rs("user_major")=user_major
	rs("user_class")=user_class
	rs("user_rd")=user_rd
	rs("user_rp")=user_rp
	rs("user_info")=user_info
	rs.update
	rs.close
	set rs=nothing
end if
%>

<%
set rs1=server.createobject("adodb.recordset")
sql="select * from admin where admin_name='"&user_number&"'"
rs1.open sql,conn,1,3
%>
<%
if  rs1.eof then
	rs1.addnew
	rs1("admin_name")=user_number
	rs1("admin_pwd")=user_number
	rs1.update
	rs1.close
	set rs1=nothing
	response.write "<script language='javascript'>window.confirm('用户已经成功添加到数据库')</script><a href='add_info.asp'>继续录入研究生信息</a>"	
end if

%>