Java:无法为EmbeddedDerby加载JDBC驱动程序

Question

我在为Em申明德比加载JDBC驱动程序时遇到了问题。以下是我编译和运行我的程序的案例

>

案例1：

编译：E：\java\WorkReminder

Run: E:\java\WorkReminder

错误：

无法加载JDBC驱动程序org . Apache . derby . JDBC . embedded driver。请检查您的类路径。Java . lang . classnotfoundexception:org . Apache . derby . JDBC . embedded driver at Java . net . URL class loader $ 1 . run(URL class loader . Java:200)at Java . security . access controller . doprivileged(Native Method)at Java . net . URL class loader . Java:188)at Java . lang . class loader . load class(class loader . Java:306)at sun . misc . launcher $ app class loader . load class(launcher . Java:268)at

案例2：如果我这样做，一切都很好

编译：E：\java\WorkReminder

更改目录:E:\java\WorkReminder

Run: E:\java\WorkReminder\class

输出:

已加载适当的驱动程序

已插入行。

2-----

1956年________ _____________河内

1975年_________ _____________西贡

SimpleApp已完成

有人可以帮我解释为什么我在案例 1 中出现错误，因为我正在编写更复杂的程序？我的代码：

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;
import java.util.Properties;

public class MyDerbyProgram
{
    /* the default framework is embedded*/
    private String framework = "embedded";
    private String driver = "org.apache.derby.jdbc.EmbeddedDriver";
    private String protocol = "jdbc:derby:";

    public static void main(String[] args)
    {
        new MyDerbyProgram().go(args);
        System.out.println("SimpleApp finished");
    }

    void go(String[] args)
    {
        /* load the desired JDBC driver */
        loadDriver();
        try
        {
            Connection connection = DriverManager.getConnection(protocol + "testDB; create=true");
            connection.setAutoCommit(false);


            //Create table
            Statement statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
            statement.execute("create table location(num int, address varchar(40))");

            //Insert
            PreparedStatement psInsertStatement = connection.prepareStatement("insert into location values(?, ?)");
            psInsertStatement.setInt(1, 1956);
            psInsertStatement.setString(2, "Ha Noi");
            psInsertStatement.executeUpdate();
            psInsertStatement.setInt(1, 1975);
            psInsertStatement.setString(2, "Sai Gon");
            psInsertStatement.executeUpdate();
            System.out.println("Row inserted.");

            //Select
            ResultSet resultSet = statement.executeQuery("select * from location");

            int totalRows = 0;

            resultSet.last();
            totalRows = resultSet.getRow();
            resultSet.beforeFirst();
            System.out.println(totalRows + "-----");

            String strPrintResult = "";
            while(resultSet.next())
            {
                strPrintResult += resultSet.getString("num") + "___________________+_________________________" + resultSet.getString("address") + "\n";
            }           
            System.out.println(strPrintResult);

            //Drop table
            statement.execute("drop table location");

            //Commit transaction
            connection.commit();

            //Close
            statement.close();
            statement = null;

            psInsertStatement.close();
            psInsertStatement = null;

            resultSet.close();
            resultSet = null;

            connection.close();
            connection = null;
        }

        catch(SQLException se)
        {
            System.out.println(se.toString());
        }
    }

    private void loadDriver() {
    try {
        Class.forName(driver).newInstance();
        System.out.println("Loaded the appropriate driver");
    } catch (ClassNotFoundException cnfe) {
        System.err.println("\nUnable to load the JDBC driver " + driver);
        System.err.println("Please check your CLASSPATH.");
        cnfe.printStackTrace(System.err);
    } catch (InstantiationException ie) {
        System.err.println(
                    "\nUnable to instantiate the JDBC driver " + driver);
        ie.printStackTrace(System.err);
    } catch (IllegalAccessException iae) {
        System.err.println(
                    "\nNot allowed to access the JDBC driver " + driver);
        iae.printStackTrace(System.err);
    }
    }
    private void parseArguments(String[] args)
    {
        if (args.length > 0) {
            if (args[0].equalsIgnoreCase("derbyclient"))
            {
                framework = "derbyclient";
                driver = "org.apache.derby.jdbc.ClientDriver";
                protocol = "jdbc:derby://localhost:1527/";
            }
        }
    }
}

问候

Answer 1

-cp 选项设置类路径，您不需要这个

请看这里