📄 show.asp

📁 本系统基于WEB
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>浏览选题详细信息|毕业设计选题系统</title>
<link href="../css/Style.css" rel="stylesheet" type="text/css" />
</head>

<BODY leftMargin=0 topMargin=0 marginwidth="0">
  <!--#include file=../top.asp-->
  <!--#include file=top.asp-->
<div align="center"><td><table width="768" border="0" bgcolor="#FFFFFF"><tr><td><div align="left">
<%
Dim WID
WID = Request.QueryString("id")
Dim conn
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "select * from dbo.works where works_id = '"&WID&"'"
conn.CursorType = 0
conn.LockType = 1
conn.Open()
If conn.eof or conn.bof Then
  Response.Write("请求错误，未找到该条目。<br><a href='../index.asp'>点击此处返回首页</a>")
Else
%>
  <p>题目名称：<%Response.Write( conn("works_title"))%></p>
  <p>详细介绍：<%Response.Write( conn("works_content"))%></p>
  <p>面向专业：<%Response.Write( conn("works_speciality"))%></p>
  <p>指导教师：<% 
  Dim group
  group=conn("works_group")
  Dim conn2
  Set conn2=Server.CreateObject("ADODB.RecordSet")
  conn2.ActiveConnection = "DSN=hw;User ID=sa"
  conn2.Source = "select * from dbo.teacher where tea_group='"&group&"' ORDER BY tea_lv DESC"
  conn2.CursorType = 0
  conn2.LockType = 1
  conn2.Open()
  do while not conn2.EOF 
  response.Write conn2("tea_name")&"&nbsp;"
  conn2.MoveNext
  Loop
  Set conn2 = Nothing
  %>
  </p>
  <%
  If conn("works_state") = 1 Then response.Write ("此题目尚未通过管理员审核") End If
  If conn("works_state") = 2 Then response.Write ("此题目尚未有人选报") End If
  If conn("works_state") = 3 Then
  Dim who
  who=conn("works_group")
  Dim conn3
  Set conn3=Server.CreateObject("ADODB.RecordSet")
  conn3.ActiveConnection = "DSN=hw;User ID=sa"
  conn3.Source = "select * from dbo.student where stu_works='"&WID&"'"
  conn3.CursorType = 0
  conn3.LockType = 1
  conn3.Open()
  %>
  此课题已经被&nbsp;<a href="student.asp?id=<%Response.Write( conn3("stu_id"))%>"><%Response.Write( conn3("stu_speciality"))%>&nbsp;<%Response.Write( conn3("stu_class"))%>&nbsp;<%Response.Write( conn3("stu_name"))%></a>&nbsp;选报。
  <%
  Set conn3 = Nothing
  End If
End If
%>
<%
conn.Close()
Set conn = Nothing
%>
</div></td></tr></table></td></div>
  <!--#include file=botton.asp-->
  <!--#include file=../botton.asp-->
</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -