This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes Beginning Java and the fly likes Simple Java DB where clause question Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Java » Beginning Java
Bookmark "Simple Java DB where clause question" Watch "Simple Java DB where clause question" New topic

Simple Java DB where clause question

Joe Brigs
Ranch Hand

Joined: Jun 06, 2011
Posts: 60

I'm reading two tables the 1st one brings back a field mstr_APPL_CD that I want to use as a lookup to the 2nd query , what am I doing wrong to the 2nd where clause. I know this is very simple, but I'm having my problems. Thanks

I know this may be a JDBC question, but its pretty simple. So I posted it here
Campbell Ritchie

Joined: Oct 13, 2005
Posts: 38033
You appear to be setting a mstr_APPL_CD String in the Java™ code, and then using a mstr_APPL_CD variable in the SQL. Those two will of course be different.
Rob Spoor

Joined: Oct 27, 2005
Posts: 19654

1) try to prevent using SELECT *. That will retrieve all columns of the record. Select only what you need; in this case that would be "SELECT APPL_CD FROM ..."

2) APPL_CD is a string, so you should enclose it in quotes.

3) you now have mstr_APPL_CD as a literal inside the statement. You need to replace that with the value of the Java variable; String concatenation should do the trick.

4) I don't think you'll be able to use the Statement after closing it. I'm absolutely sure you can't after closing its connection. Only close these when you're done with them.

5) you should be careful for SQL injection (look it up). Make sure that the APPL_CD column cannot contain any dangerous values. Otherwise use PreparedStatement instead of Statement.

How To Ask Questions How To Answer Questions
I agree. Here's the link:
subject: Simple Java DB where clause question
Similar Threads
Not able to retrieve values from MySQL(using simple UI)
Please give me suggestion
Java Prepared Statement execution not returning any data
Help with SQL syntax.
Help me get started