input2.asp

留言簿毕业设计用ASP和SQL2000开发的能够链接

<% 
Dim Uid
Uid=Request.QueryString("ID")
sql ="SELECT * FROM 人员基本信息 WHERE ID=" &Uid& ""
Set Conn=Server.CreateObject("ADODB.Connection")
  Conn.ConnectionString="driver={SQL Server};server=(local);UID=sa;PWD=13513343483;Database=学院人事管理系统"
  Conn.Open
  Set rs=Server.CreateObject("ADODB.Recordset")
  Set rs = Conn.Execute(sql)
  If rs.Eof then
	Response.Write "<h2>不存在此用户</h2>"
  Else
%>

  <link href="../pic/home.css" rel="stylesheet" type="text/css">
  <!--
body {
	background-image: url(../images/backcolor.gif);
}
-->
  <style type="text/css">
<!--
body {
	background-image: url(../pic/backcolor.gif);
}
.style2 {color: #996600}
.style3 {color: #990000}
.style4 {color: #993300}
-->
  </style>
 

<form Name=myform  action="save.asp" method="post"
  <table width="255" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td width="255"><IFRAME marginWidth=0 marginHeight=0 
      src="../pic.asp" frameBorder=0 width=600 scrolling=no 
      height=35></IFRAME>&nbsp;</td>
    </tr>
    <tr>
      <td><table width="252" height="331" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="252" height="32">人员编号为： 
          <input name="UserId" type="text" id="UserId" value="<%=rs("UserId")%>" size="20"></td>
        </tr>
        <tr> 
          <td height="39">姓名：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
            <input name="UserName" type="text" id="shengao32" value="<%=rs("UserName")%>" size="20"></td>
        </tr>
        <tr> 
          <td height="38">身高&nbsp;：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <input name="shengao" type="text" id="shengao" size="20"></td>
        </tr>
        <tr> 
          <td height="32">体重&nbsp;：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <input name="tizhong" type="text" id="tizhong" size="20"> 
          </td>
        </tr>
        <tr> 
          <td height="38">血型：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
            <input name="xuexing" type="text" id="xuexing" size="20"></td>
        </tr>
        <tr> 
          <td height="38">健康状况： 
            &nbsp;
          <input name="jiankang" type="text" id="jiankang" size="20"></td>
        </tr>
        <tr> 
          <td height="38">婚姻状况：&nbsp;&nbsp;            <input name="hunyin" type="text" id="hunyin" size="20"></td>
        </tr>
        <tr> 
          <td height="38">&nbsp;&nbsp;&nbsp; <input name="submit" type="image" src="../pic/buttonLogin1.jpg" align="middle" width="52" height="18"> 
            <a href='javascript:Clearmyform()'><img src="../pic/buttonClear.gif" alt="清除" name="clear" width="52" height="18" border="0" align="middle"></a></td>
        </tr>
      </table></td>
    </tr>
  </table>
  <input type="hidden" name="flag" value="new">
  <% End If %>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
  <p>&nbsp;</p>
</form>