loadstammsparameter.java

关于彩信mms的程序,可以打包mms, 发送mms21840270MMS-PicCente

package mmspiccenter;

/**
 * <p>Title: </p>
 * <p>Description: </p>
 * <p>Copyright: Copyright (c) 2004</p>
 * <p>Company: hf</p>
 * @author unascribed
 * @version 1.0
 */
import java.util.*;
public class LoadStaMmsParameter {
    public DBConnection db = new DBConnection(/*Config.db_name,Config.db_host*/);
    public LoadStaMmsParameter() {
    }
    public void loadSta(){
        String sql = "select * from stn where TO_DAYS(done_time) <> TO_DAYS(now())";
//        String sql2 = "select * from weather_data_all";
//        Vector v2 = (Vector)db.execute(sql2) ;
//        System.out.println(v2);
        if(Config.sta_idV.size() >0){
            Config.sta_idV.removeAllElements();
        }
        Vector v = new Vector();
        v = (Vector)db.execute(sql);
        for(int i = 0;i<v.size() ;i++){
            Vector vv = new Vector();
            vv.addElement((String)((Vector)v.get(i)).get(0)) ;
            vv.addElement((String)((Vector)v.get(i)).get(1));
            Config.sta_idV .addElement(vv);
        }
        System.out.println("v:"+v);
    }
    public void loadMmsPara(){
        String sql = "select * from mms_parameter";
        if(Config.mmsParaV .size() >0){
            Config.mmsParaV .removeAllElements() ;
        }
        Vector v = new Vector();
        v = (Vector)db.execute(sql);
        try{
        for(int i = 0;i<v.size() ;i++){
            String id = (String)((Vector)v.get(i)).get(0);
            String mms_type = (String)((Vector)v.get(i)).get(1);
            String base_url = (String)((Vector)v.get(i)).get(2);
            String type_url = (String)((Vector)v.get(i)).get(3);
            String service_code = (String)((Vector)v.get(i)).get(4);
            String period = (String)((Vector)v.get(i)).get(5);
            String bg_url = (String)((Vector)v.get(i)).get(6);
            String title_url = (String)((Vector)v.get(i)).get(7);
            String title_x = (String)((Vector)v.get(i)).get(8);
            String title_y = (String)((Vector)v.get(i)).get(9);
            String w_url = (String)((Vector)v.get(i)).get(10);
            String w_x = (String)((Vector)v.get(i)).get(11);
            String w_y = (String)((Vector)v.get(i)).get(12);
            String t_url = (String)((Vector)v.get(i)).get(13);
            String t_x = (String)((Vector)v.get(i)).get(14);
            String t_y = (String)((Vector)v.get(i)).get(15);
            String xmltitle = (String)((Vector)v.get(i)).get(18);
            String www_url = (String)((Vector)v.get(i)).get(19);
            String hour = (String)((Vector)v.get(i)).get(20);
            String mms_type_code = (String)((Vector)v.get(i)).get(21);
            MmsParameter mmsParameter = new MmsParameter(id,mms_type,base_url,type_url,
                                                         service_code,period,bg_url,title_url,
                                                         title_x,title_y,w_url,w_x,w_y,t_url,
                                                         t_x,t_y,xmltitle,www_url,hour,mms_type_code);
            System.out.println(mmsParameter.base_url+"12345");
            Config.mmsParaV .addElement(mmsParameter);

        }
    }catch(Exception e){
        e.printStackTrace() ;
    }
        //System.out.println(Config.mmsParaV .size());
    }
    public static void main(String[] args) {
        LoadStaMmsParameter loadSta1 = new LoadStaMmsParameter();
        loadSta1.loadMmsPara() ;
    }
}