📄 tie_show.asp
字号:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../../login/check_power.asp"-->
<%
table_name="tie"
if check_power("参数设置")=0 then
response.redirect("/login/check_false.asp")
else%> <%
set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = "dsn=hotel;"
Recordset1.Source = "SELECT * FROM view_"&table_name
Recordset1.CursorType = 3
Recordset1.CursorLocation = 2
Recordset1.LockType = 3
Recordset1.Open
Recordset1_numRows = 0
set rsfields=Recordset1.fields
%>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%response.write "<"&"script language=JavaScript>"%><%=chr(13)+chr(10)%>
<%response.write "<"&"!--"%><%=chr(13)+chr(10)%>
<%response.write "function go"&table_name&"_add(){"%><%=chr(13)+chr(10)%>
<%response.write " location.assign("""&table_name&"_add.asp"");"%><%=chr(13)+chr(10)%>
<%response.write "}"%><%=chr(13)+chr(10)%>
<%response.write "function goparameters_show(){"%><%=chr(13)+chr(10)%>
<%response.write " location.assign(""../parameters_show.asp"");"%><%=chr(13)+chr(10)%>
<%response.write "}"%><%=chr(13)+chr(10)%>
<%response.write "//-->"%><%=chr(13)+chr(10)%>
<%response.write "<"&"/script>"%><%=chr(13)+chr(10)%>
</head>
<body bgcolor="#FFFFFF">
现有记录:<%=(recordset1.recordcount)%>条<br>
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<tr>
<td>注册ID</td>
<td>名称</td>
<td>说明</td>
<td> </td>
<td> </td>
</tr><%
while not recordset1.eof
%><tr>
<td><%=(Recordset1.Fields.Item("id").Value)%> </td>
<td><%=(Recordset1.Fields.Item("name").Value)%> </td>
<td><%=(Recordset1.Fields.Item("memo").Value)%> </td>
<td><a href=<%=table_name%>_edit.asp?id=<%=Recordset1("id").value%>>修改</a></td>
<td><a href=<%=table_name%>_del.asp?id=<%=Recordset1("id").value%>>删除</a></td>
</tr><%
recordset1.movenext
Wend
%></table>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<form name="form1" method="post" action="">
<input type="button" name="Button" value="新增记录" onclick="go<%=table_name%>_add()">
<input type="button" name="Button2" value="返 回" onClick="goparameters_show()">
</form>
</td>
</tr>
</table>
</body>
</html>
<%end if%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -