从网上找了个例子改了下用户名和表:public class TestMysql { public static void main(String args[]) {
try {
/* Test loading driver */
String driver = "com.mysql.jdbc.Driver"; System.out.println( "=> loading driver:" );
Class.forName( driver ).newInstance();
System.out.println( "OK" ); /* Test the connection */
//String url = "jdbc:mysql://localhost/coffeebreak"; System.out.println( "=> connecting:" );
//java.sql.DriverManager.getConnection( url, "root", "pass" ); java.sql.DriverManager.getConnection("jdbc:mysql://localhost/coffeebreak?user=root&password=pass");
System.out.println( "OK" );
}
catch( Exception x ) {
x.printStackTrace();
}
}
}
环境:
MySQL 5.0
Java jdk1.6
mysql-connector-java 5.1.5参考的这篇文章:http://www.cs.wcupa.edu/~rkline/mysql-java-win.html弄的但是 加载驱动之后连不上数据库,提示:
Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
074)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:283)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at TestMysql.main(TestMysql.java:18)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
va:256)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
... 12 more
请问是虾米原因啊?多谢
try {
/* Test loading driver */
String driver = "com.mysql.jdbc.Driver"; System.out.println( "=> loading driver:" );
Class.forName( driver ).newInstance();
System.out.println( "OK" ); /* Test the connection */
//String url = "jdbc:mysql://localhost/coffeebreak"; System.out.println( "=> connecting:" );
//java.sql.DriverManager.getConnection( url, "root", "pass" ); java.sql.DriverManager.getConnection("jdbc:mysql://localhost/coffeebreak?user=root&password=pass");
System.out.println( "OK" );
}
catch( Exception x ) {
x.printStackTrace();
}
}
}
环境:
MySQL 5.0
Java jdk1.6
mysql-connector-java 5.1.5参考的这篇文章:http://www.cs.wcupa.edu/~rkline/mysql-java-win.html弄的但是 加载驱动之后连不上数据库,提示:
Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1
074)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Sou
rce)
at java.lang.reflect.Constructor.newInstance(Unknown Source)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java
:283)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at TestMysql.main(TestMysql.java:18)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(Unknown Source)
at java.net.PlainSocketImpl.connectToAddress(Unknown Source)
at java.net.PlainSocketImpl.connect(Unknown Source)
at java.net.SocksSocketImpl.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.connect(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at java.net.Socket.<init>(Unknown Source)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.ja
va:256)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
... 12 more
请问是虾米原因啊?多谢
解决方案 »
- MySQL FROM_UNIXTIME和UNIX_TIMESTAMP
- 这句话出错,,请问错在何处
- mysql的管理工具navicat 8.0表中数据无法存储中文问题
- mysql里如何得到格林时间 ?
- 2003系统 安装mysql 问题 在线等!!急急
- mysql 采用 gbk,程序中该怎么写?
- 请问mysql中如何改变系统的语言别问题
- mysql两个字段模糊匹配问题请教
- cpanel操作 ,架设论坛给数据库用户名什么权限比较合适?
- mysql: unknown variable 'character_set_server=utf8'按照网上的改了字符集也是不行
- group by 后取最新的纪录问题
- mysql数据库命名规则
"root", "你的密码");
把getConnection改这种形式试试。而且你连的是coffeebreak这个库,你有没有建出来
at java.net.Socket.connect(Unknown Source)像这些写Unknown Source的,估计是配置问题