| 基于Java Excel API的数据库数据导入导出方法研究与实现 |
| |
| 引用本文： | 张明辉,王清心,王正玉.基于Java Excel API的数据库数据导入导出方法研究与实现[J].现代电子技术,2012,35(4):45-47. |
| |
| 作者姓名： | 张明辉 王清心 王正玉 |
| |
| 作者单位： | 昆明理工大学信息工程与自动化学院,云南昆明,650051 |
| |
| 摘 要： | 在Web应用系统中,用户们经常要求将数据库数据进行导入导出处理。Microsoft Excel是用户非常熟悉的办公软件,因此,Excel作为数据库数据导入导出的中间介质成为最佳选择。为了达到此目的,采用Java Excel API操作Excel文件的方法,实现了仅通过在客户端的操作,将数据库中的数据导出到Excel表格中,并将Excel表格中的数据导入数据库的功能。满足了用户进行数据库数据导入导出的要求。
|
| 关 键 词： | Java Excel API 数据库 数据导入 数据导出 |
Implementation of data import and export from database based on Java Excel API |
| |
| ZHANG Ming-hui
,
WANG Qing-xin
,
WANG Zheng-yu.Implementation of data import and export from database based on Java Excel API[J].Modern Electronic Technique,2012,35(4):45-47. |
| |
| Authors: | ZHANG Ming-hui WANG Qing-xin WANG Zheng-yu |
| |
| Affiliation: | (College of Information Engineering and Automation,Kunming University of Technology,Kunming 650051,China) |
| |
| Abstract: | In Web application system,clients always call for the data import and export from a database.Microsoft Excel is an office software which is very familiar to many clients,so Excel as a intermedia becomes the first option for data import and export from database.In order to achieve the goal,this method is adopted to operate Excel by Java Excel API.Only through the process on the client side,can the data be exported from database into Excel and data be imported from Excel into database.It meet the requirements of clients for data import and export. |
| |
| Keywords: | Java Excel API database data import data export |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
