mod_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 id,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

id=trim(request("id"))
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_rd=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 id="& id
rs.open sql,conn,1,3

%>
<%
	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_collogetestach")=user_rd
	rs("user_rp")=user_rp
	rs("user_info")=user_info
	rs.update
	rs.close
	set rs=nothing
	response.redirect "info_manager.asp"
%>