📄 choice.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 ID
ID = Request.QueryString("id")
Dim conn
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "select * from dbo.student where stu_id='"&ID&"'"
conn.CursorType = 0
conn.LockType = 1
conn.Open()
%>
<p>正在为 <% response.Write conn("stu_name") %> 选报题目</p>
<%
conn.Close
Set conn = Nothing
%>
<table width="800" border="0">
<%
Dim conn5
Set conn5=Server.CreateObject("ADODB.RecordSet")
conn5.ActiveConnection = "DSN=hw;User ID=sa"
conn5.Source = "select * from dbo.works where works_state = 2 ORDER BY works_group"
conn5.CursorType = 0
conn5.LockType = 1
conn5.Open()
%>
<tr><td>小组</td><td>题目</td><td>面向专业</td><td>状态</td><td>功能选项</td></tr>
<% do while not conn5.EOF %>
<tr>
<td>
<%
Dim group3
group3=conn5("works_group")
Dim conn6
Set conn6=Server.CreateObject("ADODB.RecordSet")
conn6.ActiveConnection = "DSN=hw;User ID=sa"
conn6.Source = "select * from dbo.teacher where tea_group='"&group3&"' ORDER BY tea_lv DESC"
conn6.CursorType = 0
conn6.LockType = 1
conn6.Open()
do while not conn6.EOF
response.Write conn6("tea_name")&" "
conn6.MoveNext
Loop
Set conn6 = Nothing
%>
</td>
<td><% response.Write conn5("works_title") %></td>
<td><% response.Write conn5("works_speciality") %></td>
<td><% If conn5("works_state") = 1 Then response.Write ("审核中") End If
If conn5("works_state") = 2 Then response.Write ("待选") End If
If conn5("works_state") = 3 Then response.Write ("已选") End If %></td>
<td><a href="choice2.asp?id=<% response.Write ID %>&works=<% response.Write conn5("works_id") %>"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 选报</a></td>
</tr>
<%
conn5.MoveNext
Loop
conn5.Close
Set conn5 = Nothing
%>
</table>
</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 + -