java连接服务器问题
源代码:
package daowithmysql;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class Conect {
public static void main (String[] args) {
try {
Class.forName("com.mysql.cj.jdbc.Driver");
System.out.println("We have succeed in loading Driver program.");
} catch (ClassNotFoundException e){
System.out.println("We have failed in loading Driver program.");
return;
}
String url = "jdbc:mysql://localhost:3306/mydb?verifyServerCertificate=false&useSSL=false";
String user = "root";
String password = "ROOT123456";
try (Connection c = DriverManager.getConnection(url, user, password)){
System.out.println("We have succeed in connecting the SQL: " + c);
} catch (SQLException e) {
e.printStackTrace();
}
}
}
然后eclipse控制台输出:
ading Driver program.
java.sql.SQLSyntaxErrorException: Unknown database 'mydb'
at mysql.connector.java@8.0.13/com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
at mysql.connector.java@8.0.13/com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
at mysql.connector.java@8.0.13/com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
at mysql.connector.java@8.0.13/com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:835)
at mysql.connector.java@8.0.13/com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
at mysql.connector.java@8.0.13/com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
at mysql.connector.java@8.0.13/com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:677)
at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:228)
at daowithmysql.Conect.main(Conect.java:19)
报的错是,不存在'mydb'这个数据库
若你程序是参考别人的,你要按你自己的环境修改相应的程序的
或在你的mysql服务器中建立相应的数据库
下一篇:试验室评审准则报告编制、审核、签发程序重点关注的内容是什么
上一篇:求高手指点