private static void commandParamsSample(Connection conn, int idProdDep, int idDevDep)
{
// create a command
DBCommand cmd = db.createCommand();
// Create cmd parameters
DBCommandParam curDepParam = cmd.addParam(); // Current Department
DBCommandParam genderParam = cmd.addParam(); // Gender ('M' or 'F')
// Define the query
cmd.select(T_EMP.C_FULLNAME);
cmd.join (T_EMP.C_EMPLOYEE_ID, db.V_EMPLOYEE_INFO.C_EMPLOYEE_ID);
cmd.where (T_EMP.C_GENDER.is(genderParam));