Package org.apache.empire.jsf2.websample.web.pages

Examples of org.apache.empire.jsf2.websample.web.pages.Page

52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
    @Override
    public Options getFieldOptions(DBColumn column)
    {
        if (column.equals(T.DEPARTMENT_ID))
        {
            SampleDB db = (SampleDB) getDatabase();
            DBCommand cmd = db.createCommand();
            cmd.select(db.T_DEPARTMENTS.DEPARTMENT_ID);
            cmd.select(db.T_DEPARTMENTS.NAME);
            cmd.orderBy(db.T_DEPARTMENTS.NAME);
            return db.queryOptionList(cmd, SampleUtils.getConnection());
        }
        // base class implementation
        return super.getFieldOptions(column);
    }
View Full Code Here
133
134
135
136
137
138
139
140
141
142
143
    }
    return conn;
  }

  private void initDatabase() {
    sampleDB = new SampleDB();

    // Open Database (and create if not existing)
    log.info("*** open database ***");
    String driverProvider = config.getDatabaseProvider();
    DBDatabaseDriver driver = getDatabaseDriver(driverProvider);
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
    @Override
    public Options getFieldOptions(DBColumn column)
    {
        if (column.equals(T.DEPARTMENT_ID))
        {
            SampleDB db = (SampleDB) getDatabase();
            DBCommand cmd = db.createCommand();
            cmd.select(db.T_DEPARTMENTS.DEPARTMENT_ID);
            cmd.select(db.T_DEPARTMENTS.NAME);
            cmd.orderBy(db.T_DEPARTMENTS.NAME);
            return db.queryOptionList(cmd, SampleUtils.getConnection());
        }
        // base class implementation
        return super.getFieldOptions(column);
    }
View Full Code Here
187
188
189
190
191
192
193
194
      TDepartments DEP = getDatabase().T_DEPARTMENTS;

      DBCommand queryCmd = createQueryCommand();
      queryCmd.select(DEP.DEPARTMENT_ID,DEP.NAME);
     
      SampleDB db = getDatabase();
        return db.queryOptionList(queryCmd, getConnection());
    }
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
    }
    return conn;
  }

  private void initDatabase() {
    sampleDB = new SampleDB();

    // Open Database (and create if not existing)
    log.info("*** open database ***");
    String driverProvider = config.getDatabaseProvider();
    DBDatabaseDriver driver = getDatabaseDriver(driverProvider);
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
    }
    return conn;
  }

  private void initDatabase() {
    sampleDB = new SampleDB();

    // Open Database (and create if not existing)
    log.info("*** open database ***");
    String driverProvider = config.getDatabaseProvider();
    DBDatabaseDriver driver = getDatabaseDriver(driverProvider);
View Full Code Here
187
188
189
190
191
192
193
194
      TDepartments DEP = getDatabase().T_DEPARTMENTS;

      DBCommand queryCmd = createQueryCommand();
      queryCmd.select(DEP.DEPARTMENT_ID,DEP.NAME);
     
      SampleDB db = getDatabase();
        return db.queryOptionList(queryCmd.getSelect(), getConnection());
    }
View Full Code Here
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
    @Override
    public Options getFieldOptions(DBColumn column)
    {
        if (column.equals(T.DEPARTMENT_ID))
        {
            SampleDB db = (SampleDB) getDatabase();
            DBCommand cmd = db.createCommand();
            cmd.select(db.T_DEPARTMENTS.DEPARTMENT_ID);
            cmd.select(db.T_DEPARTMENTS.NAME);
            cmd.orderBy(db.T_DEPARTMENTS.NAME);
            return db.queryOptionList(cmd.getSelect(), SampleUtils.getConnection());
        }
        // base class implementation
        return super.getFieldOptions(column);
    }
View Full Code Here
70
71
72
73
74
75
76
77
78
79
80
  @Override
  public void preRenderViewAction() {
    if (employeeRecord == null) {
      employeeRecord = new EmployeeRecord();
      SampleDB sampleDB = FacesUtils.getDatabase();
      String id = FacesUtils.getHttpRequest().getParameter("id");
      if (id != null) {
        try {
          employeeRecord.read(sampleDB.T_EMPLOYEES,
              new String[] { id }, FacesUtils.getConnection());
View Full Code Here
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
  public EmployeeListPage() {
  }

  @Override
  public void preRenderViewAction() {
    SampleDB sampleDB = FacesUtils.getDatabase();

    DBColumnExpr C_FULL_NAME = sampleDB.T_EMPLOYEES.C_LAST_NAME.append(", ")
        .append(sampleDB.T_EMPLOYEES.C_FIRST_NAME).as("NAME");
    DBColumnExpr C_DEPARTMENT = sampleDB.T_DEPARTMENTS.C_NAME
        .as("DEPARTMENT");
    // lade Liste aus der Datenbank

    SampleDB.Employees EMP = sampleDB.T_EMPLOYEES;
    SampleDB.Departments DEP = sampleDB.T_DEPARTMENTS;

    DBCommand cmd = sampleDB.createCommand();
    cmd.select(EMP.C_EMPLOYEE_ID);
    cmd.select(C_FULL_NAME, EMP.C_GENDER, EMP.C_DATE_OF_BIRTH);
    cmd.select(C_DEPARTMENT);
    cmd.join(DEP.C_DEPARTMENT_ID, EMP.C_DEPARTMENT_ID);
View Full Code Here
TOP

Related Classes of org.apache.empire.jsf2.websample.web.pages.Page

  • com.sun.faces.mgbean.BeanManager
  • org.apache.commons.beanutils.PropertyUtilsBean
  • org.apache.empire.commons.OptionEntry
  • org.apache.empire.commons.Options
  • org.apache.empire.data.Column
  • org.apache.empire.data.DataType
  • org.apache.empire.data.Record
  • org.apache.empire.db.DBColumn
  • org.apache.empire.db.DBColumnExpr
  • org.apache.empire.db.DBCommand
    • Copyright © 2018 www.massapicom. All rights reserved.
    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.