tomcat+jsp+mysql
mysql-connector-java-3.1.6.tar.gz
下载地址 http://dev.mysql.com/downloads/connector/j/ (用户名：yangzhiming@126.com 密码：
1988ming)
1、安装JDK
下载 jdk-7-linux-i586.rpm
http://java.sun.com/javase/downloads/index.jsp
# rpm –ivh jdk-7-linux-i586.rpm
# vi ~/.bash_profile
JAVA_HOME=/usr/java/jdk1.7.0
CLASSPATH=JAVAHOME/lib:JAVA_HOME/jre/lib
PATH=PATH:JAVA_HOME/bin:$JAVA_HOME/jre/bin
export PATH CLASSPATH JAVA_HOME
使环境变量立刻生效
# source ~/.bash_profile
# source /etc/profile
# java -version （jdk的版本为jdk1.4.2则表示jdk已成功安装）。
2、安装Tomcat
下载apache-tomcat-6.0.10.tar.gz
http://jakarta.apache.org/tomcat
# tar zxf apache-tomcat-6.0.10.tar.gz -C /usr/src
# mv /usr/src/apache-tomcat-6.0.10 /usr/src/tomcat
# /usr/src/tomcat/bin/startup.sh (启动tomcat)
或
# /usr/src/tomcat/bin/catalina.sh start
Using CATALINA_BASE: /usr/local/tomcat
Using CATALINA_HOME: /usr/local/tomcat
Using CATALINA_TEMDIR: /usr/local/tomcat/temp
Using JAVA_HOME: /usr/java/jdk1.6.0_01
# /usr/src/tomcat/bin/catalina.sh start/stop (启动/关闭tomcat)
到此tomcat已经安装完成，现在使用浏览器访问 http://localhost:8080，出现tomcat默认页面，
4) 拷贝mysql驱动
cp ./mysql-connector-java-3.1.14/mysql-connector-java-3.1.14-bin.jar
/usr/src/tomcat/webapps/ROOT/WEB-INF/lib/
3 配置JDK环境变量
修改/etc/profile,加入如下几行
JAVA_HOME=/usr/local/jdk1.7.0
JRE=/usr/local/jdk1.7.0/jre
CLASSPATH=JAVAHOME/lib:JRE/lib:/usr/src/tomcat/webapps/ROOT/WEB-INF/lib/mysql-connector-java-
3.1.14-bin.jar:.
PATH=PATH:JAVA_HOME/bin:$JRE/bin:.
export JAVA_HOME JRE CLASSPATH
export PATH
4 启动TOMCAT
/usr/src/tomcat/bin/startup.sh
5 关闭TOMCAT
/usr/src/tomcat/bin/shutdown.sh
安装mysql
# useradd -M -s /sbin/nologin mysql
# tar zxf mysql-5.0.56.tar.gz -C /usr/src
# cd /usr/src/mysql-5.0.56
# ./configure --prefix=/usr/local/mysql
# make
# make install
# cp support-files/my-medium.cnf /etc/my.cnf
# /usr/local/mysql/bin/mysql_install_db --user=mysql
# chown -R root.mysql /usr/local/mysql/
# chown -R mysql /usr/local/mysql/var
# echo "/usr/local/mysql/lib/mysql" >> /etc/ld.so.conf
# ldconfig
# /usr/local/mysql/bin/mysqld_safe --user=mysql &
# 回车(Enter键)
# netstat -ntpl | grep 3306
# cp support-files/mysql.server /etc/init.d/mysqld
# chmod +x /etc/init.d/mysqld
# chkconfig --add mysqld
# chkconfig --level 35 mysqld on
# export PATH=PATH:/usr/local/mysql/bin # echo "PATH=PATH:/usr/local/mysql/bin" >> /etc/profile
# mysqladmin -u root password "123456"
# mysql -u root -p
> create database phpbb;
> use phpbb;
> create table phpbb(user_name char(30) not null,user_passwd char(20) not null);
> insert into phpbb.phpbb(user_name,user_passwd) values('phpbb',encrypt('123456');
6 写mysql.jsp 测试 (先在mysql数据库里建个数据库phpbb，表phpbb，用户phpbb，密码phpbb)
<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%Class.forName("org.gjt.mm.mysql.Driver").newInstance();
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);%>
<%while(rs.next()) {%>
<%=rs.getString(1)%>
<br>
<%}%>
<%rs.close();
stmt.close();
conn.close();
%>
</body>
</html>
7 外部测试地址http://210.51.1.148:8080/jsp/mysql.jsp
本文转自linux博客51CTO博客，原文链接http://blog.51cto.com/yangzhiming/834961如需转载请自行联系原作者
yangzhimingg
