Возникла проблема, при запуске выдает ошибку.
Код
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DbConnection {
public static void main(String[] args) throws ClassNotFoundException, SQLException {
//Connection url
String dbUrl = "jbdc:mysql://localhost:3306/table";
String username = "root";
String password = "root";
String query = "select phone_conformation_token, email_conformation_token from registrations where email = 'emailtest@mail.ru' ";
Class.forName("com.mysql.jdbc.Driver");
Connection con = DriverManager.getConnection(dbUrl, username, password);
//Create Statement Object
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery(query);
//while loop to get ResultSet all rows data
while (rs.next()) {
String uName = rs.getString(1);
System.out.println(uName);
}
в CLASSPATH путь указан, jar подключен к проекту.
Стектрейс:
Exception in thread "main" java.sql.SQLException: No suitable driver found for jbdc:mysql://localhost:3306/table
at java.sql.DriverManager.getConnection(DriverManager.java:689)
at java.sql.DriverManager.getConnection(DriverManager.java:247)
at ru.myproject.DbConnection.main(DbConnection.java:23)