Win a copy of Java Mock Exams (software) this week in the Programmer Certification (OCPJP) forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic

Need Help Iterating though a Result Set

 
Ioanna Katsanou
Ranch Hand
Posts: 77
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: 132
4
  • 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: 1719
8
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: 77
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: 613
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: 1719
8
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: 77
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: 1719
8
Android Eclipse IDE Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are welcome.
 
Campbell Ritchie
Marshal
Posts: 53094
124
  • 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
Bartender
Posts: 18465
61
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.
 
What are you doing? You are supposed to be reading this tiny ad!
the new thread boost feature brings a LOT of attention to your favorite threads
https://coderanch.com/t/674455/Thread-Boost-feature
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!