⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 addobjectfinish.asp

📁 一个网上的考试系统
💻 ASP
字号:
🔍 
<!--#include file ="../include.asp"-->
<% 
	StartPage "增加科目确认首页",2
%>

<!--
<HTML>
<HEAD>
<META NAME="GENERATOR" Content="Microsoft Visual Studio 6.0">
</HEAD>
<link rel="stylesheet" type="text/css" href="../default.css">
<BODY  leftmargin=150 rightmargin=150 topmargin=30>
<IMG src="../images/title.JPG" border=0>
<hr>
<br>
-->
<%
	Object = Request.Form("Object")
%>
<table  align=center border="1" cellpadding="0" cellspacing="0" style="BORDER-COLLAPSE: collapse" bordercolor="lightskyblue" width="90%">
	<tr>
		<td  height=20  bgcolor=LightSkyBlue></td>
	</tr>
	
	<tr>
		<td  align=center>
			<table  border=0 width=90%>
				<tr>
					<td  align=center  colspan=2><font  size=7  color=LightSkyBlue >管理员增加科目页</font></td>
				</tr>
				
				<tr>
					<td  align=left><b><font  size=5  color=LightSkyBlue>增加流程</font></b></td>
					<td></td>
				</tr>
				
				<tr>
					<td  align=center>
						<b><font  size=5  color=LightSkyBlue>输入科目</font></b>
					</td>
					<td align=center>
					<%
						set conn = Server.CreateObject ("adodb.connection")
						conn.Open "NetExamine","sa",""
						set userconn = Server.CreateObject ("adodb.recordset")	
						sqlstr = "select * from 科目表 where 科目名 = '" &Object& "'"
						userconn.Open sqlstr,conn
						
						if not userconn.EOF then
							Response.Write "<center><font size = 3 color=LightSkyBlue>您所输入的课程名已经有人存在<br>请返回重新输入</font></center>"
							Response.Write"<br><br><center><a href =Add_Object.asp>返回</a></center>"
						else
							userconn.Close ()
							sqlstr ="insert into 科目表 values('"&Object&"')"
							userconn.Open sqlstr,conn
							
							Object = Object +"题目表"
							sqlstr ="create table "&Object&" (索引号 INT IDENTITY(1,1) NOT FOR REPLICATION,题目名 char(20),题目描述 char(100),题目总分 int,小题得分 int)"
							userconn.Open sqlstr,conn
							'userconn.Close()
							Response.Write "<center><font size = 5 color=LightSkyBlue>您所已经成功的增加了这个科目</font></center>"
							Response.Write"<br><br><center><a href =AdminFunction.asp>返回功能页</a></center>"
							
						end if
						'userconn.Close ()
						conn.Close()
					%>					
					</td>
				</tr>
				
				<tr>
					<td  align=center><font  size=5  color=LightSkyBlue>确认增加</b></td>
					<td></td>
				</tr>
				
				<tr>
					<td align=center><b></td>
					<td  align=center></td>
				</tr>
			</table>
		</td>
	</tr>
	
	<tr>
		<td  height=20  bgcolor=LightSkyBlue></td>
	</tr>
</table>
<% 
	EndPage
%>
<!--
<br>
<hr>
<center>
<font  size=2>
欢迎来到本网站，最佳分辨率：800×600
<br>如果有困难请与我联系：FD_FYY@hotmail.com
</font>
</BODY>
</HTML>
-->

⌨️ 快捷键说明

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