statement 来执行 sql 语句, executeQuery 变成 executeUpdate

    1. try (Connection conn = DriverManager.getConnection(JDBC_URL, JDBC_USER, JDBC_PASSWORD)) {
    2. try (PreparedStatement ps = conn.prepareStatement(
    3. "INSERT INTO students (id, grade, name, gender) VALUES (?,?,?,?)")) {
    4. ps.setObject(1, 999); // 注意:索引从1开始
    5. ps.setObject(2, 1); // grade
    6. ps.setObject(3, "Bob"); // name
    7. ps.setObject(4, "M"); // gender
    8. int n = ps.executeUpdate(); // 1
    9. }
    10. }