cleardaysubthread.java

WAP PUSH后台源码,WAP PUSH后台源码

package com.sxit.wap.threads;
import java.sql.*;
/********************************
 这个程序是用来清除包天的定制记录
 10分钟运行一次
 ******************************/

public class ClearDaySubThread extends Thread {
  private int index;
  private static int i = 0;
  public ClearDaySubThread () {
    index = i++;
  }
  public void run () {
    System.out.println("清除包天定制线程 :" +index);
    String sql = "";
    try {
      String curr = DateUtil.getDateSql(Database.dbType, DateUtil.getCurrTime());
      sql = "DELETE FROM WAP_USER_SUB WHERE END_DATE >= " + curr + " AND FEE_TYPE = 2";
      Database.updateBySql(sql);
      System.out.println(DateUtil.getCurrTime() + ">>>>>" + sql);
    } catch (Exception e) {
      e.printStackTrace();
    }
  }
  public static void main(String[] args) {
    ClearDaySubThread clearDaySubThread = new ClearDaySubThread();
    clearDaySubThread.start();
  }
}