Please refer this link :
http://andrejusb.blogspot.in/2014/02/explaining-change-indicator-property.html?spref=fb
It will be helpful.
http://andrejusb.blogspot.in/2014/02/explaining-change-indicator-property.html?spref=fb
It will be helpful.
Friday, September 15, 2017
Wednesday, June 8, 2016
Preparing ViewObject's query for execution using ViewObjectImpl::prepareRowSetForQuery(ViewRowSetImpl vrs) method
If you need to assign bind variable values or modify where clause conditionally just before the the query execution
ViewObjectImpl::prepareRowSetForQuery(ViewRowSetImpl vrs)
This method engages well with ViewObjectImpl::getQueryHitCount()and ViewObjectImpl::getEstimatedRowCount() as well. I mean the prepareRowSetForQuery(...) will get invoked before calling the the above methods by the runtime.
This is useful if you need to set bind variable values before the query execution for List Of Values or ViewAccssors used for displaying Tree components.
You can use this method safely(zero side effect) to add your logic for tweaking default query by setting bind variable values or additional where clause at run time.
Example:
public class DepartmentsViewObjectImpl extends ViewObjectImpl{
...
@Override
public void prepareRowSetForQuery(ViewRowSetImpl vrs) {
vrs.ensureVariableManager().setVariableValue("bindVarDeptId", deptIdRuntimeValue);
super.prepareRowSetForQuery(vrs);
}
Hope this will help you
ViewObjectImpl::prepareRowSetForQuery(ViewRowSetImpl vrs)
This method engages well with ViewObjectImpl::getQueryHitCount()and ViewObjectImpl::getEstimatedRowCount() as well. I mean the prepareRowSetForQuery(...) will get invoked before calling the the above methods by the runtime.
This is useful if you need to set bind variable values before the query execution for List Of Values or ViewAccssors used for displaying Tree components.
You can use this method safely(zero side effect) to add your logic for tweaking default query by setting bind variable values or additional where clause at run time.
Example:
public class DepartmentsViewObjectImpl extends ViewObjectImpl{
...
@Override
public void prepareRowSetForQuery(ViewRowSetImpl vrs) {
vrs.ensureVariableManager().setVariableValue("bindVarDeptId", deptIdRuntimeValue);
super.prepareRowSetForQuery(vrs);
}
Hope this will help you
Tuesday, June 7, 2016
how to display ArrayList in FacesMessage programatically in ADF
In some scenario, we need to display List in popup or FacesMessage as list.
Following is the way to display List, follow the following Steps,
Example :we are storing 3 Employee name in array List and displaying it as ErrorMessage:
1)create a ArrayList of 3 Employees in bean :
ArrayList<String> empList = new ArrayList();
empList.add("ABC");
empList.add("PQR");
empList.add("XYZ");
Now empList have 3 Employee names,we have to show this list in FacesMessage
pass this empList ArrayList to displayList() method as follows;
displayList(empList) ;
2)following function used for display List
public void displayList(ArrayList empList) ;
{
StringBuilder saveMsg = new StringBuilder();
saveMsg.append("<html><head> <style> p.big { line-height: 1.5; } </style> </head><body>");
saveMsg.append("<b><p class=\"big\" style='color:black; width: 800px;'>");
saveMsg.append("<b><p style='color:red'>" + "Employee List" +
" </p></b>");
saveMsg.append("<ul>");
for (String name : empList) {
saveMsg.append("<li> <b>" + name + "</b></li>");
}
saveMsg.append("</ul><br>");
saveMsg.append("</body></html>");
// FacesMessage msg = new FacesMessage(saveMsg.toString());
// FacesContext.getCurrentInstance().addMessage(null, msg);
JSFUtils.addFacesErrorMessage(saveMsg.toString());
}
Hope this will help you
Following is the way to display List, follow the following Steps,
Example :we are storing 3 Employee name in array List and displaying it as ErrorMessage:
1)create a ArrayList of 3 Employees in bean :
ArrayList<String> empList = new ArrayList();
empList.add("ABC");
empList.add("PQR");
empList.add("XYZ");
Now empList have 3 Employee names,we have to show this list in FacesMessage
pass this empList ArrayList to displayList() method as follows;
displayList(empList) ;
2)following function used for display List
public void displayList(ArrayList empList) ;
{
StringBuilder saveMsg = new StringBuilder();
saveMsg.append("<html><head> <style> p.big { line-height: 1.5; } </style> </head><body>");
saveMsg.append("<b><p class=\"big\" style='color:black; width: 800px;'>");
saveMsg.append("<b><p style='color:red'>" + "Employee List" +
" </p></b>");
saveMsg.append("<ul>");
for (String name : empList) {
saveMsg.append("<li> <b>" + name + "</b></li>");
}
saveMsg.append("</ul><br>");
saveMsg.append("</body></html>");
// FacesMessage msg = new FacesMessage(saveMsg.toString());
// FacesContext.getCurrentInstance().addMessage(null, msg);
JSFUtils.addFacesErrorMessage(saveMsg.toString());
}
Hope this will help you
Monday, June 6, 2016
find out the comparsion between user modifed and DB stored value in ADF
Sometimes for drop down we need to check current changed value with DB value.
so following are the steps to get DB value from EO:
1)From value changed Listener get column name and new value in managed bean
public void countryIdChanged(ValueChangeEvent valueChangeEvent) {
String newcountryId = valueChangeEvent.getNewValue().toString();
OperationBinding executeVerifyActualColumnValue = ADFUtils.findOperation("verifyActualValue");//method return in VOImpl
executeVerifyActualColumnValue.getParamsMap().put("columnName", countryid);
executeVerifyActualColumnValue.getParamsMap().put("columnValue", newcountryId );
executeVerifyActualColumnValue.execute();
}
2)in VOImpl write this method "verifyActualValue"
public boolean verifyActualColumnValue(String columnName, String newcountryId ) {
CountryVORowImpl currentRow = (CountryVORowImpl ) this.getCurrentRow();
GoalsEOImpl countryEntity = (CountryEOImpl) currentRow.getEntity(0);
String oldColumnValue = null;
oldColumnValue =
(String) countryEntity.getAttribute(countryEntity .COUNTRYID, countryEntity.ORIGINAL_VERSION);
//here oldColumnValue is DB Value and compare this value with DB Value
}
Friday, February 12, 2016
Export Table data or VOIterator Data in Excel in ADF using fileDownloadActionListener
Using fileDownloadActionListener we can export data as follows in adf:
Steps:
1) Create Adf Application
2)Create EO and VO for Employee Table.
3)Create page and Drag and Drop Employee VO DataControl in page.
4)Take one button named as "Export Data"
5)In Component Palette search fileDownloadActionListener and Drag and Drop on Export Data button
6)In properties of fileDownloadActionListener set following values to attributes:
contentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
filename="Employee.xls"
method="#{Employees.getExcel}"
create method in Employee bean.
and paste following code in method getExcel()
NOTE : First add library poi-3.7-20101029 .jar
public void getExcel(FacesContext facesContext, OutputStream outputStream) {
DCIteratorBinding dcIteratorBindings = null;
try {
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet worksheet = workbook.createSheet("Employee"); //Tab Name
DCBindingContainer bindings = (DCBindingContainer) BindingContext.getCurrent().getCurrentBindingsEntry();
dcIteratorBindings = bindings.findIteratorBinding("EmployeesView1Iterator"); // VOIterator
HSSFRow excelrow = null;
// Get all the rows of a iterator
Row[] rows = dcIteratorBindings.getAllRowsInRange();
int i = 0;
for (Row row : rows) {
//print header on first row in excel
if (i == 0) {
excelrow = (HSSFRow) worksheet.createRow((short) i);
short j = 0;
for (String colName : row.getAttributeNames()) {
HSSFCell cellA1 = excelrow.createCell((short) j);
cellA1.setCellValue(colName)
j++;
}
}
//print data from second row in excel
++i;
short j = 0;
excelrow = worksheet.createRow((short) i);
for (String colName : row.getAttributeNames()) {
HSSFCell cell = excelrow.createCell(j);
if (row.getAttribute(colName) != null) {
cell.setCellValue(row.getAttribute(colName).toString());
}
j++;
}
worksheet.createFreezePane(0, 1, 0, 1);
}
workbook.write(outputStream);
outputStream.flush();
} catch (Exception e) {
e.printStackTrace();
}
}
Hope it will help you
Steps:
1) Create Adf Application
2)Create EO and VO for Employee Table.
3)Create page and Drag and Drop Employee VO DataControl in page.
4)Take one button named as "Export Data"
5)In Component Palette search fileDownloadActionListener and Drag and Drop on Export Data button
contentType="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet"
filename="Employee.xls"
method="#{Employees.getExcel}"
create method in Employee bean.
and paste following code in method getExcel()
NOTE : First add library poi-3.7-20101029 .jar
public void getExcel(FacesContext facesContext, OutputStream outputStream) {
DCIteratorBinding dcIteratorBindings = null;
try {
HSSFWorkbook workbook = new HSSFWorkbook();
HSSFSheet worksheet = workbook.createSheet("Employee"); //Tab Name
DCBindingContainer bindings = (DCBindingContainer) BindingContext.getCurrent().getCurrentBindingsEntry();
dcIteratorBindings = bindings.findIteratorBinding("EmployeesView1Iterator"); // VOIterator
HSSFRow excelrow = null;
// Get all the rows of a iterator
Row[] rows = dcIteratorBindings.getAllRowsInRange();
int i = 0;
for (Row row : rows) {
//print header on first row in excel
if (i == 0) {
excelrow = (HSSFRow) worksheet.createRow((short) i);
short j = 0;
for (String colName : row.getAttributeNames()) {
HSSFCell cellA1 = excelrow.createCell((short) j);
cellA1.setCellValue(colName)
j++;
}
}
//print data from second row in excel
++i;
short j = 0;
excelrow = worksheet.createRow((short) i);
for (String colName : row.getAttributeNames()) {
HSSFCell cell = excelrow.createCell(j);
if (row.getAttribute(colName) != null) {
cell.setCellValue(row.getAttribute(colName).toString());
}
j++;
}
worksheet.createFreezePane(0, 1, 0, 1);
}
workbook.write(outputStream);
outputStream.flush();
} catch (Exception e) {
e.printStackTrace();
}
}
7)run the project
Tuesday, February 9, 2016
How to export ADF table data into excel Sheet in ADF
Sometime we need to export table data in Excel file.So Adf gives you simple solution on this.
Steps to export table data on button click:
create Sample application
create EO and VO of Employee table.
create page and drag and drop Employee data control as table
drag and drop button on page named "Export table data"
From "Component Palette" select Export Collection action Listener and drop on Export table data button.
following window will appears
In Exportid enter value of the table that you want to export
here it is "t1"
For Type “Select excelHTML” from drop down list and you are all set to go.
run the application and get the excel file
Hope this will help you
Steps to export table data on button click:
create Sample application
create EO and VO of Employee table.
create page and drag and drop Employee data control as table
drag and drop button on page named "Export table data"
From "Component Palette" select Export Collection action Listener and drop on Export table data button.
following window will appears
In Exportid enter value of the table that you want to export
here it is "t1"
For Type “Select excelHTML” from drop down list and you are all set to go.
run the application and get the excel file
Hope this will help you
Tuesday, December 22, 2015
Oracle MAF: Programmatically call REST service ( REST with JSON output)
This example is using RESTServicesAdapter. Using that programmatically you can call a REST service and you can manipulate response as per need.
My REST service details are as follows:
URL: localhost:1111/HrServiceFirst-ViewController-context-root/resources/view/emp
{"lstEmp":[{"address":"ss","empId":22222,"empName":"sss"},{"address":"SKING","empId":100,"empName":"Steven"},{"address":"NKOCHHAR","empId":101,"empName":"Neena"},{"address":"LDEHAAN","empId":102,"empName":"Lex"},{"address":"AHUNOLD","empId":103,"empName":"Alexander"}]}
Step 1: Create new Mobile Application Framework (MAF) Application:
Step 2 :Right click on Connenction create new REST Connection
Give the name of rest Connection and URL End point click ok as follow:
Step 3: Create Employee Class and add following variable and generate accessors
public Integer empId;
public String empName;
public String address;
Step 4: create CallService class and add follwing code in it
package mobile;
import java.util.ArrayList;
import java.util.List;
import oracle.adfmf.dc.ws.rest.RestServiceAdapter;
import oracle.adfmf.framework.api.Model;
import oracle.adfmf.json.JSONArray;
import oracle.adfmf.json.JSONException;
import oracle.adfmf.json.JSONObject;
public class CallService {
public CallService() {
super();
}
List<Employee> lstEmp=new ArrayList<Employee>();
private Employee emp;
public void setLstEmp(List<Employee> lstEmp) {
this.lstEmp = lstEmp;
}
public List<Employee> getLstEmp() {
return lstEmp;
}
public void getEmployees() {
RestServiceAdapter restServiceAdapter = Model.createRestServiceAdapter();
restServiceAdapter.clearRequestProperties();
restServiceAdapter.setConnectionName("restConn");
restServiceAdapter.setRequestType(RestServiceAdapter.REQUEST_TYPE_GET);
restServiceAdapter.setRetryLimit(0);
restServiceAdapter.setRequestURI("/emp");
try {
String response = restServiceAdapter.send("");
JSONObject res = null;
res = new JSONObject(response);
JSONArray lstOfEmp=res.getJSONArray("lstEmp");
for(int i=0;i<lstOfEmp.length();i++){
JSONObject obj=lstOfEmp.getJSONObject(i);
System.out.println("Emp name "+obj.getString("empName"));
Employee e=new Employee();
e.setEmpName(obj.getString("empName"));
lstEmp.add(e);
}
} catch (JSONException jsone) {
// TODO: Add catch code
jsone.printStackTrace();
} catch (Exception e) {
// TODO: Add catch code
e.printStackTrace();
}
}
}
Step 6: drag and drop DC in Page with empName view Attribute in List View
Step 7: Deploy project on emulator
Output:
Give the name of rest Connection and URL End point click ok as follow:
Step 3: Create Employee Class and add following variable and generate accessors
public Integer empId;
public String empName;
public String address;
package mobile;
import java.util.ArrayList;
import java.util.List;
import oracle.adfmf.dc.ws.rest.RestServiceAdapter;
import oracle.adfmf.framework.api.Model;
import oracle.adfmf.json.JSONArray;
import oracle.adfmf.json.JSONException;
import oracle.adfmf.json.JSONObject;
public class CallService {
public CallService() {
super();
}
List<Employee> lstEmp=new ArrayList<Employee>();
private Employee emp;
public void setLstEmp(List<Employee> lstEmp) {
this.lstEmp = lstEmp;
}
public List<Employee> getLstEmp() {
return lstEmp;
}
public void getEmployees() {
RestServiceAdapter restServiceAdapter = Model.createRestServiceAdapter();
restServiceAdapter.clearRequestProperties();
restServiceAdapter.setConnectionName("restConn");
restServiceAdapter.setRequestType(RestServiceAdapter.REQUEST_TYPE_GET);
restServiceAdapter.setRetryLimit(0);
restServiceAdapter.setRequestURI("/emp");
try {
String response = restServiceAdapter.send("");
JSONObject res = null;
res = new JSONObject(response);
JSONArray lstOfEmp=res.getJSONArray("lstEmp");
for(int i=0;i<lstOfEmp.length();i++){
JSONObject obj=lstOfEmp.getJSONObject(i);
System.out.println("Emp name "+obj.getString("empName"));
Employee e=new Employee();
e.setEmpName(obj.getString("empName"));
lstEmp.add(e);
}
} catch (JSONException jsone) {
// TODO: Add catch code
jsone.printStackTrace();
} catch (Exception e) {
// TODO: Add catch code
e.printStackTrace();
}
}
}
Step 5:create Data Control of CallService Class;
Step 6: create feature in maf-feature.xml with type MAF Task Flow and create Task Flow.
create ViewActivity call named RestServiceCall and Create .amx Page
Then select getEmployees() method from data control drop in task flow:
In PageDef of method View add accessor iterator in executables
Step 6: drag and drop DC in Page with empName view Attribute in List View
Step 7: Deploy project on emulator
Output:
Subscribe to:
Posts (Atom)