configqueryimpl.java

电信的网厅的整站代码

package com.doone.fj1w.fjmgr.order.list;

import java.sql.SQLException;
import java.util.HashMap;
import java.util.Map;

import com.doone.data.DacClient;
import com.doone.data.*;
import com.doone.fj1w.common.ConfigFactory;
import com.doone.fj1w.fjmgr.order.DAO;
import com.doone.util.FileLogger;
/**
 * <strong>
 *  提供对配制库的查询
 * </strong>
 * @author Administrator
 *
 */
public class ConfigQueryImpl extends DAO implements QueryListInterface {

    private static final long serialVersionUID = -341321324432L;
    
    static FileLogger _logger = new FileLogger();
    
    //查询地市
    private String citycode = "";
    //查询名称
    private String paraname = "";
    
    /*****************SQL Statement***********************/
    /**查询配制库中没有citycode的值*/
    private final String SQL_QUERY_CON 
       = "SELECT t.paradesc as OPTIONTEXT,t.paravalue as OPTIONVALUE" +
         " FROM ts_configsub t WHERE t.paraname=?";
    
    /**有citycode的值*/
    private final String SQL_QUERY_CON_CITYCODE
       = "SELECT t.paradesc as OPTIONTEXT,t.paravalue as OPTIONVALUE" +
         " FROM ts_configsub t WHERE t.paraname=?"+
         " and t.citycode=?";
    
    public ConfigQueryImpl() {
    }
    
    /*
     *  (non-Javadoc)
     * @param Map map 
     * @see com.doone.fj1w.common.taglib.list.QueryListInterface#getList()
     */
    public DataTable getList(Map map) throws RuntimeException {
      
        try{
            if(map == null)
                map = new HashMap();
            
            citycode = (String)map.get("CITYCODE");
            paraname = (String)map.get("PARAM");
            
            if(citycode != null && !citycode.equals("")){
              Object[] _object = new Object[]{this.paraname,this.citycode};  
              return _dac.executeQuery(this.SQL_QUERY_CON_CITYCODE,_object);
              
            }else{
              Object[] _object = new Object[]{this.paraname};  
              return _dac.executeQuery(this.SQL_QUERY_CON,_object);
            }
            
        }catch(SQLException sqlx){
            _logger.warn(sqlx.getMessage(),sqlx);
            throw new RuntimeException(sqlx);    
        }catch(RuntimeException rux){
            _logger.warn(rux.getMessage(),rux);
            throw rux;
        }
    }
    
    public static DataTable getConfigList(String configName) {
    	try {
    		if (configName == null)
    			throw new NullPointerException("配置名称,或地市不能为空。");
    		
    		String sql = "select paravalue, paradesc,parastate, parasys from ts_configsub where upper(paraname)=?";
    		Object[] aParam = new Object[1];
    		aParam[0] = configName.toUpperCase();
    		DacClient db = new DacClient();
    		return db.executeQuery(sql, aParam);
    	} catch (Exception ex) {
    		FileLogger.getLogger().warn(ex);
    		
    		throw new RuntimeException(ex);
    	}
    }
    
    public static DataRow getSingleConfigInfo(String configName,String value) {
    	try {
    		DataTable dt = ConfigFactory.getSysConfigList(configName);
    		DataRow dr = null;
    		for(int i=0;i<dt.getRows().getCount();i++){
    			if(value.equals(dt.getRow(i).getString("paravalue"))){
    				dr = dt.getRow(i);
    			}
    		}
    		return dr;
    	} catch (Exception ex) {
    		FileLogger.getLogger().warn(ex);
    		
    		throw new RuntimeException(ex);
    	}
    }
    
    public static DataRow getSingleConfigInfo(String configName,String value,String cityCode) {
    	try {
    		DataTable dt = ConfigFactory.getSysConfigList(configName);
    		DataRow dr = null;
    		for(int i=0;i<dt.getRows().getCount();i++){
    			if(value.equals(dt.getRow(i).getString("paravalue")) &&
    			   cityCode.equals(dt.getRow(i).getString("cityCode"))){
    				dr = dt.getRow(i);
    			}
    		}
    		return dr;
    	} catch (Exception ex) {
    		FileLogger.getLogger().warn(ex);
    		
    		throw new RuntimeException(ex);
    	}
    }
    
    /**
     * <code>
     *   本地库字段意思
     *   没有返回空字符.
     * </code>
     * @param configName
     * @param value
     * @param cityCode
     * 
     * @author predan
     * @see    ConfigFactory#getSysConfigList(String)
     * @see    DataTable#getRows()#getRow(int)
     * @serial jdk 1.4.2_08
     * @return
     */
    public static String getSingleConfigInfoString(String configName,
                                                   String value,
                                                   String cityCode) {
            DataTable dt = null;
            try{
              dt =ConfigFactory.getSysConfigList(configName);
            }catch(Exception ex){
            	return "";
            }
            
            if(dt == null || dt.getRows().getCount() == 0) return "";//
            
            int i = dt.getRows().getCount();
            for(;
                 -- i >= 0
                && !(value.equals(dt.getRow(i).getString("paravalue"))
                     && cityCode.equals(dt.getRow(i).getString("cityCode")));
                );
            
            if(i >= 0)
               return dt.getRow(i).getString("paradesc");
            
           return "";
    }

}