📄 modify.asp
字号:
<script>
//
// 力天2002网络办公系统
// Copyright (c) 深圳市力天软件开发有限公司
// http://www.ebexpert.net
//
// 文件名 : modify.asp
// 描述 : 衣食住行数据修改
// 版本 :
// 作者 : zyh
// 备注 :
</script>
<!--#include file="const.inc"-->
<%
hname=trim(request("hname"))
if hname<>"" then
city=trim(request("city"))
phone=trim(request("phone"))
fax=trim(request("fax"))
address=trim(request("address"))
remark=trim(request("remark"))
id=request("id")
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../access.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
conn.Execute "update pubfood set hname='" & hname & "',city='" & city & "',phone='" & phone & "',fax='" & fax & "',address='" & address & "',remark='" & remark & "' where id=" & id
set conn=nothing
%>
<script language="javascript">
window.close();
window.opener.parent.frames("main").document.location ="index.asp";
</script>
<% else %>
<html>
<head>
<title>修改衣食住行</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../css/eintrdemo.css">
</head>
<%
Set conn=Server.CreateObject("ADODB.Connection")
DBPath1=server.mappath("../access.mdb")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & DBPath1
set rs=server.CreateObject("adodb.recordset")
rs.Open "select * from pubfood where id=" & request("id"),conn,3,1
%>
<body bgcolor="#efefef" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0"
onLoad="MM_preloadImages('images/modify_on.gif')">
<form method="post" action="" name="form">
<table width="100%" border="0" cellspacing="1" cellpadding="2">
<tr bgcolor="#4E5960">
<td class="heading"> <font color="#FFFFFF"><b>修改衣食住行</b></font></td>
</tr>
</table>
<table width="100%" border="1" cellspacing="0" cellpadding="1" bordercolordark="#FFFFFF" bordercolor="#000000">
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">宾馆名称</td>
<td width="88%">
<input type="text" name="hname" class="form" value="<%=trim(rs("hname"))%>" size="30">
<input type=hidden value="<%=rs("id")%>" name="id">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">所在城市</td>
<td width="88%">
<input type="text" name="city" class="form" value="<%=trim(rs("city"))%>" size="30">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">联系电话</td>
<td width="88%">
<input type="text" name="phone" class="form" value="<%=trim(rs("phone"))%>" size="30">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">传真：</td>
<td width="88%">
<input size=30 maxlength=30 name="fax" value="<%=trim(rs("fax"))%>">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">地址</td>
<td width="88%">
<input type="text" name="address" class="form" value="<%=trim(rs("address"))%>" size="30">
</td>
</tr>
<tr>
<td width="12%" bgcolor="bfbfbf" valign="top">备注说明：</td>
<td width="88%">
<textarea name="remark" cols="40" rows="4"><%=trim(rs("remark"))%></textarea>
</td>
</tr>
</table>
<div align="center"><br>
<a href="javascript:document.form.submit();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image1','','images/modify_on.gif',1)"><img name="Image1" border="0" src="images/modify_off.gif" width="60" height="19" hspace="5"></a><a href="javascript:document.form.reset();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image2','','images/reset_on.gif',1)"><img name="Image2" border="0" src="images/reset_off.gif" width="60" height="19" hspace="5"></a><a href="Javascript:window.close();" onMouseOut="MM_swapImgRestore()" onMouseOver="MM_swapImage('Image3','','images/closelittle_2.gif',1)"><img name="Image3" border="0" src="images/closelittle_1.gif" width="60" height="19" hspace="5"></a><br>
</div></form>
</body>
</html>
<% end if %>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -