菜鸟,初写连接数据库的程序,报错不知道如何解决帮忙(附代码)

[ncflywolf]

import java.sql.*;
import javax.naming.*;
import java.util.*;

public class sqltomy
{

public static void main(String[] args)
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url = "jdbc:mysql://localhost:3306/centerdb?user=root&password=&useUnicode=true&characterEncoding=gb2312" ;
Connection conn = DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from aaa limit 0,10";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(0));
}
}
}

--------------------Configuration: j2sdk1.4.2 <Default>--------------------
C:\Program Files\Xinox Software\JCreator Pro\MyProjects\sqltomy.java:10: unreported exception java.lang.ClassNotFoundException; must be caught or declared to be thrown
Class.forName("org.gjt.mm.mysql.Driver").newInstance();

[Philzzf]

改成：
import java.sql.*;
import javax.naming.*;
import java.util.*;

public class sqltomy
{

public static void main(String[] args) throws Exception //modified
{
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url = "jdbc:mysql://localhost:3306/centerdb?user=root&password=&useUnicode=true&characterEncoding=gb2312" ;
Connection conn = DriverManager.getConnection(url);
Statement stmt=conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql = "select * from aaa limit 0,10";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString(0));
}
}
}

[ncflywolf]

我这样改过,编译通过,但是执行就报:
Exception in thread "main" java.lang.ClassNotFoundException:org.git.mm.myslq.Driver

Press any key to Continue ...

[watermoon515]

mysql是不是没有配置好啊

[林仪明]

嗯嗯！估计是没有配置好！

[cxj_2000]

java -classpath path_to_mysql_driver sqltomy

[creatpro]

用jbuilder编译试一下