/* This procedure demonstrates the use of command parameter for prepared statements */
private static void commandParamsSample(Connection conn, int idProdDep, int idDevDep)
{
// create a command
DBCommand cmd = db.createCommand();
// Create cmd parameters
DBCmdParam curDepParam = cmd.addParam(); // Current Department
DBCmdParam 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));
cmd.where (db.V_EMPLOYEE_INFO.C_CURRENT_DEP_ID.is(curDepParam));
System.out.println("Perfoming two queries using a the same command with different parameter values.");
DBReader r = new DBReader();
try {