anyone help ?

try providing more information:

1). what do u get with the statement when you use SQL*PLUS?
2). The actual code you used to retrieve records.

Jim

Hi Belmon!

You can do something like this:

Statement statement = connection.createStatement();
String query = "select * from pinfo"; // your query
ResultSet rs = statement.executeQuery(query);

while (rs.next()) {
your_textarea.append(rs.getString("name") + " ");
your_textarea.append(rs.getString("age") + " ");
your_textarea.append(rs.getString("remark") == null ? "" :
rs.getString("remark") + "\n");
}

Anyway, you format it the way you want. But I think that null verifying
is useful for you. You have to put it on the fields which MAY be null,
that's why I didn't put it to name or age.. because, by your example,
name or age can't be NULL.

See ya,
Cristian Deives