📄 list.asp
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn_fj16.asp" -->
<!--#include file="admin_qx.asp" -->
<% isdl %>
<% Response.Buffer =True
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0
Response.CacheControl = "no-cache"
Response.AddHeader "Pragma", "No-Cache" %>
<%
ziduan=trim(request("ziduan"))
key=trim(request("key"))
by=trim(request("by"))
if key<>"" and ziduan<>""then
sql="select * from jlzd321 where ischeck='1' and isrecycle='0' and "&ziduan&" like '%"&key&"%' "
end if
if key=""then
sql="select * from jlzd321 where ischeck='1' and isrecycle='0' "
end if
if by="" then
sql=sql & " order by nian desc , qi asc,xuehao asc"
end if
if by<>"" then
Select case by
case "jiuyequxiangasc"
sql=sql & " Order by jiuyequxiang asc"
case "jiuyequxiangdesc"
sql=sql & " Order by jiuyequxiang desc"
case "chushengnianyuedesc"
sql=sql & " Order by chushengnianyue desc"
case "chushengnianyueasc"
sql=sql & " Order by chushengnianyue asc"
case "wenhuachengduasc"
sql=sql & " Order by wenhuachengdu asc"
case "wenhuachengdudesc"
sql=sql & " Order by wenhuachengdu desc"
case "xuehaoasc"
sql=sql & " Order by xuehao asc "
case "xuehaodesc"
sql=sql & " Order by xuehao desc"
End Select
end if
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,2
if rs.eof then
response.write "<script language=JavaScript>{window.alert('提示：没有找到符合条件的记录！\n\n 请按“确定”返回!');window.history.go(-1);}</script>"
response.end
end if
PageSize=trim(request("pageSize"))
if PageSize<>""then
session("pageSize")=PageSize
pz=PageSize
end if
if PageSize=""then
if session("pageSize")<>""then
pz=session("pageSize")
else
pz=20
end if
end if
rs.PageSize=pz
pagecount=rs.PageCount
page=int(request.QueryString ("page"))
if page<=0 then page=1
if request.QueryString("page")="" then page=1
rs.AbsolutePage=page
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<style>
</style>
<style type="text/css">
<!--
table {
word-break:break-all;
}
.style1 {color: #0000FF}
.STYLE2 {color: #FF0000}
.STYLE3 {font-size: 12px}
.STYLE4 {font-size: 12px; color: #FF0000; }
body {
margin-left: 0px;
margin-right: 0px;
margin-bottom: 2px;
background-color: #39867b;
margin-top: 0px;
SCROLLBAR-FACE-COLOR: #c6ebde;
SCROLLBAR-HIGHLIGHT-COLOR: #ffffff;
SCROLLBAR-SHADOW-COLOR: #39867b;
SCROLLBAR-3DLIGHT-COLOR: #39867b;
SCROLLBAR-ARROW-COLOR: #330000;
SCROLLBAR-TRACK-COLOR: #e2f3f1;
SCROLLBAR-DARKSHADOW-COLOR: #ffffff;
}
.STYLE13 {color: #0000FF; font-size: 14px; }
body,td,th {
font-size: 12px;
}
.STYLE17 {color: #006600}
a:link {
color: #006600;
text-decoration: none;
}
a:visited {
color: #0000FF;
text-decoration: none;
}
a:hover {
color: #FF0000;
text-decoration: underline;
}
a:active {
color: #99FF66;
text-decoration: none;
}
.STYLE5 {color: #000000}
-->
</style>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>浏览与简单查询</title>
</head>
<body class="STYLE3">
<%
if rs.eof then
response.write"没有记录"
end if
%><table width="100%" height="100%" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#18CF9D">
<tr>
<td align="center" valign="middle"><table width="100%" height="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="114" valign="top" bgcolor="#DEFAEC" ><form action="list.asp" method="post" name="form1" target="_self" id="form1">
<table width="95%" border="0" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
<tr>
<td class="STYLE2">
<div align="center">
<select name="ziduan" id="ziduan">
<option value="xingming">选择查找项目(默认为姓名)</option>
<option value="xuehao">学号</option>
<option value="xingbie">性别</option>
<option value="wenhuachengdu">文化程度</option>
<option value="peixunzhuanye">培训专业</option>
<option value="jiguan">籍贯</option>
<option value="shenfenzhenghao">身份证号</option>
<option value="jiuyequxiang">就业单位</option>
</select>
<span class="STYLE3">关键字:</span>
<input name="key" type="text" id="key" value="<%=key%>" size="15" />
<label>
<span class="STYLE3">
<input type="submit" name="Submit" value="查找">
*<a href="search_adv.asp" target="_self">高级搜索</a>*</span> <a href="list.asp">重新载入</a></label></div></td>
</tr>
</table></form>
<%if not rs.eof then%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -