📄 cancel.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>
</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">
<tr>
<td><div align="left">
<%
Dim PWD
PWD = Request.Form("textfield")
Dim conn
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "select * from dbo.student where stu_id='"&session("student")&"'"
conn.CursorType = 1
conn.LockType = 3
conn.Open()
If conn("stu_pass")=PWD then
Dim conn2
Set conn2=Server.CreateObject("ADODB.RecordSet")
conn2.ActiveConnection = "DSN=hw;User ID=sa"
conn2.Source = "update dbo.works set works_state='2' where works_id='"&conn("stu_works")&"'"
conn2.CursorType = 1
conn2.LockType = 3
conn2.Open()
Set conn = Nothing
set conn2=Nothing
Set conn=Server.CreateObject("ADODB.RecordSet")
conn.ActiveConnection = "DSN=hw;User ID=sa"
conn.Source = "update dbo.student set stu_works='0000' where stu_id='"&session("student")&"'"
conn.CursorType = 1
conn.LockType = 3
conn.Open()
Set conn = Nothing
%>
您已经放弃了您所选的题目<br>
现在您可以<a href="list.asp"> <img src="../image/cc.jpg" border="0"/> 重新选择</a> 其它题目。
<% Else %>
您输入的密码错误，<a href="javascript:history.back()"><img src="../image/cc.jpg" border="0"/> 点击这里重新输入</a><br>如果当前登录的用户不是您，请勿尝试修改他人选题。
<%
conn.Close()
Set conn = Nothing
End if
%>
</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 + -