My environment is Windows 2000, but the same concept should be available in Linux. I will have a chance to verify it, and then POST. 1. First install JDK 1.4.2_01, http://java.sun.com/j2se/2 Next, the ORACLE9I is installed. After the installation is complete, change the parameters of XML Database because XML Database's HTTP Server preset use port 8080, will be able to change the proposes with Tomcat to change to 8081, refer to these two pictures http://home.pchome.com .tw / service / anthonycs / image / oracle04.gifhttp: //home.pchome.com.tw/service/anthonycs/image/oracle05.gif3. You can then install Tomcat, use the JDK1.4.2_01 installed as Tomcat as Tomcat Virtual Machine4 Download Oracle JDBC Driver http://otn/java/sqlj_jdbc/content.html According to JDK1.4.2_01, Oracle 9.2.0.1.0 is three files OCRS12.ZIP OJDBC14. Jar ojdbc14_g.jar places the downloaded file to / WebApps / Examples / Web-INF / LIB / Restart Tomcat service Note: To pick the correct JDK and Oracle version of Driverjdk, Tomcat, Oracle JDBC Driver should be coordinated, especially CAUTION There are more than two JDK versions to install Tomcat. HR is an example, refer to the three pictures below, the picture is large, and you will be able to enjoy the better http://home.pchome.com.tw/service/anthonycs/image/oracle01.gifhtp://home.pchome.com. Tw / Service / Anthonycs / Image / Oracle02.gifhttp: //home.pchome.com.tw/service/anthonycs/image/oRacle03.gif6. Write a JSP page, refer to the following blue Part of the Oracle host is set (IP, SID, password) <% @ page contenttype = "text / html; charSet = BIG5" Language = "java" import = "java.sql. *, Oracle.jdbc. * "%>
<% results = null; string oracle: th: @oracle host ip: 1521: SID "; string oracleuser =" hr "; string oraclepass =" xxxx "; try {drivermanager.registerdriver (new oracle.jdbc.driver.Oracledriver ());} catch (sqlexception e) {Out.Print (" Driver } ");} Try {connection conn =