综合自动化MIS中基于JDBC技术对Excel文件的操作

Operating the Excel document of MIS in integrated power automation system based on JDBC technology

随着Internet技术的不断发展,单纯的采用HTML语言写成的静态网页在交互性、动态性等方面已经不能满足用户的需求。Java技术的面向对象、面向网络和数据库支持及跨平台特性为解决异构环境下的MIS应用提供了一条新的途径。文章介绍了B/S模式和JDBC技术,分析了JDBC的体系结构,引入了利用JDBC访问面向Internet的数据库的Java Applet结构框架,并提出了在电力系统综合自动化MIS中的一种基于JDBC技术读取Excel文件,并写入数据库的方法。

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 Interuet-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.