java - 为什么我没有找到适合 jdbc 的驱动程序 :derby://localhost:1527/employee;create=true error in my code?

Question

/*
 * To change this license header, choose License Headers in Project Properties.
 * To change this template file, choose Tools | Templates
 * and open the template in the editor.
 */


package database_console;

/**
 *
 * @author nareshreddy
 */

//import java.sql.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;


public class DBConnect {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        try{


        String host  =  "jdbc:derby://localhost:1527/employee;create=true";
        String uName = "root";
        String uPass =  "14mcmi34";

        Connection con = DriverManager.getConnection( host, uName,uPass );

        Statement stmt = con.createStatement( );

        String SQL = "SELECT * FROM WORKERS";
        ResultSet rs = stmt.executeQuery( SQL );

        while( rs.next( ) ) {
            int id_col = rs.getInt("ID");
            String first_name = rs.getString("First_Name");
            String last_name = rs.getString("Last_Name");
            String job = rs.getString("Job_Title");

            String p = "id_col + \" \" + first_name + \" \" + last_name + \" \" + job";

            System.out.println(p);
        }
        }
        catch ( SQLException err ) {
            System.out.println( err.getMessage( ) );
        }


    }

}

我得到了“没有找到适合 jdbc 的驱动程序:derby://localhost:1527/employee;create=true ”错误为什么？添加我的“/home/nareshreddy/HARDDISK/2nd Sem/SE lab/java program/java Jar file/mysql-connector-java-5.0.8/mysql-connector-java-5.0.8-bin.jar ”文件后

Answer 1

您的连接字符串需要 derby DB 驱动程序，而不是 mysql 连接器。所以下载Driver对于 Derby DB 并将其添加到类路径中，或者如果您想使用 mysql，则必须将连接字符串更改为 jdbc:mysql://...