用 statement 来执行 sql 语句, executeQuery 变成 executeUpdate
try (Connection conn = DriverManager.getConnection(JDBC_URL, JDBC_USER, JDBC_PASSWORD)) {try (PreparedStatement ps = conn.prepareStatement("INSERT INTO students (id, grade, name, gender) VALUES (?,?,?,?)")) {ps.setObject(1, 999); // 注意:索引从1开始ps.setObject(2, 1); // gradeps.setObject(3, "Bob"); // nameps.setObject(4, "M"); // genderint n = ps.executeUpdate(); // 1}}
