예제 #1
0
  public List lookupResourceComponentByParentResourceComponent(
      ResourcesComponents rc, Session session) {
    long t1;
    long t2;
    ResourcesComponents rcmps = null;
    ArrayList al = new ArrayList();
    Iterator it = null;
    t1 = System.currentTimeMillis();
    List res =
        session
            .getNamedQuery("mySqlQuery")
            .setLong("resourceComponentId", rc.getIdentifier())
            .list();
    t2 = System.currentTimeMillis();
    it = res.iterator();
    Object t[];
    while (it.hasNext()) {
      rcmps = new ResourcesComponents();
      t = (Object[]) it.next();
      rcmps.setTitle((String) t[0]);
      rcmps.setDateExpression((String) t[1]);
      rcmps.setIdentifier((Long) t[2]);
      rcmps.setHasChild((Boolean) t[3]);
      rcmps.setSequenceNumber((Integer) t[4]);
      al.add(rcmps);
    }

    return al;
  }
예제 #2
0
 public List lookupResourceComponentByParentResource(Resources r, Session session) {
   // Session session = SessionFactory.getInstance().openSession();
   long t1, t2;
   t1 = System.currentTimeMillis();
   Criteria criteria =
       session
           .createCriteria(ResourcesComponents.class)
           .addOrder(Order.asc("resourcesOrder"))
           //				.setProjection(Projections.projectionList()
           //						.add(Projections.property(ResourcesComponents.PROPERTYNAME_TITLE))
           //						.add(Projections.property(ResourcesComponents.PROPERTYNAME_SEQUENCE_NUMBER))
           //
           //	.add(Projections.property(ResourcesComponents.PROPERTYNAME_RESOURCES_COMPONENT_ID))
           //						.add(Projections.property(ResourcesComponents.PROPERTYNAME_DATE_EXPRESSION)))
           //				.setResultTransformer(new AliasToBeanResultTransformer(ResourcesComponents.class))
           .add(Expression.eq("resource", r));
   //		t2 = System.currentTimeMillis();
   //        System.out.println("query1 time = "+(t2-t1)+" milliseconds");
   List al = new ArrayList();
   al = criteria.list();
   // session.close();
   return al;
 }