<% 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 "" Response.Write "" Response.Write "" & tname & "简介" Response.Write "" Response.Write "" Response.write "
" & tname & "
" Response.write "" Response.write "" If rs(12).ActualSize<1 Then Response.write "" Else Response.write "" End If Response.write "" Response.write "

      " & rs(13).Value & "

      " & rs(13).Value & "

" rs.Close '下面开始在著作库中按名人码查找作品 ' CommandText="select * from thesis where 作者 like '" & tname & "'" CommandText="select * from writer where ChiswID like '" & IDnum & "'order by 年份,北图编号" ' Set rs=Server.CreateObject("ADODB.Recordset") rs.Open CommandText,Conn,1,1 If rs.RecordCount > 0 Then Response.Write "

" & tname & "主要著作:

" ' ficount=rs.Fields.Count Response.write "" Response.write "" ' For I=0 To ficount-2 ' Response.write "" ' Next Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" While Not rs.EOF Response.write "" ' For I=0 To ficount-2 ' Response.write "" ' Next Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" Response.write "" rs.MoveNext WEND Response.write "
" & rs(I).Name & "书名地点出版社年份页数版式北图编号合作者
" & rs(I).Value & "" & rs(1).Value & "" & rs(2).Value & "" & rs(3).Value & "" & rs(4).Value & "" & rs(5).Value & "" & rs(6).Value & "" & rs(7).Value & "" & rs(8).Value & "
" Response.Write "
本站共收录" & rs.RecordCount &"部主要著作!
" End If rs.Close '下面开始在学位论文库中按名人码查找论文 CommandText="select * from thesis where ChiswID like '" & IDnum & "'" ' Set rs=Server.CreateObject("ADODB.Recordset") rs.Open CommandText,Conn,1,1 If rs.RecordCount > 0 Then 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 "" Response.write "" Response.write "" Response.write "" While Not rs.EOF Response.write "" Response.write "" For I=3 To 11 ' If I <>1 and I <>2 Then Response.write "" ' End if Next Response.write "" rs.MoveNext WEND Response.write "
论文类别作者姓名籍贯论文题目地点培养单位年份页码版式收藏号指导老师领域分类
" & rs(0).Value & "" & rs(I).Value & "
" ' Response.Write "
共有" & rs.RecordCount &"个记录!
" End If rs.Close '下面开始在学术论文库中按名人码查找论文 CommandText="select * from paper where ChiswID like '" & IDnum & "'order by 年份" ' Set rs=Server.CreateObject("ADODB.Recordset") rs.Open CommandText,Conn,1,1 If rs.RecordCount > 0 Then 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 "" While Not rs.EOF Response.write "" For I=2 To 9 Response.write "" Next Response.write "" rs.MoveNext WEND Response.write "
作者姓名论文题目期刊名年份页码收藏号合作者关键字
" & rs(I).Value & "
" Response.Write "
本站共收录" & rs.RecordCount &"篇主要学术论文!
" End If rs.Close Set rs=nothing Set Conn=nothing Response.write "
" Response.write "" %>