我的代码不能打印出数据库中的数据

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 ai_assignment;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.text.ParseException;
import java.util.logging.Level;
import java.util.logging.Logger;

/**
 *
 * @author ADAM KENYON
 */
public class AI_Assignment {
    String connectString = "D:\\Users\\ADAM KENYON\\Documents\\NetBeansProjects\\AI_Assignment\\Database\\AI_assignment";
    private static Object ex;

    /**
     * @param args the command line arguments
     * @throws java.text.ParseException
     */
    public static void main(String[] args) throws ParseException {
        // TODO code application logic here
       AI_Assignment assignment = new AI_Assignment(); assignment.database();

    }

    public void database() throws ParseException {
        try {
            Connection con;
            Class.forName("org.hsqldb.jdbcDriver");
            con = DriverManager.getConnection("jdbc:hsqldb:file:" + connectString, // filenames
                    "", // username
                    "");  // password
            try (Statement statement = con.createStatement()) {
                ResultSet rs = statement.executeQuery("SELECT * FROM TEST");
                while (rs.next()) {
                    int ID = rs.getInt("ID");
                    System.out.print(ID);
                }
                 statement.close();
                  con.close();
            }
        } catch (SQLException | ClassNotFoundException SQLException) {
            Logger.getLogger(AI_Assignment.class.getName()).log(Level.SEVERE, null, SQLException);
        }
    }
}

到目前为止，这就是我所拥有的，它全部编译了，但没有数据被打印到输出中。有什么帮助吗？

我正在看一个在线教程，我想我做错了什么，但我不知道。我的猜测是connectString变量是错误的，它会在我等待响应的时候把它搞乱。

编辑: THe代码现在是最新的，这是抛出的错误"Nov 25,2015 5:35:13 AM ai_assignment.AI_Assignment database SEVERE: null

java.lang.ClassNotFoundException: jdbcDriver“

Answer 1

根据问题中列出的最新异常，您在加载JDBC驱动程序时遇到问题。检查hsqldb's documentation时，应将Class.forName("org.hsqldb.jdbcDriver");替换为Class.forName("org.hsqldb.jdbc.JDBCDriver");