associatormanagefacade.java

STRUTS数据库项目开发宝典

      queryString += orderByPart;
      Query query = hibernateHelper.createQuery(queryString);
      List list = hibernateHelper.list(query);
      return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }

   /**
    * Returns a subset of all zkk instances.
    *
    * @param startIndex the start index within the result set (1 = first record);
    * any zero/negative values are regarded as 1, and any values greater than or equal to
    * the total number of zkk instances will simply return an empty set.
    * @param endIndex the end index within the result set (<code>getZkkListSize()</code> = last record),
    * any values greater than or equal to the total number of zkk instances will cause
    * the full set to be returned.
    * @return a collection of ZkkIf objects, of size <code>(endIndex - startIndex)</code>.
    */
   public Collection getZkkList(int startIndex, int endIndex) throws GenericBusinessException {
      if (startIndex < 1) {
         startIndex = 1;
      }
      if ( (endIndex - startIndex) < 0) {
         // Just return an empty list.
         return new ArrayList();
      }
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "from ZkkBean e";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.hykbm";
         queryString += orderByPart;
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         query.setFirstResult(startIndex - 1);
         query.setMaxResults(endIndex - startIndex + 1);
         List list = hibernateHelper.list(query);
         return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }

   /**
    * Obtains the total number of zkk objects in the database.
    *
    * @return an integer value.
    */
   public int getZkkListSize() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "select count(*) from ZkkBean";
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         List list = hibernateHelper.list(query);
         Integer countResult = (Integer) list.get(0);
         return countResult.intValue();
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }
   /**
    * Retrieves a data object from the database by its primary key.
    *
    * @param id the unique reference
    * @return XfmxIf the data object
    */
   public org.helpsoft.entity.xfmx.XfmxIf getXfmx(java.lang.String id) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
      // Get a hibernate session.
      XfmxBean bean = (XfmxBean) hibernateHelper.load(XfmxBean.class, id);
      return bean;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }

   /**
    * Returns a collection of all xfmx instances.
    *
    * @return a collection of XfmxIf objects.
    */
   public Collection getXfmxList() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
      String queryString = "from XfmxBean e";
      // Add a an order by on all primary keys to assure reproducable results.
      String orderByPart = "";
      orderByPart += " order by e.xfbm";
      queryString += orderByPart;
      Query query = hibernateHelper.createQuery(queryString);
      List list = hibernateHelper.list(query);
      return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }

   /**
    * Returns a subset of all xfmx instances.
    *
    * @param startIndex the start index within the result set (1 = first record);
    * any zero/negative values are regarded as 1, and any values greater than or equal to
    * the total number of xfmx instances will simply return an empty set.
    * @param endIndex the end index within the result set (<code>getXfmxListSize()</code> = last record),
    * any values greater than or equal to the total number of xfmx instances will cause
    * the full set to be returned.
    * @return a collection of XfmxIf objects, of size <code>(endIndex - startIndex)</code>.
    */
   public Collection getXfmxList(int startIndex, int endIndex) throws GenericBusinessException {
      if (startIndex < 1) {
         startIndex = 1;
      }
      if ( (endIndex - startIndex) < 0) {
         // Just return an empty list.
         return new ArrayList();
      }
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "from XfmxBean e";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.xfbm";
         queryString += orderByPart;
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         query.setFirstResult(startIndex - 1);
         query.setMaxResults(endIndex - startIndex + 1);
         List list = hibernateHelper.list(query);
         return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }

   /**
    * Obtains the total number of xfmx objects in the database.
    *
    * @return an integer value.
    */
   public int getXfmxListSize() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "select count(*) from XfmxBean";
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         List list = hibernateHelper.list(query);
         Integer countResult = (Integer) list.get(0);
         return countResult.intValue();
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }


    /**
     *
     * Retrieves a list of data object for the specified hykh field.
     *
     * @param hykh the field
     * @return Collection of HyIf data objects, empty list in case no results were found.
     */
    public java.util.Collection findHyByHykh(java.lang.String hykh) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "from HyBean e where e.hykh = :hykh ";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.hykh";
         queryString += orderByPart;
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         hibernateHelper.setQueryParameter(query, "hykh", hykh);
         List list = hibernateHelper.list(query);
         return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
    }

    /**
     *
     * Retrieves a list of data object for the specified hyxm field.
     *
     * @param hyxm the field
     * @return Collection of HyIf data objects, empty list in case no results were found.
     */
    public java.util.Collection findHyByHyxm(java.lang.String hyxm) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "from HyBean e where e.hyxm = :hyxm ";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.hykh";
         queryString += orderByPart;
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         hibernateHelper.setQueryParameter(query, "hyxm", hyxm);
         List list = hibernateHelper.list(query);
         return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
    }

    /**
     *
     * Retrieves a list of data object for the specified kdjb field.
     *
     * @param kdjb the field
     * @return Collection of HyIf data objects, empty list in case no results were found.
     */
    public java.util.Collection findHyByKdjb(java.lang.String kdjb) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "from HyBean e where e.kdjb = :kdjb ";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.hykh";
         queryString += orderByPart;
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         hibernateHelper.setQueryParameter(query, "kdjb", kdjb);
         List list = hibernateHelper.list(query);
         return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
    }

    /**
     *
     * Retrieves a list of data object for the specified dqzt field.
     *
     * @param dqzt the field
     * @return Collection of HyIf data objects, empty list in case no results were found.
     */
    public java.util.Collection findHyByDqzt(java.lang.String dqzt) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "from HyBean e where e.dqzt = :dqzt ";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.hykh";
         queryString += orderByPart;
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         hibernateHelper.setQueryParameter(query, "dqzt", dqzt);
         List list = hibernateHelper.list(query);
         return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
    }

    /**
     *
     * Retrieves a list of data object for the specified hyjf field.
     *
     * @param hyjf the field
     * @return Collection of HyIf data objects, empty list in case no results were found.
     */
    public java.util.Collection findHyByHyjf(java.lang.String hyjf) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "from HyBean e where e.hyjf = :hyjf ";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.hykh";
         queryString += orderByPart;
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         hibernateHelper.setQueryParameter(query, "hyjf", hyjf);
         List list = hibernateHelper.list(query);
         return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
    }

    /**
     *
     * Retrieves a list of data object for the specified bz field.
     *
     * @param bz the field
     * @return Collection of HyIf data objects, empty list in case no results were found.
     */
    public java.util.Collection findHyByBz(java.lang.String bz) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "from HyBean e where e.bz = :bz ";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.hykh";
         queryString += orderByPart;
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         hibernateHelper.setQueryParameter(query, "bz", bz);
         List list = hibernateHelper.list(query);
         return list;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
    }

    /**
     *
     * Retrieves a list of data object for the specified hyxb field.
     *
     * @param hyxb the field
     * @return Collection of HyIf data objects, empty list in case no results were found.
     */
    public java.util.Collection findHyByHyxb(java.lang.String hyxb) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "from HyBean e where e.hyxb = :hyxb ";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.hykh";
         queryString += orderByPart;
         // Get a hibernate session.
         Query query = hibernateHelper.createQuery(queryString);
         hibernateHelper.setQueryParameter(query, "hyxb", hyxb);
         List list = hibernateHelper.list(query);
         return list