associatormanagefacade.java

STRUTS数据库项目开发宝典

   /**
    * Obtains the total number of sp objects in the database.
    *
    * @return an integer value.
    */
   public int getSpListSize() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "select count(*) from SpBean";
         // 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 SplbIf the data object
    */
   public org.helpsoft.entity.splb.SplbIf getSplb(java.lang.String id) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
      // Get a hibernate session.
      SplbBean bean = (SplbBean) hibernateHelper.load(SplbBean.class, id);
      return bean;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }

   /**
    * Returns a collection of all splb instances.
    *
    * @return a collection of SplbIf objects.
    */
   public Collection getSplbList() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
      String queryString = "from SplbBean e";
      // Add a an order by on all primary keys to assure reproducable results.
      String orderByPart = "";
      orderByPart += " order by e.splbbm";
      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 splb 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 splb instances will simply return an empty set.
    * @param endIndex the end index within the result set (<code>getSplbListSize()</code> = last record),
    * any values greater than or equal to the total number of splb instances will cause
    * the full set to be returned.
    * @return a collection of SplbIf objects, of size <code>(endIndex - startIndex)</code>.
    */
   public Collection getSplbList(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 SplbBean e";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.splbbm";
         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 splb objects in the database.
    *
    * @return an integer value.
    */
   public int getSplbListSize() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "select count(*) from SplbBean";
         // 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 CzkIf the data object
    */
   public org.helpsoft.entity.czk.CzkIf getCzk(java.lang.String id) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
      // Get a hibernate session.
      CzkBean bean = (CzkBean) hibernateHelper.load(CzkBean.class, id);
      return bean;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }

   /**
    * Returns a collection of all czk instances.
    *
    * @return a collection of CzkIf objects.
    */
   public Collection getCzkList() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
      String queryString = "from CzkBean e";
      // Add a an order by on all primary keys to assure reproducable results.
      String orderByPart = "";
      orderByPart += " order by e.hykbm";
      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 czk 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 czk instances will simply return an empty set.
    * @param endIndex the end index within the result set (<code>getCzkListSize()</code> = last record),
    * any values greater than or equal to the total number of czk instances will cause
    * the full set to be returned.
    * @return a collection of CzkIf objects, of size <code>(endIndex - startIndex)</code>.
    */
   public Collection getCzkList(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 CzkBean 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 czk objects in the database.
    *
    * @return an integer value.
    */
   public int getCzkListSize() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "select count(*) from CzkBean";
         // 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 TxIf the data object
    */
   public org.helpsoft.entity.tx.TxIf getTx(java.lang.String id) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
      // Get a hibernate session.
      TxBean bean = (TxBean) hibernateHelper.load(TxBean.class, id);
      return bean;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }

   /**
    * Returns a collection of all tx instances.
    *
    * @return a collection of TxIf objects.
    */
   public Collection getTxList() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
      String queryString = "from TxBean e";
      // Add a an order by on all primary keys to assure reproducable results.
      String orderByPart = "";
      orderByPart += " order by e.txbh";
      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 tx 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 tx instances will simply return an empty set.
    * @param endIndex the end index within the result set (<code>getTxListSize()</code> = last record),
    * any values greater than or equal to the total number of tx instances will cause
    * the full set to be returned.
    * @return a collection of TxIf objects, of size <code>(endIndex - startIndex)</code>.
    */
   public Collection getTxList(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 TxBean e";
         // Add a an order by on all primary keys to assure reproducable results.
         String orderByPart = "";
         orderByPart += " order by e.txbh";
         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 tx objects in the database.
    *
    * @return an integer value.
    */
   public int getTxListSize() throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
         String queryString = "select count(*) from TxBean";
         // 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 ZkkIf the data object
    */
   public org.helpsoft.entity.zkk.ZkkIf getZkk(java.lang.String id) throws GenericBusinessException {
      org.helpsoft.HibernateQueryHelper hibernateHelper = new org.helpsoft.HibernateQueryHelper();   
      try {
      // Get a hibernate session.
      ZkkBean bean = (ZkkBean) hibernateHelper.load(ZkkBean.class, id);
      return bean;
      } finally {
         if (hibernateHelper != null) {
         	hibernateHelper.close();
         }
      }
   }

   /**
    * Returns a collection of all zkk instances.
    *
    * @return a collection of ZkkIf objects.
    */
   public Collection getZkkList() throws GenericBusinessException {
      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";