how can i write a user defined query statement

[David Nelson]

this function is just like most site provided, there are several options, user can specify values for some options, but don't have to specify all of them,

e.g. to find users, there are some options such as: age arrange, sex, occupation, living place, height..., user can specify values for some of them, so that to shrink search result.

how can i write a prepared statement for this kind of query,

Cheers.

[Adeel Ansari]

here somethin for you Nelson

String query = "SELECT p.PATIENT_UTSTR, p.PMH_MRN, p.UTSW_MRN,   p.LAST_NAME, p.FIRST_NAME, p.MIDDLE_NAME, " +
"s.SEX_DESC, e.NAME, p.PATIENT_ID from PATIENT p, ETHNICITY e, SEX s, PATIENT_DEMOGRAPH pd " +
"where pd.ETHNICITY = e.ID " +
"AND pd.SEX = s.SEX_ID "+
"AND p.PATIENT_ID = pd.PATIENT_ID";

 
String patUTSTRQuery = " and p.PATIENT_UTSTR = ?";
String middleNameQuery = " and p.MIDDLE_NAME = ?";
String sexQuery = " and pd.SEX = ?";
.
.
.
 
String ethniQuery = " and pd.ETHNICITY = ?";
 

And then some if conditions,

if(bean.getPatientUTSTR() !=null && bean.getPatientUTSTR().length()>0)
{
query = query + patUTSTRQuery;
utstrFlag = true;
}

if(bean.getPmhMrn() !=null && bean.getPmhMrn().length()>0)
{
query = query + pmhMrnQuery;
pmhMrnFlag = true;
}
                        .
                        .
                        .
                        .
                        . 

if(bean.getFirstName() !=null && bean.getFirstName().length()>0)
{
query = query + firstNameQuery;
firstNameFlag = true;
}
 

hope it will give you atleast an idea.
[ October 25, 2004: Message edited by: adeel ansari ]

[David Nelson]

i c it, thanks sooo much