编程要求在右侧编辑器补充代码向上一章节中已创建好的数据库mydb中的表student中插入数据并将插入的数据进行输出：id name sex age1 张三 男 192 李四 女 183 王五 男 20提示：已为你封装好student类可在右侧文件夹中查看此类可直接使用。测试说明平台会对你编写的代码进行测试：测试输入：无预期输出：1 张三 男 192 李四 女 183 王五 男 20package

package jdbc;

import java.sql.*;

public class JDBCInsert { public static void insert() { try { //加载驱动 Class.forName("com.mysql.cj.jdbc.Driver"); } catch (ClassNotFoundException e) { e.printStackTrace(); }

    Connection conn = null;
    PreparedStatement statement = null;
    try{
        //连接数据库
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydb?useSSL=false&serverTimezone=UTC",
                "root","123456");

        //插入数据
        String sql = "INSERT INTO student (id, name, sex, age) VALUES (?, ?, ?, ?)";
        statement = conn.prepareStatement(sql);
        statement.setInt(1, 1);
        statement.setString(2, "张三");
        statement.setString(3, "男");
        statement.setInt(4, 19);
        statement.executeUpdate();

        statement.setInt(1, 2);
        statement.setString(2, "李四");
        statement.setString(3, "女");
        statement.setInt(4, 18);
        statement.executeUpdate();

        statement.setInt(1, 3);
        statement.setString(2, "王五");
        statement.setString(3, "男");
        statement.setInt(4, 20);
        statement.executeUpdate();

        //查询数据并输出
        String query = "SELECT * FROM student";
        ResultSet rs = statement.executeQuery(query);
        while(rs.next()){
            System.out.println(rs.getInt("id")+" "+rs.getString("name")
                    +" "+rs.getString("sex")+" "+rs.getInt("age"));
        }

    } catch (SQLException e) {
        e.printStackTrace();
    }
    finally {
        try {
            if (statement != null)
                statement.close();
            if (conn != null)
                conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}