Editing: homework/add_stu.asp

<!--#INCLUDE FILE="connectdb.asp"--> <!--#include file="inc_cache_control.asp"--> <!--#include file="inc_access_control.asp"--> <!--#include file="chk_login.asp"--> <form name="form1" Action = "add_stu_form.asp" method="post"> <% username_stu=request.form("username_stu") password_stu=request.form("password_stu") name_stu=request.form("name_stu") surname_stu = request.form("surname_stu") %> <% sql_data="select * from student where username_stu='"&username_stu&"' " set ors_data=server.createobject("adodb.recordset") ors_data.open sql_data,conn,1,3 if not ors_data.eof then%> <SCRIPT LANGUAGE="JavaScript"> <% 'response.write "���ʫ��"&username_stu response.write"alert('�ѹ�֡���ͼ������');" response.write "window.location.href='add_stu_form.asp';" %> --> </SCRIPT> <% else sqldata="insert into student(username_stu,password_stu,name_stu,surname_stu) values('"&username_stu&"','"&_ password_stu&"','"&name_stu&"','"&_ surname_stu&"')" set orsdata = Server.CreateObject("adodb.recordset") orsdata.open sqldata,conn,1,3 response.write sqldata response.write "<meta http-equiv='refresh' content ='0;url=add_stu_form.asp'>" end if 'end if set conn = nothing 'ors_data.close %> </FORM>