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

📄 download_excel.jsp

📁 远程教育系统中教师管理系统,包含完整的教师管理,包括现有教育体系中的复杂教师管理.推荐
💻 JSP
字号:
<%/*---------------------------------------------
    用途:下载教师报表
    程序员:guoyehong
    最后修改时间:2004-8-25 11:25
    修改情况:
    修改时间:  修改原因:
 ------------------------------------------------*/ %>
<%@page contentType="text/html;charset=gb2312" %>
<%
//////////////////////////////////////////////////////////////
// Privilege Guarding

	String 	PrivXP="批量添加教师信息";
	String 	PrivME="00205";
	String 	PrivOUT="HTML"; // HTML | XSL | NONE
%>
<%@ include file="../pub/privGuarding.jsp" %>	
<%
// Privilege Guarding
//////////////////////////////////////////////////////////////
%>
<%@page import="java.util.*"%>
<%@page import="java.sql.*"%>
<jsp:useBean id="work" scope="application" class="com.dbConnection.dbpool"/>

<html xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns="http://www.w3.org/TR/REC-html40">

<head>
<meta http-equiv=Content-Type content="text/html; charset=GB2312">
<meta name=ProgId content=FrontPage.Editor.Document>
<meta name=Generator content="Microsoft FrontPage 4.0">
<link rel=File-List href="./formtable_excel.files/filelist.xml">
</head>

<body>
<!--[if !excel]>  <![endif]-->
<!--下列信息由 Microsoft Excel 的“发布为 Web 页”向导生成。-->
<!--如果同一条目从 Excel 中重新发布,则所有位于 DIV tag 之间的信息均将得到替换。-->
<!----------------------------->
<!--“从 EXCEL 发布 Web 页”向导开始-->
<!----------------------------->

<div id="电子表格9_7_3883" align=center x:publishsource="Excel"><object
 id="电子表格9_7_3883_WebCalc"
 classid="CLSID:0002E510-0000-0000-C000-000000000046" width="576" height="288">
 <param name="HTMLURL" value>
 <param name="HTMLData" value="&lt;html xmlns:x=&quot;urn:schemas-microsoft-com:office:excel&quot;
xmlns=&quot;http://www.w3.org/TR/REC-html40&quot;&gt;

&lt;head&gt;
&lt;style type=&quot;text/css&quot;&gt;
&lt;!--tr
	{mso-height-source:auto;}
td
	{white-space:nowrap;}
.wcC890742
	{white-space:nowrap;
	font-family:宋体;
	mso-number-format:General;
	font-size:auto;
	font-weight:auto;
	font-style:auto;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	mso-color-source:auto;
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-left:none;
	border-right:none;
	border-bottom:none;
	mso-protection:locked;}
.wc8589342
	{white-space:nowrap;
	font-family:黑体;
	mso-number-format:General;
	font-size:14pt;
	font-weight:700;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-left:none;
	border-right:none;
	border-bottom:none;
	mso-protection:locked;}
.wcCC89342
	{white-space:nowrap;
	font-family:黑体;
	mso-number-format:General;
	font-size:14pt;
	font-weight:700;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-left:none;
	border-right:none;
	border-bottom:none;
	mso-protection:locked;}
.wc0499342
	{white-space:nowrap;
	font-family:黑体;
	mso-number-format:General;
	font-size:14pt;
	font-weight:700;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-left:none;
	border-right:none;
	border-bottom:none;
	mso-protection:locked;}
.wcC7A9342
	{white-space:nowrap;
	font-family:宋体;
	mso-number-format:General;
	font-size:12pt;
	font-weight:400;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-left:none;
	border-right:none;
	border-bottom:none;
	mso-protection:locked;}
.wc0FA9342
	{white-space:nowrap;
	font-family:宋体;
	mso-number-format:General;
	font-size:12pt;
	font-weight:400;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-left:none;
	border-right:none;
	border-bottom:none;
	mso-protection:locked;}
.wc46B9342
	{white-space:nowrap;
	font-family:宋体;
	mso-number-format:General;
	font-size:12pt;
	font-weight:400;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:general;
	vertical-align:bottom;
	border-top:none;
	border-left:none;
	border-right:none;
	border-bottom:none;
	mso-protection:locked;}
.wcC2C9342
	{white-space:nowrap;
	font-family:宋体;
	mso-number-format:General;
	font-size:12pt;
	font-weight:400;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:center;
	vertical-align:bottom;
	border-top:solid .5pt black;
	border-left:none;
	border-right:none;
	border-bottom:solid .5pt black;
	mso-protection:locked;}
.wc4EC9342
	{white-space:nowrap;
	font-family:宋体;
	mso-number-format:General;
	font-size:12pt;
	font-weight:400;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:center;
	vertical-align:bottom;
	border-top:solid .5pt black;
	border-left:solid .5pt black;
	border-right:none;
	border-bottom:solid .5pt black;
	mso-protection:locked;}
.wc86D9342
	{white-space:nowrap;
	font-family:宋体;
	mso-number-format:General;
	font-size:12pt;
	font-weight:400;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-left:none;
	border-right:none;
	border-bottom:solid .5pt black;
	mso-protection:locked;}
.wcCDD9342
	{white-space:nowrap;
	font-family:宋体;
	mso-number-format:General;
	font-size:12pt;
	font-weight:400;
	font-style:normal;
	text-decoration:auto;
	mso-background-source:auto;
	mso-pattern:auto;
	color:black;
	text-align:center;
	vertical-align:bottom;
	border-top:none;
	border-left:solid .5pt black;
	border-right:none;
	border-bottom:solid .5pt black;
	mso-protection:locked;}
--&gt;
&lt;/style&gt;
&lt;/head&gt;

&lt;body&gt;
&lt;!--[if gte mso 9]&gt;&lt;xml&gt;
 &lt;x:ExcelWorkbook&gt;
  &lt;x:ExcelWorksheets&gt;
   &lt;x:ExcelWorksheet&gt;
    &lt;x:OWCVersion&gt;9.0.0.2710&lt;/x:OWCVersion&gt;
    &lt;x:Label Style='border-top:solid .5pt silver;border-left:solid .5pt silver;
     border-right:solid .5pt silver;border-bottom:solid .5pt silver'&gt;
     &lt;x:Caption&gt;Microsoft Office Spreadsheet&lt;/x:Caption&gt;
    &lt;/x:Label&gt;
    &lt;x:Name&gt;Sheet1&lt;/x:Name&gt;
    &lt;x:WorksheetOptions&gt;
     &lt;x:Selected/&gt;
     &lt;x:Height&gt;7620&lt;/x:Height&gt;
     &lt;x:Width&gt;15240&lt;/x:Width&gt;
     &lt;x:TopRowVisible&gt;0&lt;/x:TopRowVisible&gt;
     &lt;x:LeftColumnVisible&gt;0&lt;/x:LeftColumnVisible&gt;
     &lt;x:ProtectContents&gt;False&lt;/x:ProtectContents&gt;
     &lt;x:DefaultRowHeight&gt;405&lt;/x:DefaultRowHeight&gt;
     &lt;x:StandardWidth&gt;2389&lt;/x:StandardWidth&gt;
    &lt;/x:WorksheetOptions&gt;
   &lt;/x:ExcelWorksheet&gt;
  &lt;/x:ExcelWorksheets&gt;
  &lt;x:SpreadsheetAutoFit/&gt;
  &lt;x:MaxHeight&gt;80%&lt;/x:MaxHeight&gt;
  &lt;x:MaxWidth&gt;80%&lt;/x:MaxWidth&gt;
 &lt;/x:ExcelWorkbook&gt;
&lt;/xml&gt;&lt;![endif]--&gt;

&lt;table class=wcC890742 x:str&gt;
 &lt;col width=&quot;120&quot; style='mso-width-source:userset'&gt;
 &lt;col width=&quot;70&quot; style='mso-width-source:userset'&gt;
 &lt;col width=&quot;40&quot; style='mso-width-source:userset'&gt;
 &lt;col width=&quot;40&quot; style='mso-width-source:userset'&gt;
&lt;tr height=&quot;27&quot; style='mso-height-source:userset'&gt;&lt;td class=wc8589342 colspan=&quot;14&quot;&gt;
教师信息表(其中带*的必须填写,教师密码为教师编号)
&lt;/td&gt;
 &lt;/tr&gt; 
<tr height=&quot;21&quot; style='mso-height-alt:315'>
  <td class=wc8C8AED2>*教师编号</td>
  <td class=wc8C8AED2>*姓名</td>
  <td class=wc8C8AED2>电子邮件</td>
  <td class=wc8C8AED2>联系电话</td>
  <td class=wc8C8AED2>通信地址</td>
  <td class=wc8C8AED2>邮政编码</td>
  <td class=wc8C8AED2>工作单位</td>
  <td class=wc8C8AED2>职务</td>
  <td class=wc8C8AED2>职称</td>
  <td class=wc8C8AED2>性别(男/女)</td>
  <td class=wc8C8AED2>教龄</td>
  <td class=wc8C8AED2>工作性质</td>
  <td class=wc8C8AED2>教师简介</td>
  <td class=wc8C8AED2>教师类型(教师/助教,默认为教师)</td>
</tr>
</table>
</body>
</html>
">
 <param name="DataType" value="HTMLDATA">
 <param name="AutoFit" value="-1">
 <param name="DisplayColHeaders" value="-1">
 <param name="DisplayGridlines" value="-1">
 <param name="DisplayHorizontalScrollBar" value="-1">
 <param name="DisplayRowHeaders" value="-1">
 <param name="DisplayTitleBar" value="0">
 <param name="DisplayToolbar" value="-1">
 <param name="DisplayVerticalScrollBar" value="-1">
 <param name="EnableAutoCalculate" value="-1">
 <param name="EnableEvents" value="-1">
 <param name="MoveAfterReturn" value="-1">
 <param name="MoveAfterReturnDirection" value="0">
 <param name="RightToLeft" value="0">
 <param name="ViewableRange" value="1:65536">
<p style="margin-top:100;font-family:宋体;font-size:8.0pt">如要交互使用该
Web 页,必须装有 Microsoft (R) Internet Explorer 4.01 或更新版本以及
Microsoft Office Web Components。请访问 <a HRef="http://officeupdate.microsoft.com/office/redirect/fromOffice9/MSOWCPub.htm?&amp;HelpLCID=2052">Microsoft
Office Web 站点</a> 以获取更多信息。</p>
</object>
</div>
<!----------------------------->
<!--“从 EXCEL 发布 Web 页”向导结束-->
<!----------------------------->
</body>
</html>

⌨️ 快捷键说明

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