📄 bigsearch.asp
字号:
else
total = rs.RecordCount
do while not(rs.EOF or rs.BOF)
%>
<tr bgcolor="<%=TableBodyColor%>" onMouseOver="this.style.backgroundColor='#ffffff'; " onMouseOut="this.style.backgroundColor='';">
<td>
<%=rs("name")%>
</td>
<td>
<%=rs("lessonName")%>
</td>
<td>
<%=rs("author")%>
</td>
<td>
<%=rs("worker")%>
</td>
<td>
<%=rs("Froming")%>
</td>
<td>
<%=rs("yearinfo")%>
</td>
</tr>
<%
i = i + 1
rs.MoveNext
loop
if i < 10 then
for j = 1 to (10 - i)
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
end if
%>
<tr bgcolor="<%=TableLeftColor%>">
<td colspan="11">
<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table13">
<tr>
<td align="right">
共有 <font color="red"><b>
<%=total%>
</b></font>条符合条件的资料
</td>
</tr>
</table>
</td>
</tr>
<%
end if
%>
</table>
<%
rs.Close()
end sub
'科研工作——论著情况
sub research_lzqk
total = 0
j = 0
i = 0
rs.Open sql,conn,1,1
%>
<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center"
ID="Table9">
<tr style="BACKGROUND-IMAGE: url('../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../Images/title1.gif');">
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>论著名称</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>出版社</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>主 编</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>合作者</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>出版时间</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>年 度</b></td>
</tr>
<%
if rs.BOF or rs.EOF then
for j = 1 to 10
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
else
total = rs.RecordCount
do while not(rs.EOF or rs.BOF)
%>
<tr bgcolor="<%=TableBodyColor%>" onMouseOver="this.style.backgroundColor='#ffffff'; " onMouseOut="this.style.backgroundColor='';">
<td>
<%=rs("name")%>
</td>
<td>
<%=rs("lessonName")%>
</td>
<td>
<%=rs("author")%>
</td>
<td>
<%=rs("worker")%>
</td>
<td>
<%=rs("startendTime")%>
</td>
<td>
<%=rs("yearinfo")%>
</td>
</tr>
<%
i = i + 1
rs.MoveNext
loop
if i < 10 then
for j = 1 to (10 - i)
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
end if
%>
<tr bgcolor="<%=TableLeftColor%>">
<td colspan="11">
<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table12">
<tr>
<td align="right">
共有 <font color="red"><b>
<%=total%>
</b></font>条符合条件的资料
</td>
</tr>
</table>
</td>
</tr>
<%
end if
%>
</table>
<%
rs.Close()
end sub
'科研工作——获奖情况
sub research_hjqk
total = 0
j = 0
i = 0
rs.Open sql,conn,1,1
%>
<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center" ID="Table7">
<tr style="BACKGROUND-IMAGE: url('../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../Images/title1.gif');">
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>获奖名称</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>获奖项目名称</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>主持人</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>合作者</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>时 间</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>授予单位</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>备 注</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>年 度</b></td>
</tr>
<%
if rs.BOF or rs.EOF then
for j = 1 to 10
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
else
total = rs.RecordCount
do while not(rs.EOF or rs.BOF)
%>
<tr bgcolor="<%=TableBodyColor%>" onMouseOver="this.style.backgroundColor='#ffffff'; " onMouseOut="this.style.backgroundColor='';">
<td>
<%=rs("name")%>
</td>
<td>
<%=rs("lessonName")%>
</td>
<td>
<%=rs("author")%>
</td>
<td>
<%=rs("worker")%>
</td>
<td>
<%=rs("startendTime")%>
</td>
<td>
<%=rs("unit")%>
</td>
<td>
<%=rs("Froming")%>
</td>
<td>
<%=rs("yearinfo")%>
</td>
</tr>
<%
i = i + 1
rs.MoveNext
loop
if i < 10 then
for j = 1 to (10 - i)
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
end if
%>
<tr bgcolor="<%=TableLeftColor%>">
<td colspan="11">
<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table11">
<tr>
<td align="right">
共有 <font color="red"><b>
<%=total%>
</b></font>条符合条件的资料
</td>
</tr>
</table>
</td>
</tr>
<%
end if
%>
</table>
<%
rs.Close()
end sub
'教师情况
sub js
sql1= "Select * from resume where adder like '%"&keywords&"%'and degree like'%"&xl&"%'"
total = 0
j = 0
i = 0
Set rs1 = Server.CreateObject("ADODB.RecordSet")
rs1.Open sql1,conn,1,1
%>
<table width="95%" border="0" cellpadding="3" cellspacing="1" bgcolor="#000000" align="center" ID="Table8">
<tr style="BACKGROUND-IMAGE: url('../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../Images/title1.gif');">
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>教师名称</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>起止时间</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>获得学位</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>工作地</b></td>
<td bgcolor="#BEC7D6" style="background-image: url('')">
<b>职务</b></td>
</tr>
<%
if rs1.BOF or rs1.EOF then
total=0
page=0
pagecount=0
for j = 1 to 10
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
else
total = rs1.RecordCount
do while not(rs1.EOF or rs1.BOF)
%>
<tr bgcolor="<%=TableBodyColor%>" onMouseOver="this.style.backgroundColor='#ffffff'; " onMouseOut="this.style.backgroundColor='';">
<td>
<%=rs1("adder")%>
</td>
<td>
<%=rs1("startendTime")%>
</td>
<td>
<%=rs1("degree")%>
</td>
<td>
<%=rs1("workPlace")%>
</td>
<td>
<a href="MyProfile.asp?id=<%=rs1("id")%>" target="_blank" title="查看该教师的档案资料"><%=rs1("adder")%></a>
</td>
</tr>
<%
i = i + 1
rs1.MoveNext
loop
if i < 10 then
for j = 1 to (10 - i)
%>
<tr bgcolor="<%=TableBodyColor%>">
<td> </td>
<td> </td>
<td> </td>
<td> </td>
<td> </td>
</tr>
<%
next
end if
%>
<tr bgcolor="<%=TableLeftColor%>">
<td colspan="11">
<table cellSpacing="0" cellPadding="0" border="0" height="80%" width="100%" ID="Table10">
<tr>
<td align="right">
共有 <font color="red"><b>
<%=total%>
</b></font>条符合条件的资料
</td>
</tr>
</table>
</td>
</tr>
<%
end if
%>
</table>
<%
end sub
%>
<script language="javascript" src="../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../../copyright.htm" type="text/javascript"></script>
</body>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -