コード例 #1
0
  public List<Service> getServicesByPart(Part part, Vehicle vehicle) {
    Session session = HibernateUtil.createSessionFactory().openSession();
    Transaction tx = null;
    String hql = null;
    if (part != null) {
      hql =
          "from Service as service where vehicle_id="
              + vehicle.getVehicle_id()
              + " and part_id = "
              + part.getPart_id()
              + ")";
    } else {
      hql =
          "from Service as service where vehicle_id="
              + vehicle.getVehicle_id()
              + " and part_id = null)";
    }
    Query query = session.createQuery(hql);

    try {
      tx = session.beginTransaction();
      List<Service> services = (List<Service>) query.list();
      tx.commit();
      return services;
    } catch (HibernateException e) {
      if (tx != null) {
        tx.rollback();
      }
      System.out.println(e);
    } finally {
      HibernateUtil.close();
    }

    return null;
  }
コード例 #2
0
 public Service getService(int service_id) {
   Session session = HibernateUtil.createSessionFactory().openSession();
   try {
     Service service = (Service) session.get(Service.class, service_id);
     return service;
   } catch (HibernateException e) {
     System.out.println(e);
   } finally {
     HibernateUtil.close();
   }
   return null;
 }
コード例 #3
0
 public Service updateService(Service service) {
   Session session = HibernateUtil.createSessionFactory().openSession();
   Transaction tx = null;
   try {
     tx = session.beginTransaction();
     session.merge(service);
     tx.commit();
   } catch (HibernateException e) {
     if (tx != null) {
       tx.rollback();
     }
     System.out.println(e);
   } finally {
     HibernateUtil.close();
   }
   return service;
 }