java - 使用java插入表时出现SQl错误

Question

已关闭。这个问题是 not reproducible or was caused by typos 。目前不接受答案。

---

这个问题是由拼写错误或无法再重现的问题引起的。虽然类似的问题可能在这里 on-topic ，但这个问题的解决方式不太可能帮助 future 的读者。

已关闭 3 年前。

奥 git _a

我正在尝试使用以下代码将新行插入到 sql 表 Customers 中:

                    String str = "register customer Mark Waid 1234567 389529548 Monthly LilacHaifa "
                    + "1234567891234567 5/2025";
                    String[] tokens = str.trim().split("\\s++");
                    sql = "INSERT INTO Customers " +
                    "(ID, Name, Password, Connected, SubscriptionType, Status, Store Name, CreditCardNumber, Balance, ExpirationDate) "
                    + "VALUES (?,?,?,?,?,?,?,?,?,?)";
                    preparedStmt = conn.prepareStatement(sql);
                    preparedStmt.setInt(1, Integer.parseInt(tokens[5]));
                    preparedStmt.setString(2, tokens[2] + " " + tokens[3]);
                    preparedStmt.setString(3, tokens[4]);
                    preparedStmt.setInt(4, 1);
                    preparedStmt.setString(5, tokens[6]);
                    preparedStmt.setInt(6, 1);
                    preparedStmt.setString(7, tokens[7]);
                    preparedStmt.setString(8, tokens[8]);
                    preparedStmt.setDouble(9, 0);
                    preparedStmt.setString(10, tokens[9]);
                    preparedStmt.executeUpdate();

但我收到以下错误

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Name, CreditCardNumber, Balance, ExpirationDate) VALUES (389529548,'Mark Waid','' at line 1
SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Name, CreditCardNumber, Balance, ExpirationDate) VALUES (389529548,'Mark Waid','' at line 1
SQLState: 42000
VendorError: 1064
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:936)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2985)
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1631)
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1723)
    at com.mysql.jdbc.Connection.execSQL(Connection.java:3283)
    at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1332)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1604)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1519)
    at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1504)
    at ocsf.LilacServer.handleMessageFromClient(LilacServer.java:297)
    at ocsf.AbstractServer.receiveMessageFromClient(AbstractServer.java:474)
    at ocsf.ConnectionToClient.run(ConnectionToClient.java:219)

我的查询肯定有问题，但我无法准确识别它是什么。感谢您的帮助。

Answer 1

Store Name 列中有一个空格，因此应该正确引用它，具体取决于您使用的数据库。

例如:

MS SQL Server:[商店名称]
Oracle:“商店名称”
MySQL:`商店名称`
Postgres:“商店名称”