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

📄 listuser.asp

📁 ASP实现的一个旅游线路预订系统...ASP代码
💻 ASP
字号:
<!--#include file="conn.asp"-->
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/css.css" rel="stylesheet" type="text/css">
</head>
<body>
<%dim userid
		userid=request.querystring("id")
		set rs=server.createobject("adodb.recordset")
		rs.open "select * from [user] where userid="&userid ,conn,1,1%>
<table width="80%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#6B8FC8">
  <tr> 
    <td><div align="center"><font color="#FFFFFF">用户详细资料</font></div></td>
  </tr>
  <tr>
    <td height="163" valign="top" bgcolor="#E8F1FF"> 
      <form name="form1" method="post" action="saveuser.asp?action=save&id=<%=userid%>">
        <br>
		
        <table width="80%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#CCCCCC">
          <tr> 
            <td width="20%" bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">用户名称:</td>
            <td width="80%" bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><font color=#FF0000><%=trim(rs("username"))%></font></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">登陆密码:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="userpassword" type="text" id="userpassword" size="12">
              不改密码请为空!</td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">真实姓名:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="userzhenshiname" type="text" id="userzhenshiname" size="12" value=<%=trim(rs("userzhenshiname"))%>></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">电子邮件:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="useremail" type="text" id="useremail" value=<%=trim(rs("useremail"))%>></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">密码提问:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="quesion" type="text" id="quesion" value=<%=trim(rs("quesion"))%>></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">密码答案:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="answer" type="text" id="answer"></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">收货人姓名:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="shouname" type="text" id="shouhuoname" size="12" value=<%=trim(rs("shouname"))%>></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">收货人性别:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%if rs("shousex")=0 then%>
              <input type="radio" name="usersex" value="1">
              <input name="usersex" type="radio" value="0" checked>
              <%else%> <input type="radio" name="usersex" value="1" checked>
              <input name="usersex" type="radio" value="0" >
              <%end if%></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">收货人省/市:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="shengshi" type="text" id="shengshi" size="12" value=<%=trim(rs("shengshi"))%>></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">收货地址:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="shouhuodizhi" type="text" id="shouhuodizhi" size="30" value=<%=trim(rs("shouhuodizhi"))%>></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">邮编:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="youbian" type="text" id="youbian" size="12" value=<%=rs("youbian")%>></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">电话:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><input name="usertel" type="text" id="usertel" size="12" value=<%=trim(rs("usertel"))%>></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">送货方式:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%select case rs("songhuofangshi")
	case "1"
	response.write "普通平邮"
	case "2"
	response.write "特快专递(EMS)"
	end select%></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">支付方式:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%select case rs("zhifufangshi")
	case "1"
	response.write "邮局汇款"
	case "2"
	response.write "建设银行汇款"
	case "3"
	response.write "交通银行汇款"
	end select %></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">注册时间:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%=rs("adddate")%></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">最后登陆时间:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%=rs("lastlogin")%></td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">登陆次数:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%=rs("logins")%>次</td>
          </tr>
          <tr> 
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">已下订单数:</td>
            <td bgcolor="#E8F1FF" style="PADDING-LEFT: 8px"><%dim rs2
			set rs2=server.CreateObject("adodb.recordset")
			rs2.open "select distinct(dingdan) from shop_action where username='"&trim(rs("username"))&"' ",conn,1,1
			response.write rs2.recordcount&"笔订单"
			rs2.close
			set rs2=nothing
			%></td>
          </tr>
          <tr>
            <td height="28" colspan="2" bgcolor="#E8F1FF" style="PADDING-LEFT: 8px">查找此用户的所有定单: 
              <select name="zhuangtai" onchange="var jmpURL=this.options[this.selectedIndex].value ; if(jmpURL!='') {window.location=jmpURL;} else {this.selectedIndex=0 ;}" ><base target=Right> 
                <option value="" selected>--选择查讯状态--</option>
                <option value="editdingdan.asp?zhuangtai=0&namekey=<%=trim(rs("username"))%>" >全部订单状态</option>
                <option value="editdingdan.asp?zhuangtai=1&namekey=<%=trim(rs("username"))%>" >未作任何处理</option>
                <option value="editdingdan.asp?zhuangtai=2&namekey=<%=trim(rs("username"))%>" >用户已经划出款</option>
                <option value="editdingdan.asp?zhuangtai=3&namekey=<%=trim(rs("username"))%>" >服务商已经收到款</option>
                <option value="editdingdan.asp?zhuangtai=4&namekey=<%=trim(rs("username"))%>" >服务商已经发货</option>
                <option value="editdingdan.asp?zhuangtai=5&namekey=<%=trim(rs("username"))%>" >用户已经收到货</option>
              </select></td>
          </tr><%rs.close
			set rs=nothing
			conn.close
			set conn=nothing%>
          <tr> 
            <td height="28" colspan="2" bgcolor="#E8F1FF"><div align="center"> 
                <input type="submit" name="Submit" value="确认提交">
                &nbsp;&nbsp;&nbsp; 
                <input type="button" name="Submit2" value="返回上一页" onclick='javascript:history.go(-1)'>
              </div></td>
          </tr>
        </table>
      </form> 
    </td>
  </tr>
</table>

</body>
</html>

⌨️ 快捷键说明

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