package lab2;

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 * 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 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);

		      }

	         }

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

	}

}