Examples of org.apache.empire.db.DBRecord

org.apache.empire.db.DBRecord
This class handles one record from a database table.

   * Insert a department
   */
  private int insertDepartmentSampleRecord(Connection conn,
      String department_name, String businessUnit) {
    // Insert a Department
    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
    return rec.getInt(sampleDB.T_DEPARTMENTS.DEPARTMENT_ID);
  }

View Full Code Here

   * Insert a person
   */
  private int insertEmployeeSampleRecord(Connection conn, String salutation,
      String firstName, String lastName, String gender, int depID) {
    // Insert an Employee
    DBRecord rec = new DBRecord();
    rec.create(sampleDB.T_EMPLOYEES);
    rec.setValue(sampleDB.T_EMPLOYEES.SALUTATION, salutation);
    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
    return rec.getInt(sampleDB.T_EMPLOYEES.EMPLOYEE_ID);
  }

View Full Code Here

     * </PRE>
   */
  private static int insertDepartment(Connection conn, String departmentName, String businessUnit)
    {
    // 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

     * </PRE>
   */
  private static int insertEmployee(Connection conn, String firstName, String lastName, String gender, int departmentId)
    {
    // Insert an Employee
    DBRecord rec = new DBRecord();
    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

     * </PRE>
   */
  private static void updateEmployee(Connection conn, int idPers, String phoneNumber)
    {
    // Update an Employee
    DBRecord rec = new DBRecord();
    rec.read(db.EMPLOYEES, idPers, conn);
    // Set
    rec.setValue(db.EMPLOYEES.PHONE_NUMBER, phoneNumber);
    rec.update(conn);
  }

View Full Code Here

     * </PRE>
   */
  private static int insertDepartment(Connection conn, String departmentName, String businessUnit)
    {
    // 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

    // ------- Action Construction -------
    
    public EmployeeDetailAction() {
        // Init Record Support Object
        DBTable table = getDatabase().T_EMPLOYEES;
        DBRecord record = new EmployeeRecord(this);
        // create a support Object
        recordSupport = new RecordActionSupport(this, table, record, SessionPersistence.Key);
    }

View Full Code Here

     * </PRE>
   */
  private static int insertEmployee(Connection conn, String firstName, String lastName, String gender, int departmentId)
    {
    // Insert an Employee
    DBRecord rec = new DBRecord();
    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

     * </PRE>
   */
  private static void updateEmployee(Connection conn, int idPers, String phoneNumber)
    {
    // Update an Employee
    DBRecord rec = new DBRecord();
    rec.read(db.EMPLOYEES, idPers, conn);
    // Set
    rec.setValue(db.EMPLOYEES.PHONE_NUMBER, phoneNumber);
    rec.update(conn);
  }

View Full Code Here

        removeFromSession();
    }
    
    public DBRecord detachRecord()
    {
        DBRecord rec = record;
        record = null;
        return rec;
    }

View Full Code Here

0 1 2 3 4 5 6 7 8 9

TOP

Related Classes of org.apache.empire.db.DBRecord

com.vsked.empire.samples.db.SampleApp

components.control

org.apache.commons.beanutils.PropertyUtilsBean

org.apache.empire.db.hsql.DBDatabaseDriverHSqlTest

org.apache.empire.db.mssql.DBDatabaseDriverMSSqlTest

org.apache.empire.db.postgresql.DBDatabaseDriverPostgreSQLTest

org.apache.empire.db.sqlite.DBDatabaseDriverSQLiteTest

org.apache.empire.jsf2.websample.web.SampleApplication

org.apache.empire.samples.cxf.wssample.server.EmployeeServiceImpl

org.apache.empire.samples.cxf.wssample.server.ServerControl

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.