本科毕业设计论-基于web的动态表格.doc

PAGE \* MERGEFORMAT 2摘要摘要近几年，随着因特网技术的迅猛发展，全球信息化的脚步也在不断的加快。web应用变得越来越普遍的同时也越来越复杂，基于web的动态表格就是一个典型的实例，不论是企业系统，还是高校教务系统，都有这类功能需求。 本文就是基于上述需求，利用Apache公司提出的一个发展比较成熟的POI软件包中的HSSF接口探索出一条解决Java语言操作微软公司Excel文件的有效途径。作者在参阅大量资料的基础上，首先介绍了本文案例中需要用到的基于B/S文件上传与下载的方法，然后提出了操作Excel文件的几种方法并做了比较，最后对Excel文件格式进行了分析并且对POI软件包中的HSSF接口进行了较深入的研究。在掌握了相关技术知识的前提下，设计并且完成了基于B/S的Excel数据输入与输出案例，达到了预期的效果。关键字：web应用 POI软件包 HSSF API Excel文件 ABSTRACTABSTRACTABSTRACT In recent years, with the rapid development of Internet technology, global information has also been accelerated pace. Web applications become more popular and more complicated. Web-based dynamic form is a typical example of it. Not only an enterprise system but also a university academic system needs it. This thesis is just to meet that requirement and find a solution to operate Excel document by Java Language with Apache POI HSSF API.After reading a large amount of data，The author first introduced file upload and download methods based on B/S. Then proposed several methods of operating Excel files and compared each method, at last the Excel file format is analyzed and had a depth research on the POI HSSF API.After grasped the related knowledge，the author designed a case called the data of Excel input and output based on B/S.The result is satisfactory． Keywords: web application POI HSSF API Excel file PAGE \* MERGEFORMAT ii 目录目录 PAGE \* MERGEFORMAT i目 录 TOC \o 1-3 \h \z \u HYPERLINK \l _Toc262892376第一章 绪论 PAGEREF _Toc262892376 \h 1HYPERLINK \l _Toc2628923771.1 课题的背景及意义 PAGEREF _Toc262892377 \h 1HYPERLINK \l _Toc2628923781.2 课题来源及主要研究内容 PAGEREF _Toc262892378 \h 1HYPERLINK \l _Toc2628923791.3 国内外研究发展动态 PAGEREF _Toc262892379 \h 2HYPERLINK \l _Toc2628923801.4 本文结构安排 PAGEREF _Toc262892380 \h 3HYPERLINK \l _Toc262892381第二章 基于B/S实现文件上传与下载 PAGEREF _Toc262892381 \h 5HYPERLINK \l _Toc2628923822.1 实现文件上传的方法 PAGEREF _Toc262892382 \h 5HYPERLI