%
on Error Resume Next
'获取查询目标(ID)
IDnum=trim(Request.QueryString("ID"))
' Response.Write "
你要查询的是:" & IDnum &"的记录!
"
If IDnum="" Then
Response.End
End If
'打开数据库
CoStr="Driver={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("/chi/db/chiwhos.mdb")
Set Conn=Server.CreateObject("ADODB.Connection")
Conn.Open CoStr
CommandText="select * from man where ID like '" & IDnum & "'"
Set rs=Server.CreateObject("ADODB.Recordset")
rs.Open CommandText,Conn,1,1
tname = rs(1).Value
'页头
Response.Write ""
Response.Write "
" & rs(13).Value & " | "
Else
Response.write "" & rs(13).Value & " | "
End If
Response.write "
" & tname & "主要著作:
" ' ficount=rs.Fields.Count Response.write "| " & rs(I).Name & " | " ' Next Response.write "书名 | " Response.write "地点 | " Response.write "出版社 | " Response.write "年份 | " Response.write "页数 | " Response.write "版式 | " Response.write "北图编号 | " Response.write "合作者 | " Response.write "
| " & rs(I).Value & " | " ' Next Response.write "" & rs(1).Value & " | " Response.write "" & rs(2).Value & " | " Response.write "" & rs(3).Value & " | " Response.write "" & rs(4).Value & " | " Response.write "" & rs(5).Value & " | " Response.write "" & rs(6).Value & " | " Response.write "" & rs(7).Value & " | " Response.write "" & rs(8).Value & " | " Response.write "
" & tname & "学位论文:
" ' Response.write "| 论文类别 | " ' Response.write "作者姓名 | " ' Response.write "籍贯 | " Response.write "论文题目 | " Response.write "地点 | " Response.write "培养单位 | " Response.write "年份 | " Response.write "页码 | " Response.write "版式 | " Response.write "收藏号 | " Response.write "指导老师 | " Response.write "领域分类 | " Response.write "
| " & rs(0).Value & " | " For I=3 To 11 ' If I <>1 and I <>2 Then Response.write "" & rs(I).Value & " | " ' End if Next Response.write "
" & tname & "主要学术论文:
" ' Response.write "| 作者姓名 | " Response.write "论文题目 | " Response.write "期刊名 | " Response.write "年份 | " Response.write "页码 | " Response.write "收藏号 | " Response.write "合作者 | " Response.write "关键字 | " Response.write "
| " & rs(I).Value & " | " Next Response.write "