删除查询不起作用Java Netbeans

Question

我正在尝试删除数据库中的记录，如果我键入的用户名不是管理员，我可以删除它，但是它不起作用，我认为它的查询是任何想法，谢谢。我一直在试图弄清楚的新手...

   String password = new String(oldPass.getPassword());
    String realpass = pw.getText();
    String us = userr.getText();
      user = us;
        System.out.println("ok");
        String query = "DELETE FROM user WHERE privilege = 'NOT ADMIN' +        username = '"+us+"'";
      try {
            Statement st = (Statement) con.createStatement();
            int r = st.executeUpdate(query);
            if (r != 0) {
                JOptionPane.showMessageDialog(null, "Successfully deleted!", "Delete", JOptionPane.OK_OPTION);
                login w = new login();
                w.setVisible(true);
                this.dispose();
            } else {
                JOptionPane.showMessageDialog(null, "Wait! something's wrong, please try again later.", "Ooopppss!", JOptionPane.OK_OPTION);

            }
        } catch (Exception e) {
            System.out.println(e);
        }

      // TODO add        // TODO add your handling code here:
}                              

Answer 1

也许您缺少或或操作员取决于您在这里尝试做什么示例

DELETE FROM user WHERE privilege = 'NOT ADMIN' AND user='user'

无论如何，我建议您使用字符串"不admin"，您可以从特权中创建一个新的目录