📄 main.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 conn
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "select * from dbo.teacher where tea_id='"&session("teacher")&"'"
conn.CursorType = 0
conn.LockType = 1
conn.Open()
%>
<p>您已经成功登录，请于20分钟内进行操作，超时将会自动登出系统，请重新登录。<br>
操作结束后务必退出本系统，并关闭浏览器。</p>
<p>您的帐户信息：</p>
<p>
编号：<% Response.Write(session("teacher")) %><br>
姓名：<% Response.Write(conn("tea_name")) %><br>
电话：<% Response.Write(conn("tea_tel")) %><br>
邮件：<% Response.Write(conn("tea_email")) %><br>
级别：<% If conn("tea_lv")=2 Then Response.Write("教授") Else Response.Write("讲师") End If%><br>
小组：
<%
Dim group
group=conn("tea_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")&" "
conn2.MoveNext
Loop
Set conn2 = Nothing
%>
小组编号：<% Response.Write(conn("tea_group")) %>
</p>
<p><a href="changepwd.asp"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 修改登录密码</a> <a href="changeinf.asp"> <img src="../image/cc.jpg" width="11" height="11" border="0" /> 修改用户信息</a></p>
<p>本组题目列表：</p>
<table width="700" border="0">
<tr>
<td>题目名称</td>
<td>面向专业</td>
<td>题目状态</td>
</tr>
<%
Dim conn3
Set conn3=Server.CreateObject("ADODB.RecordSet")
conn3.ActiveConnection = "DSN=hw;User ID=sa"
conn3.Source = "select * from dbo.works where works_group='"&group&"' ORDER BY works_state"
conn3.CursorType = 0
conn3.LockType = 1
conn3.Open()
do while not conn3.EOF
%>
<tr>
<td><a href="show.asp?id=<% Response.Write(conn3("works_id")) %>" title="<% Response.Write(conn3("works_content")) %>"><% Response.Write(conn3("works_title")) %></a></td>
<td><% Response.Write(conn3("works_speciality")) %></td>
<td>
<%
If conn3("works_state") = 1 Then
response.Write "审核中"
End If
If conn3("works_state") = 2 Then
response.Write "待选"
End If
If conn3("works_state") = 3 Then
response.Write "已选"
End If
%>
</td>
<%
conn3.MoveNext
Loop
Set conn3 = Nothing
%>
</tr></table>
<%
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 + -