users_edit.asp

实验室资源管理系统 实验室人事资料管理、实验室设备管理、实验课程管理及实验室软件资料管理及相关分析统计功能

<!--#include file="conn.asp"-->
<!--#include file="admin.asp"-->
<!--#include file="../Inc/articleCHAR.INC"-->
<%if Request.QueryString("no")="eshop" then
id=request("id")
Set rs = Server.CreateObject("ADODB.Recordset")
sql="select * from student where id="&id
rs.open sql,conn,1,3

rs("username")=request("username")
rs("password")=request("password")
rs("sex")=request("sex")
rs("realname")=request("realname")
rs("zhengjian")=request("zhengjian")
rs("zhengjian_number")=request("zhengjian_number")
rs("email")=request("email")
rs("youbian")=request("youbian")
rs("banji")=request("banji")
rs("address")=request("address")
rs("zuowei_number")=request("zuowei_number")
rs("xingyuzhi")=request("xingyuzhi")
rs("addtime")=request("addtime")
rs("remark")=request("remark")
rs("sh_infor")=request("sh_infor")
rs("status")=request("status")
rs("phone")=request("phone")
rs("mobile")=request("mobile")

rs.update
rs.close
response.redirect "users_manage.asp"
end if
%>
<%
id=request.querystring("id")
Set rs = Server.CreateObject("ADODB.Recordset")
rs.Open "Select * From student where id="&id, conn,3,3
%>
<!-- #include file="Inc/Head.asp" -->
<table width="100%" height="100%" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td align="center" valign="top"> <br>
      <table width="560" border="0" cellpadding="2" cellspacing="1" class="table_southidc">
        <tr> 
          <td class="back_southidc" height="25"> <div align="center"><strong>修改实验信息 <br>
              </strong></div></td>
        </tr>
        <tr> 
          <form method="post" action="users_edit.asp?no=eshop">
            <input type=hidden name=id value=<%=id%>>
            <td><div align="center"> 
                <table width="100%" border="0" cellspacing="1" cellpadding="0">
                  <tr bgcolor="#E7E7E7"> 
                    <td width="8%" height="25" bgcolor="#ECF5FF"> 
                      <div align="center">登录名：</div></td>
                    <td width="62%" bgcolor="#ECF5FF"> 
                      <input type="text" name="username" maxlength="30" size="25" value="<%=rs("username")%>" readonly>                    </td>
                  </tr>
                  <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center">密码<font color="#000000">：</font></div></td>
                    <td>                    
                      <input type="text" name="password" maxlength="30" size="25" value="<%=rs("password")%>"></td>
                  </tr>
				      <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">性别：</font></div></td>
                    <td><select name="sex" id="select" >
                      <option value="男" <%if rs("sex")="男" then Response.write"selected" end if%>>男</option>
                      <option value="女" <%if rs("sex")="女" then Response.write"selected" end if%>>女</option>
                                        </select></td>
                  </tr>
				      <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">姓名：</font></div></td>
                    <td>                    
                      <input type="text" name="realname" maxlength="30" size="25" value="<%=rs("password")%>"></td>
                  </tr>
				  
				  <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">证件类型：</font></div></td>
                    <td>                    
                      <select name="zhengjian" >
		<option  value="身份证" <%if rs("zhengjian")="身份证" then Response.write"selected" end if%>>身份证</option>
		<option value="军官证" <%if rs("zhengjian")="军官证" then Response.write"selected" end if%>>军官证</option>
		

	</select></td>
                  </tr>
				  
				  
				      <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">证件号码：</font></div></td>
                    <td>                    
                      <input type="text" name="zhengjian_number" maxlength="30" size="25" value="<%=rs("zhengjian_number")%>"></td>
                  </tr>
				   <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">班级：</font></div></td>
                    <td>                    
                      <input type="text" name="banji" maxlength="30" size="25" value="<%=rs("banji")%>"></td>
                  </tr>
				   <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">电子邮件：</font></div></td>
                    <td>                    
                      <input type="text" name="email" maxlength="30" size="25" value="<%=rs("email")%>"></td>
                  </tr>
				   <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">地址：</font></div></td>
                    <td>                    
                      <input type="text" name="address" maxlength="30" size="25" value="<%=rs("address")%>"></td>
                  </tr>
				   
				  <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">邮政编码：</font></div></td>
                      <td>                    
                      <input type="text" name="youbian" maxlength="30" size="25" value="<%=rs("youbian")%>"></td>
                  </tr>
				  
				   <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">固定电话：</font></div></td>
                      <td>                    
                      <input type="text" name="phone" maxlength="30" size="25" value="<%=rs("phone")%>"></td>
                  </tr>
				  
				   
				   <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">手机号码：</font></div></td>
                    <td>                    
                      <input type="text" name="mobile" maxlength="30" size="25" value="<%=rs("mobile")%>"></td>
                  </tr>
				  
				  <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">审核信息：</font></div></td>
                    <td>                    
                      <input type="text" name="sh_infor" maxlength="30" size="25" value="<%=rs("sh_infor")%>"></td>
                  </tr>
				   <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">座位号：</font></div></td>
                    <td>                    
                      <input type="text" name="zuowei_number" maxlength="30" size="25" value="<%=rs("zuowei_number")%>"></td>
                  </tr>
				   <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">信誉值：</font></div></td>
                    <td>                    
                      <input type="text" name="xingyuzhi" maxlength="30" size="25" value="<%=rs("xingyuzhi")%>"></td>
                  </tr>
				   
				   <tr bgcolor="#ECF5FF"> 
                    <td height="22"> 
                      <div align="center"><font color="#000000">状态：</font></div></td>
                    <td>                    
                      <input type="text" name="status" maxlength="30" size="25" value="<%=rs("status")%>"></td>
                  </tr>
				   
				  
                  <tr bgcolor="#E7E7E7"> 
                    <td height="25" colspan="2" bgcolor="#ECF5FF"> 
                      <div align="center"> 
                        <input type="submit" value="修改">
                        &nbsp; 
                       <a href="javascript:history.go(-1);" style="color: #0000FF">返回</a>                      </div></td>
                  </tr>
                </table>
              </div></td>
          </form>
        </tr>
      </table>
      <br> <br> </td>
  </tr>
</table>
<!-- #include file="Inc/Foot.asp" -->