摘要
方便有效地实现数据共享是网络信息共享系统开发的目的,为了能处理各种复杂的以Excel形式存在的源信息,系统数据库的数据表非预先设计,而是由提供数据源的Excel文件自动创建,查询和更新时也不需要设计对应的表单,相关字段自动从数据库对应表中获取并生成列表供用户选择,查询结果直接写出到Excel文件,便于用户编辑使用。实践证明,该方法为网络信息共享系统提供了一个高效易扩展的开发方案。
Convenient and effective information sharing is the main purpose of network information sharing system. In order to handle various Excel files, it is not necessary to predesign the database's tables structure which will be created by Excel files automaticly. When querying or updating data,the system will generate the fields automaticly for users to choose and set operating conditions, so, there is no necessary to predesign forms in the whole process, and, the seach result will output with Excel file which can be edited very easily by users. Practice has proved that this method provides a highly efficient development programs.
出处
《现代计算机》
2009年第7期129-132,共4页
Modern Computer
基金
上海市科委2007年科技攻关重点项目(No.075115002)