Examples of org.apache.empire.db.DBRecord.update()

org.apache.empire.db.DBRecord.update()
Updates the record and saves all changes in the database. @see org.apache.empire.db.DBTable#updateRecord(DBRecord,Connection) @param conn a valid connection to the database.

    DBRecord rec = new DBRecord();
    rec.create(sampleDB.T_DEPARTMENTS);
    rec.setValue(sampleDB.T_DEPARTMENTS.NAME, department_name);
    rec.setValue(sampleDB.T_DEPARTMENTS.BUSINESS_UNIT, businessUnit);
    try {
      rec.update(conn);
    } catch (Exception e) {
      log.error(e.getLocalizedMessage());
      return 0;
    }
    // Return Department ID

View Full Code Here

    rec.setValue(sampleDB.T_EMPLOYEES.FIRST_NAME, firstName);
    rec.setValue(sampleDB.T_EMPLOYEES.LAST_NAME, lastName);
    rec.setValue(sampleDB.T_EMPLOYEES.GENDER, gender);
    rec.setValue(sampleDB.T_EMPLOYEES.DEPARTMENT_ID, depID);
    try {
      rec.update(conn);
    } catch (Exception e) {
      log.error(e.getLocalizedMessage());
      return 0;
    }
    // Return Employee ID

View Full Code Here

    // Insert a Department
    DBRecord rec = new DBRecord();
    rec.create(db.DEPARTMENTS);
    rec.setValue(db.DEPARTMENTS.NAME, departmentName);
    rec.setValue(db.DEPARTMENTS.BUSINESS_UNIT, businessUnit);
    rec.update(conn);
    // Return Department ID
    return rec.getInt(db.DEPARTMENTS.DEPARTMENT_ID);
  }


  /**

View Full Code Here

    rec.create(db.EMPLOYEES);
    rec.setValue(db.EMPLOYEES.FIRSTNAME, firstName);
    rec.setValue(db.EMPLOYEES.LASTNAME, lastName);
    rec.setValue(db.EMPLOYEES.GENDER, gender);
    rec.setValue(db.EMPLOYEES.DEPARTMENT_ID, departmentId);
    rec.update(conn);
    // Return Employee ID
    return rec.getInt(db.EMPLOYEES.EMPLOYEE_ID);
  }


  /**

View Full Code Here

    // Update an Employee
    DBRecord rec = new DBRecord();
    rec.read(db.EMPLOYEES, idPers, conn);
    // Set
    rec.setValue(db.EMPLOYEES.PHONE_NUMBER, phoneNumber);
    rec.update(conn);
  }


  /**
   * <PRE>
   * Performs an SQL-Query and prints the result to System.out

View Full Code Here

    // Insert a Department
    DBRecord rec = new DBRecord();
    rec.create(db.DEPARTMENTS);
    rec.setValue(db.DEPARTMENTS.NAME, departmentName);
    rec.setValue(db.DEPARTMENTS.BUSINESS_UNIT, businessUnit);
    rec.update(conn);
    // Return Department ID
    return rec.getInt(db.DEPARTMENTS.DEPARTMENT_ID);
  }


  /**

View Full Code Here

    rec.create(db.EMPLOYEES);
    rec.setValue(db.EMPLOYEES.FIRSTNAME, firstName);
    rec.setValue(db.EMPLOYEES.LASTNAME, lastName);
    rec.setValue(db.EMPLOYEES.GENDER, gender);
    rec.setValue(db.EMPLOYEES.DEPARTMENT_ID, departmentId);
    rec.update(conn);
    // Return Employee ID
    return rec.getInt(db.EMPLOYEES.EMPLOYEE_ID);
  }


  /**

View Full Code Here

    // Update an Employee
    DBRecord rec = new DBRecord();
    rec.read(db.EMPLOYEES, idPers, conn);
    // Set
    rec.setValue(db.EMPLOYEES.PHONE_NUMBER, phoneNumber);
    rec.update(conn);
  }


  /**
   * <PRE>
   * Performs an SQL-Query and prints the result to System.out

View Full Code Here

    rec.setValue(db.T_EMPLOYEES.C_SALUTATION, salutation);
    rec.setValue(db.T_EMPLOYEES.C_FIRSTNAME, firstName);
    rec.setValue(db.T_EMPLOYEES.C_LASTNAME, lastName);
    rec.setValue(db.T_EMPLOYEES.C_GENDER, gender);
    rec.setValue(db.T_EMPLOYEES.C_DEPARTMENT_ID, depID);
    if (!rec.update(conn)) {
      log.error(rec.getErrorMessage());
      return 0; 
    }
    // Return Employee ID
    return rec.getInt(db.T_EMPLOYEES.C_EMPLOYEE_ID);

View Full Code Here

        // Insert a Department
        DBRecord rec = new DBRecord();
        rec.create(db.DEPARTMENTS);
        rec.setValue(db.DEPARTMENTS.NAME, department_name);
        rec.setValue(db.DEPARTMENTS.BUSINESS_UNIT, businessUnit);
        if (!rec.update(conn))
        {
            log.error(rec.getErrorMessage());
            return 0;
        }
        // Return Department ID

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.