?? jjss.asp
字號:
if pagecount=1 then page_start=1
page_end=rs.pagesize*pagecount
if pagecount*rs.pagesize=>rs.recordcount then page_end=rs.recordcount end if%>共有[<font color="#000000"><%=rs.recordcount%></font>]條教員信息
以下是[<font color="#000000"><%=page_start%><font color="#000000">～</font><%=page_end%></font>]條</font></td>
<tr>
<td colspan="3" valign="bottom"></td>
<tr>
<td colspan="3" valign="bottom"><% response.write"<form name=go2to form method=Post action='jjss.asp?key="+key+"&jylb="+jylb+"'>"
response.write "<font color='#0000600'></font>"
if pagecount=1 then
response.write "<font color='#000000'>首頁 上一頁</font> "
else
response.write "<a href=jjss.asp?page=1&key="+key+"&jylb="+jylb+"><font color='000000'><font size=2>首頁</font></font></a> "
response.write "<a href=jjss.asp?page="+cstr(pagecount-1)+"&key="+key+"&jylb="+jylb+"><font color='000000'>上一頁</font></a> "
end if
if rs.PageCount-pagecount<1 then
response.write "<font color='#000000'>下一頁 尾頁</font></font>"
else
response.write "<a href=jjss.asp?page="+cstr(pagecount+1)+"&key="+key+"&jylb="+jylb+"><font color='000000'>下一頁</font></font></a> "
response.write "<a href=jjss.asp?page="+cstr(rs.PageCount)+"&key="+key+"&jylb="+jylb+"><font color='000000'>尾頁</font></font></a>"
end if
response.write "<font color='000000'> 頁次:<font color='000000'>"&pagecount&"</font>/"&rs.pagecount&"頁</font></font>"
response.write "<font color='000000'>轉到第<input type='text' name='page' size=2 maxLength=3 style='font-size: 9pt; color:#000000; position: relative; height: 18' value="&PageCount&">頁</font></font> "
response.write "<input class=button type='button' value='確 定' onclick=checks() style='font-family: 宋體; font-size: 9pt; color: #000000; position: relative; height: 19'>" %>
</td>
<%end if%>
<tr align="left">
<td height="20" valign="center" colspan="2">
<table border="0" cellpadding="2" cellspacing="1" height="0" width="100%" align="center" bgcolor="dfdfdf">
<tr bgcolor="#d5c88a">
<td width="75" height="18" valign="bottom"><font color="#000000">教員名稱</font></td>
<td width="37" height="18" valign="bottom"><font color="#000000">性別</font></td>
<td width="40" height="18" valign="bottom"><font color="#000000">學歷</font></td>
<td width="278" height="18" valign="bottom" bgcolor="#d5c88a"><font color="#000000">教授科目</font></td>
<td width="77" height="18" valign="bottom"><font color="#000000">要求地區</font></td>
</tr>
<% do while not rs.eof %>
<tr bgcolor="#FFFFFF">
<td width="75" height="19" valign="center"><a class="sbtxt" href="jiajiaoviews.asp?uid=<%=rs("id")%>&uname=<%=rs("uname")%>" target="_blank"><%=rs("iname")%></a></td>
<td width="37" height="19" valign="center"><a class="sbtxt" href="jiajiaoviews.asp?uid=<%=rs("id")%>&uname=<%=rs("uname")%>" target="_blank"><%=rs("sex")%></a></td>
<td width="40" height="19" valign="center"><a class="sbtxt" href="jiajiaoviews.asp?uid=<%=rs("id")%>&uname=<%=rs("uname")%>" target="_blank"><%=rs("edu")%></a></td>
<td width="278" height="19" valign="center"><a class="sbtxt" href="jiajiaoviews.asp?uid=<%=rs("id")%>&uname=<%=rs("uname")%>" target="_blank"><%=rs("kmsm")%></a></td>
<td width="77" height="19" valign="center"><%=rs("skdd")%></td>
</tr>
<% c=c+1
rs.movenext
if c>=30 then exit do
loop
rs.close
set rs=nothing %>
</table>
</td>
</tr>
</table>
</td>
</tr>
<%end if%>
</table>
</td>
</tr>
<%else%>
<tr bgcolor="#FFFFFF">
<td>
<table border=0 cellpadding=0 cellspacing=0 width=100% align="center">
<tr valign="bottom">
<td height=20 colspan="3"><font color="#666600" ><b>學員信息搜索結果-></b></font></td>
</tr>
<tbody>
<tr>
<td height=85 colspan="3" valign="top">
<table border="0" cellpadding="2" cellspacing="0" height="0" bordercolor="#316594" bordercolordark="#FFFFFF" width="100%">
<% set rs=server.createobject("adodb.recordset")
if not isempty(request("page")) then
pagecount=cint(request("page"))
else
pagecount=1
end if
sq2="select * from xueyuan where kmsm like '%"&gjcs&"%' and kmsm like '%"&fls&"%' and skdd like '%"&dqs&"%' order by id desc"
rs.open sq2,conn,1,1
if rs.eof and rs.bof then%>
<tr>
<td height="20"> </td>
</tr>
<tr>
<td height="20" >沒有找到您所需要的記錄。</td>
</tr>
<%else
c=0
rs.pagesize=30
if pagecount>rs.pagecount or pagecount<=0 then
pagecount=1
end if
rs.AbsolutePage=pagecount %>
<tr> <% if rs.pagecount=1 then %>
<td ?height="19" colspan="2" valign="bottom" height="25"><font color="#000000">共有[<font color="#000000"><%=rs.recordcount%></font>]條學員信息
以下是[<font color="#333399">1～</font><font color="#000000"><%=rs.recordcount%></font>]條</font></td>
</tr>
<%else%>
<tr>
<td colspan="3" valign="bottom" height="25"><font color="#000000">
<% page_start=(pagecount-1)*rs.pagesize
if pagecount=1 then page_start=1
page_end=rs.pagesize*pagecount
if pagecount*rs.pagesize=>rs.recordcount then page_end=rs.recordcount end if%>共有[<font color="#000000"><%=rs.recordcount%></font>]條學員信息
以下是[<font color="#000000"><%=page_start%><font color="#000000">～</font><%=page_end%></font>]條</font></td>
<tr>
<td colspan="3" valign="bottom"></td>
<tr>
<td colspan="3" valign="bottom"><% response.write"<form name=go2to form method=Post action='jjss.asp?key="+key+"&jylb="+jylb+"'>"
response.write "<font color='#0000600'></font>"
if pagecount=1 then
response.write "<font color='#000000'>首頁 上一頁</font></font> "
else
response.write "<a href=jjss.asp?page=1&key="+key+"&jylb="+jylb+"><font color='000000'>首頁</font></font></a> "
response.write "<a href=jjss.asp?page="+cstr(pagecount-1)+"&key="+key+"&jylb="+jylb+"><font color='000000'>上一頁</font></a> "
end if
if rs.PageCount-pagecount<1 then
response.write "<font color='#000000'>下一頁 尾頁</font>"
else
response.write "<a href=jjss.asp?page="+cstr(pagecount+1)+"&key="+key+"&jylb="+jylb+"><font color='000000'>下一頁</font></font></a> "
response.write "<a href=jjss.asp?page="+cstr(rs.PageCount)+"&key="+key+"&jylb="+jylb+"><font color='000000'>尾頁</font><</a>"
end if
response.write "<font color='000000'> 頁次:<font color='000000'>"&pagecount&"</font>/"&rs.pagecount&"頁</font></font>"
response.write "<font color='000000'>轉到第<input type='text' name='page' size=2 maxLength=3 style='font-size: 9pt; color:#000000; position: relative; height: 18' value="&PageCount&">頁</font></font> "
response.write "<input class=button type='button' value='確 定' onclick=checks() style='font-family: 宋體; font-size: 9pt; color: #000000; position: relative; height: 19'>" %>
</td>
<%end if%>
<tr align="left">
<td height="20" valign="center" colspan="2">
<table border="0" cellpadding="2" cellspacing="1" height="0" width="100%" align="center" bgcolor="dfdfdf">
<tr bgcolor="#d5c88a">
<td width="20%" height="19" valign="center">授課地點</td>
<td width="65%" height="19" valign="center">課目說明</td>
<td width="15%" height="19" valign="center" align="left">發布日期</td>
</tr>
<% do while not rs.eof %>
<tr bgcolor="#FFFFFF">
<td height="20" valign="center" width="20%"> <a href="qiujiaoviews.asp?uid=<%=rs("id")%>&uname=<%=rs("uname")%>" class="sbtxt"><%=rs("skdd")%></a>
</td>
<td height="20" valign="center" width="65%"><a class="sbtxt" href="qiujiaoviews.asp?uid=<%=rs("id")%>&uname=<%=rs("uname")%>"><%=rs("kmsm")%></a></td>
<td height="20" valign="center" align="left" width="15%"><%=rs("idate")%></td>
</tr>
<% c=c+1
rs.movenext
if c>=30 then exit do
loop
rs.close
set rs=nothing %>
</table>
</td>
</tr>
</table>
</td>
</tr>
<%end if%>
</table>
</td>
</tr>
<%end if%>
</table>
</td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="0" align="center">
<tr bgcolor="#FFFFFF">
<td height="15"> </td>
</tr>
<tr>
<td><!--#include virtual="../inc/down.htm"--></td>
</tr>
</table>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -