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

📄 instructor.asp

📁 建造工业系统所需的SQL源代码
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<!--#include file="conn/conn.asp"-->
<%
Set rs=Server.CreateObject("ADODB.RecordSet")
sql="Select * From tb_instructor"
rs.Open sql,conn,1,3
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>技术支持!</title>
<link href="Css/style.css" rel="stylesheet">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body>
<table width="871" border="0" align="center" cellpadding="-2" cellspacing="-2" class="tableBorder">
  <tr>
    <td valign="top"><table width="100%" height="54" border="0" cellpadding="-2" cellspacing="-2" background="Images/Top_01.gif">
      <tr>
        <!--网页头部-->
        <td valign="top"><!--#include file="top.asp"--></td>
      </tr>
    </table>
      <table width="100%"  border="0" cellspacing="-2" cellpadding="-2">
        <tr>
          <td height="238" valign="top"><table width="100%" height="507"  border="0" cellpadding="-2" cellspacing="-2">
            <tr>
              <td width="17" valign="top"><table width="100%" height="402"  border="0" cellpadding="-2" cellspacing="-2">
                <tr>
                  <td width="200" height="189" background="Images/welcome.gif">&nbsp;</td>
                </tr>
                <tr>
                  <td width="200" height="115" background="Images/honour_welcome_B.GIF"></td>
                </tr>
                <tr>
                  <td height="88"></td>
                </tr>
              </table></td>
              <td valign="top" class="bg_gradual"><table width="100%" height="124"  border="0" cellpadding="-2" cellspacing="-2" background="Images/instructor.gif">
                    <tr valign="top">
                      <td height="59" colspan="4"><table width="100%"  border="0" cellspacing="-2" cellpadding="-2">
                          <tr>
                            <td width="79%" height="24">&nbsp;</td>
                            <td width="21%" style="color:#313D99">&gt; 技术支持 &gt;&gt; </td>
                          </tr>
                      </table></td>
                    </tr>
                    <tr>
                      <td width="16%" height="52">&nbsp;</td>
                      <td width="38%" style="color:#5D5D5D; line-height:normal">长春市明日实业有限公司<br>
Chang Chun Ming Ri Industry Co.,Ltd</td>
                      <td width="43%" style="color:#5D5D5D"><marquee direction="left" scrolldelay="100" scrollamount="5">全自动排气阀--吉林省名优产品!</marquee></td>
                      <td width="3%" style="color:#5D5D5D">&nbsp;</td>
                    </tr>
                    <tr>
                      <td colspan="4"></td>
                    </tr>
              </table>
			  <%
			  If rs.eof And rs.bof Then
			  	Response.Write("暂时无技术支持信息!")
			  Else
			%>	
                <table width="98%" height="308"  border="0" cellpadding="-2" cellspacing="-2" style="margin:5pt">
                  <tr>
                    <td valign="top">
					
			<%'分页、分栏显示
			rs.pagesize=6
			page=CLng(Request("page"))
			if page<1 then page=1
			rs.absolutepage=page
			for i=1 to rs.pagesize
				If i mod 2=1 Then
			  %>  
					<table width="100%" height="179" border="0" cellpadding="-2" cellspacing="-2">
                      <tr>
                        <td align="center">
                          <table width="100%"  border="0" cellspacing="-2" cellpadding="-2">
                            <tr>
                              <td align="center" valign="middle">
							  <%If not isnull(rs("Img")) Then%>
                                <img src="showImg.asp?ID=<%=rs("ID")%>&tbName=tb_instructor" width="380" height="270" border="1">
                               <%Else%>
							 <img src="Images/noneIMG_w.gif" width="185" height="133" border="0">
							  <%End If%>
							    </td>
                            </tr>
                            <tr>
                              <td height="25" align="center"><%=rs("Title")%></td>
                            </tr>
                          </table></td>
				<% Else%>

							<td><table width="100%"  border="0" cellspacing="-2" cellpadding="-2">
                            <tr>
                              <td align="center" valign="middle">
							  <%If not isnull(rs("Img")) Then%>
                                <img src="showImg.asp?ID=<%=rs("ID")%>&tbName=tb_instructor" width="380" height="270" border="1">
                               <%Else%>
							 <img src="Images/noneIMG_w.gif" width="185" height="133" border="0">
							  <%End If%>
							  </td>
                            </tr>
                            <tr>
                              <td height="25" align="center"><%=rs("Title")%></td>
                            </tr>
                          </table>
							</td>
						  </tr>
						</table>
						<br>
				  <%
			  	End If
			  rs.MoveNext
			  If rs.Eof Then exit For 
			  Next%>	
			  <table width="95%" height="25"  border="0" align="center" cellpadding="-2" cellspacing="-2">
                <tr>
                  <td width="33%" height="26" valign="bottom"><% if page<>1 then %>
                    <a href=?page=1 class="white"><font color="#666666">第一页</font></a> <a href=?page=<%=(page-1)%> class="white"><font color="#666666">上一页</font></a>
                    <%end if 
			if page<>rs.pagecount then %>
                    <a href=?page=<%=(page+1)%> class="white"><font color="#666666">下一页</font></a> <a href=?page=<%=rs.pagecount%> class="white"><font color="#666666">最后页</font></a>
                    <%end if%></td>
                  <%If not(rs.Eof and rs.Bof) Then%>
                  <td width="35%" align="right" class="word_grey">[<%=page%>/<%=rs.PageCount%>]&nbsp;&nbsp;每页<%=rs.PageSize%>条&nbsp;&nbsp;共<%=rs.RecordCount%>条记录</td>
                  <%End If%>   
                </tr>
              </table>
			  <%End If%>					
                    </td>
                  </tr>
                </table>
				                <table width="100%" height="56"  border="0" cellpadding="-2" cellspacing="-2">
                    <tr>
                      <td height="56" bgcolor="#FFFFFF"><!--#include file ="CopyRight.htm"--></td>
                      <td width="208"><img src="Images/re_top.gif" width="208" height="56" border="0" usemap="#Map"></td>
                    </tr>
                </table></td>
              </tr>
          </table></td>
        </tr>
      </table><table width="100%"  border="0" cellspacing="-2" cellpadding="-2">
  <tr>
    <td height="8" background="Images/bottom.gif"></td>
  </tr>
</table></td>
  </tr>
</table>

<script language="javascript">
	ourmove()
</script>
<map name="Map">
  <area shape="rect" coords="82,17,125,39" href="#">
  <area shape="circle" coords="49,28,14" href="index.asp" alt="返回首页">
</map>
</body>
</html>

⌨️ 快捷键说明

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