windows jsp+tomcat+mysql配置

软件：

jdk-6u10-beta-bin-b25-windows-i586-p-29_may_2008.exe

 

apache-tomcat-6.0.16.exe

 

MySQL Server 5.0

 

mysql-connector-java-5.1.1-alpha-bin.jar（分别复制到C:\Program Files\Java\jdk1.6.0_10\lib;C:\Program Files\Java\jdk1.6.0_10\jre\lib\ext；C:\Program Files\Apache Software Foundation\Tomcat 6.0\lib）

 

PATH:.;C:\Program Files\Java\jdk1.6.0_10\bin;C:\Program Files\Java\jdk1.6.0_10  \jre\bin;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem

 

CLASSPATH:.;C:\Program Files\Java\jdk1.6.0_10\lib;C:\Program Files\Java\jdk1.6.0_10\jre\lib

 

text.jsp:

 

 

<%@ page contentType="text/html; charset=gb2312" %>
<%@ page language="java" %>
<%@ page import="com.mysql.jdbc.Driver" %>
<%@ page import="java.sql.*" %>
<%
String driverName="com.mysql.jdbc.Driver";
String userName="root";
String userPasswd="62358981";
String dbName="jsp";
String tableName="teacher";
String url="jdbc:mysql://localhost/"+dbName+"?user="+userName+"&password="+userPasswd;
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection connection=DriverManager.getConnection(url);
Statement statement = connection.createStatement();
String sql="SELECT * FROM "+tableName;
ResultSet rs = statement.executeQuery(sql);

ResultSetMetaData rmeta = rs.getMetaData();

int numColumns=rmeta.getColumnCount();

out.print("id");
out.print("|");
out.print("name");
out.print("
");
while(rs.next()) {
out.print(rs.getString(1)+" ");
out.print("|");
out.print(rs.getString(2));
out.print("
");
}
out.print("
");
out.print("数据库操作成功，恭喜你");
rs.close();
statement.close();
connection.close();
%>



问题：

1，环境变量设置。

xp系统默认变量paht设置为：%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem

2,java运行路径问题

本来java解释器（1.6版）用的好好的，可是出于好奇安装了Jbuilder（内带1.3版），但删除Jbuilder后java解释器却用不了！运行的时候显示下面这些英文：
Registry key 'Software\JavaSoft\Java Runtime Environment\CurrentVersion'
has value '1.3', but '1.6' is required.
Error: could not find java.dll
Error: could not find Java 2 Runtime Environment.

在网上找了些资料可修改注册表如下:

看看'HKEY_LOCAL_MACHINE\Software\JavaSoft\Java Runtime Environment\CurrentVersion'键下有没有1.3这个键如果有就把currentversion的键值改1.6