java - 严重: java. sql.SQLException:字段 'columnname'没有默认值

Question

 JSONArray newdata = new JSONArray(tabledata);

 int prep = 0;
 String add_sie = "INSERT INTO " + table + " " +
    "(" + yearcolumn + "," + orgcolumn + "," + suborgcolumn + "," + amount + "," + createdbycolumn + "," + createddatecolumn + "," + statuscolumn + " , " + createdtimecolumn + " )" +
    " VALUES (?,?,?,?,?,?,?,?)";

 preparedStatement = conn.prepareStatement(add_sie);
 for (int i = 0; i < newdata.length(); i++) {

    preparedStatement.setString(1, newdata.getJSONObject(i).get("year").toString());
    preparedStatement.setString(2, newdata.getJSONObject(i).get("org").toString());
    preparedStatement.setString(3, newdata.getJSONObject(i).get("sub_org").toString());
    preparedStatement.setString(4, newdata.getJSONObject(i).get("sub_org_amt").toString());
    preparedStatement.setString(5, af_mas_bi_createdby);
    preparedStatement.setString(6, af_mas_bi_datecreated);
    preparedStatement.setString(7, af_mas_bi_timecreated);
    preparedStatement.setString(8, "approved");
    //preparedStatement.executeUpdate();

    //preparedStatement.executeBatch();

 }
 preparedStatement.executeBatch();

我收到错误 Severe: java.sql.SQLException: Field 'abap_id' doesn't have a default value 这是我放在数据库中的 id，它的结构是

为什么我在那个 id 中得到错误，即使它是自动递增的，而且我没有将它放入具有特定值的插入中

Answer 1

 String add_sie = "INSERT INTO " + table + " " +
"(abap_id," + yearcolumn + "," + orgcolumn + "," + suborgcolumn + "," + amount + "," + createdbycolumn + "," + createddatecolumn + "," + statuscolumn + " , " + createdtimecolumn + " )" +
" VALUES (NULL,?,?,?,?,?,?,?,?)";

重要!如果您不将该值设置为 null 或 NULL 并手动插入值，则 AUTO_INCREMENT 种子不会更新。如果 AUTO_INCREMENT 列具有 UNIQUE 约束或者是 PRIMARY KEY，这可能会导致违反唯一约束错误。