java - Mysql DB连接JDBC卡住程序

Question

我已将 MySQL JDBC 库添加到我的 eclipse 项目中，但我仍然无法连接到数据库，程序没有抛出错误，它只是卡住了我。这是我使用的图书馆的链接 http://dev.mysql.com/downloads/connector/j和我当前的代码(省略了用户名、主机和密码。

  private Connection connect = null;
  private Statement statement = null;
  private PreparedStatement preparedStatement = null;
  private ResultSet resultSet = null;

@Override
    try {
          // This will load the MySQL driver, each DB has its own driver
          Class.forName("com.mysql.jdbc.Driver");
          // Setup the connection with the DB
          connect = DriverManager
              .getConnection("jdbc:mysql://host:8080/feedback?"
                  + "user=******Admin&password=********");

          // Statements allow to issue SQL queries to the database
          statement = connect.createStatement();
          // Result set get the result of the SQL query
          System.out.println("Connected");
        } catch (Exception e) {
          System.out.println("Connection failed");

解决方案我的端口错误，驱动程序安装不正确并且数据库名称错误。这是修复驱动程序后的正确连接线。

 connect = DriverManager
                  .getConnection("jdbc:mysql://localhost:3306/DataBase?"
                      + "user=****Admin&password=*******");

Answer 1

尝试以格式连接

DriverManager.getConnection("jdbc:mysql://localhost:port","username" , "password");

请使用适合您的mysql版本的最新驱动。