jsp连接mysql数据库连不上几天了，大哥门，帮小第一把

Question

下面是错误提示：500 Servlet Exception
Note: sun.tools.javac.Main has been deprecated.
/myjsp/sql3.jsp:10: Undefined variable: drvier
   Class.forName(drvier);
                 ^
/myjsp/sql3.jsp:18: Undefined variable or class name: DriverManger
   Connection DBcon = DriverManger.getConnection(ur1,userID,passwd);
                      ^
/myjsp/sql3.jsp:19: Method isClose() not found in interface java.sql.Connection.
   if( !DBcon.isClose() )
                     ^
3 errors, 1 warning

Answer 1

3个拼写错误1.
Class.forName(driver);
2.
Connection DBcon = DriverManager.getConnection(ur1,userID,passwd);
3.
if( !DBcon.isClosed() )

Answer 2

http://expert.csdn.net/Expert/FAQ/FAQ_Index.asp?id=15371

Answer 3

xue_sharp(著名的反派角色) 不是写了吗
1
把
Class.forName(drvier); 
改为
Class.forName(driver);
2.
把
Connection DBcon = DriverManger.getConnection(ur1,userID,passwd);
改为
Connection DBcon = DriverManager.getConnection(ur1,userID,passwd);
3.
把
if( !DBcon.isClose() )
改为
if( !DBcon.isClosed() )

Answer 4

谢谢你的，又有问题了
程序说:"无法载入org.gjt.mm.mysql.Driver驱动程序无法连接到数据库"
可我已经把"mm.mysql-2.0.4-bin.jar"考到:F:\resin\lib下了，怎么办？

Answer 5

在classpath里指一下驱动的路径！

Answer 6

"classpath"在哪里？在resin.conf里还是2000的环境变量？

Answer 7

我在2000的环境变量里已经设置了ClassPath="F:\resin\lib"可是还是老样字：“无法载入org.gjt.mm.mysql.Driver驱动程序无法连接到数据库”。急死人了，怎么办？

Answer 8

在你的JDK安装目录下有没有$root$\JSDK\src\com\mysql\jdbc\
如果有，应该不会有问题。再给你一个例子：
import java.sql.*;
import java.io.*;public class MySQL{
public static void main(String[] args){
try{
Class.forName("com.mysql.jdbc.Driver");
// Connection conn = DriverManager.getConnection(
// "jdbc:mysql://localhost/mysql?user=root&password=root");
Connection conn1 = DriverManager.getConnection(
"jdbc:mysql://202.114.13.195/mysql","root","root");
// Statement stmt = conn.createStatement();
Statement stmt1 = conn1.createStatement();
// ResultSet rslt = stmt.executeQuery("select * from user");
ResultSet rslt1 = stmt1.executeQuery("select * from user"); /* while(rslt.next()){
System.out.print(rslt.getString(1));
System.out.print(" ");
System.out.print(rslt.getString(2));
System.out.print(" ");
System.out.print(rslt.getString(3));
System.out.print(" ");
System.out.print(rslt.getString(4));
System.out.print(" ");
System.out.print(rslt.getString(5));
System.out.print(" ");
System.out.print(rslt.getString(6));
System.out.print(" ");
System.out.print(rslt.getString(7));
System.out.print(" ");
System.out.print(rslt.getString(8));
System.out.print(" ");
System.out.print(rslt.getString(9));
System.out.print(" ");
System.out.print(rslt.getString(10));
System.out.print(" ");
System.out.print(rslt.getString(11));
System.out.print(" ");
System.out.print(rslt.getString(12));
System.out.print(" ");
System.out.print(rslt.getString(13));
System.out.println("");
}*/
// System.out.println(rslt1.toString());
System.out.println("³É¹¦À²£¡Connected to remote server successfully!");
while(rslt1.next()){
System.out.print(rslt1.getString(1));
System.out.print(" ");
System.out.print(rslt1.getString(2));
System.out.print(" ");
System.out.print(rslt1.getString(3));
System.out.print(" ");
System.out.print(rslt1.getString(4));
System.out.print(" ");
System.out.print(rslt1.getString(5));
System.out.print(" ");
System.out.print(rslt1.getString(6));
System.out.print(" ");
System.out.print(rslt1.getString(7));
System.out.print(" ");
System.out.print(rslt1.getString(8));
System.out.print(" ");
System.out.print(rslt1.getString(9));
System.out.print(" ");
System.out.print(rslt1.getString(10));
System.out.print(" ");
System.out.print(rslt1.getString(11));
System.out.print(" ");
System.out.print(rslt1.getString(12));
System.out.print(" ");
System.out.print(rslt1.getString(13));
System.out.println("");
}
/* while(rslt1.next()){
System.out.print(rslt1.getString(1));
System.out.print(" ");
System.out.print(rslt1.getString(2));
System.out.print(" ");
System.out.print(rslt1.getString(3));
System.out.print(" ");
System.out.print(rslt1.getString(4));
System.out.print(" ");
System.out.print(rslt1.getString(5));
System.out.print(" ");
System.out.print(rslt1.getString(6));
System.out.println("");
}*/
}catch(Exception e){
e.printStackTrace();
}
}
}

Answer 9

Windows2000下设置环境变量的方法：右键“我的电脑”－》属性－》高级－》环境变量－》系统变量：添加变量名classpath，将你的包路径添加上去。

Answer 10

谢谢这位大哥，我连上去了，原来我没有解压src.zip

Answer 11

按楼上的方法，如下添加
classpath=F:\resin\lib\mm.mysql-2.0.4-bin.jar