你的ClassPath中有没有包括mysql-connector-java-3.0.7-stable-bin.jar?
还有你用的JDK是1.3还是1.4?
还有你用的JDK是1.3还是1.4?
解决方案 »
- 如何从文件中读取字节,位运算
- 学习Java的好的书籍是什么,请教有经验的高手
- 变态题
- 想做一个Panel,在Frame上能用鼠标修改大小,应该怎么做好?
- *************求 myeclipseide8 m2 的下载地址*************
- java中如何读取图片信息。
- 在执行Runtime.exec的时候所执行的程序是否受JDK的约束呢?
- 如何用java编程实现生成csr(请求证书文件)?
- 谁可以给我一个java的例子读excel的*.cvs文件,thanks
- 怎么样去除浏览器中的滚动条,而采用内部的滚动条!
- 关于HttpURLConnection中的POST?
- 关于package的问题,在线等
改成
driver="org.gjt.mm.mysql.Driver";
Version 1.4.1 for windowsaccp(只有在梦醒的时候才知道自己是做了一个梦) String driver="com.mysql.jdbc.Driver";
改成
driver="org.gjt.mm.mysql.Driver";两个都试过都不行!
你有没有设?
public static void main(String[] args) {
try {
String driver = "org.gjt.mm.mysql.Driver";
String url = "jdbc:myql://localhost:3306/sunnywest";
String user = "root";
String password = "12345";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from send");
while (rs.next()) {
System.out.println("" + rs.getInt(1) + "");
System.out.println(":" + "<br>");
}
rs.close();
conn.close();
}
catch (Exception e) {
e.printStackTrace();
}
}
这个就可以运行
把你的出错信息贴出来~
your CLASSPATH (see the "USAGE AND INSTALLATION" section above), or your
URL format is incoorect (once again see "USAGE AND INSTALLATION").USAGE AND INSTALLATIONMySQL Connector/J is distributed as a .zip or .tar.gz archive containing
the sources and class files as well as a class-file only "binary" .jar
archive named "mysql-connector-java-3.0.7-stable-bin.jar".You will need to use the appropriate gui or command-line utility to un-archive
the distribution (for example, WinZip for the .zip archive, and "tar" for
the .tar.gz archive).Once you have un-archived the distribution archive,
you can install the driver in one of two ways:Either copy the "com" and "org" subdirectories and all of their contents
to anywhere you like, and put the directory holding the "com" and "org"
subdirectories in your classpath, or...Put mysql-connector-java-3.0.7-stable-bin.jar in your classpath, either by adding the
FULL path to it to your CLASSPATH enviornment variable, or putting it
in $JAVA_HOME/jre/lib/ext.
at java.sql.DriverManager.getConnection(DriverManager.java:532)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at Mysql.main(Mysql.java:15)
import java.sql.*;class Mysql
{
public static void main(String[] args) {
try {
String driver = "org.gjt.mm.mysql.Driver";
String url = "jdbc:myql://localhost:3306/sunnywest";
String user = "root";
String password = "sunnyday";
Connection conn = null;
ResultSet rs = null;
Statement stmt = null;
Class.forName(driver).newInstance();
conn = DriverManager.getConnection(url, user, password);
stmt = conn.createStatement();
rs = stmt.executeQuery("select * from send");
while (rs.next()) {
System.out.println("" + rs.getInt(1) + "");
System.out.println(":" + "<br>");
}
rs.close();
conn.close();
}
catch (Exception e) {
e.printStackTrace();
}
}}
1、JavaTM 2 SDK, Standard Edition Version 1.4.1 for windows
位置 c:\j2sdk2、将mysql-connector-java-3.0.8-stable-bin.zip解压缩到了c:\j2sdk\mysql下
也把mysql-connector-java-3.0.8-stable-bin.jar复制到c:\j2sdk\jre\lib\ext下了3、set classpath=.;c:\j2sdk\mysql;c:\j2sdk\mysql\mysql-connector-java-3.0.8-stable-bin.jar;%classpath%
少一个字母~~~~
String url = "jdbc:mysql://localhost:3306/sunnywest";
文件名字是 mysql-connector-java-3.0.8-stable.zip
包含bin和source两种文件,下在地址是
http://www.mysql.com/downloads/download.php?file=Downloads%2FConnector-J%2Fmysql-connector-java-3.0.8-stable.zip&mirror=http%3A%2F%2Fmysql.todayisp.com%2F2、解压缩下载的文件,比如这个 mysql-connector-java-3.0.8-stable.zip
建议解压缩到 %JAVA_HOME%\mysql 目录下
%JAVA_HOME%是jdk的安装目录。3、mysql for jdbc driver有两种或三种安装发式: 第一种方法:因为com和org两个目录都在%JAVA_HOME%\mysql下
set classpath=.;%JAVA_HOME%\mysql;%classpath% 第二种方法:因为mysql-connector-java-3.0.8-stable-bin.jar在 %JAVA_HOME%\mysql 目录下
set classpath=.;%JAVA_HOME%\mysql\mysql-connector-java-3.0.8-stable-bin.jar.jar;%classpath% 第三种方法:直接把mysql-connector-java-3.0.8-stable-bin.jar拷贝到%JAVA_HOME%\jre\lib\ext下
%JAVA_HOME%就是J2SDK的安装目录,如我的为c:\j2sdk就拷贝到c:\j2sdk\jre\lib\ext下谢谢大家,总结一下,感觉自己还是很粗心,呵呵!
mysql's English Document 请参见
mysql-connector-java-3.0.8-stable.zip
中的README,再次谢谢大家。
明天结帖!
1、JavaTM 2 SDK, Standard Edition Version 1.4.1 for windows
位置 c:\j2sdk2、将mysql-connector-java-3.0.8-stable-bin.zip解压缩到了c:\j2sdk\mysql下
也把mysql-connector-java-3.0.8-stable-bin.jar复制到c:\j2sdk\jre\lib\ext下了3、set classpath=.;c:\j2sdk\mysql;c:\j2sdk\mysql\mysql-connector-java-3.0.8-stable-bin.jar;%classpath%