@Table(name="PERSON") @Inheritance(strategy=InheritanceType.SINGLE_TABLE) @DiscriminatorColumn(name="SEX", discriminatorType=DiscriminatorType.STRING,length=1)
@Entity
@Table(name = "PERSON")
@DiscriminatorValue("M")
@NamedQueries( { @NamedQuery(name = "Men.findAll", query = "select o from Men o") })
public class Men extends Person implements Serializable {
@Column(name = "MEN_ATTR")
private String menAttr;
public Men() {
}
public String getMenAttr() {
return menAttr;
}
public void setMenAttr(String menAttr) {
this.menAttr = menAttr;
}
}
@Entity
@Table(name = "PERSON")
@DiscriminatorValue("W")
@NamedQueries( { @NamedQuery(name = "Women.findAll", query = "select o from Women o") })
public class Women extends Person implements Serializable {
@Column(name = "WOMEN_ATTR")
private String womenAttr;
public Women() {
}
public String getWomenAttr() {
return womenAttr;
}
public void setWomenAttr(String womenAttr) {
this.womenAttr = womenAttr;
}
}
/**
* Add attribute defaulting logic in this method.
* @param attributeList list of attribute names/values to initialize the row
*/
protected void create(AttributeList attributeList) {
super.create(attributeList);
SequenceImpl seq = new SequenceImpl("EMPLOYEES_SEQ", getDBTransaction());
Number seqNextval = seq.getSequenceNumber();
setEmployeeId(seqNextval);
}private RichTable empTable;
private List selectedEmpArray = new ArrayList();
private int modifiedRows = 0;
private int newRows = 0;
public IndexBean() {
}
public void setEmpTable(RichTable empTable) {
this.empTable = empTable;
}
public RichTable getEmpTable() {
return empTable;
}
public void setModifiedRows(int modifiedRows) {
this.modifiedRows = modifiedRows;
}
public int getModifiedRows() {
return modifiedRows;
}
public void setNewRows(int newRows) {
this.newRows = newRows;
}
public int getNewRows() {
return newRows;
}
/**
* Get the selected rowKey
* Add the rowKey to selectedEmpArray arrayList
* @param selectionEvent
*/
public void empSelectionEvent(SelectionEvent selectionEvent) {
RowKeySet empRKS = selectionEvent.getAddedSet();
if (empRKS.size() > 0) {
Iterator empRKSIterator = empRKS.iterator();
while (empRKSIterator.hasNext()) {
Key key = (Key)((List)empRKSIterator.next()).get(0);
//Add the key if not existed in selectedEmpArray
if (!selectedEmpArray.contains(key)) {
selectedEmpArray.add(key);
}
}
}
}
public BindingContainer getBindings() {
return BindingContext.getCurrent().getCurrentBindingsEntry();
}
/**
* While loop the selectedEmpArray
* Get the entity status for the rowKeys
* @param actionEvent
*/
public void fetchModifiedRows(ActionEvent actionEvent) {
if (selectedEmpArray.size() > 0) {
//Resetting the row counts
this.setModifiedRows(0);
this.setNewRows(0);
DCBindingContainer dcBindings = (DCBindingContainer)getBindings();
DCIteratorBinding EmpsDCIterBinding = dcBindings.findIteratorBinding("EmployeesView1Iterator");
RowSetIterator EmpsRSIter = EmpsDCIterBinding.getRowSetIterator();
ViewObject vo = EmpsDCIterBinding.getViewObject();
Iterator selectedEmpsIter = selectedEmpArray.iterator();
while (selectedEmpsIter.hasNext()) {
Row currentRow = EmpsRSIter.getRow((Key)selectedEmpsIter.next());
EmpsRSIter.setCurrentRow(currentRow);
ViewRowImpl myRow = (ViewRowImpl)vo.getCurrentRow();
EntityImpl entityImpl = (EntityImpl)myRow.getEntity(0);
if (EntityImpl.STATUS_MODIFIED == entityImpl.getEntityState()) {
this.setModifiedRows((this.getModifiedRows() + 1));
} else if (EntityImpl.STATUS_NEW == entityImpl.getEntityState()) {
this.setNewRows((this.getNewRows() + 1));
}
}
}
//Commit the transaction
commitAction();
}
public String commitAction() {
BindingContainer bindings = getBindings();
OperationBinding operationBinding = bindings.getOperationBinding("Commit");
Object result = operationBinding.execute();
if (!operationBinding.getErrors().isEmpty()) {
return null;
}
return null;
}
/**
* CreateInsert new row and get rowKey for the added row
* Add the rowKey to the selectedEmpArray arrayList
* @param actionEvent
*/
public void createNewRow(ActionEvent actionEvent) {
BindingContainer bindings = getBindings();
OperationBinding oper = bindings.getOperationBinding("CreateInsert");
oper.execute();
DCBindingContainer dcBindings = (DCBindingContainer)BindingContext.getCurrent().getCurrentBindingsEntry();
DCIteratorBinding EmpsIter = dcBindings.findIteratorBinding("EmployeesView1Iterator");
EmployeesViewImpl eImpl = (EmployeesViewImpl)EmpsIter.getViewObject();
//Add the key if not existed in selectedEmpArray
if (!selectedEmpArray.contains(eImpl.getCurrentRow().getKey())) {
selectedEmpArray.add(eImpl.getCurrentRow().getKey());
}
}
public class Employees {
private Integer employeeId;
private String firstName;
private String lastName;
private String email;
private String phoneNo;
private Date hireDate;
private String jobId;
private Integer salary;
private Integer departmentId;
public Employees() {
super();
}
public Employees(int employeeId, String firstName, String lastName, String email, String phoneNo, Date hireDate,
String jobId, int salary, int departmentId) {
this.setEmployeeId(employeeId);
this.setFirstName(firstName);
this.setLastName(lastName);
this.setEmail(email);
this.setPhoneNo(phoneNo);
this.setHireDate(hireDate);
this.setJobId(jobId);
this.setSalary(salary);
this.setDepartmentId(departmentId);
}
public void setEmployeeId(Integer employeeId) {
this.employeeId = employeeId;
}
public Integer getEmployeeId() {
return employeeId;
}
public void setFirstName(String firstName) {
this.firstName = firstName;
}
public String getFirstName() {
return firstName;
}
public void setLastName(String lastName) {
this.lastName = lastName;
}
public String getLastName() {
return lastName;
}
public void setEmail(String email) {
this.email = email;
}
public String getEmail() {
return email;
}
public void setPhoneNo(String phoneNo) {
this.phoneNo = phoneNo;
}
public String getPhoneNo() {
return phoneNo;
}
public void setHireDate(Date hireDate) {
this.hireDate = hireDate;
}
public Date getHireDate() {
return hireDate;
}
public void setJobId(String jobId) {
this.jobId = jobId;
}
public String getJobId() {
return jobId;
}
public void setSalary(Integer salary) {
this.salary = salary;
}
public Integer getSalary() {
return salary;
}
public void setDepartmentId(Integer departmentId) {
this.departmentId = departmentId;
}
public Integer getDepartmentId() {
return departmentId;
}
}public class PopulateData {
private static List allEmployees;
static {
allEmployees = new ArrayList();
allEmployees.add(new Employees(100, "Steven", "King", "SKING", "515.123.4567", new Date(), "AD_PRES", 24000,
20));
allEmployees.add(new Employees(101, "Neena ", "Kochhar", "NKOCHHAR", "515.123.4568", new Date(), "AD_VP",
17000, 90));
allEmployees.add(new Employees(102, "Lex", "De Haan", "AHUNOLD", "515.423.4567", new Date(), "IT_PROG", 15000,
90));
allEmployees.add(new Employees(103, "Alexander", "Hunold", "AHUNOLD", "515.423.4567", new Date(), "IT_PROG",
10000, 20));
allEmployees.add(new Employees(104, "Bruce", "Ernst", "BERNST", "515.423.4568", new Date(), "IT_PROG", 5000,
50));
allEmployees.add(new Employees(105, "David", "Austin", "DAUSTIN", "515.423.4569", new Date(), "IT_PROG", 7000,
30));
allEmployees.add(new Employees(106, "Valli", "Pataballa", "VPATABAL", "515.423.4560", new Date(), "IT_PROG",
8000, 50));
allEmployees.add(new Employees(107, "Diana", "Lorentz", "DLORENTZ", "515.423.5567", new Date(), "IT_PROG",
9000, 50));
allEmployees.add(new Employees(108, "Nancy", "Greenberg", "NGREENBE", "515.124.4569", new Date(), "FI_MGR",
10000, 100));
allEmployees.add(new Employees(109, "Daniel", "Faviet", "DFAVIET", "515.124.4169", new Date(), "FI_ACCOUNT",
13000, 100));
allEmployees.add(new Employees(110, "John", "Chen", "JCHEN", "515.124.4269", new Date(), "FI_ACCOUNT", 14000,
100));
allEmployees.add(new Employees(111, "Ismael", "Sciarra", "ISCIARRA", "515.124.4369 ", new Date(), "FI_ACCOUNT",
12000, 60));
allEmployees.add(new Employees(112, "Jose Manuel", "Urman", "JMURMAN", "515.124.4469", new Date(),
"FI_ACCOUNT", 4000, 60));
allEmployees.add(new Employees(112, "Jose Manuel", "Urman", "JMURMAN", "515.124.4469", new Date(),
"FI_ACCOUNT", 7800, 60));
allEmployees.add(new Employees(113, "Luis", "Popp", "LPOPP", "515.124.4567", new Date(), "FI_ACCOUNT", 6900,
70));
allEmployees.add(new Employees(114, "Den", "Raphaely", "DRAPHEAL", "515.127.4561", new Date(), "PU_MAN", 11000,
90));
}
public PopulateData() {
super();
}
public static List getAllEmployees() {
return allEmployees;
}
} public List filterByDeptId(Integer departmentId) {
try {
List allEmployees = PopulateData.getAllEmployees();
if (departmentId != null) {
List filteredEmployees = new ArrayList();
for (Employees e : allEmployees) {
if (e.getDepartmentId() == departmentId) {
filteredEmployees.add(e);
}
}
return filteredEmployees;
} else {
return allEmployees;
}
} catch (Exception e) {
e.printStackTrace();
}
return null;
}
public List getAllEmployees() {
return PopulateData.getAllEmployees();
} /**
* This method will overrides the view object's insertRow()
* First create a new row
* Removes the row from the collection and then retain it for insertion into another location.
* Navigates to the last row in the row set.
* Navigates to next row
* Inserts the same row to the row set
* @param row
*/
@Override
public void insertRow(Row row) {
super.insertRow(row);
row.removeAndRetain();
last();
next();
getDefaultRowSet().insertRow(row);
}