📄 modifymember.jsp
字号:
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<%
String spath="wangye/ec.mdb";
String dbpath = application.getRealPath(spath);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver").newInstance();
String url="jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ="+dbpath;
Connection conn= DriverManager.getConnection(url,"","");
Statement stmt=conn.createStatement();
%>
<%
String username=(String)session.getAttribute("username");
ResultSet rs=stmt.executeQuery("select * from person where username='"+username+"'");
while(rs.next()){
String truename=rs.getString(3);
String password=rs.getString(4);
String address=rs.getString(5);
String postcode=rs.getString(6);
String cardno=rs.getString(7);
String tel=rs.getString(8);
String email=rs.getString(9);
%>
<html >
<head>
<title>无标题文档</title>
</head>
<body>
<table width="770" border="1" align="center">
<tr>
<th colspan="7" scope="col"><img src="../image/1.jpg" width="760" height="200" /></th>
</tr>
<tr>
<th width="104" height="40" background="../image/t1.jpg" scope="row"><table width="100" border="0">
<tr>
<th scope="col"><a href="../index.jsp">首页</a></th>
</tr>
</table></th>
<td width="104" background="../image/t1.jpg"><table width="100" border="0">
<tr>
<th scope="col"><a href="zhanshi.jsp">数码</a></th>
</tr>
</table></td>
<td width="104" background="../image/t1.jpg"><table width="100" border="0">
<tr>
<th scope="col">服装</th>
</tr>
</table></td>
<td width="104" background="../image/t1.jpg"><table width="100" border="0">
<tr>
<th scope="col">饰品</th>
</tr>
</table></td>
<td width="104" background="../image/t1.jpg"><table width="100" border="0">
<tr>
<th scope="col">家电</th>
</tr>
</table></td>
<td width="104" background="../image/t1.jpg"><table width="100" border="0">
<tr>
<th scope="col">食品</th>
</tr>
</table></td>
<td width="100" background="../image/t1.jpg"><table width="100" border="0">
<tr>
<th scope="col">日用</th>
</tr>
</table></td>
</tr>
</table>
<table width="770" border="1" align="center">
<tr>
<th width="754" bgcolor="#A6BBFC" scope="col" ><marquee direction="left" scrollamount="1" scrolldelay="1" onMouseOver="this.stop();" onMouseOut="this.start();">
<%if(username==null || username==""){%>
<font color="#330000">顾客您好！购买商品请先登录</font> <a href="../zhuce.jsp" >[新用户注册]</a>
<%}else{%><%=username%> <font color="#330000">您好! 电子商务交易平台欢迎您!</font>
<%}%>
</marquee></th>
</tr>
</table>
<table width="770" border="1" align="center">
<tr>
<th width="770" rowspan="2" bgcolor="#FFFACE">
<form action="modifyMember_deal.jsp" method="post" name="myform">
<table width="100%" border="0" cellspacing="-2" cellpadding="-2">
<tr>
<td width="18%" height="30" align="center">用 户 名：</td>
<td width="82%" ><%=username%>
</td>
</tr>
<tr>
<td height="28" align="center">真实姓名：</td>
<td height="28"><input name="truename" type="text" maxlength="20" value="<%=truename%>">
*</td>
</tr>
<tr>
<td height="28" align="center">密 码：</td>
<td height="28"><input name="pwd" type="password" size="20" maxlength="20" value="<%=password%>">
*密码长度为4-16位</td>
</tr>
<tr>
<td height="28" align="center">确认密码：</td>
<td height="28"><input name="pwd1" type="password" size="20" maxlength="20" value="<%=password%>">
*</td>
</tr>
<tr>
<td height="28" align="center">联系地址：</td>
<td ><input name="address" type="text"size="50" value="<%=address%>">
*</td>
</tr>
<tr>
<td height="28" align="center">邮政编码：</td>
<td ><input name="postcode" type="text" size="20" value="<%=postcode%>">
*</td>
</tr>
<tr>
<td height="28" align="center">身份证号：</td>
<td><input name="cardno" type="text" value="<%=cardno%>">
*</td>
</tr>
<tr>
<td height="28" align="center">联系电话：</td>
<td><input name="tel" type="text" value="<%=tel%>">
*</td>
</tr>
<tr>
<td height="28" align="center" >Email：</td>
<td ><input name="email" type="text" size="50" value="<%=email%>">
*</td>
</tr>
<tr>
<td height="34"> </td>
<td ><input name="Button" type="submit" value="确定保存">
<input name="Submit2" type="reset" value="重新填写">
<input name="Submit22" type="button" value="返回" onClick="window.location.href='../index.jsp'"> </td>
</tr>
</table>
</form></th>
</tr>
</table>
<table width="770" border="1" align="center">
<tr>
<th background="../image/2.jpg" scope="col"><br>
<p><a href="#"><font size="2">关于我们</font></a>
<font size="2"> |
<a href=# onclick="">加入收藏</a> | <a href=# onClick="">设为首页</a> | <a href="#">请您留言</a><br><br>
电子商务交易平台 版权所有</font></p><br>
</th>
</tr>
</table>
</body>
</html>
<% }
stmt.close();
conn.close();
%>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -