sendalert.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 SendAlert extends Engine {
     private DBConnection db = null;
    public SendAlert(DBConnection d) {
        super("SendAlert");
        setDaemon(true);
        this.db = d;
    }
    public void run(){
        while(true){
            if(Config.SubmitAlertV .getSize() > 0){
                SubmitPackageAlert alert = (SubmitPackageAlert)Config.SubmitAlertV.pop();
                insert(alert);
            }
            sleep(1000);
        }
    }
    public boolean insert(SubmitPackageAlert submitPackage){
         boolean insertOk = false;
         String sql = "insert sms_submit (service_id,fee_user_type,fee_terminal_id,"+
                      "msg_fmt,msg_src,fee_type,fee_code,src_terminal_id,dest_terminal_id,"+
                      "msg_content,create_time)values('"+submitPackage.serviced_id +"',"+submitPackage.fee_user_type +
                      ",'"+submitPackage.fee_terminal_id+"',"+submitPackage.msg_fmt+",'"+Config.sp_id +"','"+
                      submitPackage.fee_type+"','"+submitPackage.fee_code +"','"+submitPackage.src_terminal_id +
                      "','"+submitPackage.dest_terminal_id+"','"+submitPackage.msg_content+"','"+Utility.getDateString()+"')";//submitPackage.msg_content
         System.out.println(sql);
         int i = Integer.parseInt(String.valueOf(db.executeUpdate(sql)));
         if(i == 1){
             insertOk = true;
         }
         return insertOk;
    }
    public static void main(String[] args) {
        //SendAlert sendAlert1 = new SendAlert();
    }
}