java - INSERT INTO 语句中的语法错误

Question

我决定添加一个“添加”按钮，将员工记录添加到我的 Access 数据库的员工表中。

每当我单击“添加”按钮时，都会显示一条错误消息，指出“INSERT INTO 语句中存在语法错误”。有人可以帮忙吗？我的编码有问题吗？因为我确实完全按照这个视频进行操作，即使在视频中，该人成功地将记录“保存”到数据库中，但我不断收到错误。

conn = Connect.ConnectDB();
        String sql = "insert into Employee ("
                +"Employee ID,"
                +"Employee Name,"
                +"Employee NICN,"
                +"Employee Gender,"
                +"Employee Contact Number,"
                +"Employee Department)"
                +"values("+txteid.getText()+ ",'"+txtename.getText()+"','"+txtenicn.getText()+"','"+txtegender.getText()+"','"+txtecnumber.getText()+"','"
                +txtedept.getText()+"')";
        try{
            pst = conn.prepareStatement(sql);
            pst.execute();
            JOptionPane.showMessageDialog(null, "Added");

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

Answer 1

您使用准备好的语句，因此您必须使用参数

   conn = getConnection();
   String sql = "insert into Employee ("
                +"Employee ID,"
                +"Employee Name,"
                +"Employee NICN,"
                +"Employee Gender,"
                +"Employee Contact Number,"
                +"Employee Department)"
                +"values(?,?,?,?,?,?)";

然后设置参数:

      pstmt.setInt(1, txteid.getText()); // set input parameter 1
      pstmt.setString(2, txtename.getText()); // set input parameter 2
 ...
      pstmt.executeUpdate(); // execute insert statement