OAF Basic Data Type Conversion Methods For Frequent Usage
| Source Data Type | Target Data Type | Conversion Sample |
| oracle.jbo.domain.Number | int | Number Id = row.getId(); int idIntValue = Id.intValue(); |
| oracle.jbo.domain.Date | String | Date dobDomainDate = row.getDob(); String dobStr = dobDomainDate.toString(); |
1. Conversion of java String to java.sql.date
private java.sql.Date stringToDate(String dateS)
{
///String into Java.util.date
// java.util.Date into java.SQL.Date
java.sql.Date sqlStartDate = null;
if (dateS != null && !””.equals(dateS)) {
String dateFormat = “yyyy-MM-dd”;
SimpleDateFormat df = new SimpleDateFormat(dateFormat);
java.util.Date parsedDate1 = null;
{
try {
parsedDate1 = df.parse(dateS); // String into DB
} catch (ParseException e) {
System.out.println(“exception occurred in conversion “);
throw new OAException(“Formatting Issue, Unable to Parse Data”) ;
// TODO
}
sqlStartDate = new java.sql.Date(parsedDate1.getTime());
}
}
return sqlStartDate;
}
2. Comparison of dates
//Below code will compare To Date with From Date and will throw an error if it is less than from date
// compareTo method return values are : -1 , 0 , 1 for : lessthan, equalto, greater than
if(pageContext.getParameter(“go”)!=null)
{
String fromDateStr = pageContext.getParameter(“fromDate”) ;
Date fromDate = stringToDate(fromDateStr);
String toDateStr = pageContext.getParameter(“toDate”) ;
Date toDate = stringToDate(toDateStr);
pageContext.writeDiagnostics(this , ” From Date –>” + fromDate + ” To Date–>”+ toDate , 1);
if(toDate!=null && fromDate!=null )
{
if(toDate.compareTo(fromDate) <0 )
{
throw new OAException(“XXCUS”,”XXDHG_SSHR_EXP_DATE_ERR”,null,OAException.ERROR,null);
}
}
**this document is still under preparation, gets updated frequently.