📄 lvxingshe.asp

📁 部分功能：1.查询旅游信息：主要查询景点和酒店的信息

💻 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>&nbsp;&nbsp;&nbsp;&nbsp;修改┆删除</td></tr>

<%
var conn = new ActiveXObject("ADODB.Connection");
var sql = "SELECT * FROM LVXingShe";
conn.Open(Application("ConnectionString"));
var rs = conn.Execute(sql);
while (!rs.eof) {
%>
<form method="post" action="lvxingshe_modify.asp">
<input name="BianHao" type="hidden" value="<%=rs("BianHao")%>" />
<tr>
	<td><input name="MingCheng" type="text" value="<%=rs("MingCheng")%>" size="18" /></td>
	<td><input name="DengJi" type="text" value="<%=rs("DengJi")%>" size="4" /></td>
	<td><input name="FuZeXianLu" type="text" value="<%=rs("FuZeXianLu")%>" size="12" /></td>
	<td><input name="LianXiDianHua" type="text" value="<%=rs("LianXiDianHua")%>" size="12" /></td>
	<td><input type="submit" value="修改" />┆<a href="lvxingshe_delete.asp?bianhao=<%=rs("BianHao")%>" onclick="var bool = confirm('是否确定删除此记录！'); if (!bool) return false;">删除</a></td>
</tr>
</form>
<%
rs.MoveNext();
}
%>

<form method="post" action="lvxingshe_add.asp">
<tr>
	<td><input name="MingCheng" type="text" size="18" /></td>
	<td><input name="DengJi" type="text" size="4" /></td>
	<td><input name="FuZeXianLu" type="text" size="12" /></td>
	<td><input name="LianXiDianHua" type="text" size="12" /></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 + -