📄 smartpit.asp
字号:
<!--#include file="conn.asp"-->
<%
if session("AdminName")="" then
Response.Redirect "admin_login.asp"
end if
%>
<%
if request("mod")="ok" then
Sql="Select * FROM account where smartpit like '"&request("smartpit") &"'"
Rs.Open Sql,Conn,3,3
rs("account_id")=request("accountid")
rs("amount")=request("amount")
rs("s_date")=request("s_date")
rs("password")=request("password")
rs("lockid")=request("lockid")
Rs.Update
rs.close
response.write "<script language='javascript'>" & VbCRlf
response.write "alert('保存成功,');" & VbCrlf
response.write "</script>" & VbCRLF
end if
%>
<html>
<head>
<title>无标题文档</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<table width="688" border="0">
<tr>
<td>
<form name="form1" method="post" action="smartpit.asp?act=search">
<table width="448" border="0" align="center" bgcolor="#CCCCCC">
<tr bgcolor="#FFFFFF">
<td colspan="2">帐号查询</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="108">SmartPit：</td>
<td width="330">
<input type="text" name="smartpit" size="50">
</td>
</tr>
<tr bgcolor="#FFFFFF">
<td width="108"> </td>
<td width="330">
<input type="submit" name="Submit" value="=====查询=====">
</td>
</tr>
</table>
</form>
</td>
</tr>
<%
if request("act")="search" then
Sql="Select * FROM account where smartpit like '"&request("smartpit") &"'"
Rs.Open Sql,Conn,3,3
if rs.recordcount=0 then
response.write "<script language='javascript'>" & VbCRlf
response.write "alert('您查找的帐号不存在,');" & VbCrlf
response.write "</script>" & VbCRLF
else
%>
<tr>
<td bgcolor="#FFFFFF">
<form name="form2" method="post" action="smartpit.asp?act=search&mod=ok">
<table width="445" border="0" align="center" bordercolor="#000000" bgcolor="#999999">
<tr>
<td width="124" bgcolor="#33CCCC">帐号EMAIL</td>
<td width="311" bgcolor="#FFFFFF">
<input type="text" name="accountid" size="50" value="<%=rs("account_id")%>">
</td>
</tr>
<tr>
<td width="124" bgcolor="#33CCCC">SmartPit</td>
<td width="311" bgcolor="#FFFFFF">
<input type="text" name="smartpit" size="20" value="<%=rs("smartpit")%>" readonly>
</td>
</tr>
<tr>
<td width="124" bgcolor="#33CCCC">金额</td>
<td width="311" bgcolor="#FFFFFF">
<input type="text" name="amount" size="20" value="<%=rs("amount")%>">
日元 </td>
</tr>
<tr>
<td width="124" bgcolor="#33CCCC">开账日期</td>
<td width="311" bgcolor="#FFFFFF">
<input type="text" name="s_date" size="30" value="<%=rs("s_date")%>">
</td>
</tr>
<tr>
<td width="124" bgcolor="#33CCCC">充值次数</td>
<td width="311" bgcolor="#FFFFFF">
<input type="text" name="logins" size="10" value="<%=rs("logins")%>">
次 </td>
</tr>
<tr>
<td width="124" bgcolor="#33CCCC">帐号密码</td>
<td width="311" bgcolor="#FFFFFF">
<input type="text" name="password" size="20" value="<%=rs("password")%>">
</td>
</tr>
<tr>
<td width="124" bgcolor="#33CCCC">账户是否有效</td>
<td width="311" bgcolor="#FFFFFF">
<input type="text" name="lockid" size="10" value="<%=rs("lockid")%>">
（0代表有效，1代表无效） </td>
</tr>
<tr>
<td width="124" bgcolor="#33CCCC"> </td>
<td width="311" bgcolor="#FFFFFF">
<input type="submit" name="Submit2" value="修改ok">
<input type="reset" name="Submit22" value="重置reset">
</td>
</tr>
</table>
</form>
</td>
</tr>
<%
end if
rs.close
end if
%>
<tr>
<td> </td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -