importjava.beans.Statement;importjava.sql.DriverManager;importjava.sql.ResultSet;importjava.sql.SQLException;importcom.sun.corba.se.pept.transport.Connection;publicclassc...
import java.beans.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import com.sun.corba.se.pept.transport.Connection;
public class connect {
/**
* @param args
*/
public static void main(String[] args) {
try
{
Class.forName("com.mysql.jdbc.Driver");
Connection con=(Connection) DriverManager.getConnection("jdbc:mysql://localhost:3306/angel_info","dbuser","1234");
Statement stat=(Statement) ((java.sql.Connection) con).createStatement();
String sql="select * from angel_info";
ResultSet rs=((java.sql.Statement) stat).executeQuery(sql);
while(rs.next())
{
System.out.println(rs.getString("id"));
}
}
catch(SQLException e)
{System.out.println(e);}
catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
}
java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
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)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Unknown Source)
at connect.main(connect.java:17)
classpath如下:
.;%JAVA_HOME%\lib\dt.jar;%JAVA_HOME%\lib\tools.jar;%CATALINA_HOME%\common\lib\servlet-api.jar;%JAVA_HOME%\lib;D:\Program Files\Java\jre1.5.0_09\lib;D:\Program Files\Tomcat 5.5\common\lib\mysql-connector-java-3.1.14-bin.jar
展开