mod_info1.asp

网上学生管理信息系统,能够方便高校老师管理学生的信息,同时也便于学生网上查询

<!--#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_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

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

%>
<%
	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
	response.redirect "info_manager.asp"
%>