java - JDBC 给我参数索引超出范围(1 > 参数数量，即 0)

Question

这个问题已经有答案了:

java.sql.SQLException Parameter index out of range (1 > number of parameters, which is 0) [closed] (2 个回答)

已关闭 7 年前。

获取 Parameter index out of range (1 > number of parameters, which is 0)下面标记的行上有错误。有什么想法吗？

            ...
            int hash = ConsistantHash.hash(name);
            query = "INSERT INTO `server_info` (`host`, `port, `s_port`, `name`, `hash`) VALUES (?, ?, ?, ?, ?)";

            statement = connection.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);
            statement.setString(1, host); //this line
            statement.setInt(2, c_port);
            statement.setInt(3, s_port);
            statement.setString(4, name);
            statement.setInt(5, hash);

            statement.executeUpdate();
            statement.close();

Answer 1

您缺少端口列的匹配转义:

`port

应该是

`port`