| 综合自动化MIS中基于JDBC技术对Excel文件的操作 |
| |
| 引用本文： | 邹雯奇,戚宇林,于志新,尹秀艳.综合自动化MIS中基于JDBC技术对Excel文件的操作[J].电力系统通信,2006,27(5):37-40. |
| |
| 作者姓名： | 邹雯奇 戚宇林 于志新 尹秀艳 |
| |
| 作者单位： | 1. 华北电力大学,电子与通信工程系,河北,保定,071003
2. 保定供电公司,河北,保定,071051 |
| |
| 摘 要： | 随着Internet技术的不断发展,单纯的采用HTML语言写成的静态网页在交互性、动态性等方面已经不能满足用户的需求。Java技术的面向对象、面向网络和数据库支持及跨平台特性为解决异构环境下的MIS应用提供了一条新的途径。文章介绍了B/S模式和JDBC技术,分析了JDBC的体系结构,引入了利用JDBC访问面向Internet的数据库的Java Applet结构框架,并提出了在电力系统综合自动化MIS中的一种基于JDBC技术读取Excel文件,并写入数据库的方法。
|
| 关 键 词： | B/S模式 JDBC Java组件 |
| 文章编号： | 1005-7641(2006)05-0037-04 |
| 收稿时间： | 2005-10-26 |
| 修稿时间： | 2005-12-02 |
Operating the Excel document of MIS in integrated power automation system based on JDBC technology |
| |
| ZOU Wen-qi,QI Yu-lin,YU Zhi-xin,YIN Xiu-yan.Operating the Excel document of MIS in integrated power automation system based on JDBC technology[J].Telecommunications for Electric Power System,2006,27(5):37-40. |
| |
| Authors: | ZOU Wen-qi QI Yu-lin YU Zhi-xin YIN Xiu-yan |
| |
| Affiliation: | 1. Dept. of Electronic and Communication, North China Electric Power University, Baoding 071003, China ; 2. Baoding Power Supply Co. ,Baoding 071051 ,China |
| |
| Abstract: | With the development of Internet,more and more users do not think that the static Web pages can meet their demand and appetite in interactivity and dynamics.The features of Java technology on object-oriented,network-oriented,database support and across the operating systems afford a new approach for solving MIS(Management Information System) application in the heterogeneity structures.This paper introduced B/S model,analyzed JDBC technology and its architecture.The structural frame of Java Applet,which can access Internet-oriented database by using JDBC,is also discussed.Finally,an applet based on JDBC is given as an example,which can read data from Excel document of MIS in integrated power automation system then write these data to database. |
| |
| Keywords: | B/S model JDBC Java applet |
| 本文献已被 CNKI 维普 万方数据 等数据库收录！ |
|
