<%
dim key1, key2
key1=trim(request.form("key1"))
key2=trim(request.form("key2"))
if key1="" or key2="" then
xinxi1="请输入查询关键字"
end if
%>
<%
dim page
page=request("page")
PageSize =200
dim rs,strSQL,news
if request("style")="s_season" then
strSQL ="SELECT * FROM students where s_season like '%"&key1&"%' and s_grade like '%"&key2&"%' ORDER BY id DESC"
end if
if request("style")="s_cash" then
strSQL ="SELECT * FROM students where s_cash like '%"&key1&"%' and s_grade like '%"&key2&"%' ORDER BY id DESC"
end if
if request("style")="s_old" then
strSQL ="SELECT * FROM students where s_old like '%"&key1&"%' and s_grade like '%"&key2&"%' ORDER BY id DESC"
end if
if request("style")="s_kemu" then
strSQL ="SELECT * FROM students where s_kemu like '%"&key1&"%' and s_grade like '%"&key2&"%' ORDER BY id DESC"
end if
if request("style")="s_backflag" then
strSQL ="SELECT * FROM students where s_backflag like '%"&key1&"%' and s_grade like '%"&key2&"%' ORDER BY id DESC"
end if
if request("style")="s_know" then
strSQL ="SELECT * FROM students where s_know like '%"&key1&"%' and s_grade like '%"&key2&"%' ORDER BY id DESC"
end if
if request("style")="s_school" then
strSQL ="SELECT * FROM students where s_school like '%"&key1&"%' and s_grade like '%"&key2&"%' ORDER BY id DESC"
end if
if request("style")="s_kebie" then
strSQL ="SELECT * FROM students where s_kebie like '%"&key1&"%' and s_grade like '%"&key2&"%' ORDER BY id DESC"
end if
if request("style")="change_name" then
strSQL ="SELECT * FROM students where change_name like '%"&key1&"%' and s_grade like '%"&key2&"%' ORDER BY id DESC"
end if
Set rs = Server.CreateObject("ADODB.Recordset")
rs.open strSQL,Conn,3,3
rs.PageSize = PageSize
totalfilm=rs.recordcount
pgnum=rs.Pagecount
if page="" or clng(page)<1 then page=1
if clng(page) > pgnum then page=pgnum
if pgnum>0 then rs.AbsolutePage=page
if rs.eof then
xinxi="没有搜到任何相关信息！"
%>
<%else%>
<table width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<td bgcolor="#959595"><img src="images/adorn.gif" width="10" height="18"></td>
<td bgcolor="#959595"><table border="0" cellspacing="0" cellpadding="0" width="100%">
<tr bgcolor="#959595"> <form method=Post action="detail_search1.asp"><FONT COLOR="#ffffff">
[<b><%=rs.pagecount%></b>/<%=page%>页] [共<%=totalfilm%>个] <%if page=1 then%> [首 页] [上一页] <% else %> [<a href="detail_search1.asp?page=1">首 页</a>]
[<a href="detail_search1.asp?page=<%=page-1%>">上一页</a>]<%end if%><%if rs.pagecount-page<1 then%> [下一页] [尾 页] <%else%> [<a href="detail_search1.asp?page=<%=page+1%>">下一页</a>] [<a href="detail_search1.asp?page=<%=rs.pagecount%>">尾 页</a>]</FONT> <%end if%> <input type='text' name='page' size=2 maxlength=10 style="font-size:9pt;color:#FF0000;background-color:#FFFFFF;border-left: 1px solid #000000; border-right: 1px solid #000000; border-top: 1px solid #000000; border-bottom: 1px solid #000000" value="<%=page%>" align=center> <input style="border:1 solid black;FONT-SIZE: 9pt; FONT-STYLE: normal; FONT-VARIANT: normal; FONT-WEIGHT: normal; HEIGHT: 18px; LINE-HEIGHT: normal" type='submit' value=' Goto ' size=2></td>
</tr>
</table>
