1.jsp调用oracle
1.安装tomcat
[root@h1 root]# cd /var/app/
[root@h1 app]# unzip apache-tomcat-6.0.14.zip
2.复制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
out.println(hello,everybody);
%>
1.jsp [new] 17l, 81c written
3.安装jdk，，修改/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
------------------------
windwos 下修改系统环境变量
用户环境变量添加java_home
系统环境变量添加classpath=%java_hme%\lib
系统环境变量添加path=.;%java_hme%\bin;
4.启动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.编写运行
[root@h1 root]# cd /var/app/apache-tomcat-6.0.14/webapps/root
[root@h1 root]# vi
[root@h1 root]# vi db.jsp
string url=\'#\'
class.forname(oracle.jdbc.driver.oracledriver);
connection conn = drivermanager.getconnection(url,u01,abc);
statement stmt = conn.createstatement();
resultset rs = stmt.executequery(select id ,name from t1);
while(rs.next()){
out.println(rs.getint(1)+\t+rs.getstring(2)+
);
}
%>
~
db.jsp 12l, 432c written
[root@h1 root]#