tomcat
在linux下配置jsp+tomcat+mysql环境
1 下载安装文件
 1) jdk-1_2_2_017-linux-i586.tar.gz
 下载地址http://java.sun.com/products/archive/j2se/1.2.2_017/
 2) jakarta-tomcat-4.1.31.tar.gz
 下载地址http://apache.freelamp.com/jakarta/tomcat-4/v4.1.31/bin/jakarta-tomcat-4.1.31.tar.gz
 3) mysql-connector-java-3.1.6.tar.gz
 下载地址http://dev.mysql.com/downloads/connector/j/3.1.html
2 用root身份安装jdk,tomcat,mysql驱动
 1) 拷贝安装文件到/usr/local/目录
 cp /root/src/jdk-1_2_2_017-linux-i586.tar.gz /usr/local/
 cp /root/src/tar -zxvf ./jakarta-tomcat-4.1.31.tar.gz /usr/local/
 cp /root/src/tar -zxvf ./mysql-connector-java-3.1.6.tar.gz /usr/local/
 2) 解包
 cd /usr/local
 tar -zxvf ./jdk-1_2_2_017-linux-i586.tar.gz
 tar -zxvf ./jakarta-tomcat-4.1.31.tar.gz
 tar -zxvf ./mysql-connector-java-3.1.6.tar.gz
 3) 删除原安装文件
 rm -f ./*.tar.gz
 4) 拷贝mysql驱动
 cp ./mysql-connector-java-3.1.6/mysql-connector-java-3.1.6-bin.jar ./jakarta-tomcat-4.1.31/webapps/root/web-inf/lib/
3 配置jdk环境变量
 修改/etc/profile,加入如下几行
 java_home=/usr/local/jdk1.2.2
 jre=/usr/local/jdk1.2.2/jre
 classpath=$java_home/lib:$jre/lib:/usr/local/jakarta-tomcat-4.1.31/webapps/root/web-inf/lib/mysql-connector-java-3.1.6-bin.jar:.
 path=$path:$java_home/bin:$jre/bin:.
 export java_home jre classpath
 export path
4 启动tomcat
  /usr/local/jakarta-tomcat-4.1.31/bin/startup.sh
5 关闭tomcat
 /usr/local/jakarta-tomcat-4.1.31/bin/shutdown.sh
6 写mysql.jsp 测试
string url =jdbc:mysql://localhost/phpbb?user=phpbb&password=phpbb&useunicode=true&characterencoding=8859_1;
 connection conn= drivermanager.getconnection(url);
 statement stmt=conn.createstatement(resultset.type_scroll_sensitive,resultset.concur_updatable);
 string sql=show tables;
 resultset rs=stmt.executequery(sql);%>
stmt.close();
 conn.close();
 %>
7 外部测试地址http://210.51.1.148:8080/jsp/mysql.jsp