<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 PWD
Dim ID
PWD = Request.Form("textfield1")
ID = Request.Form("hiddenField1")
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 = 0毕业论文http://www.Lwfree.cn/ 论文网http://www.Lwfree.com/
conn.LockType = 1
conn.Open()
if conn("stu_pass")=PWD then
if conn("stu_works")="0" then
Dim conn2
Set conn2=Server.CreateObject("ADODB.RecordSet")
conn2.ActiveConnection = "DSN=hw;User ID=sa"
conn2.Source = "select * from dbo.works where works_id='"&ID&"'"
conn2.CursorType = 0
conn2.LockType = 1
conn2.Open()
if conn2("works_state") = 2 then
conn2.close()
conn2.Source = "update dbo.works set works_state= 3 where works_id='"&ID&"'"
conn2.CursorType = 1
conn2.LockType = 3
conn2.Open()
conn.close()
conn.Source = "update dbo.student set stu_works='"&ID&"' where stu_id='"&session("student")&"'"
conn.CursorType = 1
conn.LockType = 3
conn.Open()
Response.Write("选题成功，<a href='main.asp'>点击这里刷新您的信息</a>")
else
Response.Write("此课题已经被选报，您无法选报这个题目，<a href='list.asp'>点击此处浏览所有可选课题</a>")
end if
Set conn2 = Nothing
上一页 [1] [2] [3] [4] [5] [6] [7] [8] [9]