⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 member.jsp

📁 用JSP写的一个在线购物网站的代码
💻 JSP
字号:
<%
sql="select * from manager where name='"+member+"'";
rs=data.executeQuery(sql);
if(rs.next())
{
String pwd=rs.getString("pwd");
String pwdquery=rs.getString("pwdquery");
String pwdanswer=rs.getString("pwdanswer");
String sex=rs.getString("sex");
String realname=rs.getString("realname");
String email=rs.getString("email");
String address=rs.getString("address");
String tel=rs.getString("tel");
String brith=rs.getString("brith");
String IDcard=rs.getString("IDcard");
String zipcode=rs.getString("zipcode");
rate=rs.getString("rate");
if(rate.equals("0"))
{ rate="普通会员"; }
if(rate.equals("1"))
{ rate="VIP会员"; }
int whetherShop=rs.getInt("whetherShop");
int preordainShop=rs.getInt("preordainShop");
String regTime=rs.getString("regTime").substring(0,16);
String lastTime=rs.getString("lastTime").substring(0,16);
String mode=rs.getString("mode");
%>
<script language="JavaScript">
function check()
{
  if(document.update.newpwd.value.length!=0)
  {
     if(document.update.newpwd.value.length<6 || document.update.newpwd.value.length>10)
	 {
	     alert("请检查您新密码的位数是否在6和10之间");
		 document.update.newpwd.focus();
		 return false;
	 }
  }
  if(document.update.newpwd.value!=document.update.repwd.value)
  {
     alert("请检查您两次输入的新密码是否相同");
	 document.update.repwd.focus();
	 return false;
  }
}
</script>
					  <table width="500" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#CCCCCC">
                          <tr bgcolor="#CCCCCC"> 
                            <td height="25" colspan="2" bgcolor="#63bce6"><div align="center" class="defaulttext">修改资料</div></td>
                          </tr>
                          <form method="post" action="upmem.jsp" name="update" onSubmit="return check()">
                            <input type="hidden" name="name" value="<%=member%>">
                            <tr bgcolor="#F2F2F2"> 
                              <td colspan="2" bgcolor="#F2F2F2"> 
                                <table width="450" border="0" align="center" cellpadding="0" cellspacing="0" class="defaultinput">
          <tr> 
            <td height="15" colspan="3"><div align="center"><span class="bluetextbg"> 
                </span> </div></td>
          </tr>
          <tr> 
            <td height="25" width="140"> <div align="right">用户名称:</div></td>
            <td width="10">&nbsp;</td>
            <td height="25" width="350"> <font color="#FF0000"><%=member%></font></td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">旧密码:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input type="password" name="pwd2" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" size="15" maxlength="10" value="<%=pwd%>"></td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">新密码:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input type="password" name="newpwd" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" size="15" maxlength="10"> 
              <font color="#FF0000">  如果不想修改密码请保留为空</font></td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">重复新密码:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input type="password" name="repwd" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" size="15" maxlength="12"> 
            </td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">密码提示问题:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <select name="pwdquery" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <option value='<%=pwdquery%>' selected><%=pwdquery%></option>
                <%
					                    sql="select * from pwdquery";
					                    rs=data.executeQuery(sql);
					                    pwdquery="";
					                    while(rs.next())
					                    {
					                    pwdquery=rs.getString("pwdquery");
					                    %>
                <option value='<%=pwdquery%>'><%=pwdquery%></option>
                <%}%>
              </select></td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">密码提示答案:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input name="pwdanswer" type="text" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=pwdanswer%>" size="20" maxlength="10"> 
            </td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">性别:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <%if(sex.equals("先生")){%> <input type="radio" name="sex" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="先生" checked>
              先生 
              <input type="radio" name="sex" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="女士">
              女士 
              <input type="radio" name="sex" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="保密">
              保密 
              <%}%> <%if(sex.equals("女士")){%> <input type="radio" name="sex" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="先生">
              先生 
              <input type="radio" name="sex" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="女士" checked>
              女士 
              <input type="radio" name="sex" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="保密">
              保密 
              <%}%> <%if(sex.equals("保密")){%> <input type="radio" name="sex" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="先生">
              先生 
              <input type="radio" name="sex" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="女士">
              女士 
              <input type="radio" name="sex" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="保密" checked>
              保密 
              <%}%> </td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">真实姓名:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input name="realname" type="text" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva," value="<%=realname%>" size="20" maxlength="10"> 
            </td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">电子邮件:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input name="email" type="text" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=email%>" size="20" maxlength="50"> 
            </td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">家庭住址:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input type="text" name="address" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" size="20" maxlength="80" value="<%=address%>"> 
            </td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">联系电话:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input type="text" name="tel" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" size="20" maxlength="18" value="<%=tel%>"> 
            </td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">出生日期:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"><input type="text" name="brith" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=brith%>" size="20" maxlength="10"></td>
          </tr>
          <tr> 
            <td height="25"> <div align="right"></div>
              <div align="right">身份证号码:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input type="text" name="IDcard" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=IDcard%>" size="20" maxlength="18"></td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">邮政编码:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <input type="text" name="zipcode" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva" value="<%=zipcode%>" size="20" maxlength="6"></td>
          </tr>
          <tr> 
          <tr> 
            <td height="25"> <div align="right">用户级别:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> <font color="#FF0000"><%=rate%></font></td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">是否已购物:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326"> 您在本商场共购物<font color="#FF0000"><%=whetherShop%></font>件(单)</td>
          </tr>
          <tr> 
            <td height="25"> <div align="right">是否有预定:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25" width="326">您在本商场共预定商品<font color="#FF0000"><%=preordainShop%></font>件(单)</td>
          </tr>
          <tr> 
            <td height="25"><div align="right">注册日期:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25"> <%=regTime%></td>
          </tr>
          <tr> 
            <td height="25"><div align="right">上一次登陆时间:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25"><%=lastTime%></td>
          </tr>
          <tr> 
            <td height="25"><div align="right">交易方式:</div></td>
            <td height="25">&nbsp;</td>
            <td height="25"><select name="mode" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <option value='<%=mode%>'><%=mode%></option>
                <%
					                     sql="select * from mode";
					                     rs=data.executeQuery(sql);
					                     mode="";
					                    while(rs.next())
					                     {
					                    mode=rs.getString("mode");
					                    %>
                <option value='<%=mode%>'><%=mode%></option>
                <%}%>
              </select></td>
          </tr>
          <tr> 
            <td height="15" colspan="3"> </td>
          </tr>
          <tr> 
            <td height="20" colspan="3"> <div align="center"> 
                <input type="submit" name="regedit" value="修改" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <input type="reset" name="cancel" value="复位" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <input type="button" name="back" value="返回首页" onClick="javascript:self.location='main.jsp'" style="background-color:#ECECEC; border-style:1; font-size: 11; color: #000000; font-family: arial, verdana, geneva">
                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                  <tr> 
                    <td height="10"></td>
                  </tr>
                </table>
              </div></td>
          </tr>
        </table>								
								</td>
                            </tr>
                            <tr bgcolor="#CCCCCC"> 
                              <td height="25" colspan="2" bgcolor="#63bce6"></td>
                            </tr>
                          </form>
                        </table>
                        <%}%>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -