📄 regdb.asp
字号:
<%
'dim username,password,comname_c,comname_e,province,city_c,city_e,address_c,address_e,postcode,
' principal_c,principal_e,principal_fax,principal_phone,principal_email,oper_c,oper_e,oper_fax,oper_phone,oper_email,
' fina_c,fina_e,fina_fax,fina_phone,fina_email,main_dns_name,main_dns_ip,main_dns_os,ass_dns_name,ass_dns_ip,ass_dns_os
'取得数据
username=request.form("username")
password=request.form("passwd")
comname_c=request.form("comname_c")
comname_e=request.form("comname_e")
domain=request.form("domain")
domain_ip=request.form("domain_ip")
province=request.form("province")
city_c=request.form("city_c")
city_e=request.form("city_e")
address_c=request.form("address_c")
address_e=request.form("address_e")
postcode=request.form("postcode")
principal_c=request.form("prcp_c")
principal_e=request.form("prcp_e")
principal_fax=request.form("prcp_fax")
principal_phone=request.form("prcp_phone")
principal_email=request.form("prcp_email")
oper_c=request.form("oper_c")
oper_e=request.form("oper_e")
oper_fax=request.form("oper_fax")
oper_phone=request.form("oper_phone")
oper_email=request.form("oper_email")
fina_c=request.form("fina_c")
fina_e=request.form("fina_e")
fina_fax=request.form("fina_fax")
fina_phone=request.form("fina_phone")
fina_email=request.form("fina_email")
main_dns_name=request.form("main_dns_name")
main_dns_ip=request.form("main_dns_ip")
main_dns_os=request.form("main_dns_os")
ass_dns_name=request.form("ass_dns_name")
ass_dns_ip=request.form("ass_dns_ip")
ass_dns_os=request.form("ass_dns_os")
'开始数据库操作
Set conn=Server.CreateObject("ADODB.Connection")
conn.Open "driver={Microsoft Access Driver (*.mdb)}; DBQ=" & server.MapPath("../database/yino.mdb")
sql="select * from [main] where username='"&username&"'"
set rs=server.createobject("adodb.recordset")
rs.open sql,conn,3,3
if not rs.eof and not rs.bof or username="考普森" then
response.write "<center>对不起，用户名" & username & "已经有人使用，请选择其他用户名。<a href=reg.asp>返回</a></center>"
else
rs.addnew
rs("username")=username
rs("password")=password
rs("comname_c")=comname_c
rs("comname_e")=comname_e
rs("domain")=domain
rs("province")=province
rs("city_c")=city_c
rs("city_e")=city_e
rs("postcode")=postcode
rs("principal_c")=principal_c
rs("principal_e")=principal_e
rs("principal_fax")=principal_fax
rs("principal_phone")=principal_phone
rs("principal_email")=principal_email
rs("oper_c")=oper_c
rs("oper_e")=oper_e
rs("oper_fax")=oper_fax
rs("oper_phone")=oper_phone
rs("oper_email")=oper_email
rs("fina_c")=fina_c
rs("fina_e")=fina_e
rs("fina_fax")=fina_fax
rs("fina_phone")=fina_phone
rs("fina_email")=fina_email
rs("main_dns_domain")=main_dns_name
rs("main_dns_ip")=main_dns_ip
rs("main_dns_os")=main_dns_os
rs("assist_dns_domain")=ass_dns_name
rs("assist_dns_ip")=ass_dns_ip
rs("assist_dns_os")=ass_dns_os
rs("address_c")=address_c
rs("address_e")=address_e
rs.update
rs.close
conn.close
%>
<HTML><HEAD><TITLE>注册</TITLE>
<META content="text/html; charset=gb2312" http-equiv=Content-Type>
<STYLE type=text/css>TD {
FONT-FAMILY: "宋体"; FONT-SIZE: 9pt
}
.e_8 {
FONT-FAMILY: "Verdana"; FONT-SIZE: 8pt
}
.select {
BACKGROUND-COLOR: #ffffcc; COLOR: #000000
}
.input {
BACKGROUND-COLOR: #ffffff; BORDER-BOTTOM: #000000 1px solid; BORDER-LEFT: #000000 1px solid; BORDER-RIGHT: #000000 1px solid; BORDER-TOP: #000000 1px solid; COLOR: #ff0000
}
.x18 {
LINE-HEIGHT: 14pt
}
</STYLE>
<META content="MSHTML 5.00.3315.2870" name=GENERATOR></HEAD>
<BODY aLink=#990099 bgColor=#ffffff leftMargin=0 link=#0066ff text=#000000
topMargin=0 vLink=#cc0000>
<TABLE align=center bgColor=#000000 border=0 cellPadding=1 cellSpacing=0
width=640>
<TBODY>
<TR>
<TD>
<TABLE bgColor=#ffffff border=0 cellPadding=0 cellSpacing=0>
<TBODY>
<TR bgColor=#ffb41d>
<TD colSpan=3 height=12><IMG height=72
src="../images/paycentertop_01.gif"
width=174><IMG height=72
src="../images/paycentertop_02.gif"
width=168><IMG height=72
src="../images/paycentertop_03.gif"
width=158><IMG height=72
src="../images/paycentertop_04.gif"
width=140></TD></TR>
<TR>
<TD colSpan=3><IMG height=1
src="../images/paycenter_02.gif"
width=640></TD></TR>
<TR>
<TD bgColor=#ffffff vAlign=top><IMG height=35
src="../images/paycenter_03.gif" width=475>
<table width="98%" border="0" cellspacing="0" cellpadding="0" height="30">
<tr>
<td align="center">用户注册信息已提交，请您确认后返回！</td>
</tr>
</table>
<BR>
<TABLE align=center border=0 cellPadding=1 cellSpacing=0
width="98%" height="1342">
<TBODY>
<TR bgColor=#993300>
<TD height="1337">
<TABLE border=0 cellPadding=3 cellSpacing=1 height="1336">
<TBODY>
<TR>
<TD bgcolor="#cc6600" colSpan=2><font color="#ffffff"><b>用户信息：</b></font></TD>
</TR>
<TR>
<TD bgcolor="#FFCC33" height="22" width="29%">用户名称：</TD>
<TD bgcolor="#FFFFFF" width="71%"> <%=username%> </TD>
</TR>
<TR>
<TD bgcolor="#FFCC33" height="22" width="29%">用户密码：</TD>
<TD bgcolor="#FFFFFF" width="71%"> <%=password%></TD>
</TR>
<TD bgcolor="#cc6600" width="29%" height="28"><font
color=#ffffff><b>单位信息：</b></font></TD>
<TD bgcolor="#FFFFFF" width="71%" height="28"> </TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="29%"><FONT
color=#000000>单位名称：(中文)</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=comname_c%></TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="31%"><FONT
color=#000000>单位名称：(英文)</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=comname_e%></TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="31%"><FONT
color=#000000>公司域名</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=domain%></TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="31%"><FONT
color=#000000>公司域名IP</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=domain_ip%></TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="29%"><FONT
color=#000000>省份：</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=province%></TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="29%"><FONT
color=#000000>城市：(中文)</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=city_c%></TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="29%"><FONT
color=#000000>城市：(英文)</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=city_e%></TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="29%"><FONT
color=#000000>街道：(中文)</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=address_c%></TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="29%"><FONT
color=#000000>街道：(英文)</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=address_e%></TD>
</TR>
<TR>
<TD align=left bgColor=#ffcc33 width="29%"><FONT
color=#000000>邮政编码：</FONT></TD>
<TD bgColor=#ffffff width="71%"> <%=postcode%></TD>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -