Java 到 MySQL 的连接

Question

我在 EC2 Linux 实例上，我似乎无法获取此 java 代码来查询数据库，我在下面的代码底部显示了错误。它表明它找不到驱动程序，知道我手动安装了 mysql-connector-java-5.1.12.jar，因为我安装 Java 时它不在那里。我不确定如何检查 jar 是否安装正确？

import java.sql.*;

 public class Java2MySql{
 public static void main(String[] args) {

  String url = "jdbc:mysql://localhost:3306/";
  String dbName = "myBlog";
  String driver = "com.mysql.jdbc.Driver";
  String userName = "root";
  String password = "NoWay!";
  Connection conn = null;
  try {
       Class.forName(driver);
     }catch (ClassNotFoundException e) {
            System.out.println("Where is your MySQL JDBC Driver?");
    }

      System.out.println("MySQL JDBC Driver Registered!");

   try{
        conn = DriverManager.getConnection(url+dbName,userName,password);

        //query users
        Java2MySql j = new Java2MySql();
        j.getUsers(conn);
      } catch (SQLException e) {
        System.out.println("Connection Failed! Check output console");
        e.printStackTrace();
      } finally {
       try {
            conn.close();
          } catch (Throwable ignore){}

     }
 }

 private void getUsers(Connection conn){

 Statement stmt = null;
 ResultSet rs = null;
  try{
      stmt = conn.createStatement() ;
      String query = "select * from users ;" ;

      s = stmt.executeQuery(query) ;

       while ( rs.next() ) {
           int numColumns = rs.getMetaData().getColumnCount();
           for ( int i = 1 ; i <= numColumns ; i++ ) {
                   System.out.println( "COLUMN " + i + " = " + rs.getObject(i) );
              }
         }

    }catch(SQLException ex){
      // handle any errors
      System.out.println("SQLException: " + ex.getMessage());
      System.out.println("SQLState: " + ex.getSQLState());
    }finally {
             try {
                  rs.close();
                 } catch (SQLException sqlEx) {}

            try{
                 stmt.close();
               } catch(SQLException sqlEx){}
             }
         }

  }

异常(exception):

$java Java2MySql
Where is your MySQL JDBC Driver?
MySQL JDBC Driver Registered!
Connection Failed! Check output console
java.sql.SQLException: No suitable driver found for jdbc:mysql://localhost:3306/myBlog
    at java.sql.DriverManager.getConnection(DriverManager.java:596)
    at java.sql.DriverManager.getConnection(DriverManager.java:215)
    at Java2MySql.main(Java2MySql.java:22)

Answer 1

相关 JAR 需要位于您的 CLASSPATH 中。您可能希望在调用 java 时使用 -classpath 参数在尝试运行的 Java 应用程序之前显式设置其位置，或设置 CLASSPATH 环境变量。