aspose file tools
The moose likes JDBC and Relational Databases and the fly likes Sql statement Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of OCA Java SE 8 Programmer I Study Guide 1Z0-808 this week in the OCAJP forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Sql statement" Watch "Sql statement" New topic

Sql statement

shumani edzani

Joined: Oct 03, 2008
Posts: 9
Hi All..

I have been struggling with this code for 3 hours now,can you please help.this code is hard coded and i need to unhard code it,so here is the code please help.

select staticdata.descr as deptname,appraisal.state as appraisalPhase,appraisal.lastupdated,appraisal.scoreunitid
from appraisal
left JOIN hruser on hruser.userid = appraisal.appraisee
LEFT JOIN staticdata on = hruser.deptname
where appraisal.lastupdated > "1999/01/01"
AND appraisal.lastupdated < "2009/01/01"
AND in ("1179991863437762177185","123539977081431915490412353998213101873543512353999380021949703600")
group by hruser.deptname

Thank you.
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42952
What do you mean by "un-hardcode" it? What are you trying to do with this query?
denis sorn
Ranch Hand

Joined: Apr 30, 2008
Posts: 33
I presume he wants to be able to change parameters dynamically...

If this is what you want Shumani you can do it with PreparedStatement.
It is sorta covered in the JavaRanch Style Guide.
subject: Sql statement