JSP + SQL2000 Development Environment installation and configuration

JSP + SQL2000 Development Environment installation and configuration

I. Software preparation

Java Runtime Environment jdk1.4.1: install the software j2sdk-00004_000001-windows-i586.exe

JSP server tomcat5.5: install the software apache-tomcat-5.5.17.exe

SQL2000 database server: sql2000.rar

SQL2000 SP4 Patch: Install software SQL2000-KB884525-SP4-x86-CHS.EXE

SQL2000 JDBC driver: msbase. jar, MSSQLServer. jar, msutil. Jar

Ii. JDK installation and configuration

J2sdk-1_4_1_01-windows-i586.exe installation path: "D:/Java/j2sdk1.4.1 _ 01 /"
The j2sdk-1_4_1_01-windows-i586.exe automatically generates the "C:/program files/Java/j2re1.4.1 _ 01/" directory after installation

JDK configuration: Open "my computer-> properties-> advanced-> environment variables" on the desktop"

Add a classpath environment variable with the following values: D:/Java/j2sdk1.4.1 _ 01/lib/dt. jar; D:/Java/j2sdk1.4.1 _ 01/lib/tools. Jar

Modify the value of the PATH environment variable, open the path environment variable, and add the following:; D:/Java/j2sdk1.4.1 _ 01/bin; C: /program files/Java/j2re1.4.1 _ 01/bin

Install configuration check: Open "system Start Menu-> RUN> cmd>" and enter Java-version in the command line. If you get the version and model, the installation is successful.

Iii. installation and configuration of tomcat5.5

Tomcat5.5 installation: apache-tomcat-5.5.17.exe installation path: "C:/program files/Apache Software Foundation/tomcat 5.5 /"

Tomcat5.5 configuration: Open "my computer"> Properties> advanced> environment variable "on the desktop, find the environment variable in classpath, edit the variable value, and add"; C: /program files/Apache Software Foundation/tomcat 5.5/common/lib/servlet-api.jar"

Installation configuration check: Open IE and enter http: // localhost: 8080/. If yes, the installation is successful. Servlet can also run

Iv. installation and configuration of SQL2000
SQL2000 program file installation path: "C:/program files/Microsoft SQL Server"
SQL2000 database file installation path: "D:/program files/Microsoft SQL Server"

V. installation and configuration of SQL2000 JDBC driver

Open C:/program files/Microsoft SQL Server 2000 driver for JDBC/lib on the local hard disk and find msbase. jar, MSSQLServer. jar, and msutil. jar.
Copy these three files to the Tomcat server installation path C:/program files/Apache Software Foundation/tomcat 5.5/common/lib/