1. jsp calls Oracle
1. install tomcat
[Root @ h1 ROOT] # cd/var/App/
[Root @ h1 App] # unzip apache-tomcat-6.0.14.zip
2. Copy ojdbc. jar
[Root @ h1 ~] # Cd/app/oracle/product/11.2.0/dbhome_2/jdbc/lib
[Root @ h1 lib] # find ojdbc6.jar
Ojdbc6.jar
[Root @ h1 lib] # cp ojdbc6.jar/var/App/apache-tomcat-6.0.14/lib/
[Root @ h1 lib] # cd/var/App/apache-tomcat-6.0.14/lib/
[Root @ h1 lib] # ls
Annotations-api.jar el-api.jar ojdbc6.jar tomcat-i18n-fr.jar
Catalina-ant.jar jasper-el.jar servlet-api.jar tomcat-i18n-ja.jar
Catalina-ha.jar jasper. jar tomcat-coyote.jar
Catalina. jar jasper-jdt.jar tomcat-dbcp.jar
Catalina-tribes.jar jsp-api.jar tomcat-i18n-es.jar
[Root @ h1 webapps] # cd/var/App/apache-tomcat-6.0.14/webapps/ROOT
[Root @ h1 ROOT] # vi 1.jsp
<%
<% @ Page pageEncoding = 'gbk' %>
<%
Out. println ("Hello, Everybody ");
%>
"1.jsp" [New] 17L, 81C written
3. Install jdk and modify/etc/profile
[Root @ h1 ROOT] # cd/var/App/
[Root @ h1 APP] #./jdk-6u27-linux-x64.bin
[Root @ h1 App] # vi/etc/profile
Export JAVA_HOME =/var/App/jdk1.6.0 _ 27
Export PATH = $ JAVA_HOME/bin:.: $ PATH
Export CLASSPATH = $ JAVA_HOME/lib :.
"/Etc/profile" 84L, 1905C written
[Root @ h1 App] # source/stc/profile
------------------------
Modify system environment variables in windwos
Add JAVA_HOME to user environment variables
Add CLASSPATH = % JAVA_HME % \ lib to the system environment variable
Add PATH =.; % JAVA_HME % \ bin to the system environment variable;
4. start tomcat
[Root @ h1 bin] # cd/var/App/apache-tomcat-6.0.14/bin
[Root @ h1 bin] # ls
Bootstrap. jar catalina-tasks.xml digest. bat service. bat shutdown. bat startup. sh tomcat-juli.jar tool-wrapper.sh
Catalina. bat commons-daemon.jar digest. sh setclasspath. bat shutdown. sh tomcat6.exe tomcat-native.tar.gz version. bat
Catalina. sh cpappend. bat jsvc.tar.gz setclasspath. sh startup. bat tomcat6w.exe tool-wrapper.bat version. sh
[Root @ h1 bin] #./startup. sh
-Bash:./startup. sh: Permission denied
[Root @ h1 bin] #./startup. sh
Using CATALINA_BASE:/var/App/apache-tomcat-6.0.14
Using CATALINA_HOME:/var/App/apache-tomcat-6.0.14
Using CATALINA_TMPDIR:/var/App/apache-tomcat-6.0.14/temp
Using JRE_HOME:/var/App/jdk1.6.0 _ 27
5. Write and run
[Root @ h1 ROOT] # cd/var/App/apache-tomcat-6.0.14/webapps/ROOT
[Root @ h1 ROOT] # vi
[Root @ h1 ROOT] # vi db. jsp
<% @ Page contentType = "text/html; charset = gbk" import = "java. SQL. *" %>
<%
String url = \'#\'"
Class. forName ("oracle. jdbc. driver. OracleDriver ");
Connection conn = DriverManager. getConnection (url, "u01", "abc ");
Statement stmt = conn. createStatement ();
ResultSet rs = stmt.exe cuteQuery ("select id, name from t1 ");
While (rs. next ()){
Out. println (rs. getInt (1) + "\ t" + rs. getString (2) + "<br> ");
}
%>
~
"Db. jsp" 12L, 432C written
[Root @ h1 ROOT] #