public List<ZipDTO> findZipForState(String pState){
String aQuery = "select o from Ziptable o where o.statename = '" + pState + "' " ;
Query aQueryObject = manager.createQuery(aQuery);
DataTranslator aTranslator = new DataTranslator();
List<?> theZipDetails = aQueryObject.getResultList();
return aTranslator.translateToZipDTO(theZipDetails);
}
public List<UserDTO> findUserForZip(int pZip) {
String aQuery = "select o from Userrecord o where o.zip " ;