我的查询语句:protected java.lang.String SQLString = "select .... FROM ADMINISTRATOR.EMPLOYEE WHERE ( ( ADMINISTRATOR.EMPLOYEE.SEX = ? ) AND ( ADMINISTRATOR.EMPLOYEE.WORKDEPT = ? ) )";
此语句是在websphere studio的向导下生成。我想加入null判断,却不知加在何处,试了试总出错。大侠救我!
此语句是在websphere studio的向导下生成。我想加入null判断,却不知加在何处,试了试总出错。大侠救我!
{
pre_statement.setString(1, sex);
pre_statement.setString(2, workdept);
}
else
{
break;
}
判断一下就可以了
if (sex = null && workdept = null){返回错误;}
else{
if (sex != null && workdept != null){查询语句;//双条件查询}
else{
if(sex != null ){查询语句;//按性别查询}
else{查询语句;//按性别查询}
}
}可以了吧?