java - 我的 SQL 语法错误

Question

try {
    String sql = "Insert into eyeglass (Brand, Model, Size, Color, Type, Case, Lens, Style, Warranty, Remarks) values(?,?,?,?,?,?,?,?,?,? )";

    pst = conn.prepareStatement(sql);
    pst.setString(1, txtBrand.getText());
    pst.setString(2, txtModel.getText());
    pst.setString(3, txtSize.getText());
    pst.setString(4, txtColor.getText());
    pst.setString(5, txtType.getText());
    pst.setString(6, txtCase.getText());
    pst.setString(7, txtLens.getText());
    pst.setString(8, txtStyle.getText());
    pst.setString(9, txtWarranty.getText());
    pst.setString(10, txtRemarks.getText());
    pst.execute();
    JOptionPane.showMessageDialog(null, "Saved");
} catch (Exception e) {
    JOptionPane.showMessageDialog(null, e);
}

我得到错误:你的SQL语法有错误；查看与您的 MySQL 服务器版本对应的手册，了解在 'Case, Lens, Style, Warranty, Remarks) values(",",",",",",",",",") 附近使用的正确语法' 在第 1 行，我不明白为什么会这样。

Answer 1

CASE 是一个 MySQL reserved word .转义单词或更改数据库列名，后者最好避免完全转义。

String sql = 
  Insert into eyeglass 
   (Brand, Model, Size, Color, Type, `Case`, Lens, Style, Warranty, Remarks) values(?,?,?,?,?,?,?,?,?,? )";