productbean.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.sysmgr;


import com.doone.data.DacClient;
import com.doone.data.DataRow;
import com.doone.data.DataTable;
import com.doone.util.FileLogger;

public class ProductBean  {
  DataRow repositoryInfo;
  private DacClient _dbClient;

  public ProductBean() {
  }
  
  /**
   * 找出所有程控产品的顶级产品
   * @param dbClient
   * @return
  */
  public DataTable getAllProductByCity(DacClient dbClient) {
        try {
            StringBuffer sql = new StringBuffer();
            sql.append("select ");
            sql.append("PRODUCTID, ");
            sql.append("CITYCODE, ");
            sql.append("PRODUCTNAME, ");
            sql.append("STATE ");
            sql.append(" from ");
            sql.append("Td_Product");
            sql.append(" where upproductid=0");      
            DataTable dt = dbClient.executeQuery(sql.toString());
            return dt;
          }
          catch (Exception ex) {
        	  FileLogger.getLogger().warn(ex);
              ex.printStackTrace();
              throw new RuntimeException(ex);
          }
  }
  
  public DataTable getProductById(DacClient dbClient,String sProductId) {
      try {
          StringBuffer sql = new StringBuffer();
          sql.append("select ");
          sql.append("PRODUCTID, ");
          sql.append("CITYCODE, ");
          sql.append("PRODUCTNAME, ");
          sql.append("STATE ");
          sql.append(" from ");
          sql.append("Td_Product");
          sql.append(" where PRODUCTID=?");
          Object[] aParam = new Object[1];
          aParam[0] = sProductId;
          DataTable dt = dbClient.executeQuery(sql.toString(),aParam);
          return dt;
        }
        catch (Exception ex) {
        	FileLogger.getLogger().warn(ex);
            ex.printStackTrace();
            throw new RuntimeException(ex);
        }
  }


}