这个是跳转后的页面
<%
HH_Name=request.QueryString("h_name")
HH_ID=request.QueryString("h_id")
if request.QueryString("cmd")="reg" then
HH_ID=trim(server.htmlencode(request.form("HH_ID")))
HD_Info=trim(server.htmlencode(request.form("HD_Info")))
HH_SZXdis=trim(server.htmlencode(request.form("HH_SZXdis")))
HH_HCZdis=trim(server.htmlencode(request.form("HH_HCZdis")))
HH_JCdis=trim(server.htmlencode(request.form("HH_JCdis")))
HH_ZLZXdis=trim(server.htmlencode(request.form("HH_ZLZXdis")))
''----------------判断某一项是否被选种 选种返回 TRUE 值 --------------------------
function getTF(InCHK)
if Instr(HH_CHK,InCHK)>0 then
getTF = true
else
getTF = false
end if
end function
''-------------------------------- 函数结束 -------------------------------------
'-----------------------------1202:4:08----------------------------
if HH_ID="" or HD_Info="" then
Response.Write("操作超时,请重新注册!789")
response.Write HH_ID & HD_Info
'Response.Redirect( "HotelReg.asp" )
response.Write("<table width=50% height=50 align=center bgcolor=#e0e0e0><tr><td><div align=center><br>请 完 整 填 写 所 有 必 填 项 目!<br><br><a href=javascript:history.go(-1)>点此回上页</a></div></td></tr></table>")
Response.End()
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM HotelDetails where HH_ID='"&HH_ID&"'"
rs.open sql,conn,3,3
if rs.eof or rs.bof then
Response.Write("操作出现错误,请规范操作!")
'Response.Redirect( "HotelReg.asp" )
response.Write("<table width=50% height=50 align=center bgcolor=#e0e0e0><tr><td><div align=center><br>操作出现错误,请规范操作!<br><br><a href=javascript:history.go(-1)>点此回上页</a></div></td></tr></table>")
Response.End()
end if
''rs("HH_ID")=NewHH_ID
rs("HD_Info")=HD_Info
rs("HH_CHK")=HH_CHK
rs("HD_Eat")=HD_Eat
rs("HD_Meeting")=HD_Meeting
rs("HD_Service")=HD_Service
rs("HD_Creditcard")=HD_Creditcard
<%@LANGUAGE="VBSCRIPT" CODEPAGE="65001"%>
<!--#include file="conn.asp"-->
<%
if request.QueryString("cmd")="reg" then
HH_Name=server.htmlencode(request.form("HH_Name"))
login_name=HH_Name
if Instr(login_name,"=")>0 or Instr(login_name,"%")>0 or Instr(login_name,chr(32))>0 or Instr(login_name,"?")>0 or Instr(login_name,"&")>0 or Instr(login_name,";")>0 or Instr(login_name,",")>0 or Instr(login_name,"'")>0 or Instr(login_name,",")>0 or Instr(login_name,chr(34))>0 or Instr(login_name,chr(9))>0 or Instr(login_name,"")>0 then
'response.Write"<div align=center>请输入合法的用户名!</div>"
response.write"<div align=center class=f1>不合法的用户名!请另选一用户名注册!<br><a href=javascript:history.go(-1)>点此重新注册</a></div>"
response.End()
end if
HH_Addr=server.htmlencode(request.form("HH_Addr"))
HH_LoginName=server.htmlencode(request.form("HH_LoginName"))
login_name=HH_LoginName
if Instr(login_name,"=")>0 or Instr(login_name,"%")>0 or Instr(login_name,chr(32))>0 or Instr(login_name,"?")>0 or Instr(login_name,"&")>0 or Instr(login_name,";")>0 or Instr(login_name,",")>0 or Instr(login_name,"'")>0 or Instr(login_name,",")>0 or Instr(login_name,chr(34))>0 or Instr(login_name,chr(9))>0 or Instr(login_name,"")>0 then
'response.Write"<div align=center>请输入合法的用户名!</div>"
response.write"<div align=center class=f1>不合法的用户名!请另选一用户名注册!<br><a href=javascript:history.go(-1)>点此重新注册</a></div>"
response.End()
end if
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from HotelHead where HH_LoginName='"& login_name &"'"
rs.open sql,conn,3,3
if rs.eof then
response.write"<div align=center>恭喜,<font color=red >"&login_name&"</font> 此名称您可以注册!</div>"
else
if HD_PriceF<200 then
HD_PriceTyp="A"
elseif HD_PriceF>=200 and HD_PriceF<300 then
HD_PriceTyp="B"
elseif HD_PriceF>=300 and HD_PriceF<400 then
HD_PriceTyp="C"
elseif HD_PriceF>=400 and HD_PriceF<500 then
HD_PriceTyp="D"
elseif HD_PriceF>=500 and HD_PriceF<800 then
HD_PriceTyp="E"
elseif HD_PriceF>=800 and HD_PriceF<1200 then
HD_PriceTyp="F"
elseif HD_PriceF>=1200 then
HD_PriceTyp="G"
end if
HD_XingJi=server.htmlencode(request.form("HD_XingJi"))
HH_Faren=server.htmlencode(request.form("HH_Faren"))
if HH_Faren="" then
HH_Faren="0"
end if
HH_Mobile=server.htmlencode(request.form("HH_Mobile"))
if HH_Mobile="" then
HH_Mobile="0"
end if
HH_Url=server.htmlencode(request.form("HH_Url"))
if HH_Url="" then
HH_Url="0"
end if
HH_Certificate=server.htmlencode(request.form("HH_Certificate"))
if HH_Certificate="" then
HH_Certificate="0"
end if
HH_Principal=server.htmlencode(request.form("HH_Principal")) '负责人
'HH_Certificate=server.htmlencode(request.form("HH_Certificate")) '证件
HH_Email=server.htmlencode(request.form("HH_Email"))
HH_Phone=server.htmlencode(request.form("HH_Phone"))
HH_Fax=server.htmlencode(request.form("HH_Fax"))
''HH_Mobile=server.htmlencode(request.form("HH_Mobile"))
''HH_Url=server.htmlencode(request.form("HH_Url"))
HH_MiniWeb=server.htmlencode(request.form("HH_MiniWeb"))
HH_RegIP=Request.ServerVariables("REMOTE_ADDR")
'-----------------------------1202:4:08----------------------------
if HH_Name="" or HH_Addr="" or HH_Faren="" or HH_Principal="" or HH_Certificate=""or HH_Email="" or HH_Phone="" or HH_Mobile="" or HH_Url="" or HH_MiniWeb="" then
''response.Write HH_Name&HH_Addr&HH_Faren&HH_Principal&HH_Certificate&HH_Email&HH_Phone&HH_Mobile&HH_Url&HH_MiniWeb
response.Write("<table width=50% height=50 align=center bgcolor=#e0e0e0><tr><td><div align=center><br>请 完 整 填 写 所 有 必 填 项 目!<br><br><a href=javascript:history.go(-1)>点此回上页</a></div></td></tr></table>")
else
Set rs = Server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM HotelHead order by ID "
rs.open sql,conn,3,3
if rs.eof or rs.bof then
NewHH_ID="1000001" '如果第一笔记录从1000001开始
else
rs.movelast
NewHH_ID=clng(rs("HH_ID"))+1
end if
rs.addnew
rs("HH_ID")=NewHH_ID
rs("HH_Name")=HH_Name
rs("HH_Addr")=HH_Addr
rs("HH_LoginName")=HH_LoginName
rs("HH_LoginPwd")=HH_LoginPwd
rs("HH_Faren")=HH_Faren
rs("HH_Principal")=HH_Principal
rs("HH_Certificate")=HH_Certificate
rs("HH_Email")=HH_Email
rs("HH_Fax")=HH_Fax
rs("HH_Phone")=HH_Phone
rs("HH_Mobile")=HH_Mobile
rs("HH_Url")=HH_Url
rs("HH_MiniWeb")=HH_MiniWeb
rs("HH_Sdate")=now()
rs("HH_Regip")=HH_RegIP
'rs("HH_show")=NewHH_ID&"/show.gif"
'rs("HH_big")=NewHH_ID&"/big.gif"
'rs("HH_left")=NewHH_ID&"/left.gif"
'rs("HH_center")=NewHH_ID&"/center.gif"
'rs("HH_right")=NewHH_ID&"/right.gif"
rs.update
rs.close
set rs=nothing
end if
'------写详细信息
Set rs = Server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM HotelDetails order by ID "
rs.open sql,conn,3,3
rs.addnew
rs("HH_ID")=NewHH_ID
rs("HH_Name")=HH_Name
rs("HD_City")=HD_City
rs("HD_Area")=HD_Area
rs("HD_Price")=HD_PriceTyp
rs("HD_DJprice")=HD_PriceF
rs("HD_XingJi")=HD_XingJi
rs("HH_show")=NewHH_ID&"/show.gif"
rs("HH_big")=NewHH_ID&"/big.gif"
rs("HH_left")=NewHH_ID&"/left.gif"
rs("HH_center")=NewHH_ID&"/center.gif"
rs("HH_right")=NewHH_ID&"/right.gif"
rs.update
rs.close
set rs=nothing
'------写房间信息
Set rs = Server.CreateObject("ADODB.Recordset")
sql="SELECT * FROM HotelRoom order by ID "
rs.open sql,conn,3,3
rs.addnew
rs("HH_ID")=NewHH_ID
rs("HR_Name")="A" '标准单间的类型
rs("HR_Nike")="标准单间" '默认的房间名称,以后可以修改.
rs("HR_StandardPrice")=HR_StandardPrice
rs("HR_PromotionPrice")=HR_PromotionPrice
rs("HR_WeekendPrice")=HR_PromotionPrice
rs("HR_Breakfast")="A"
rs("HR_RegDate")=now()
rs.update
rs.close
set rs=nothing
Response.Write "三张表都写成功了"
''response.End()
Response.Redirect("HotelRegDetails.asp?h_name="&HH_Name&"&h_id="&NewHH_ID&"")
'Response.Write "<meta http-equiv=""refresh"" content=""0;url=HotelRegDetails.asp?n="&U_LoginName&"&p="&U_LoginPwd&""">"