注:confirm('')中的内容必须是用“单引号”括起来.
sqlin="declare @maxid numeric(4) select @maxid=max(id) from teacher insert into teacher(id,teachnum,name,pwd,sex,phone,email) values((@maxid+1),'"&trim(request("teachnum"))&"','"&trim(request("name"))&"','"&trim(request("pwd"))&"','"&trim(request("sex"))&"','"&trim(request("phone"))&"','"&trim(request("email"))&"')"
set rs=conn.execute(sqlin)
%>