首先要有jdbc driver到网上找找
代码如下package congtest;import java.sql.*;
import java.util.*;public class TestMySQL{
public static void main(String[] args) throws Exception{
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/cong");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from test");
while(rs.next()){
System.out.println(rs.getString(1));
}
}
}
代码如下package congtest;import java.sql.*;
import java.util.*;public class TestMySQL{
public static void main(String[] args) throws Exception{
Class.forName("org.gjt.mm.mysql.Driver");
Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/cong");
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("select * from test");
while(rs.next()){
System.out.println(rs.getString(1));
}
}
}
E:\javacode>java TestMySQL
Exception in thread "main" java.lang.NoClassDefFoundError: TestMySQL (wrong name
: congtest/TestMySQL)
at java.lang.ClassLoader.defineClass0(Native Method)
at java.lang.ClassLoader.defineClass(Unknown Source)
at java.security.SecureClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.defineClass(Unknown Source)
at java.net.URLClassLoader.access$100(Unknown Source)
at java.net.URLClassLoader$1.run(Unknown Source)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at sun.misc.Launcher$AppClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClass(Unknown Source)
at java.lang.ClassLoader.loadClassInternal(Unknown Source)
望高手执教。