📄 gzwh.asp

📁 人事管理系统人事管理系统人事管理系统人事管理系统
💻 ASP
字号:
<%
dim conn,sql,rs,page
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database/rsxt.mdb") 
sql="select * from [gzda] order by id desc"

set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<!-- #include file="Inc/Head.asp" -->
<table width="100%" height="500" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="150" align="center" valign="top"><table width="150" height="100%" border="0" cellpadding="0" cellspacing="0" class="HeaderTdStyle">
      <tr>
        <td align="center" valign="top"><table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td align="center">功能菜单</td>
            </tr>
          </table>
            <table width="100%" height="530" border="0" cellpadding="0" cellspacing="0" class="MenuBg">
              <tr>
                <td align="center" valign="top"><br>
                    <table width="90%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="16%"><img src="Img/Left_1.gif" width="28" height="11"></td>
                        <td width="84%" height="20"><font color="#FFFF00">人事记录管理</font></td>
                      </tr>
                    </table>
                    <table width="90%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="34%" height="20" align="right"><img src="Img/Left_1_1.gif" width="29" height="16"></td>
                        <td width="66%" valign="bottom"><a href="tjry.asp"><font color="#FFFF00">添加员工</font></a></td>
                      </tr>
                    </table>
                    <table width="90%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="34%" height="20" align="right"><img src="Img/Left_1_1.gif" width="29" height="16"></td>
                        <td width="66%" valign="bottom"><a href="xz.asp"><font color="#FFFF00">查询信息</font></a></td>
                      </tr>
                    </table>
                    <table width="90%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="34%" height="20" align="right"><img src="Img/Left_1_1.gif" width="29" height="16"></td>
                        <td width="66%" valign="bottom"><a href="ztcx.asp"><font color="#FFFF00">总体显示</font></a></td>
                      </tr>
                  </table></td>
              </tr>
          </table></td>
      </tr>
    </table></td>
    <td align="center" valign="top"> 
      <div align="center">

       
        <table width="30%" height="32" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#666666">
          <tr>
            <td><table width="100%" border="0" cellpadding="0" cellspacing="1">
                <tr>
                  <td bgcolor="#F5F5F5"><table width="100%" height="58" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
                      <tr bgcolor="#E3E3E3">
                        <td width="6%" height="25"><div align="center">工种信息</div></td>
                        <td width="7%" height="25">&nbsp;
                            <div align="center">操&nbsp;&nbsp;&nbsp;&nbsp;作</div></td>
                      </tr>
                      <%do while not rs.eof%>
                      <tr valign="top" bgcolor="#F5F5F5" class="h25">
                        <td height="30">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<%=rs("yggz")%></td>
                        <td>&nbsp;&nbsp;&nbsp;&nbsp;<a href="gzxg.asp?ID=<%=rs("id")%>">修改</a>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <a href="gzdel.asp?ID=<%=rs("ID")%>&Action=Del" onClick="return ConfirmDel();">删除</a><br>
                              </tr>
                      <%
            rs.movenext
           loop
         %>
                  </table></td>
                </tr>
            </table></td>
          </tr>
        </table>
        <table width="30%" border="0" align="center">
          <tr>
            <td><div align="center"><a href="gztj.asp">添加工种</a></div></td>
          </tr>
        </table>
        <div align="center"></div>
        <font face="楷体_GB2312"></font>
        <p><br>
        </p>
      </div></td>
  </tr>
</table>

</body>
</html>
⌨️ 快捷键说明

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