无效的 SQL 类型：显示 sqlKind = UNINITIALIZED 错误

Question

    String s1 = PasswordText4.getText();
    String s2 = ConfirmText4.getText();
    String s3 = NameText4.getText();
    String s4 = UsernameText4.getText();
    String s5 = jLabel16.getText();

    if (PasswordText4.getText().equals(ConfirmText4.getText()) && s1.length() != 0 && s3.length() != 0 && s1.length() >= 4 && s2.length() >= 4) {
        try {
            String sql
                    = "BEGIN"
                    + "UPDATE LOGIN SET USERNAME = ?, PASSWORD = ?, NAME = ?"
                    + "WHERE USERNAME = ?;"
                    + "commit;"
                    + "END;";
            CallableStatement cstmt = conn.prepareCall(sql);
            cstmt.setString(1, UsernameText4.getText());
            cstmt.setString(2, PasswordText4.getText());
            cstmt.setString(3, NameText4.getText());
            cstmt.setString(4, jLabel16.getText());

            //System.out.println(jLabel16.getText());

            int dialogButton = JOptionPane.YES_NO_OPTION;
            int dialogResult = JOptionPane.showConfirmDialog(null, "Are you sure you want to update?", "Warning", dialogButton);
            if (dialogResult == JOptionPane.YES_OPTION) {
                cstmt.execute();
                JOptionPane.showMessageDialog(null, "Information Updated");
                jLabel15.setText(NameText4.getText());
                jLabel16.setText(UsernameText4.getText());
                jLabel17.setText(PasswordText4.getText());
            }

        } catch (Exception e) {
            JOptionPane.showMessageDialog(null, e);
        }
    }

这段代码有什么问题？当我尝试更新我的数据时，无效 SQL 类型：

显示 sqlKind = UNINITIALIZED 错误。

请帮我找到解决问题的方法。

预先感谢您的回答。

原文由 Mehrab Zaman 发布，翻译遵循 CC BY-SA 4.0 许可协议

Answer 1

Berger 是对的，您需要在查询部分之间添加空格，例如：

 String sql = " BEGIN "
           + " UPDATE LOGIN SET USERNAME = ?, PASSWORD = ?, NAME = ? "
           + " WHERE USERNAME = ?; "
           + " commit; "
           + " END;" ;

原文由 Alberto Velasco 发布，翻译遵循 CC BY-SA 3.0 许可协议