<%@ Language=vbscript%>
<HTML>
<HEAD>
<meta name= "generator" content= "Microsoft Visual Studio 6.0" >
</HEAD>
<BODY>
<%
If Request.ServerVariables ("http_method") = "POST" and Request.Form ("Submit") <> "skip to" then
' If you submit the form content by post
Set Conn=server. CreateObject ("Adodb.connection")
Conn. Connectionstring= "Dsn=testsys"
Conn. Open
Strstid=request.form ("Stid")
Strstname=request.form ("Stname")
If Request.Form ("submit") = "Join" Then
' If a request to join student information is performed
Strsql= "SELECT * from Studentinfo where stid= '" & Strstid & "'"
' Studentinfo the student's record in the table of the database according to the student number to be added
Set Mrs1=conn. Execute (strSQL)
If not (mrs1. BOF and Mrs1. EOF) Then
' If the student number you want to join already exists, you are prompted to re-enter the information
Response.Write "The school number already exists, please re-enter the student information <br>"
Response.Write "<a href=taddstudent.asp?page=" & Request ("page") & "&stname=" & Strstname & " &stid= "& Strstid &" > Return </a> "
Else
' If the student number you want to join does not exist, add the student information to the database
