国家自然科学基金青岛海洋资料共享服务系统设计与实现
摘要
在海洋科学众多学科的发展过程中,海洋调查数据一直推动着海洋科学的发展并且起着不可替代的重要作用。目前我国积累了大量的海洋科学数据,但在数据管理方面的工作尚未全面深入的展开。为了利用计算机科学技术实现海洋科学数据的共享服务,避免重复调查和资源闲置浪费,同时也为了加强国家自然科学基金海洋科学项目资料的管理,实现基金资助项目资料的统一管理和无偿共享使用,充分发挥国家基金投入的社会效益和经济效益,国家自然科学基金委于2003年初委托国家海洋局第一海洋研究所筹建“青岛海洋科学资料共享服务中心”,建立其相应的各类海洋科学基金项目资料的收集、整编和共享服务体系。国家自然科学基金青岛海洋资料共享服务系统(以下简称“共享服务系统”)主要完成与数据共享用户的网络交流,系统的核心是基金项目信息的查询和维护功能。查询功能中既有单条件查询和多条件查询,也有精确查询和模糊查询,其目的都是为了方便用户查询。且系统有完整的用户注册和用户信息管理功能。
本文详细说明了利用JSP和JavaScript等技术开发的“青岛海洋资料共享服务系统”,探讨当今海洋资料共享服务系统的开发与研究。主要介绍了基于B/S架构的青岛海洋资料共享服务系统的开发背景、开发方法、系统需求分析、系统功能设计、系统数据库结构设计、系统开发实现等。重点说明了系统的设计思想、难点技术和解决方案。同时也简单介绍了Java、JSP、Ajax、CSS等相关技术,以及Oralce、Macromedia DreamWeaver 8.0、Tomcat5.0等相关软件。
系统采用的Oracle数据库有着最为灵活的数据库结构和极高的安全性、稳定性,使用JDBC连接数据库,它对数据库应用有着良好的支持。考虑到跨平台、可移植等要求,选用JSP开发共享服务系统。JSP实现页面上的动态内容,将显示逻辑和业务逻辑分离,使Web应用程序的开发变得容易和快捷,且支持基于可重用的跨平台组件的设计如JavaBeans,JavaBeans封装业务逻辑,其脚本在服务器端执行。基于Java的Web应用程序,用户可通过浏览器软件连接后台数据库完成信息的浏览、查询与维护。
动态网页开发过程中使用JavaScript可以开发Internet客户端的应用程序。JavaScript包含于Ajax技术中,Ajax是多种技术的综合。其中使用JavaScript将XHTML、DOM、XML、XMLHttpRequest绑定。Ajax可以构建更为动态和响应更灵敏的Web应用程序,主要功能在于浏览器客户端和服务器端采用异步通信交互方式,当通讯信息返回时,使用JavaScript相应地更新部份UI,而不刷新整个页面。
本系统基于Windows Server 2003和Oracle,采用B/S架构,MVC设计模式,J2EE技术开发。整个系统操作简便、界面友好,在数据安全及稳定性方面都有较高的水平。
It is well known that the oceanographic observation data have been playing an important role in promoting the development of marine science. In china, a great deal of oceanographic data have been accumulated, but the work in the data management field is just started. In order to achieve the oceanographic data sharing service, avoid the redundant investigation and idle resource and strengthen the management of oceanographic data, the First Institute of Oceanography, SOA was commissioned by the National Natural Science Foundation(NASF) in 2003 to establish the Qingdao Oceanographic Data Sharing Service Center and the associated service system for data collection, compilation and sharing under different marine science foundation projects. The main task of the service system is to achieve the internet communication between the data sharing users, and its core function is the inquiry and maintenance of different foundation project information and data. The inquiry and maintenance of different foundation project information and data. The inquiry functions includes unconditional inquiry, conditional inquiry, precise inquiry and fuzzy inquiry to facilitate the user’s inquiry, and the service system possesses integrated functions for user registration and user information management.
In this paper, the development background, development method, demand analysis, function design, database structure design and development realization of the service system are introduced, and the design concept, key techniques and solution scheme of the service system are emphatically explained. In addition, the relevant techniques such as Java, JSP ,Ajax and CSS and the relevant softwares such as Oracle, Macromedia DreamWeaver 8.0 and Tomcat 5.0 are briefly introduced.
Oracle database used for the service system has flexible database structure, excellent safety and stability, and JDBC connecting database provides good support for the database application, JSP is used to develop a sharing service system to meet the cross-platform and portable requirements, JSP can visualize the dynamic texts on pages, separate the display logic from the service logic, facilitate he development of Web application programmes and support the design of cross-platform modules such as JavaBean and JavaBean seal service logic, and JSP scripts are executed at the server terminal. The user can use Java-based Web application programme and browser software to link with the background database to make the information browse, query and maintenance.
JavaScript can be used to develop the application programme at the Internet client terminal for developing the dynamic web pages. JavaScript is included in Ajax technology, and Ajax is a complex of multiple technologies. JavaScript is used to bind XHTML, DOM, XML and XMLHttpRequest. Ajax can be used to formulate more dynamic and sensitive Web application programmes, and its main function is to adopt the interactive mode of asynchronous communication between the browser client and server, and JavaScript will update part of UI accordingly rather than refresh the entire page when the communication information returns.
The service system is based on Windows Server 2003 and Oracle database technique, and was developed by using the B/S framework, MVC design model and J2EE technology. The whole system is characterized by simple and convenient operation, friendly interface and high safety and stability.
本文详细说明了利用JSP和JavaScript等技术开发的“青岛海洋资料共享服务系统”,探讨当今海洋资料共享服务系统的开发与研究。主要介绍了基于B/S架构的青岛海洋资料共享服务系统的开发背景、开发方法、系统需求分析、系统功能设计、系统数据库结构设计、系统开发实现等。重点说明了系统的设计思想、难点技术和解决方案。同时也简单介绍了Java、JSP、Ajax、CSS等相关技术,以及Oralce、Macromedia DreamWeaver 8.0、Tomcat5.0等相关软件。
系统采用的Oracle数据库有着最为灵活的数据库结构和极高的安全性、稳定性,使用JDBC连接数据库,它对数据库应用有着良好的支持。考虑到跨平台、可移植等要求,选用JSP开发共享服务系统。JSP实现页面上的动态内容,将显示逻辑和业务逻辑分离,使Web应用程序的开发变得容易和快捷,且支持基于可重用的跨平台组件的设计如JavaBeans,JavaBeans封装业务逻辑,其脚本在服务器端执行。基于Java的Web应用程序,用户可通过浏览器软件连接后台数据库完成信息的浏览、查询与维护。
动态网页开发过程中使用JavaScript可以开发Internet客户端的应用程序。JavaScript包含于Ajax技术中,Ajax是多种技术的综合。其中使用JavaScript将XHTML、DOM、XML、XMLHttpRequest绑定。Ajax可以构建更为动态和响应更灵敏的Web应用程序,主要功能在于浏览器客户端和服务器端采用异步通信交互方式,当通讯信息返回时,使用JavaScript相应地更新部份UI,而不刷新整个页面。
本系统基于Windows Server 2003和Oracle,采用B/S架构,MVC设计模式,J2EE技术开发。整个系统操作简便、界面友好,在数据安全及稳定性方面都有较高的水平。
It is well known that the oceanographic observation data have been playing an important role in promoting the development of marine science. In china, a great deal of oceanographic data have been accumulated, but the work in the data management field is just started. In order to achieve the oceanographic data sharing service, avoid the redundant investigation and idle resource and strengthen the management of oceanographic data, the First Institute of Oceanography, SOA was commissioned by the National Natural Science Foundation(NASF) in 2003 to establish the Qingdao Oceanographic Data Sharing Service Center and the associated service system for data collection, compilation and sharing under different marine science foundation projects. The main task of the service system is to achieve the internet communication between the data sharing users, and its core function is the inquiry and maintenance of different foundation project information and data. The inquiry and maintenance of different foundation project information and data. The inquiry functions includes unconditional inquiry, conditional inquiry, precise inquiry and fuzzy inquiry to facilitate the user’s inquiry, and the service system possesses integrated functions for user registration and user information management.
In this paper, the development background, development method, demand analysis, function design, database structure design and development realization of the service system are introduced, and the design concept, key techniques and solution scheme of the service system are emphatically explained. In addition, the relevant techniques such as Java, JSP ,Ajax and CSS and the relevant softwares such as Oracle, Macromedia DreamWeaver 8.0 and Tomcat 5.0 are briefly introduced.
Oracle database used for the service system has flexible database structure, excellent safety and stability, and JDBC connecting database provides good support for the database application, JSP is used to develop a sharing service system to meet the cross-platform and portable requirements, JSP can visualize the dynamic texts on pages, separate the display logic from the service logic, facilitate he development of Web application programmes and support the design of cross-platform modules such as JavaBean and JavaBean seal service logic, and JSP scripts are executed at the server terminal. The user can use Java-based Web application programme and browser software to link with the background database to make the information browse, query and maintenance.
JavaScript can be used to develop the application programme at the Internet client terminal for developing the dynamic web pages. JavaScript is included in Ajax technology, and Ajax is a complex of multiple technologies. JavaScript is used to bind XHTML, DOM, XML and XMLHttpRequest. Ajax can be used to formulate more dynamic and sensitive Web application programmes, and its main function is to adopt the interactive mode of asynchronous communication between the browser client and server, and JavaScript will update part of UI accordingly rather than refresh the entire page when the communication information returns.
The service system is based on Windows Server 2003 and Oracle database technique, and was developed by using the B/S framework, MVC design model and J2EE technology. The whole system is characterized by simple and convenient operation, friendly interface and high safety and stability.
引文
【01】YAN S J,TIAN C Y,YANG X R. Marine Geologic Sample Information Web Promulgation Based on ASP.NET Technology[J]. Advances in Marine Science,2006,24(3):384-391.闫仕娟,田赤英,杨兴荣.基于 ASP.NET 技术的海洋地质样品信息网络发布[J].海洋科学进展, 2006,24(3):384-391.
【02】LI A H,ZHOU Y B,LIU H X,LU M.Analysis and Design of WebGIS-based Marine Science Data Sharing Platform[J]. Advances in marine science.2004,22(1): 85-90.李安虎,周玉斌,刘海行,卢铭. 基于 WebGIS 的海洋科学数据共享平台的分析与设计[J].海洋科学进展,2004,22(1): 85-90.
【03】http://tech,ccidnet.com/art/1077/20041006/709453_1.html
【04】HTML+CSS 入门讲座.V.K 工作室编著.北京:科学出版社,2001.8
【05】HTML4 实用大全(第二版).吴志滨,于莹等译.北京:中国水利水电出版社,2001.6
【06】网络编程语言 JSP 实例教程.周颢编著,牛允鹏审. 北京:电子工业出版社,2002.6
【07】JSP 编程技巧.清宏计算机工作室编著. 北京:机械工业出版社,2001.1
【08】JSP 应用开发详解(第二版).飞思科技产品研发中心编著.北京:电子工业出版社,2004.5
【09】快学易用 JSP.郭健,马圣超编著.北京:北京邮电大学出版社, 2001.5
【10】JSP 网络开发入门与实践.吴建,张旭东编著.北京:人民邮电出版社, 2006.11
【11】JSP+Oracle 网站开发实例精讲.龙马工作室编著.北京:人民邮电出版社, 2007.2
【12】JSP 入门与提高.杨学瑜,王志军,刘同利编著.北京:清华大学出版社, 2002.3
【13】JSP Web 编程指南.司马亚,牛红等译.北京:电子工业出版社, 2002.2
【14】Java 语言及应用.张卫民,黄瑞芳,卢宇彤编著.北京:清华大学出版社, 1996.10
【15】Java 基础教程.郑晓军,严望佳,朱嘉琳编著.北京:科学出版社, 1997.1
【16】Java API 参考手册.C.Fraizer,J.Bond 编著.北京:科学出版社, 1997.3
【17】Java 语言程序设计.殷兆麟编著.北京:高等教育出版社, 2002.12
【18】精通 JBuilder 3 环境下的 JAVA 编程/锐思创作室编著.北京:人民邮电出版社, 2001.1
【19】深入 JAVA Servlet 网络编程.清华大学出版社
【20】Java 课程设计.耿祥义编著.北京:清华大学出版社, 2004.1
【21】Java 就业培训教程.张孝祥编著.北京:清华大学出版社, 2003.9
【22】J2EE 应用开发(第二版).赵强编著.北京:电子工业出版社, 2006.11
【23】SQL 程序员参考手册.刘丹,冯彦君等译.北京:中国水利水电出版社,1999.5
【24】数据库理论与新技术.周志逵,江涛编著.北京:北京邮电大学出版社,2001.4
【25】Oracle 8.X For Windows NT 实用教程.瓮正科,王新英编著.北京:清华大学出版社,1998.10
【26】Ajax 开发精要.柯自聪编著.北京:电子工业出版社, 2006.5
【27】看实例学 JAVASCRIPT.麦中凡等译.北京:清华大学出版社, 1997.9
【28】趣味程序导学 JAVASCRIPT.杨正华,葛菱南编著.北京:清华大学出版社, 2002.1
【29】JavaScript 网页特效实例大全.王征编著.北京:清华大学出版社, 2006.9
【30】JavaScript 创建动态网页的高级脚步语言.Kelly Murdock 著.北京:清华大学出版社, 2001.8
【31】CGI 编程指南.蔡奇玉,连振汉,张志强编著.北京:机械工业出版社,1997.5
【32】海洋科学导论.冯士笮,李凤岐,李少菁.北京:高等教育出版社
【02】LI A H,ZHOU Y B,LIU H X,LU M.Analysis and Design of WebGIS-based Marine Science Data Sharing Platform[J]. Advances in marine science.2004,22(1): 85-90.李安虎,周玉斌,刘海行,卢铭. 基于 WebGIS 的海洋科学数据共享平台的分析与设计[J].海洋科学进展,2004,22(1): 85-90.
【03】http://tech,ccidnet.com/art/1077/20041006/709453_1.html
【04】HTML+CSS 入门讲座.V.K 工作室编著.北京:科学出版社,2001.8
【05】HTML4 实用大全(第二版).吴志滨,于莹等译.北京:中国水利水电出版社,2001.6
【06】网络编程语言 JSP 实例教程.周颢编著,牛允鹏审. 北京:电子工业出版社,2002.6
【07】JSP 编程技巧.清宏计算机工作室编著. 北京:机械工业出版社,2001.1
【08】JSP 应用开发详解(第二版).飞思科技产品研发中心编著.北京:电子工业出版社,2004.5
【09】快学易用 JSP.郭健,马圣超编著.北京:北京邮电大学出版社, 2001.5
【10】JSP 网络开发入门与实践.吴建,张旭东编著.北京:人民邮电出版社, 2006.11
【11】JSP+Oracle 网站开发实例精讲.龙马工作室编著.北京:人民邮电出版社, 2007.2
【12】JSP 入门与提高.杨学瑜,王志军,刘同利编著.北京:清华大学出版社, 2002.3
【13】JSP Web 编程指南.司马亚,牛红等译.北京:电子工业出版社, 2002.2
【14】Java 语言及应用.张卫民,黄瑞芳,卢宇彤编著.北京:清华大学出版社, 1996.10
【15】Java 基础教程.郑晓军,严望佳,朱嘉琳编著.北京:科学出版社, 1997.1
【16】Java API 参考手册.C.Fraizer,J.Bond 编著.北京:科学出版社, 1997.3
【17】Java 语言程序设计.殷兆麟编著.北京:高等教育出版社, 2002.12
【18】精通 JBuilder 3 环境下的 JAVA 编程/锐思创作室编著.北京:人民邮电出版社, 2001.1
【19】深入 JAVA Servlet 网络编程.清华大学出版社
【20】Java 课程设计.耿祥义编著.北京:清华大学出版社, 2004.1
【21】Java 就业培训教程.张孝祥编著.北京:清华大学出版社, 2003.9
【22】J2EE 应用开发(第二版).赵强编著.北京:电子工业出版社, 2006.11
【23】SQL 程序员参考手册.刘丹,冯彦君等译.北京:中国水利水电出版社,1999.5
【24】数据库理论与新技术.周志逵,江涛编著.北京:北京邮电大学出版社,2001.4
【25】Oracle 8.X For Windows NT 实用教程.瓮正科,王新英编著.北京:清华大学出版社,1998.10
【26】Ajax 开发精要.柯自聪编著.北京:电子工业出版社, 2006.5
【27】看实例学 JAVASCRIPT.麦中凡等译.北京:清华大学出版社, 1997.9
【28】趣味程序导学 JAVASCRIPT.杨正华,葛菱南编著.北京:清华大学出版社, 2002.1
【29】JavaScript 网页特效实例大全.王征编著.北京:清华大学出版社, 2006.9
【30】JavaScript 创建动态网页的高级脚步语言.Kelly Murdock 著.北京:清华大学出版社, 2001.8
【31】CGI 编程指南.蔡奇玉,连振汉,张志强编著.北京:机械工业出版社,1997.5
【32】海洋科学导论.冯士笮,李凤岐,李少菁.北京:高等教育出版社
© 2004-2018 中国地质图书馆版权所有 京ICP备05064691号 京公网安备11010802017129号 地址：北京市海淀区学院路29号 邮编：100083 电话：办公室：(+86 10)66554848；文献借阅、咨询服务、科技查新：66554700 |