asddasasdasd

import java.sql.*;

public class Labb {
    public static void main(String[] args) {
        try
        {
          // create the mysql database connection
          String myDriver = "com.mysql.jdbc.Driver";

          //specify the database to connect
          String myUrl = "jdbc:mysql://localhost/studentcontract";

          //connect to the database
          Class.forName(myDriver);
          Connection conn = DriverManager.getConnection(myUrl, "root", "");

          // create the SQL select statement.

                  String query = "SELECT AVG(HEIGHT) FROM student";

          // create the java statement
          Statement st = conn.createStatement();

          // execute the query; the result of the execution is stored in an object of ResultSet class
          ResultSet rs = st.executeQuery(query);

          // there can be more than one result. so, we have to go through each data. in each round, only one record will be readed.
          while (rs.next())
          {
              int studentId = rs.getInt("studentId");
              String firstName = rs.getString("firstname");
              String lastName = rs.getString("lastname");
              int age = rs.getInt("age");
              float height = rs.getInt("height");



              System.out.format("%s\n",height);


          }
          st.close();
        }
        catch (Exception e)
        {
          System.err.println("Got an exception! ");
          System.err.println(e.getMessage());
          e.printStackTrace();
        }

    }

}