String aQuery = "select o from Userrecord o where o.zip = '" + pZip + "' " ;
Query aQueryObject = manager.createQuery(aQuery);
DataTranslator aTranslator = new DataTranslator();
List<?> theUserDetails = aQueryObject.getResultList();
return aTranslator.translateToUserDTO(theUserDetails);
}
public boolean zipCodeExists(String zip){
String queryStirng = "select COUNT( z ) from Ziptable z where z.zip = :zip ";
Query query = manager.createQuery(queryStirng);