In php i know we can use
$row = mysql_fetch_array ($result)
thanks in advanced.
... how do I store that information?
This wholly depends on what you mean by "store". Your example is somewhat confusing because
$row = mysql_fetch_array ($result) does not store anything; it assigns the result of an SQL query to a php handle.
Well what i mean is i need to store the information that we get back in an array so it can be manipulated later on.
PreparedStatement ps= con.prepareStatement("SELECT ........ blahblah");
in php we can use foreach and take each array value and then manipulate it but I don't know much about java.