jsp mysql tomcat配置_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:

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