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_testnumber,user_idnumber,user_sex,user_time,user_city,user_area,user_address,user_postcode,user_homephone,user_bedroomphone,user_mobilephoe,user_email,user_major,user_class,user_collogetestach,user_rp,user_info

user_number=trim(request("user_number"))
user_name=trim(request("user_name"))
user_testnumber=trim(request("user_testnumber"))
user_idnumber=trim(request("user_idnumber"))
user_sex=trim(request("user_sex"))
user_time=trim(request("user_time"))
user_city=trim(request("user_city"))
user_area=trim(request("user_area"))
user_address=trim(request("user_address"))
user_postcode=trim(request("user_postcode"))
user_homephone=trim(request("user_homephone"))
user_bedroomphone=trim(request("user_bedroomphone"))
user_mobilephoe=trim(request("user_mobilephoe"))
user_email=trim(request("user_email"))
user_major=trim(request("user_major"))
user_class=trim(request("user_class"))
user_collogetestach=trim(request("user_collogetestach"))
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_testnumber")=user_testnumber
	rs("user_idnumber")=user_idnumber
	rs("user_sex")=user_sex
	rs("user_time")=user_time
	rs("user_city")=user_city
	rs("user_area")=user_area
	rs("user_address")=user_address
	rs("user_postcode")=user_postcode
	rs("user_homephone")=user_homephone
	rs("user_bedroomphone")=user_bedroomphone
	rs("user_mobilephoe")=user_mobilephoe
	rs("user_email")=user_email
	rs("user_major")=user_major
	rs("user_class")=user_class
	rs("user_collogetestach")=user_collogetestach
	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_testnumber&"'"
rs1.open sql,conn,1,3
%>
<%
if  rs1.eof then
	rs1.addnew
	rs1("admin_name")=user_testnumber
	rs1("admin_pwd")=user_testnumber
	rs1.update
	rs1.close
	set rs1=nothing
	response.write "<script language='javascript'>window.confirm('用户已经成功添加到数据库')</script><a href='add_info.asp'>继续录入学生信息</a>"	
end if

%>