how to parse sql queries embedded in java code??
807589Dec 4 2008 — edited Dec 4 2008i m devloping a java code analyzer.
So i need to find how many queries are thre in a java file.
e.g. java code
private String getUpdateQueryForAppFileNo(PersonalDTO personalDTO) throws Exception
{
StringBuffer sBuffer = new StringBuffer(300);
sBuffer.append("update LOS_APP_APPLICATIONS set LAA_FILENO=(Select LSO_BRANCH_CODE || '");
sBuffer.append(personalDTO.getProductId()).append("' || '").append(personalDTO.getApplicationID());
sBuffer.append("' from LOS_SEC_OFFICE where LSO_OFFICE_CODE_C=").append(personalDTO.getBranchId());
sBuffer.append(") where APP_ID_C ='").append(personalDTO.getApplicationID()).append("'");
logger.debug(sBuffer.toString());
return sBuffer.toString();
}