add_fangjian.asp

酒店管理系统

<!--#include file="../inc/title.inc"-->
<!--#include file="../inc/conn.asp"-->
<!--#include file="checkpwd.asp"-->
<%
fanghao2=request.Form("fanghao2")
roomlei=request.Form("hiddenField")
if fanghao2="" then
response.Redirect("chuanjinafj.asp")
end if
sql1="select * from fj where roomname='"&fanghao2&"'"
set rs1=conn.execute(sql1)
if  not rs1.eof then
response.Redirect("chuanjinafj.asp")
else 
sql2="insert into fj (roomlei,roomname) values("&roomlei&",'"&fanghao2&"')"
conn.execute(sql2)
conn.close
end if
conn.close
%>