|
<%
key = trim(request("key")) '//从客户端取得查询关键字
'/**
' *如果查询关键字为空，则列出数据库中所有的产品信息
' ** /
sql="select * from t_keyan "
if key<>"" then
sql = sql&" where ((awardtime like '%"&key&"%' or name like '%"&key&"%' or awardname like '%"&key&"%' or awardlist like '%"&key&"%') and type='教学优秀奖') "
else
sql = sql&" where (type='教学优秀奖') "
end if
sql = sql&" order by addtime desc"
'response.write sql
'response.end
set rs=server.CreateObject("adodb.recordset")
rs.open sql,conn,1,1
%>
|
数学与应用数学专业本科生课程拓扑图 |
 |
|
|
|
|
|
