<%@ language="vbscript"%>
<%response.Expires = 0%>

<!--#include file="conn.asp"-->
<%
set rs=server.createobject("adodb.recordset")
sqltext="select * from Manage_User where UserName='" & request.form("uid") & "' and PassWord='" & request.form("pwd1") & "'"
rs.open sqltext,conn,1,1

'查找數據庫，檢查此管理員是否已經存在
if rs.recordcount >= 1 then 
   if rs("UserName")=request.form("uid") then
      Response.Redirect "loginsb.asp?msg=此管理員帳號已經存在，請選用其它名稱!"
      response.end
      rs.close
   end if
end if


set rs=server.createobject("adodb.recordset")
sqltext="select * from Manage_User"
rs.open sqltext,conn,3,3

'添加一個管理員帳號到數據庫
rs.addnew
rs("UserName")=request.form("uid")
rs("PassWord")=request.form("pwd1")
rs.update
Response.Redirect "managerlist.asp"

%>