Page 1/2 of JSP + MySQL website environment configuration in Windows

Use MySQL for the database (if any problem occurs during the configuration process, restart tomcat to try it)
1. Download Software
. J2se
Http://java.sun.com/j2se/.4.2/download.html
2. Tomcat server
Http://tomcat.apache.org/download-4.cgi
3. MySQL Server
Http://dev.mysql.com/downloads/mysql/5.0.html
Select Latin as the character set during installation (same as the character set used by the database)
After the database is installed, run the following command to check the character set used by the database:
Help
4. JDBC driver
Http://dev.mysql.com/downloads/connector/j/5.0.html
2. Install the above software in sequence
Assume that the paths after installation are as follows:
. J2se
C: \ j2sdks. 4.2
2. Tomcat
C: \ Program Files \ Apache Software Foundation \ Tomcat 4.
3. MySQL
C: \ Program Files \ mysql \ MySQL Server 5.0
Iii. Configuration
. Set Environment Variables
Right-click my computer and choose Properties> advanced> environment variable to add the following variables:
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. Set JSP connection to MySQL
Set
Mysql-connector-java-5.0.5-bin.jar
Mysql-connector-java-5.0.5-bin-g.jar
Copy to c: \ j2sdk. 4.2 \ Lib
Set
Mysql-connector-java-5.0.5-bin.jar
Copy
C: \ Program Files \ Apache Software Foundation \ Tomcat 4. \ common \ Lib
C: \ Program Files \ Apache Software Foundation \ Tomcat 4. \ shared \ Lib
(Never copy mysql-connector-java-5.0.5-bin-g.jar)