📄 persongzchx.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>工资查询</title>
</head>
<body>
<!--#include file="Connections/auto.asp" -->
<%
set RS = server.CreateObject("ADODB.Recordset")
set RS1 = server.CreateObject("ADODB.Recordset")
%>
<table width="580" border="0" cellspacing="1" bgcolor="#336699" cellpadding="0">
<form name="form1" action ="persongz.asp" method="post" >
<tr>
<td height="25" colspan="3" background="picture/tile.gif"><div id="title" >
<div align="center">工资查询</div>
</div></td>
</tr>
<tr>
<td align="center" bgcolor="#FFFFFF">姓名：
<input type="hidden" name="sid" value="<%=Session("Rname")%>"><%=Session("UName")%>
<select name="nian">
<option value="2004">2004</option>
<option value="2005">2005</option>
<option value="2006" selected>2006</option>
<option value="2007">2007</option>
</select>
年
<select name="yue" >
<option value="1" selected>1</option>
<option value="2">2</option>
<option value="3">3</option>
<option value="4">4</option>
<option value="5">5</option>
<option value="6">6</option>
<option value="7">7</option>
<option value="8">8</option>
<option value="9">9</option>
<option value="10">10</option>
<option value="11">11</option>
<option value="12">12</option>
</select>
月
<input type="submit" name="Submit" value="提交">
</form>
</td>
</tr>
<%
if request.form("nian")<>"" then
Sname = "select * from gongzi where gyear="&request.form("nian")&" and gmonth="&request.form("yue")&" and toperson='"&Session("Rname")&"'"
RS.open Sname , CN,1,3
if RS.eof then
%>
<%
else
%>
<%
end if
RS.close
else%>
<%
end if
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -