addservicepool.java

短信网关发送接受平台。

package orderapp;

/**
 * Title:
 * Description:将mobile_service表中的数据读入Config.servicePool中
 * Copyright:    Copyright (c) 2002
 * Company:
 * @author
 * @version 1.0
 */
import java.util.*;
import data.ConnectionPool;
import java.sql.*;
public class addServicePool {
       public ConnectionPool serviceData;
       public service Service;
       public ResultSet rs;
       public String sql;
       public log.Log log;
	public addServicePool() {
	       log=new log.Log();
	       System.out.println("Now is Load the Service......");
	       serviceData=new ConnectionPool();
	       sql="select * from mobile_service";
	       rs=serviceData.executeQuery(sql);
	       Config.servicePool.removeAllElements();
	       int i=0;
	       try{
			while(rs.next()){
				Service=null;
				Service =new service();

				Service .service_id=rs.getString("service_id");
				//System.out.println(Service .service_id);
				Service .service_type=rs.getString("service_type");
				//System.out.println(Service .service_type);
				Service .gateway=rs.getString("gateway");//???
				Service .registered_delivery = rs.getInt("registered_delivery");
				Service .src_terminal_id = rs.getString("src_terminal_id");
				Service .fee_user_type = rs.getInt("fee_user_type");
				Service .fee_type = rs.getInt("fee_type");
				Service .fee_code= rs.getString("fee_code");
				Service .agent_flag = rs.getInt("agent_flag");
				Service .given_value = rs.getString("given_value");
				//Config.servicePool.add(Service);

				Config.servicePool.add(i,Service );
				Service=null;
				i++;
			}
	       }
	       catch(Exception e){
			       e.printStackTrace();
	       }
	       String str;
	       //System.out.println(Config.servicePool.size()+"capacity");
	       Config.LogPool.push("the servicePool capacity is"+Config.servicePool.size());
/*
	       for(i=0;i<Config.servicePool.size();i++){
		       str=(String)((service)Config.servicePool.get(i)).service_id;
		       System.out.println(str);
	       }
*/

	}
}