package test;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class MySQLConnection {
public static Connection getConnection() throws InstantiationException,
IllegalAccessException, ClassNotFoundException, SQLException {
String driver = "com.mysql.jdbc.Driver";
String database = "MySQLDB";
String user = "root";
String password = "000000";
String url = "jdbc:mysql://127.0.0.1:3306/" +database+ "?user=" + user
+ "&password=" + password;
Class.forName(driver).newInstance();
Connection conn = DriverManager.getConnection(url);
return conn;
}
/**
*
*/
public MySQLConnection() {
super();
// TODO 自动生成构造函数存根
}
public static void main(String[] args) {
try {
getConnection();
System.out.println("success");
} catch (Exception e) {
System.out.println("failure!");
e.printStackTrace();
}
}
}
出现的异常:
failure!
com.mysql.jdbc.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1070)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:298)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at test.MySQLConnection.getConnection(MySQLConnection.java:20)
at test.MySQLConnection.main(MySQLConnection.java:35)
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.java:256)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
... 7 more
解决的办法:
进入命令行模式查看端口:netstat -a
终于看到端口3306没有,原来是3307.
分享到:
相关推荐
朱喜福Java网络编程第一章代码,MySqlConnnection,DBAdmin
使用Entity Framework 6.1.X连接MySQL5.7存在的几个问题的解决办法. 1.选择EF版本,弹出Your project references the latest version of EF;however,an EF database provider compatible with this version could ...
phpinclude "connnection.php" ;if ( isset ( $ _POST [ 'txtName' ])) { $ txtName = $ _POST [ 'txtName' ]; $ txtTel = $ _POST [ 'txtTel' ]; $ txtMajor = $ _POST [ 'txtMajor' ]; $ sql = "INSERT INTO ...
2.mysql的事务 1.QueryRunner 1.事务的特性ACID 2.并发访问问题----由隔离性引起 3.事务的隔离级别 默认是自动事务: 执行sql语句:executeUpdate() ---- 每执行一次executeUpdate方法 代表 事务自动提交 ...
NULL 博文链接:https://jaybin.iteye.com/blog/1407118
mqtt_client.exe 上位机,GO语言写的
Hi3516A/Hi3516D Audio Optimization Application Notes
Connnection conn1 = pool1.getConnection(); R2Pool pool2=R2PoolUtil.getPool(new File("第二个连接池的配置文件.properties")); Connnection conn2 = pool2.getConnection(); 修改源代码,请保留作者信息 张人杰...
Connnection conn1 = pool1.getConnection(); R2Pool pool2=R2PoolUtil.getPool(new File("第二个连接池的配置文件.properties")); Connnection conn2 = pool2.getConnection(); 修改源代码,请保留作者信息 张...
该库包括: ...与API进行交互的Helper类 这对于查询事件和使用配置数据非常有用-您可以使用Seq Web UI进行的所有操作,也... 浏览作为connnection属性公开的“资源组”: var installedApps = await connection . App
在服务器上安装FileZilla Server时出现425 Can’t open data connection的问题,客户端读取目录列表失败 服务器是腾讯云的,具体解决办法如下 这个问题主要是由于服务器所在网络环境的问题,解决这个问题很简单: ...
Connnection conn1 = pool1.getConnection(); R2Pool pool2=R2PoolUtil.getPool(new File("第二个连接池的配置文件.properties")); Connnection conn2 = pool2.getConnection(); 修改源代码,请保留作者信息 张...
用Navicat连接Oracle数据库时报错ORA-28547:connection to server failed,probable Oracle Net admin error-附件资源
UNITY 存储初始化工具,可以通过网络扫描到UNITY 存储信息并初始化。需要提前安装到笔记本上,本人亲测可用。
Connnection conn1 = pool1.getConnection(); R2Pool pool2=R2PoolUtil.getPool(new File("第二个连接池的配置文件.properties")); Connnection conn2 = pool2.getConnection(); 修改源代码,请保留作者...
Connnection conn1 = pool1.getConnection(); R2Pool pool2=R2PoolUtil.getPool(new File("第二个连接池的配置文件.properties")); Connnection conn2 = pool2.getConnection(); 修改源代码,请保留作者信息 ...
Connnection conn1 = pool1.getConnection(); R2Pool pool2=R2PoolUtil.getPool(new File("第二个连接池的配置文件.properties")); Connnection conn2 = pool2.getConnection(); 修改源代码,请保留作者信息 张人杰...
Connnection conn1 = pool1.getConnection(); R2Pool pool2=R2PoolUtil.getPool(new File("第二个连接池的配置文件.properties")); Connnection conn2 = pool2.getConnection(); 修改源代码,请保留作者...
Connnection conn1 = pool1.getConnection(); R2Pool pool2=R2PoolUtil.getPool(new File("第二个连接池的配置文件.properties")); Connnection conn2 = pool2.getConnection(); 修改源代码,请保留作者信息...
Connnection conn1 = pool1.getConnection(); R2Pool pool2=R2PoolUtil.getPool(new File("第二个连接池的配置文件.properties")); Connnection conn2 = pool2.getConnection(); 修改源代码,请保留作者信息...