📄 tdealsearch.asp
字号:
<!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>
<style type="text/css">
<!--
body,td,th {
font-size: 14px;
color: #003399;
}
.style2 {
font-family: "华文行楷";
font-size: 24px;
color: #003366;
font-weight: bold;
}
a:link {
color: #003399;
text-decoration: none;
}
a:visited {
text-decoration: none;
color: #003399;
}
a:hover {
text-decoration: none;
color: #003399;
}
a:active {
text-decoration: none;
color: #003399;
}
-->
</style></head>
<body>
<!--#include virtual="../inc/head.htm"-->
<table border="1" width="60%">
<tr><th>符合条件的家教</th><th>发布信息内容</th></tr>
<%
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "Dbq=" & Server.Mappath("db/info.mdb") & ";Driver={Microsoft Access Driver (*.mdb)}"
strSql="select nick from teacherdetail "
subject=Request.Form("subject")
diploma=Request.Form("select")
sex=Request.Form("sex")
if subject<>"" then
strSql=strSql & "where (subject1 like '%" & subject & "%' or subject2 like '%" & subject & "%')"
End If
if diploma<>"" then
strSql=strSql & " and diploma='" & diploma & "'"
End If
if sex<>"" then
strSql=strSql & "and sex='" & sex & "'"
End If
strSql=strSql & " and state='待聘'"
Set rs=conn.Execute(strSql)
Do While Not rs.EOF
Response.Write("<tr><td><a href=teacherdetail.asp?name=" & rs("nick") & ">" & rs("nick") & "</a>")
strSql1="select content from teacherinfo where nick='" & rs("nick") & "' order by puttime desc"
Set rs1=conn.Execute(strSql1)
if Not rs1.EOF then
Response.Write("<td>" & rs1("content"))
End If
rs.MoveNext
Loop
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -