JSP远程访问Oracle数据库

JSP Remote Access to Oracle Database

安全的Web应用平台将应用程序服务和数据库服务相分离,采取远程访问数据库的方式来保障数据的安全。结合实例介绍了JSP远程访问Oracle数据库的技术。Web服务器端是以Windows XP+JDK 1.6+Tomcat 6.0为平台,介绍了JDK 1.6、Tomcat 6.0的环境配置以及如何在Tomcat 6.0服务器上建立虚拟目录的方法。数据库服务器端是以Solaris 10+Oracle 11g为平台,描述了如何通过Oracle客户端工具远程连接、管理数据库。最后,结合数据库中新建测试表,提供了基于JDBC接口访问Oracle数据库的JSP程序实例,为进一步研究优化远程访问Oracle数据库技术奠定了基础。

Web application security platform is the application services and database services phase separation, to take remote access databases to protect data security. This paper introduced the JSP examples of remote access to Oracle database technology. Web server-side is based on Windows XP＋JDK 1.6＋Tomcat 6.0 as a platform, introduced a JDK 1.6, Tomcat 6.0 environment and how to configure Tomcat 6.0 server, create a virtual directory approach. Database server side is based on Solaris 10 -k Oracle llg as a platform, describes how through the Oracle client tools to connect remotely to manage the database. Finally, the combination of the database to test the new form, providing information based on the JDBC interface JSP visit to Oracle database instances, for further research to optimize remote access to Oracle database technology laid the foundation.