Win a copy of Murach's Java Programming this week in the Beginning Java forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Need Help Iterating though a Result Set  RSS feed

 
Ioanna Katsanou
Ranch Hand
Posts: 111
1
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,

I need help to figure something out.
I have a result set
that I need to print it out.
So the query returns something like the result in the picture:
No. Name1 Address Name2
1 Ioanna xx Ioanna
2 Maria          yy Julia
3 Nikos          zz Markos

I want with Java to print out the lines ONLY WHEN Name1 is not equal to Name2.
So if Name1 is equal to Name 2 I don't want to print it out.
I tried this:


The above does not work. What am I doing wrong??
1.JPG
[Thumbnail for 1.JPG]
 
Richard Hayward
Ranch Hand
Posts: 170
11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What does your QUERYSELECT look like?

You could put a where clause in there so the server never sends those rows back to the client.
 
Swastik Dey
Rancher
Posts: 1784
14
Android Eclipse IDE Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
True, it can always be filtered from the query itself, you don't need to such complex logic.
 
Ioanna Katsanou
Ranch Hand
Posts: 111
1
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My query is like this:

SELECT No, Name1, Address, Name2 from my_table;
 
Tapas Chand
Ranch Hand
Posts: 614
9
BSD Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Ioanna Katsanou wrote:My query is like this:

SELECT No, Name1, Address, Name2 from my_table;

In this query you can add a "where" clause which will get the records only which you want.
 
Swastik Dey
Rancher
Posts: 1784
14
Android Eclipse IDE Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator


Now just iterate through though the ResultSet , you don't need any such complex logic.
 
Ioanna Katsanou
Ranch Hand
Posts: 111
1
Java
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Swastik Dey wrote:

Now just iterate through though the ResultSet , you don't need any such complex logic.


Cool thanks a lot !!! I don't know my brain just stuck !! thanks
 
Swastik Dey
Rancher
Posts: 1784
14
Android Eclipse IDE Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are welcome.
 
Campbell Ritchie
Marshal
Posts: 54839
155
  • Likes 1
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Swastik Dey wrote: . . .
Are you sure that shouldn't read ...Name1 != Name2?
I think this discussion would fit better in our databases forum.
 
Tim Holloway
Saloon Keeper
Posts: 18631
69
Android Eclipse IDE Linux
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I tend to forget what goes with what language, but I think in SQL it's "Name1 <> Name2".

Although you really shouldn't use uppercase letters in database entity and column names. Some databases can be funny about them.
 
With a little knowledge, a cast iron skillet is non-stick and lasts a lifetime.
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!