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

📄 upi.asp

📁 学生信息化管理系统,目前最完美的学生信息化管理系统,界面美观,操作方面,个性化设置.一套软件管理多所学校.
💻 ASP
字号:
🔍 
<% Set hdobj = Server.CreateObject("HD.comOpen")'请保证此行在最前面
Conn = hdobj.WeekaaConn()

dim stv,sqstv,La,Lb
taba="student"
tab="worker"
La=Request("La")
Lb=Request("Lb")
Lc=Request("Lc")
Set stv = Server.CreateObject("ADODB.RecordSet")
sqstv = "Select * From [sets] where TB='"&taba&"'"
stv.Open Sqstv,Conn,1,3
Set stu = Server.CreateObject("ADODB.RecordSet")
sqstu = "Select * From [sets] where TB='"&tab&"'"
stu.Open Sqstu,Conn,1,3
%>	
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>红笛软件</title>
<style type="text/css">
<!--
body,td,th {
	font-size: 12px;
}
.tables {
background-image: url(../Image/bigbg.jpg);
background-repeat: no-repeat;

}
body {
	background-color: #DEE7FF;
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
	background-image: url(../Image/bg.gif);
}
.style22 {
	font-size: 18;
	color: #990000;
}
.style19 {font-size: 12px}
.style21 {color: #FF0000}
.style23 {font-family: "黑体"}
.style24 {font-size: 18;font-family: "黑体"; }
.style26 {
	font-size: 18px;
	color: #FF0000;
}
-->
</style></head>

<body>
<table width="1003" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#3399fd">
  <tr>
    <td height="150" align="center" valign="bottom"><img src="../Image/bigbga.jpg" width="1003" height="150"></td>
  </tr>
  <tr>
    <td height="28" align="center" valign="middle" background="../Image/bg01a.jpg">&nbsp;</td>
  </tr>
    <tr>
      <td bgcolor="#3399FD">

<table width="94%"  border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td height="28" align="left" bgcolor="#319AFF">&nbsp;</td>
  </tr>
  <tr>
    <td height="28" align="left" background="../Image/bg01.jpg">&nbsp;</td>
  </tr>
  <tr>
    <td align="left"><p align="center" class="style24">&nbsp;</p>
      <p align="center" class="style26">Excel表格式数据导入格式</p>
      <p align="left" class="style24">（1）、学生表</p>
      <table width="98%"  border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
      <tr align="center">
        <td width="8%" height="20">第1行</td>
        <td width="7%">a</td>
        <td width="7%">b</td>
        <td width="7%">c</td>
        <td width="7%">d</td>
        <td width="7%">e</td>
        <td width="7%">f</td>
        <td width="7%">g</td>
        <td width="7%">h</td>
        <td width="7%">i</td>
        <td width="7%">j</td>
        <td width="7%">k</td>
        <td width="7%">l</td>
        <td width="8%">m</td>
      </tr>
      <tr align="center">
        <td height="20">其它行</td>
        <td><%=stv("a")%></td>
        <td><%=stv("b")%></td>
        <td><%=stv("c")%></td>
        <td><%=stv("d")%></td>
        <td><%=stv("e")%></td>
        <td><%=stv("f")%></td>
        <td><%=stv("g")%></td>
        <td><%=stv("h")%></td>
        <td><%=stv("i")%></td>
        <td><%=stv("j")%></td>
        <td><%=stv("k")%></td>
        <td><%=stv("l")%></td>
        <td><%=stv("n")%></td>
      </tr>
      <tr align="center">
        <td height="5" colspan="14">&nbsp;</td>
        </tr>
      <tr align="center">
        <td height="20">第1行</td>
        <td>n</td>
        <td>o</td>
        <td>p</td>
        <td>q</td>
        <td>r</td>
        <td>s</td>
        <td>t</td>
        <td>u</td>
        <td>v</td>
        <td>w</td>
        <td>x</td>
        <td>y</td>
        <td>z</td>
      </tr>
      <tr align="center">
        <td height="20">其它行</td>
        <td><%=stv("n")%></td>
        <td><%=stv("o")%></td>
        <td><%=stv("p")%></td>
        <td><%=stv("q")%></td>
        <td><%=stv("r")%></td>
        <td><%=stv("s")%></td>
        <td><%=stv("t")%></td>
        <td><%=stv("u")%></td>
        <td><%=stv("v")%></td>
        <td><%=stv("w")%></td>
        <td><%=stv("x")%></td>
        <td><%=stv("y")%></td>
        <td><%=stv("z")%></td>
      </tr>
      <tr align="center">
        <td colspan="14">&nbsp;</td>
        </tr>
      <tr align="center">
        <td height="20">第1行</td>
        <td>aa</td>
        <td>ab</td>
        <td>ac</td>
        <td>ad</td>
        <td>ae</td>
        <td>af</td>
        <td>ag</td>
        <td>ah</td>
        <td>ai</td>
        <td>aj</td>
        <td>ak</td>
        <td>al</td>
        <td>&nbsp;</td>
      </tr>
      <tr align="center">
        <td height="20">其它行</td>
        <td>家长姓名</td>
        <td>关　　系</td>
        <td>住址</td>
        <td>电话</td>
        <td>家长姓名</td>
        <td>关　　系</td>
        <td>住址</td>
        <td>电话</td>
        <td>家长姓名</td>
        <td>关　　系</td>
        <td>住址</td>
        <td>电话</td>
        <td>&nbsp;</td>
      </tr>
    </table>    
    <p class="style24">（2）、老师表</p>
    <table width="98%"  border="1" align="center" cellpadding="0" cellspacing="0" bordercolor="#CCCCCC">
     <tr align="center">
        <td width="8%" height="20">第1行</td>
        <td width="7%">a</td>
        <td width="7%">b</td>
        <td width="7%">c</td>
        <td width="7%">d</td>
        <td width="7%">e</td>
        <td width="7%">f</td>
        <td width="7%">g</td>
        <td width="7%">h</td>
        <td width="7%">i</td>
        <td width="7%">j</td>
        <td width="7%">k</td>
        <td width="7%">l</td>
        <td width="8%">m</td>
      </tr>
      <tr align="center">
        <td width="8%" height="20">其它行</td>
        <td><%=stu("a")%></td>
        <td><%=stu("b")%></td>
        <td><%=stu("c")%></td>
        <td><%=stu("d")%></td>
        <td><%=stu("e")%></td>
        <td><%=stu("f")%></td>
        <td><%=stu("g")%></td>
        <td><%=stu("h")%></td>
        <td><%=stu("i")%></td>
        <td><%=stu("j")%></td>
        <td><%=stu("k")%></td>
        <td><%=stu("l")%></td>
        <td><%=stu("n")%></td>
      </tr>
      <tr align="center">
        <td colspan="14">&nbsp;</td>
        </tr>
      <tr align="center">
        <td height="20">第1行</td>
        <td>n</td>
        <td>o</td>
        <td>p</td>
        <td>q</td>
        <td>r</td>
        <td>s</td>
        <td>t</td>
        <td>u</td>
        <td>v</td>
        <td>w</td>
        <td>x</td>
        <td>y</td>
        <td>z</td>
      </tr>
      <tr align="center">
        <td height="20">其它行</td>
        <td><%=stu("n")%></td>
        <td><%=stu("o")%></td>
        <td><%=stu("p")%></td>
        <td><%=stu("q")%></td>
        <td><%=stu("r")%></td>
        <td><%=stu("s")%></td>
        <td><%=stu("t")%></td>
        <td><%=stu("u")%></td>
        <td><%=stu("v")%></td>
        <td><%=stu("w")%></td>
        <td><%=stu("x")%></td>
        <td><%=stu("y")%></td>
        <td><%=stu("z")%></td>
      </tr>
	   <tr align="center">
	     <td colspan="14">&nbsp;</td>
        </tr>
	   <tr align="center">
	     <td height="20">第1行</td>
	     <td>aa</td>
	     <td>ab</td>
	     <td>ac</td>
	     <td>ad</td>
	     <td>ae</td>
	     <td>af</td>
	     <td>ag</td>
	     <td>ah</td>
	     <td>ai</td>
	     <td>aj</td>
	     <td>ak</td>
	     <td>al</td>
	     <td>&nbsp;</td>
        </tr>
	   <tr align="center">
        <td height="20">其它行</td>
        <td>亲属姓名</td>
        <td>关　　系</td>
        <td>住址</td>
        <td>电话</td>
        <td>亲属姓名</td>
        <td>关　　系</td>
        <td>住址</td>
        <td>电话</td>
        <td>亲属姓名</td>
        <td>关　　系</td>
        <td>住址</td>
        <td>电话</td>
        <td>&nbsp;</td>
      </tr>
    </table> 
    <p align="center" class="style26">警告！Excel表格式必须按上表要求！</p>
    <p align="center">如果准备好，请进入<a href="UPO.asp"><span class="style26">下一步</span></a></p>
    <p align="left"><span class="style24">　1</span>、上述格式不对将导致数据混乱。</p>
    <p align="left">　2、表的文件名为标准的EXCEL文件名。如 student.xsl</p>
    <p align="left">　3、所有数据存放在Sheet1中，该表不得改名。</p>
    <p align="left">　4、表Sheet1的第一行中的列用 a,b,c,d,e,f......z,aa,ab,ac,ad......al 作标记。第二行起各列的含义为文字所述.</p>
    <p align="left">&nbsp;</p></td>
  </tr>
  <tr>
    <td height="25" align="left" background="../Image/bg01.jpg">&nbsp;</td>
  </tr>
</table></td>
    </tr>
    <tr>
      <td height="25" bgcolor="#3399FD">&nbsp;</td>
    </tr>
    <tr>
      <td height="25" background="../Image/bg01a.jpg" bgcolor="#3399FD">&nbsp;</td>
    </tr>
</table>
</body>
</html>

⌨️ 快捷键说明

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