未找到适用于jdbc：mysql/localhost:3306/world的驱动程序

Question

java.sql.sqlexception：未找到适用于JDBC的驱动程序：MySQL/localhost:3306/World在java.sql.drivermanager.getConnection（drivermanager.java:689)在java.sql.drivermanager.getConnection（drivermanager.java:247)在db.main（db.java:20)

下面是我的代码：

import java.io.Serializable;

import java.sql.*;

public class Db implements Serializable{


public static void main(String args[]){
    Connection connection;
    final String dbURL = "jdbc:mysql/localhost:3306/world";
    final String username = "root";
    final String pswd = "******";
    try{
        DriverManager.getDrivers();
        connection = DriverManager.getConnection(dbURL,username,pswd);
        Statement statement = connection.createStatement();
        String query = "SELECT * FROM city WHERE Name LIKE 'New%'";
        ResultSet result = statement.executeQuery(query);
        while(result.next()){

            int id          = result.getInt("ID");
            String name     = result.getString("Name");
            String cCode    = result.getString("CountryCode");
            String district = result.getString("District");
            int pop         = result.getInt("Population");

            System.out.print("id = "+id+"</br>Name = "+name+
                    "</br>Code = "+cCode+"</br>District = "+district+
                    "</br>Population = "+pop+"</br>");
        }
    }catch (SQLException e){
        e.printStackTrace();
    }catch(Exception e){
        e.printStackTrace();
    }
}
}

Answer 1

MySQL JDBC URL的语法为：

用于连接到MySQL服务器的JDBC URL的一般格式如下,方括号([])中的项是可选的：

jdbc:mysql://[host1][:port1][,[host2][:port2]]...[/[database]][?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]

下面是连接URL的一个简单示例：

jdbc:mysql://localhost:3306/sakila?profileSQL=true

jdbc:mysql://localhost/world