?? answer.asp
字號:
<HTML>
<HEAD>
<TITLE><%=title%></TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<link rel="stylesheet" type="text/css" href="css/index1.css">
<link rel="stylesheet" type="text/css" href="css/toolbar2.css">
<META content="Microsoft FrontPage 4.0" name=GENERATOR>
<base target="_self">
</HEAD>
<BODY background="image/A-bg.gif" leftMargin=0 topMargin=0>
<p> </p>
<%
questionid=Request("questionid")
userid=request("userid")
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)};dbq=" & Server.MapPath("CSTUDY.mdb")
set rs= server.createobject("adodb.recordset")
sql="select * from answer where id1="&questionid&""
Set rs=conn.execute(sql)
sql4="select * from question where ID="&questionid&""
Set rs4=conn.execute(sql4)
questiontitle=rs4("title")
Do While Not rs.Eof %>
<TABLE border="1" width="514" align="center" bordercolorlight="#000000" bordercolordark="#FFFFFF" cellspacing="0" cellpadding="5" bgcolor="#A4D1FF" height="282">
<TR>
<TD align=center width="137" height="9">
<font color="#FF0000">
提問人：</font></TD>
<TD align=center width="98" height="9">
<%sql1="select * from user where ID="&userid&""
set rs1=conn.execute(sql1)
%>
<a href="viewuser.asp?userid=<%=rs1("ID")%>" title="點擊查看用戶信息" target="_blank"><%=rs1("name")%></a>
</TD>
<TD align=center width="83" height="9"><font color="#FF0000">回答時間：</font></TD>
<TD align=center width="146" height="9"><%=rs("refer")%></TD>
</TR>
<TR>
<TD align=center width="137" height="21">
<font color="#FF0000">
標題：</font></TD>
<TD align=center width="327" height="21" colspan="3">
<%dim x,str_title
x=questiontitle
if len(x)>25 then
str_title=left(x,25)&"…"
else
end if%>
<a href="questiondetail.asp?id=<%=rs("id1")%>"><%=str_title%></a></TD>
</TR>
<TR>
<TD align=center width="137" height="11">
<font color="#FF0000">
所屬章節：</font></TD>
<TD align=center width="327" height="11" colspan="3">
<%
sql2="select * from tutorial where ID="&rs4("id2")&""
set rs2=conn.execute(sql2)
%>
<%=rs2("rule")%> <%=rs2("title")%>
</TD>
</TR>
<tr>
<TD align=center width="137" height="160" rowspan="2">
<font color="#FF0000">
回答：</font></TD>
<TD align=left width="327" height="145" colspan="3" valign="top">
<textarea rows="9" name="content" cols="54" class="td1" readonly>
<%=rs("content")%>
</textarea></TD>
</tr>
<tr>
<TD align=left width="327" height="7" colspan="3" valign="top">
<%sql3="select * from teacher where ID="&rs("id2")&""
set rs3=conn.execute(sql3)
%>
<p align="center">本問題由<a href="viewteacher.asp?userid=<%=rs("id2")%>" target="_blank"><%=rs3("name")%>老師</a>回答</TD>
</tr>
<tr>
<TD align=center width="396" height="6" colspan="4"><a href="viewquestion.asp?userid=<%=userid%>" target="_blank">查看該用戶所有問題</a></TD>
</tr>
<tr>
<TD align=center width="396" height="9" colspan="4"><a href="viewquestion.asp?chapterid=<%=rs4("id2")%>" target="_blank">查看該章節所有問題</a></TD>
</tr>
</TABLE>
<%rs.MoveNext
Loop
%>
<p></p>
<center><a href="javascript:onClick= window.close()">關閉窗口</a></center>
</body>
</html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -