import java.sql.*;
public class JavaMysqlSelectExample {
	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/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("Id");
	          String firstName = rs.getString("firstname");
	          String lastName = rs.getString("lastname");
	          int age = rs.getInt("age");
	          float 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);

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

	}

}