package database;

import java.sql.*;
import java.util.Scanner;
public class JavaMysqlSelectExample {
	public static void main(String[] args) {

		/*Scanner sc = new Scanner(System.in);
		float heightInput = 0.0f;
		heightInput = sc.nextFloat();*/

		try
	    {
	      // create the mysql database connection
	      String myDriver = "com.mysql.jdbc.Driver";

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

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

	      // create the SQL select statement.
	      String query = "SELECT avg(height) as avg 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.


//		          int id = rs.getInt("studentId");
//		          String firstName = rs.getString("firstname");
//		          String lastName = rs.getString("lastname");
//		          int age = rs.getInt("age");
//		          float height = heightInput;
//		          height = rs.getInt("height");


		          // print the results
//		          System.out.format("%s, %s, %s, %s, %s\n", id, firstName, lastName, age, height);
//		          System.out.format("%s\n", id);
//		          System.out.format("%s\n", firstName);
//		          System.out.format("%s, %s, %s, %s\n", firstName, lastName, age, height);
/*		          if(rs.getInt("height") == heightInput){
		          System.out.format("%s, %s, %s\n", firstName, lastName, heightInput);

		      }*/
	    		  while (rs.next()) {
	    			  System.out.println(rs.getString("avg"));
	    		  }



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

	}

}