數(shù)據(jù)庫采用mysql(配置過程如有問題可以重啟tomcat試一下)
一、下載軟件
.J2SE
http://java.sun.com/j2se/.4.2/download.html
2.Tomcat服務(wù)器
http://tomcat.apache.org/download-4.cgi
3.mysql服務(wù)器
http://dev.mysql.com/downloads/mysql/5.0.html
安裝時字符集選latin(應(yīng)與數(shù)據(jù)庫采用字符集相同)
安裝好數(shù)據(jù)庫后用以下命令看數(shù)據(jù)庫采用什么字符集:
help
4.JDBC驅(qū)動
http://dev.mysql.com/downloads/connector/j/5.0.html
二、依次安裝以上軟件
假設(shè)安裝后的路徑分別如下：
.J2SE
C:\j2sdk.4.2
2.Tomcat
C:\Program Files\Apache Software Foundation\Tomcat 4.
3.mysql
C:\Program Files\MySQL\MySQL Server 5.0
三、配置
.設(shè)置環(huán)境變量
在'我的電腦'上點(diǎn)右鍵,屬性->高級->環(huán)境變量,添加如下變量:
PATH=%PATH%;C:\j2sdk.4.2\bin;C:\Program Files\MySQL\MySQL Server 5.0\bin
JAVA_HOME=C:\j2sdk.4.2
CLASSPATH=C:\j2sdk.4.2\lib\tools.jar;mysql-connector-java-5.0.5-bin.jar;mysql-connector-java-5.0.5-bin-g.jar
TOMCAT_HOME=C:\Program Files\Apache Software Foundation\Tomcat 4.
2.jsp連接mysql設(shè)置
把
mysql-connector-java-5.0.5-bin.jar
mysql-connector-java-5.0.5-bin-g.jar
拷貝到C:\j2sdk.4.2\lib
把
mysql-connector-java-5.0.5-bin.jar
拷貝到
C:\Program Files\Apache Software Foundation\Tomcat 4.\common\lib
C:\Program Files\Apache Software Foundation\Tomcat 4.\shared\lib
(千萬別復(fù)制mysql-connector-java-5.0.5-bin-g.jar)