getserviceidlist.java

短信定制软件

package smstimer;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: </p>
 * @author unascribed
 * @version 1.0
 */
import java.util.*;
public class GetServiceIdList extends Engine {
    public static DBConnection db =  null;//new DBConnection();;
    public GetServiceIdList(DBConnection d){
        super("GetServiceIdList");
        setDaemon(true);
        this.db = d;
    }
    public void run(){
        int hour = Utility.getHour();
        if(hour != 1){
            getServiceList();
        }
        while(true){
            if(hour == 1){//1点时重新读入service_id属性
                getServiceList();
            }
            System.out.println(Config.service_list.size() );
            try{
                sleep(1000*60*60);
            }catch(Exception e){
                System.out.println("Exception In GetServiceIdList.run() :"+e.toString() );
            }
        }
    }
    public void getServiceList(){
        String sql = "select * from sms_service_list ";
        Vector service = new Vector();
        service = (Vector)db.execute(sql);
        System.out.println(service);
        if(Config.service_list.size() >0){
            Config.service_list.removeAllElements() ;
        }
        for(int i = 0;i<service.size() ;i++){
            String service_id = (String)((Vector)service.get(i)).get(1);
            String service_code = (String)((Vector)service.get(i)).get(0);
            String fee_type = (String)((Vector)service.get(i)).get(2);
            String fee_code = (String)((Vector)service.get(i)).get(3);
            //Fee fee = new Fee(service_id,service_code,fee_type,fee_code);
            System.out.println("insert"+service_id+service_code+fee_type+fee_code);
            Vector v = new Vector();
            v.addElement(service_code) ;
            v.addElement(service_id) ;
            v.addElement(fee_type) ;
            v.addElement(fee_code) ;
            Config.service_list.addElement(v);
        }
        System.out.println("aa"+Config.service_list);
    }
    public static void main(String[] args) {
    }
}