您现在的位置：程式碼之家 >> 數據庫知識 > >> MySQL 資料庫 >> MySQL 資料庫相關知識

Linux 環境部署 JSP + Tomcat + MySQL 開發環境完整步驟

編輯：MySQL 資料庫相關知識

軟體版本與下載

元件	版本	下載連結
JDK	1.2.2_017	https://java.sun.com/products/archive/J2SE/1.2.2_017/
Tomcat	4.1.31	https://apache.freelamp.com/jakarta/tomcat-4/v4.1.31/bin/jakarta-tomcat-4.1.31.tar.gz
MySQL Connector/J	3.1.6	https://dev.mysql.com/downloads/connector/j/3.1.html

安裝步驟

1. 解壓縮至 /usr/local

cp /root/src/jdk-1_2_2_017-linux-i586.tar.gz /usr/local/
cp /root/src/jakarta-tomcat-4.1.31.tar.gz /usr/local/
cp /root/src/mysql-connector-java-3.1.6.tar.gz /usr/local/

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
rm -f *.tar.gz

2. 部署 MySQL JDBC 驅動

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 PATH

4. Tomcat 服務控制

# 啟動
/usr/local/jakarta-tomcat-4.1.31/bin/startup.sh

# 關閉
/usr/local/jakarta-tomcat-4.1.31/bin/shutdown.sh

JSP 測試程式

<%@ 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);
ResultSet rs = stmt.executeQuery("SHOW TABLES");
while(rs.next()) {
    out.println(rs.getString(1) + "<br>");
}
rs.close(); stmt.close(); conn.close();
%>
</body></html>

儲存為 mysql.jsp，瀏覽器訪問 https://server:8080/jsp/mysql.jsp 驗證。