import java.sql.*;
public class TestMysql {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306;mydata"
, "root","root");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from dept");
while (rs.next()) {
System.out.println(rs.getString("deptno"));
} } catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(stmt != null) {
stmt.close();
stmt = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
} }}
错误提示
java.lang.NoClassDefFoundError: TestMysql
Caused by: java.lang.ClassNotFoundException: TestMysql
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
Exception in thread "main"
有时报错如下
errors during build
Errors running builder"Integrated External Tool Builder"on project JDBC,
the builder lauch configuration couldn't be found
public class TestMysql {
public static void main(String[] args) {
Connection conn = null;
Statement stmt = null;
ResultSet rs = null;
try {
Class.forName("com.mysql.jdbc.Driver");
conn = DriverManager.getConnection( "jdbc:mysql://localhost:3306;mydata"
, "root","root");
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from dept");
while (rs.next()) {
System.out.println(rs.getString("deptno"));
} } catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException ex) {
// handle any errors
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
} finally {
try {
if(rs != null) {
rs.close();
rs = null;
}
if(stmt != null) {
stmt.close();
stmt = null;
}
if(conn != null) {
conn.close();
conn = null;
}
} catch (SQLException e) {
e.printStackTrace();
}
} }}
错误提示
java.lang.NoClassDefFoundError: TestMysql
Caused by: java.lang.ClassNotFoundException: TestMysql
at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
at java.security.AccessController.doPrivileged(Native Method)
at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
at java.lang.ClassLoader.loadClass(ClassLoader.java:307)
at sun.misc.Launcher$AppClassLoader.loadClass(Launcher.java:301)
at java.lang.ClassLoader.loadClass(ClassLoader.java:248)
Exception in thread "main"
有时报错如下
errors during build
Errors running builder"Integrated External Tool Builder"on project JDBC,
the builder lauch configuration couldn't be found
解决方案 »
- javax.servlet.ServletException: Processing of multipart/form-data request failed
- 报表问题
- struts 配置出现问题
- extjs tree DWRTreeLoader从数据库读出来的叶节点在页面怎么不能添加子节点啊,但读出来的节点就可以添加子节点
- servlet包名的命名原则
- WebLogic 和Web Sphere 哪一个更好呢?
- sql 数据库的典型配置应该如何写??
- 高分求解rmi运行的问题!在线等待!急急急!!
- 能提供几本比较好的JDBC方面的书吗???
- 为什么用EJBLocalHome和EJBLocalObject,难道不是所有的调用都是远程吗?
- session的问题
- ibatis 很奇怪的问题
项目是自动build的吗?