Question

java.sql.SQLException: No suitable driver found for jdbc.mysql://127.0.0.1:3306/user

package com.test;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class One {
public static void main(String[] args) {
String driver="com.mysql.jdbc.Driver";
String url="jdbc.mysql://127.0.0.1:3306/user";
String root="root";
String pass="123456";
Connection con=null;
Statement sm=null;
ResultSet rs=null;
try {
Class.forName(driver);
con=DriverManager.getConnection(url,root,pass);
sm=con.createStatement();
rs=sm.executeQuery("select * from user");
System.out.println(rs);

} catch (ClassNotFoundException e) {
e.printStackTrace();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
}
}

Answer 1

url写错了应该是jdbc:mysql://IP地址:3306/数据库名
jdbc后面是冒号，你写成点了

Answer 2

将mysql-connector-java-3.1.14-bin.jar的jar包加入C:\Program Files\Java\jre1.6.0_02\lib\ext文件夹下，问题解决了！！