?? housestate_show.asp
字號:
<%@LANGUAGE="VBSCRIPT"%>
<!--#include file="../../login/check_power.asp"-->
<%
table_name="housestate"
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 + -