首先要有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));
}
}
}
解决方案 »
- 怎么让Iterator实现多个集合
- ibatis 插入数据的一个小问题!请教·
- Point (double x1,double y1){ x=x1; y=y1;}这有没有具体的什么意思,我觉得这简直是多此一举?
- 如何更新ResultSet的列!?
- swing主窗口框架程序出现这样的错误 在线等
- 碰撞检测的问题!
- 怎么解决在对话框中放入JTabbedPane后运行时出现异常的问题?
- 请大哥哥帮我看看了,在线等待.我想请问url该如何写?我的程序总报url出错!
- 软件开发的项目书,有的就给分100
- 矢量转珊格,,谁有算法,,或思路,,谢谢
- 能不能告诉我哪里有免费的visual age for java 4.0下载
- 初学java~~有什么好书推荐啊?最好有地儿下载~~多谢了~~100分~
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)
望高手执教。