java未找到适用于dbc的驱动程序:mysql://localhost:8080/kholofedb
我在网上搜索了整个昨天的这个问题。。。我是JDBC的初学者,但这里提供的解决方案和其他网站对我来说并不适用
我正在Linux Mint 32位上使用“mysql-connector-java-5.1.18-bin.jar
”。。我正在使用Eclipse3.8。。。我已经安装了mySQL服务器,它正在运行(我使用:sudo service mysql start
运行它)。。。在运行时,我得到了这个错误
connecting to psysical database...
java.sql.SQLException: No suitable driver found for dbc:mysql://localhost:8080/kholofedb
at java.sql.DriverManager.getConnection(DriverManager.java:604)
at java.sql.DriverManager.getConnection(DriverManager.java:221)
at com.psybergate.database.SimbleCode.main(SimbleCode.java:21)
以下是我的源代码:
package com.psybergate.database;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.Scanner;
public class SimbleCode
{
private static final String USER = "root" , PASS = "";
public static void main(String ...args)
{
try {
String connectionURL = "dbc:mysql://localhost:8080/kholofedb";
Class.forName("com.mysql.jdbc.Driver");
// Class.forName("org.postgresql.Driver");
System.out.println("connecting to psysical database...");
Connection conn = DriverManager.getConnection(connectionURL , USER , PASS);
Statement statement = conn.createStatement();
System.out.println("Connection has been made");
Scanner keyBoardScanner = new Scanner(System.in);
System.out.println("Enter table name:");
String tableName = keyBoardScanner.nextLine();
System.out.println("Creating table...");
statement.executeQuery("create table " + tableName + " (name , age ,salary)");
System.out.println("Table successfully created");
System.out.println("Inserting data into the table ...");
statement.executeUpdate("insert into " + tableName + "values (kholofelo , 21 , 9969696)");
}
catch (ClassNotFoundException | SQLException e) {
e.printStackTrace();
}
}
}
提前感谢:)
# 1 楼答案
您的连接字符串应为:
# 2 楼答案
您的连接URL应该以“jdbc:”而不是“dbc:”开头