有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

java有没有办法从删除的记录中获取密钥?

我使用PostgreSQL将表单保存在三个表中,一个用于名称和id,另一个用于填充字段,第三个用于存储字段值

private static final String REMOVE_FORM = "DELETE FROM forms WHERE name = ?";
private PreparedStatement removeFormQuery;

public boolean connect() throws SQLException{
    this.connection = DriverManager.getConnection(URL);
    this.removeFormQuery = this.connection.prepareStatement(REMOVE_FORM);
}
public void close() throws SQLException {
    if(null != this.connection) {
        this.connection.close();
    }
    if(null != this.removeFormQuery) {
            this.removeFormQuery.close();
    }
}
private void removeForm(String form) {
    try {
        removeFormQuery.setString(1, form);
        int execute = removeFormQuery.executeUpdate();
        System.out.println(execute);
        ResultSet generatedKeys = removeFormQuery.getGeneratedKeys();
        while (generatedKeys.next()) {
            int anInt1 = generatedKeys.getInt("id");
            removeFieldQuery.setInt(1, anInt1);
            if (removeFieldQuery.execute())
                System.out.println("remove field failed");
            else
                System.out.println("remove field success");
            ResultSet generatedFieldsKeys = removeFieldQuery.getGeneratedKeys();
            while (generatedFieldsKeys.next()) {
                int anInt = generatedFieldsKeys.getInt("id");
                removeListItemQuery.setInt(1, anInt);
                if (removeListItemQuery.execute())
                    System.out.println("remove listItem failed");
                else
                    System.out.println("remove listItem success");
            }
        }
    } catch (SQLException e) {
        e.printStackTrace();
    }
}

执行移除查询后,代码不会生成密钥,我是否遗漏了什么


共 (0) 个答案