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="200" border="0" align="center" cellpadding="0" cellspacing="0">
    <tr>
      <td><IFRAME marginWidth=0 marginHeight=0 
      src="../pic.asp" frameBorder=0 width=600 scrolling=no 
      height=35></IFRAME>&nbsp;</td>
    </tr>
    <tr>
      <td><table width="234" height="266" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr>
          <td height="32">人员编号为：
            <input name="UserId" type="text" id="UserId" value="<%=rs("UserId")%>" size="20">
</td>
        </tr>
        <tr>
          <td height="32">姓名：&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;            <input name="UserName" type="text" id="UserName" value="<%=rs("UserName")%>" size="20"></td>
        </tr>
        <tr>
          <td height="39">原职位&nbsp;&nbsp;&nbsp;&nbsp;： 
            <input name="zhiwei" type="text" id="zhiwei" size="20"></td>
        </tr>
        <tr>
          <td height="38">原部门&nbsp;&nbsp;：&nbsp;&nbsp;            <input name="bumen" type="text" id="bumen" size="20"></td>
        </tr>
        <tr>
          <td height="32">调动时间：&nbsp;&nbsp;
          <input name="shijian" type="text" id="shijian" size="20">          </td>
        </tr>
        <tr>
          <td height="38"><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>