📄 modifydb.asp
字号:
<!--#include file ="../profile/checkmanager.asp"-->
<%
if request("isSub")="" then
response.redirect "errorpage.asp?id=unknow"
else
'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("username")
password=request("password")
comname_c=request("comname_c")
comname_e=request("comname_e")
province=request("province")
city_c=request("city_c")
city_e=request("city_e")
address_c=request("address_c")
address_e=request("address_e")
postcode=request("postcode")
principal_c=request("prcp_c")
principal_e=request("prcp_e")
principal_fax=request("prcp_fax")
principal_phone=request("prcp_phone")
principal_email=request("prcp_email")
oper_c=request("oper_c")
oper_e=request("oper_e")
oper_fax=request("oper_fax")
oper_phone=request("oper_phone")
oper_email=request("oper_email")
fina_c=request("fina_c")
fina_e=request("fina_e")
fina_fax=request("fina_fax")
fina_phone=request("fina_phone")
fina_email=request("fina_email")
main_dns_name=request("main_dns_name")
main_dns_ip=request("main_dns_ip")
main_dns_os=request("main_dns_os")
ass_dns_name=request("ass_dns_name")
ass_dns_ip=request("ass_dns_ip")
ass_dns_os=request("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,1,3
if rs.eof and rs.bof then
response.redirect "errorpage.asp?id=userunknow"
else
rs("password")=password
rs("comname_c")=comname_c
rs("comname_e")=comname_e
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
session("password")=password
end if
%>
<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>
<div align="center"><img src="../images/enuologo.gif" width="468" height="60"></div>
</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="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>
</TR>
<TR>
<TD align=left bgColor=#cc6600 width="29%"><FONT
color=#ffffff><B>负责人信息：</B></FONT></TD>
<TD bgColor=#ffffff width="71%"> </TD>
</TR>
<TR>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -