我用的是eclipse 我已经将驱动加载到项目中了
可是还是连不上 不知道为什么 请高手帮下忙import java.sql.*; public class DBTest {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/xxx"; //xxx表示的是当前的database
String user = "root";
String password = "yuyu525";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password); if(!conn.isClosed())
System.out.println("数据库连接成功!");
conn.close();
}
catch(ClassNotFoundException e) {
System.out.println("找不到驱动程序");
e.printStackTrace();
}
catch(SQLException e) {
e.printStackTrace();
}
}
}===============================================
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException
MESSAGE: java.net.SocketException: Permission denied: connectSTACKTRACE:java.net.SocketException: java.net.SocketException: Permission denied: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DBTest.main(DBTest.java:11)
** END NESTED EXCEPTION **
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DBTest.main(DBTest.java:11)
可是还是连不上 不知道为什么 请高手帮下忙import java.sql.*; public class DBTest {
public static void main(String[] args) {
String driver = "com.mysql.jdbc.Driver";
String url = "jdbc:mysql://localhost:3306/xxx"; //xxx表示的是当前的database
String user = "root";
String password = "yuyu525";
try {
Class.forName(driver);
Connection conn = DriverManager.getConnection(url, user, password); if(!conn.isClosed())
System.out.println("数据库连接成功!");
conn.close();
}
catch(ClassNotFoundException e) {
System.out.println("找不到驱动程序");
e.printStackTrace();
}
catch(SQLException e) {
e.printStackTrace();
}
}
}===============================================
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException
MESSAGE: java.net.SocketException: Permission denied: connectSTACKTRACE:java.net.SocketException: java.net.SocketException: Permission denied: connect
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:151)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:280)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1699)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DBTest.main(DBTest.java:11)
** END NESTED EXCEPTION **
at com.mysql.jdbc.Connection.createNewIO(Connection.java:1764)
at com.mysql.jdbc.Connection.<init>(Connection.java:405)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:268)
at java.sql.DriverManager.getConnection(Unknown Source)
at java.sql.DriverManager.getConnection(Unknown Source)
at DBTest.main(DBTest.java:11)
解决方案 »
- 可变参数列表,重载函数的区别和理解
- list集合,往里面add对象product,根据product的id值来判断,如果已经存在的,就不要add了,求一种效率比较高的判断方法!
- java题目:要求单击【登录】按钮弹出菜单,哪里有错了?关键在连接?怎么连接诶?在我的这个基础上改动!
- average方法不是static的在main方法里怎么可以调用啊!!!
- 求大侠帮我给这个c++程序改成java程序 (100分重谢)
- 问一下,我这么简单的语句哪里错啦,迷糊了
- 日期转换
- Menubar上的menuitem被图像遮挡怎么办?
- 抽象类和接口的讨论
- 初学JAVA,想找几个北京的懂JAVA的朋友!!!
- 一个程序里面创建多个JFrame要注意什么?
- 各位老师,我想请教一个问题啊,WEB开发方面二个页面session有效期的问题
网络连接错了
查看mysql的3306端口开了没有!(注意防火墙关掉)
注意密码Class.forName("com.mysql.jdbc.Driver");
con=DriverManager.getConnection("jdbc:mysql://localhost:3306/test?user=root&password=1234");
st=con.createStatement();
rs=st.executeQuery("select * from test");