This week's book giveaway is in the Kotlin forum.
We're giving away four copies of Kotlin for Android App Development and have Peter Sommerhoff on-line!
See this thread for details.
Win a copy of Kotlin for Android App Development this week in the Kotlin forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Liutauras Vilda
  • Devaka Cooray
  • Jeanne Boyarsky
  • Bear Bibeault
Sheriffs:
  • Junilu Lacar
  • Paul Clapham
  • Knute Snortum
Saloon Keepers:
  • Ron McLeod
  • Tim Moores
  • Stephan van Hulst
  • salvin francis
  • Carey Brown
Bartenders:
  • Tim Holloway
  • Frits Walraven
  • Ganesh Patekar

Need Help Iterating though a Result Set  RSS feed

 
Ranch Hand
Posts: 158
1
Java Oracle
  • 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]
 
Ranch Hand
Posts: 205
13
Notepad
  • 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.
 
Rancher
Posts: 1926
15
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: 158
1
Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
My query is like this:

SELECT No, Name1, Address, Name2 from my_table;
 
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: 1926
15
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: 158
1
Java Oracle
  • 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: 1926
15
Android Eclipse IDE Java Java ME
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
You are welcome.
 
Marshal
Posts: 62875
203
  • 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.
 
Bartender
Posts: 20353
111
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.
 
She still doesn't approve of my superhero lifestyle. Or this shameless plug:
Programmatically Create PDF Using Free Spire.PDF with Java
https://coderanch.com/wiki/703735/Programmatically-Create-PDF-Free-Spire
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!