Examples of org.apache.empire.db.DBCommand.where()

org.apache.empire.db.DBCommand.where()
Adds a compare expression to the list of constraints. If another restriction already exists for the same column it will be replaced. @param expr the DBCompareExpr object

    EmployeeSearch employeeSearch = (EmployeeSearch) FacesUtils
        .getManagedBean(EmployeeSearch.class);
    if (employeeSearch.getDepartmentId() != null)
      cmd.where(EMP.C_DEPARTMENT_ID.is(employeeSearch.getDepartmentId()));
    if (StringUtils.isValid(employeeSearch.getFirstName()))
      cmd.where(EMP.C_FIRST_NAME.likeUpper(
          employeeSearch.getFirstName() + "%").or(
          EMP.C_FIRST_NAME.is(null)));
    if (StringUtils.isValid(employeeSearch.getLastName()))
      cmd.where(EMP.C_LAST_NAME.likeUpper(employeeSearch.getLastName()
          + "%"));

View Full Code Here

    if (StringUtils.isValid(employeeSearch.getFirstName()))
      cmd.where(EMP.C_FIRST_NAME.likeUpper(
          employeeSearch.getFirstName() + "%").or(
          EMP.C_FIRST_NAME.is(null)));
    if (StringUtils.isValid(employeeSearch.getLastName()))
      cmd.where(EMP.C_LAST_NAME.likeUpper(employeeSearch.getLastName()
          + "%"));


    cmd.orderBy(EMP.C_LAST_NAME);
    cmd.orderBy(EMP.C_FIRST_NAME);

View Full Code Here

        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));
        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();

View Full Code Here

        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));
        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 {

View Full Code Here

        // Define shortcuts for tables used - not necessary but convenient
        SampleAdvDB.Employees EMP = T_EMP;
        // Select required columns
        cmd.select(T_EMP.getColumns());
        // Set Constraints
        cmd.where(T_EMP.C_RETIRED.is(false));


        // Query Records and print output
        DBReader reader = new DBReader();
        try
        {

View Full Code Here

        // Define the query
        DBCommand cmd = db.createCommand();
        // Select required columns
        cmd.select(T_EMP.getColumns());
        // Set Constraints
        cmd.where(T_EMP.C_RETIRED.is(false));


        // Query Records and print output
        DBReader reader = new DBReader();
        try
        {   // Open Reader

View Full Code Here

        cmd.join(T_EDH.C_EMPLOYEE_ID, Q_MAX_DATE.findQueryColumn(T_EDH.C_EMPLOYEE_ID))
          .where(T_EDH.C_DATE_FROM.is(Q_MAX_DATE.findQueryColumn(MAX_DATE_FROM)));
        cmd.join(T_EMP.C_EMPLOYEE_ID, T_EDH.C_EMPLOYEE_ID);
        cmd.join(T_DEP.C_DEPARTMENT_ID, T_EDH.C_DEPARTMENT_ID);
        // Set Constraints
        cmd.where(T_EMP.C_RETIRED.is(false));
        // Set Order
        cmd.orderBy(T_EMP.C_LASTNAME);
        cmd.orderBy(T_EMP.C_FIRSTNAME);


        // Query Records and print output

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.