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=$JAVA_HOME/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=$JAVA_HOME/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