我已经拷贝了jdbc的驱动到E:\jdk1.3\lib\mysql-connector-java-2.0.14-bin.jar
并且在win2000的环境变量及系统量中加入了
classpath=e:\jdk1.3\lib\tools.jar;e:\jdk1.3\lib\dt.jar;e:\jdk1.3\lib\mysql-connector-java-2.0.14-bin.jar但是运行如下mysql数据连接测试程序时是出现以下错误
org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
C:\jakarta-tomcat\work\www.er.com_8080\_0002ftest_0002ejsptest_jsp_0.java:66: Ambiguous class: java.beans.Statement and java.sql.Statement
Statement stmt = con.createStatement(); 我的程序如下:
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%
Class.forName ("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://192.168.0.100:3306/lb?user=abc;password=abc");
Statement stmt = con.createStatement();
String query="SELECT * FROM user";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String s1 = rs.getString(1);
String s2 = rs.getString(2);
String s3 = rs.getString(3);
out.println(s1+"--"+s2+"--"+s3+" <A href='DELETE.jsp?userId="+s1+"'>删除</a><br>");
}
stmt.close();
con.close(); %>
请高手指点
并且在win2000的环境变量及系统量中加入了
classpath=e:\jdk1.3\lib\tools.jar;e:\jdk1.3\lib\dt.jar;e:\jdk1.3\lib\mysql-connector-java-2.0.14-bin.jar但是运行如下mysql数据连接测试程序时是出现以下错误
org.apache.jasper.JasperException: Unable to compile class for JSPNote: sun.tools.javac.Main has been deprecated.
C:\jakarta-tomcat\work\www.er.com_8080\_0002ftest_0002ejsptest_jsp_0.java:66: Ambiguous class: java.beans.Statement and java.sql.Statement
Statement stmt = con.createStatement(); 我的程序如下:
<%@ page import="java.sql.*"%>
<%@ page contentType="text/html;charset=gb2312"%>
<%
Class.forName ("org.gjt.mm.mysql.Driver");
Connection con = DriverManager.getConnection("jdbc:mysql://192.168.0.100:3306/lb?user=abc;password=abc");
Statement stmt = con.createStatement();
String query="SELECT * FROM user";
ResultSet rs = stmt.executeQuery(query);
while (rs.next()) {
String s1 = rs.getString(1);
String s2 = rs.getString(2);
String s3 = rs.getString(3);
out.println(s1+"--"+s2+"--"+s3+" <A href='DELETE.jsp?userId="+s1+"'>删除</a><br>");
}
stmt.close();
con.close(); %>
请高手指点
形成C:\Tomcat\classes\ORG\GJT\MM\MYSQL