📄 adduser.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<% String cuid= (String) session.getValue("cuid");
if((cuid==null)|(cuid=="")){
out.print("<SCRIPT language=JavaScript>alert('操作超时，请重新登录！');");
out.print("this.location.href='../system.jsp';</SCRIPT>");
}
%>
<%@ include file="../conn.jsp"%>
<%!
String replacenull(String a){
if(a==null){
return "";
}else{
return a;
}
}
String selected(String a,String b){
if(a==null){
return "";
}
if(a.equals(b)){
return "selected";
}else{
return "";
}
}
%>
<%
request.setCharacterEncoding("gb2312");
String uname= (String) session.getValue("cuid");
String sql="select * from scott.company where uname='"+uname+"'";
ResultSet rs=stmt.executeQuery(sql);
if(rs.next()){
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" href="../inc/register.css" type="text/css">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>订票—>详细资料</title>
</head>
<SCRIPT language=JavaScript src="../inc/validate.js"></SCRIPT>
<SCRIPT language=JavaScript src="../inc/companyreg.js"></SCRIPT>
<FORM name=register action=register.jsp method=post>
<body topmargin="0" leftmargin="0">
<%@ include file="../inc/top2.htm"%>
<div align="center">
<center>
<table border="0" cellpadding="0" cellspacing="0" width="780" height="61">
<tr>
<td width="778" height="18" valign="top" colspan="5" bgcolor="#5388C1">
</td>
</tr>
<tr>
<td width="139" valign="top" bgcolor="#5388C1">
<div align="center">
<table border="0" cellpadding="0" cellspacing="0" width="118" height="280">
<tr>
<td width="100%" height="163" background="../images/stat-bg.GIF" valign="top">
<p align="center"><br>
<a href="main.jsp"返回首页</a><br>
<br>
<a href="adduser.jsp">更新用户资料</a><br>
<br>
<a href="publish.jsp">发布/更新票务信息</a><br>
<br>
<a href="../changepwd.jsp?stype=company" target="_blank">修改登录密码</a><br>
<br>
<a href="search.jsp">全部车票列表</a>
</td>
</tr>
<tr>
<td width="100%" height="117" background="../images/stat-bg.GIF" valign="top">
<p align="center"><br>
<br>
<a href="../exit.jsp">退出登录</a>
</td>
</tr>
</table>
</div>
<p align="center"> </td>
<td width="31" height="325" valign="top"><img border="0" src="../images/selfk.GIF"></td>
</center>
<td width="481" height="325">
<div align="left">
<table border="1" cellpadding="0" cellspacing="0" width="94%" height="263" bordercolor="#FFFFFF" bordercolorlight="#FFFFFF" bordercolordark="#FFFFFF">
<tr>
<td width="100%" height="18" valign="bottom" bgcolor="#C6CEDE" bordercolor="#000000" bordercolorlight="#000000" bordercolordark="#FFFFFF">
<p align="center">=== 用户资料 ===</td>
</tr>
<tr>
<td width="100%" height="20" valign="bottom">
用户名:<FONT COLOR="#FF0000"><%=uname%></FONT> </td>
</tr>
<tr>
<td width="100%" height="28" valign="bottom">
所在城市:<B><SELECT size=1 name=area>
<OPTION>请在以下列表中选择</OPTION>
<OPTION value=北京市 <%=selected(rs.getString("area"),"北京市")%>>北京市
<OPTION value=天津市 <%=selected(rs.getString("area"),"天津市")%>>天津市
<OPTION value=上海市 <%=selected(rs.getString("area"),"上海市")%>>上海市
<OPTION value=重庆市 <%=selected(rs.getString("area"),"重庆市")%>>重庆市
<OPTION value=安徽省 <%=selected(rs.getString("area"),"安徽省")%>>安徽省
<OPTION value=福建省 <%=selected(rs.getString("area"),"福建省")%>>福建省
<OPTION value=甘肃省 <%=selected(rs.getString("area"),"甘肃省")%>>甘肃省
<OPTION value=广东省 <%=selected(rs.getString("area"),"广东省")%>>广东省
<OPTION value=四川省 <%=selected(rs.getString("area"),"四川省")%>>四川省
<OPTION value=贵州省 <%=selected(rs.getString("area"),"贵州省")%>>贵州省
<OPTION value=湖北省 <%=selected(rs.getString("area"),"湖北省")%>>湖北省
<OPTION value=湖南省 <%=selected(rs.getString("area"),"湖南省")%>>湖南省
<OPTION value=吉林省 <%=selected(rs.getString("area"),"吉林省")%>>吉林省
<OPTION value=江苏省 <%=selected(rs.getString("area"),"江苏省")%>>江苏省
<OPTION value=江西省 <%=selected(rs.getString("area"),"江西省")%>>江西省
<OPTION value=辽宁省 <%=selected(rs.getString("area"),"辽宁省")%>>辽宁省
<OPTION value=青海省 <%=selected(rs.getString("area"),"青海省")%>>青海省
<OPTION value=山东省 <%=selected(rs.getString("area"),"山东省")%>>山东省
<OPTION value=山西省 <%=selected(rs.getString("area"),"山西省")%>>山西省
<OPTION value=陕西省 <%=selected(rs.getString("area"),"陕西省")%>>陕西省
<OPTION value=云南省 <%=selected(rs.getString("area"),"云南省")%>>云南省
<OPTION value=浙江省 <%=selected(rs.getString("area"),"浙江省")%>>浙江省
<OPTION value=黑龙江省 <%=selected(rs.getString("area"),"黑龙江省")%>>黑龙江省
</SELECT></B>
</td>
</tr>
<tr>
<td width="100%" height="28" valign="bottom">
性别;<input type="text" name="fund" size="6" maxLength=6 value="<%=replacenull(rs.getString("fund"))%>"></td>
</tr>
<tr>
<td width="100%" height="28" valign="bottom" bgcolor="#F3F3F3">
通讯地址:<input type="text" name="address" size="30" maxLength=40 value="<%=replacenull(rs.getString("address"))%>">
</td>
</tr>
<tr>
<td width="100%" height="28" valign="bottom">
邮政编码;<input type="text" name="zip" size="6" size="6" maxLength=6 value="<%=replacenull(rs.getString("zip"))%>">
</td>
</tr>
<tr>
<td width="100%" height="28" valign="bottom" bgcolor="#F3F3F3">
<p align="left"> 联系人: <input type="text" name="pname" size="20" maxLength=20 value="<%=replacenull(rs.getString("pname"))%>">
</p></td>
</tr>
<tr>
<td width="100%" height="28" valign="bottom">
联系电话:<input type="text" name="phone" size="20" maxLength=40 value="<%=replacenull(rs.getString("phone"))%>">
</td>
</tr>
<tr>
<td width="100%" height="28" valign="bottom" bgcolor="#F3F3F3">
<p align="left"> 传真号码:<input type="text" name="fax" size="20" maxLength=40 value="<%=replacenull(rs.getString("fax"))%>">
</p></td>
</tr>
<tr>
<td width="100%" height="28" valign="bottom">
电子信箱:<input type="text" name="email" size="20" maxLength=40 value="<%=replacenull(rs.getString("email"))%>">
</td>
</tr>
<tr>
<td width="100%" valign="top">
<p align="center"><br>
备注:<br>
<br>
<textarea rows="9" name="jianj" cols="62" style="background-color: #F3F3F3; color: #000060"><%=replacenull(rs.getString("jianj"))%></textarea>
</p>
<p align="center"><input type="button" value="确 定" <%if(rs.getString("cname")!=null){ %>onClick="checkmod()"<%}else{%>onClick="check()"<%}%>>
<br>
<br>
</p></td>
</tr>
</table>
</div>
</td>
<center>
<td width="1" height="325" valign="top" bgcolor="#00006A"></td>
<td width="122" height="325" valign="top" bgcolor="#F3F3F3"> </td>
</tr>
<tr>
<td width="778" height="1" valign="top" colspan="5" bgcolor="#5388C1">
<p align="center"> </td>
</tr>
<tr>
<td width="778" height="3" valign="top" colspan="5">
<p align="center">
</td>
</tr>
<tr>
<td width="778" height="7" valign="top" colspan="5">
<p align="center"><script language="javascript" src="../inc/copyright.js"></script>
</td>
</tr>
<tr>
<td width="778" height="3" valign="top" colspan="5">
</td>
</tr>
</table>
</center>
</div>
</form>
<% }%>
</body>
</html>
<%
request.setCharacterEncoding("GB2312");
String pname =request.getParameter("pname");
if(pname!=null){
String cxz =request.getParameter("cxz");
String area =request.getParameter("area");
String fdate =request.getParameter("fdate");
String fund =request.getParameter("fund");
String cname =request.getParameter("cname");
String address =request.getParameter("address");
String zip =request.getParameter("zip");
String phone =request.getParameter("phone");
String fax =request.getParameter("fax");
String email =request.getParameter("email");
String http =request.getParameter("http");
String jianj =request.getParameter("jianj");
String trade =request.getParameter("trade");
if(fund==null){
fund="未知";
}
if(cname==null){
cname=rs.getString("cname");
}
if(fax==null){
fax="未知";
}
if(http==null){
http="http://";
}
stmt.executeUpdate("update scott.company set trade='"+trade+"',cxz='"+cxz+"',area='"+area+"',fdate='"+fdate+"' ,cname='"+cname+"',fund='"+fund+"' ,pname='"+pname+"' ,address='"+address+"',zip='"+zip+"',phone='"+phone+"',fax='"+fax+"',email='"+email+"',jianj='"+jianj+"',http='"+http+"' where uname='"+uname+"'");
out.print("<SCRIPT language=JavaScript>alert('修改成功！');");
out.print("javascript:document.location='main.jsp';</SCRIPT>");
}%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -