📄 jiudian.asp
字号:
<%@ LANGUAGE=JavaScript %>
<%
Response.expires = 0;
if (Session("YongHu")==null || Session("YongHu").LeiXing != 1)
Response.Redirect("denglu.asp");
%>
<html>
<head>
<style type="text/css">
table { border-collapse: collapse; }
table td { padding: 1px; font-size: 14px; font-family: georgia; text-align:center;}
tr.head td { background:#B5DAFF; text-align:left;}
</style>
</head>
<body>
<table border="1">
<tr class="head"><td>名称</td><td>星级</td><td>联系人</td><td>联系电话</td><td>地址</td><td> 修改┆删除</td></tr>
<%
var conn = new ActiveXObject("ADODB.Connection");
var sql = "SELECT * FROM JiuDian";
conn.Open(Application("ConnectionString"));
var rs = conn.Execute(sql);
while (!rs.eof) {
%>
<form method="post" action="jiudian_modify.asp">
<input name="BianHao" type="hidden" value="<%=rs("BianHao")%>" />
<tr>
<td><input name="MingCheng" type="text" value="<%=rs("MingCheng")%>" size="12" /></td>
<td><input name="XingJi" type="text" value="<%=rs("XingJi")%>" size="4" /></td>
<td><input name="LianXiRen" type="text" value="<%=rs("LianXiRen")%>" size="8" /></td>
<td><input name="LianXiDianHua" type="text" value="<%=rs("LianXiDianHua")%>" size="12" /></td>
<td><input name="DiZhi" type="text" value="<%=rs("DiZhi")%>" size="36" /></td>
<td><input type="submit" value="修改" />┆<a href="jiudian_delete.asp?bianhao=<%=rs("BianHao")%>" onclick="var bool = confirm('是否确定删除此记录！'); if (!bool) return false;">删除</a></td>
</tr>
</form>
<%
rs.MoveNext();
}
%>
<form method="post" action="jiudian_add.asp">
<tr>
<td><input name="MingCheng" type="text" size="12" /></td>
<td><input name="XingJi" type="text" size="4" /></td>
<td><input name="LianXiRen" type="text" size="8" /></td>
<td><input name="LianXiDianHua" type="text" size="12" /></td>
<td><input name="DiZhi" type="text" size="36" /></td>
<td colspan="3" style="text-align: left;"><input type="submit" value=" 添加 " /></td>
</tr>
</form>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -