problem with if else!!

[jesmi]

hi all

i have a problem with my code.following is my code:



[Codes]

Connection con = null;
PreparedStatement stmt = null;
ResultSet rs = null;
Map resultMap = null;
List result = null;
String sql="";


try{
con = Utilities.getDbConnection();

sql="select * from tran_event where tran_event_cd is not null";

if (chk1.equals("Y") && !eventCd.equals("null")){

sql=sql + " AND event_cd='"+eventCd+"'";
System.out.println("anything...eventcode.......... "+sql);
}
/* else
{
sql=sql;
}*/


if
(chk2.equals("Y") && !partyCd.equals("null")){
sql=sql + " AND party_cd='"+partyCd+"'";
System.out.println("anything...partyCode.......... "+sql);
}
/*else
{
sql=sql;
}*/

if
(chk3.equals("Y") && projectCd!="null"){
sql=sql + " AND project_cd='"+projectCd+"'";
System.out.println("anything...projectcode........ .."+sql);
}
/* else
{
sql=sql;
}*/
if
(chk4.equals("Y") && fromDt!="null" && toDt!="null"){
sql=sql + " AND event_dt between '"+fromDt+"' and '"+toDt+"'";

}
/* else
{
sql=sql;
}*/
stmt = con.prepareStatement(sql);
System.out.println("check"+ stmt);


rs = stmt.executeQuery();
[/Codes]

my problem is that i need my sql statement to enter in each of the specified if condition. if the condition doesn't meet the requirement then the sql statement should be added to the next condition that meets the requirement.
but my code only meets to that condition where the sql statement is placed just with that condition.

so please help me

thanks in advance

[JosAH]

if (chk1.equals("Y") && !eventCd.equals("null")){
if (chk3.equals("Y") &&  projectCd!="null"){
 

I took two sample lines from your method; the first line correctly checks two
strings for equality; the second line doesn't. Can you see the difference? There
are more incorrect lines like that.

btw, I notices you tried to tag your source code. The tag name is 'code', not 'codes'.

kind regards,

Jos