Personal info

[.:.AlCoHlHeRo.:.]

Hi all...

I am making a GUI where I want to print out the personal info of a specific user who is logged in... I have the query set up and it retrieves the personal information but only the first row in the database. e.g I log on my 'admin' account it shows my info and if I log a friends account It give me my info aswell not the friends information

Here's the query:
public String info()
{
StringBuffer sb = new StringBuffer();
try
{
Statement stmt = conn.createStatement();
ResultSet b = stmt.executeQuery("SELECT Age, Gender, DateOfBirth, name, Surname FROM User");

while (b.next())
{
String age = b.getString("Age");
String gen = b.getString("Gender");
String DOB = b.getString("DateOfBirth");
String name = b.getString("name");
String surname = b.getString("Surname");

return "Personal Information: " + "\n" + "Name: " + name + "\n" + "Surname:" + surname + "\n" + "Age: " + age + "\n" + "Gender: " + gen + "\n" + "Date of Birth: " + DOB;
}
}
catch (Exception e)
{
}
return "not found";
}
-------------------------------------------------------------------------
Here is the action It does when I try and call the information :

if (event.getSource () == show)
{
WebConnection pc = new WebConnection ();
nameA.setText (pc.info ());
}

Any help on how I can retrieve the data of the user thats logged in? Thanks:)

[Tolls]

Your query has no WHERE clause, so is returning everything from that table.
Presumably you want to only retireve tha values where id/username/whatever matches that of the current user?

Then, after getting all the users, you loop round the resultset, only to return at the end of the first loop...so of course it will return the first record it finds.

On top of that, you don't close your Statement or your Resultset. This will result in cursor leaks on the db eventually causing an exception.

[.:.AlCoHlHeRo.:.]

Thanks allot got to do it when I get to school program is on my school pc but I will get back when I get it working thanks :)