public String prepSetStatus3(char status, String url) {
   Map<String, Object> params = new HashMap<String, Object>();
   params.put("url", url);
   String hql = "from Workload o where o.url= :url";
   Query query = workloaddao.createQuery(hql, params);
   List<Workload> workloadlist = (ArrayList<Workload>) query.list();
   for (Workload workload : workloadlist) {
     workload.setStatus((new Character(status)).toString());
     workloaddao.save(workload);
   }
   return "1";
 }
 public char prepGetStatus(String url) {
   Map<String, Object> params = new HashMap<String, Object>();
   params.put("url", url);
   String hql = "from Workload o where o.url= :url";
   Query query = workloaddao.createQuery(hql, params);
   List<Workload> workloadlist = (ArrayList<Workload>) query.list();
   if (workloadlist.size() == 0) return 'U';
   else {
     Workload wl = workloadlist.get(0);
     return wl.getStatus().charAt(0);
   }
 }