java - insert 语句参数太少

Question

您好，我正在尝试插入语句，但不断收到以下错误:

java.sql.SQLException: [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 3.

这是我的代码:

 try {

    Statement stmt = con.createStatement();

    String mySqlStatement = "INSERT INTO EntrantDetails (ID, Name, Surname, Gender, DOB ChipNum) VALUES (" + details.getIDNum()+ "," + details.getName() + "," + details.getSurname() + "," + details.getGender() + "," + details.getDOB() +  "," + details.getChipNum() + ")";
    stmt.executeUpdate(mySqlStatement);       
    }

     catch (Exception ex)
     {
        ex.printStackTrace();
     }

Answer 1

您在 DOB 和 ChipNum 之间缺少一个逗号。稍微注意一下你所写的内容。