为什么Java中的任何SQLite select查询都不起作用？

Question

最近我遇到了一个问题：几乎没有sqlite查询在工作。请注意，插入等其他操作正在运行。我在StackOverflow和其他网站上读过很多不同的答案，但都不管用。

我的代码很简单：

    Statement stmt = null;

    String specTableArgs = """
            \"uuid\"    TEXT NOT NULL UNIQUE,
            \"pos\"     TEXT NOT NULL,
            \"victim\"  TEXT NOT NULL,
            PRIMARY KEY(\"uuid\")
            """;

    String testData = "INSERT INTO Spec (uuid,pos,victim) " +
            "VALUES(\"1etr\"," +
            "\"1;1\"," +
            "\"6iyr\")";

    // Let's say that it already exist
    String url = "jdbc:sqlite:/home/user/tmp/test.sqlite";
    Connection conn = DriverManager.getConnection(url);

    stmt = conn.createStatement();
    stmt.execute("CREATE TABLE IF NOT EXISTS \"Spec\" (" + specTableArgs + ");");

    stmt = conn.createStatement();
    stmt.execute(testData);

    /* Here is what DB contains (checked with DB browser):
    *  +-------+-----+--------+
    *  |  uuid | pos | victim |
    *  +-------+-----+--------+
    *  |  1etr | 1;1 |  6iyr  |
    *  +-------+-----+--------+
    */ 

    stmt = conn.createStatement();
    ResultSet rs = stmt.executeQuery("SELECT * FROM Spec");

    while (rs.next()) {
        String plrID = rs.getString("uuid");
        String vicID = rs.getString("victim");
        System.out.println(plrID + "||" + vicID);
    }

当我在SQLite浏览器中执行SELECT*FROM Spec时，一切都很正常。但是Java没有输出例外。

Answer 1

啊，我已经解决了。问题出在我的功能上：

public ResultSet executeQuery(String sql) {
    try (Statement stmt = conn.createStatement()) {
        return stmt.executeQuery(sql);
    } catch (SQLException e) {
        e.printStackTrace();
        return null;
    }
}

我不知道它是什么，但在我把它的逻辑变成这样之后，它起了作用：

// Here was call of above function
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM Spec");
// Here was call of above function

while (rs.next()) {
      String plrID = rs.getString("uuid");
      String vicID = rs.getString("victim");
      logger.info(plrID + "||" + vicID);
}