mysql 占位符整型

INSERT INTO users (id, name) VALUES (?, 'John Doe');
UPDATE users SET name = 'Jane Doe' WHERE id = ?;
DELETE FROM users WHERE id = ?;

// 错误示例
String sql = "INSERT INTO users (id, name) VALUES (?, 'John Doe')";
PreparedStatement pstmt = connection.prepareStatement(sql);
pstmt.setString(1, "123"); // 错误，应该是整型

// 正确示例
String sql = "INSERT INTO users (id, name) VALUES (?, 'John Doe')";
PreparedStatement pstmt = connection.prepareStatement(sql);
pstmt.setInt(1, 123); // 正确

// 错误示例
String sql = "INSERT INTO users (id, name) VALUES (?, ?)";
PreparedStatement pstmt = connection.prepareStatement(sql);
pstmt.setInt(1, 123); // 只设置了一个参数

// 正确示例
String sql = "INSERT INTO users (id, name) VALUES (?, ?)";
PreparedStatement pstmt = connection.prepareStatement(sql);
pstmt.setInt(1, 123);
pstmt.setString(2, "John Doe"); // 设置了两个参数