updatewebindexconfig.java

电信的网厅的整站代码

package com.doone.fj1w.common;

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

public class UpdateWebIndexConfig {
    private DacClient _dac = null;
    private DataTable _dataTable = null;
    private int time = 1000;

    public UpdateWebIndexConfig() {
        try {
            _dac = new DacClient();
            FileLogger.getLogger().debug("UpdateWebIndexConfig数据库链接：" + _dac);
        } catch (Exception ex) {
            FileLogger.getLogger().debug("UpdateWebIndexConfig数据库链接出错：" +
                                         ex.getMessage());
        }

    }
    
    /**
     * 查找菜单，首页需要修改的菜单
     * @return
     */
    public DataTable getPurviewUpdateMenu(){
    	DataTable dt = null;
    	String Sql_insert_upload = "select t.* from tf_purview t where t.STATE='E' and t.uppurviewid =" +
    			" (select a.purviewid from tf_purview a where a.purviewcode = 'SLF') order by orderno";
        try {
        	dt = _dac.executeQuery(Sql_insert_upload);
        } catch (Exception ex) {
             FileLogger.getLogger().warn("getPurviewUpdateMenu error："+ex.getMessage());
        }
        return dt;
    }
    
    /**
     * 查找各个模块下所要更改图片的页面路径 
     * @param menucode
     * @param citycode
     * @return
     */
	public  DataTable getPurviewUpdateMenuContent(String configName) {
		try {
			if (configName == null)
				throw new NullPointerException("配置名称不能为空。");

			String sql = "select paravalue, paradesc,parastate,parasys,citycode from ts_configsub where upper(paraname)=? order by paravalue";
			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  DataTable getPurviewUpdateMenuContent(String configName,String citycode) {
		try {
			if (configName == null)
				throw new NullPointerException("配置名称不能为空。");

			String sql = "select paravalue, paradesc,parastate,parasys,citycode from ts_configsub where upper(paraname)=? and citycode=? order by paravalue";
			Object[] aParam = new Object[2];
			aParam[0] = configName.toUpperCase();
			aParam[1] = citycode;
			DacClient db = new DacClient();
			return db.executeQuery(sql, aParam);
		} catch (Exception ex) {
			FileLogger.getLogger().warn(ex);

			throw new RuntimeException(ex);
		}
	}
}