add_info1.asp

社区天地图文系统(核心:尘缘雅境图文系统) 版本: 1.0 本系统是ASP+ACCESS环境下开发成功

<!--#include file="conn.asp"-->
<%
if session("user")="" then
	response.write "您无此权限"
	response.end
end if

%>

<%
dim user_number,user_name,user_testnumber,user_idnumber,user_sex,user_city,user_homephone,user_bedroomphone,user_class,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_city=trim(request("user_city"))
user_homephone=trim(request("user_homephone"))
user_bedroomphone=trim(request("user_bedroomphone"))
user_class=trim(request("user_class"))
user_info=trim(request("user_info"))
%>

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

%>
<%
	rs.addnew
	   if user_number ="user_number1" then
        rs("user_number")=now()
    else if user_number ="user_number2" then
        rs("user_number")=now()-1
    else 
        rs("user_number")=now()-2
      end if
   end if
	
	
	rs("user_name")=user_name
	rs("user_testnumber")=user_testnumber
	rs("user_idnumber")=user_idnumber
	rs("user_sex")=user_sex
		rs("user_city")=user_city
		rs("user_homephone")=user_homephone
	rs("user_bedroomphone")=user_bedroomphone
		rs("user_class")=user_class
		rs("user_info")=user_info
	rs.update
	rs.close
	set rs=nothing
	response.redirect "add_info.asp"

%>