コード例 #1
0
ファイル: Dailyinfo.java プロジェクト: chilinh12003/MyEclipse
  private int insertData(
      String user_id,
      String service_id,
      String command_code,
      String mlist,
      MsgObject msgObject,
      String mtfree,
      int msgtype,
      String Service_ss_id,
      long lduration) {
    int ireturn = 1;
    Connection connection = null;
    DBPool dbpool = new DBPool();
    // long lmilisec = System.currentTimeMillis();
    String sqlInsert =
        "Insert into "
            + mlist
            + "(user_id, service_id, date,command_code,request_id, message_type,mobile_operator,mt_free,duration) values ('"
            + user_id
            + "','"
            + service_id
            + "','"
            + new SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format(new Date())
            + "','"
            + Service_ss_id
            + "','"
            + msgObject.getLongRequestid()
            + "','"
            + msgtype
            + "','"
            + msgObject.getMobileoperator()
            + "',"
            + mtfree
            + ","
            + lduration
            + ")";

    try {

      connection = dbpool.getConnectionGateway();

      if (DBUtil.executeSQL(connection, sqlInsert) < 0) {
        Util.logger.error(
            this.getClass().getName()
                + ""
                + ": uppdate Statement: Insert  "
                + mlist
                + " Failed:"
                + sqlInsert);
        ireturn = -1;
      }
    } catch (Exception ex) {
      Util.logger.error(this.getClass().getName() + ":Insert  " + mlist + " Failed");
      ireturn = -1;
      Util.logger.printStackTrace(ex);
    } finally {
      dbpool.cleanup(connection);
    }
    return ireturn;
  }
コード例 #2
0
  @Override
  protected Collection getMessages(
      Properties prop, MsgObject msgObject, Keyword keyword, Hashtable services) throws Exception {
    // System.out.println(" ========================== GO HERE ============================");

    msgObject.setSubCP(0); // 0: VMS ; other: ICOM
    msgObject.setPkgService(true);

    return serviceMng.UnRegisterHandle(msgObject, keyword);
  }
コード例 #3
0
ファイル: Dailyinfo.java プロジェクト: chilinh12003/MyEclipse
  // Gui content theo cach nao
  // Neu content ngan thi phai split ra
  private static int sendMT(String type, MsgObject msgObject, String sclassname) {

    Connection connection = null;
    PreparedStatement statement = null;
    String sqlString = null;
    if ("".equalsIgnoreCase(msgObject.getUsertext().trim()) || msgObject.getUsertext() == null) {
      // Truong hop gui ban tin loi
      Util.logger.error(
          sclassname
              + "@sendMT@userid="
              + msgObject.getUserid()
              + "@serviceid="
              + msgObject.getServiceid()
              + "@requestid="
              + msgObject.getRequestid().toString()
              + "@message is null - LOST MESSAGE");
      return 1;
    }

    DBPool dbpool = new DBPool();

    Util.logger.info(
        sclassname
            + "@sendMT@userid="
            + msgObject.getUserid()
            + "@serviceid="
            + msgObject.getServiceid()
            + "@usertext="
            + msgObject.getUsertext()
            + "@messagetype="
            + msgObject.getMsgtype()
            + "@requestid="
            + msgObject.getRequestid().toString());
    try {
      connection = dbpool.getConnectionGateway();
      if (connection == null) {
        Util.logger.crisis(
            sclassname
                + "@sendMT: Error connection == null"
                + msgObject.getUserid()
                + "@TO"
                + msgObject.getServiceid()
                + "@"
                + msgObject.getUsertext()
                + "@requestid="
                + msgObject.getRequestid().toString());
        return -1;
      }

      // USER_ID, SERVICE_ID, MOBILE_OPERATOR, COMMAND_CODE, CONTENT_TYPE,
      // INFO, MESSAGE_TYPE, REQUEST_ID
      sqlString =
          "INSERT INTO "
              + Constants.tblMTQueue
              + "( USER_ID, SERVICE_ID, MOBILE_OPERATOR, COMMAND_CODE, CONTENT_TYPE, INFO,  MESSAGE_TYPE, REQUEST_ID) VALUES (?, ?, ?, ?, ?, ?, ?, ?)";

      // USER_ID, SERVICE_ID, MOBILE_OPERATOR, COMMAND_CODE,
      // CONTENT_TYPE, INFO, MESSAGE_TYPE, REQUEST_ID

      if ("1".equalsIgnoreCase(type)) {

        // Truoc khi gui phai split
        String[] content = msgObject.getUsertext().split("###");

        for (int i = 0; i < content.length; i++) {
          if (!"".equalsIgnoreCase(content[i])) {
            statement = connection.prepareStatement(sqlString);
            statement.setString(1, msgObject.getUserid());
            statement.setString(2, msgObject.getServiceid());
            statement.setString(3, msgObject.getMobileoperator());
            statement.setString(4, msgObject.getKeyword());
            statement.setInt(5, msgObject.getContenttype());
            statement.setString(6, content[i]);
            if (i == 0) {
              statement.setInt(7, 1);
            } else {
              statement.setInt(7, 0);
            }
            statement.setBigDecimal(8, msgObject.getRequestid());

            if (statement.executeUpdate() != 1) {
              Util.logger.crisis(
                  sclassname
                      + "@sendMT: Error@userid="
                      + msgObject.getUserid()
                      + "@serviceid="
                      + msgObject.getServiceid()
                      + "@usertext="
                      + msgObject.getUsertext()
                      + "@messagetype="
                      + msgObject.getMsgtype()
                      + "@requestid="
                      + msgObject.getRequestid().toString());

              return -1;
            }
          }
        }
        return 1;
      } else {
        statement = connection.prepareStatement(sqlString);
        statement.setString(1, msgObject.getUserid());
        statement.setString(2, msgObject.getServiceid());
        statement.setString(3, msgObject.getMobileoperator());
        statement.setString(4, msgObject.getKeyword());
        statement.setInt(5, msgObject.getContenttype());
        statement.setString(6, msgObject.getUsertext());
        statement.setInt(7, msgObject.getMsgtype());
        statement.setBigDecimal(8, msgObject.getRequestid());

        if (statement.executeUpdate() != 1) {
          Util.logger.crisis(
              sclassname
                  + "@sendMT: Error@userid="
                  + msgObject.getUserid()
                  + "@serviceid="
                  + msgObject.getServiceid()
                  + "@usertext="
                  + msgObject.getUsertext()
                  + "@messagetype="
                  + msgObject.getMsgtype()
                  + "@requestid="
                  + msgObject.getRequestid().toString());

          return -1;
        }
        return 1;
      }
    } catch (SQLException e) {
      Util.logger.crisis(
          sclassname
              + "@sendMT: Error:@userid="
              + msgObject.getUserid()
              + "@serviceid="
              + msgObject.getServiceid()
              + "@usertext="
              + msgObject.getUsertext()
              + "@messagetype="
              + msgObject.getMsgtype()
              + "@requestid="
              + msgObject.getRequestid().toString()
              + "@"
              + e.toString());

      Util.logger.printStackTrace(e);

      return -1;
    } catch (Exception e) {
      Util.logger.crisis(
          sclassname
              + "@sendMT: Error:@userid="
              + msgObject.getUserid()
              + "@serviceid="
              + msgObject.getServiceid()
              + "@usertext="
              + msgObject.getUsertext()
              + "@messagetype="
              + msgObject.getMsgtype()
              + "@requestid="
              + msgObject.getRequestid().toString()
              + "@"
              + e.toString());
      Util.logger.printStackTrace(e);
      return -1;
    } finally {
      dbpool.cleanup(statement);
      dbpool.cleanup(connection);
    }
  }
コード例 #4
0
ファイル: Dailyinfo.java プロジェクト: chilinh12003/MyEclipse
  protected Collection getMessages(
      Properties prop, MsgObject msgObject, Keyword keyword, Hashtable services) throws Exception {
    try {

      int msg1mt = Integer.parseInt(Constants.MT_PUSH);
      int msg2mt = Integer.parseInt(Constants.MT_PUSH);

      if (keyword.getService_type() == Constants.PACKAGE_SERVICE) {
        msg1mt = Integer.parseInt(Constants.MT_CHARGING);
        msg2mt = Integer.parseInt(Constants.MT_PUSH);

      } else if (keyword.getService_type() == Constants.DAILY_SERVICE) {
        msg2mt = Integer.parseInt(Constants.MT_CHARGING);
        msg1mt = Integer.parseInt(Constants.MT_NOCHARGE);
      }
      HashMap _option = new HashMap();

      String MLIST = "mlist";

      String options = keyword.getOptions();
      _option = getParametersAsString(options);
      // System.out.println("option:" + options);
      // MLIST = ((String) _option.get("mlist"));
      MLIST = getStringfromHashMap(_option, "mlist", "mlist_stk");
      //

      // infoid=GV&type=0&pool=content&index=1&typedb=2
      String infoid = getStringfromHashMap(_option, "infoid", "0");
      String stype = getStringfromHashMap(_option, "type", "0");
      String poolname = getStringfromHashMap(_option, "pool", "content");
      String indexsubcode = getStringfromHashMap(_option, "index", "1");

      // Loai du lieu can lay
      // 1: ngan can split
      // 2: dai
      // 3: tieng viet
      String typedb = getStringfromHashMap(_option, "typedb", "1");
      // textbasetype: kieu dich vu textbase
      // 0: textbase tra ngau nhien hang ngay
      // 1: textbase tra theo thu tu hang ngay
      // 2: text base tra theo ngay
      // 3: xo so
      // 4: soi cau
      // 5: chung khoan

      // subcodetype
      // 0: binh thuong
      // 1: date
      boolean firstmo = false;
      String lastcode = "0";
      int mtcount = 0;
      String id = "0";

      String strResult = null;

      // textbasetype: kieu dich vu textbase
      // 0: textbase tra ngau nhien hang ngay
      // 1: textbase tra theo thu tu hang ngay
      // 2: text base tra theo ngay
      // 3: xo so

      // strResult = getContent2(infoid);
      // 01/04/2009
      String currDate = new SimpleDateFormat("dd/MM/yyyy").format(new Date());

      String usertext = msgObject.getUsertext();
      usertext = replaceAllWhiteWithOne(usertext);
      String[] sTokens = usertext.split(" ");
      int isub1 = Integer.parseInt(indexsubcode);
      // String ssub1 = "";
      try {
        currDate = sTokens[isub1];
      } catch (Exception e) {
        // ssub1 = "";
        long milliSecond = System.currentTimeMillis();
        java.util.Calendar calendar = java.util.Calendar.getInstance();
        if (calendar.get(calendar.HOUR_OF_DAY) < 7) {
          currDate = Timestamp2DDMMYYYY(new Timestamp(milliSecond - 24 * 60 * 60 * 1000));
        }
      } finally {

      }

      Util.logger.info("Ngay gio: " + currDate);

      int msgtype = 1;
      if (currDate.length() != 10) {
        strResult =
            "Sai dinh dang ngay thang. Nhap day du thong tin theo dang DD/MM/YYYY. Ho tro 199";
        msgtype = 0;
      }

      strResult = getContent2(poolname, typedb, infoid, currDate);

      if ((strResult == null) || "".equalsIgnoreCase(strResult)) {

        strResult =
            "Thong tin ngay "
                + currDate
                + " chua duoc cap nhat, ban hay tra cuu voi ngay khac. DTHT: 199";
        msgtype = 0;
      }

      MsgObject msgObj =
          new MsgObject(
              1,
              msgObject.getServiceid(),
              msgObject.getUserid(),
              msgObject.getKeyword(),
              strResult,
              msgObject.getRequestid(),
              DateProc.createTimestamp(),
              msgObject.getMobileoperator(),
              msgtype,
              0);

      sendMT(typedb, msgObj, CLASSNAME);

    } catch (Exception e) {
      Util.logger.printStackTrace(e);
    }

    return null;
  }
コード例 #5
0
ファイル: Dailyinfo.java プロジェクト: chilinh12003/MyEclipse
  public static String getContent5(MsgObject msgObject) {
    Connection connection = null;
    PreparedStatement statement = null;
    String sqlString = null;
    if ("".equalsIgnoreCase(msgObject.getUsertext().trim()) || msgObject.getUsertext() == null) {
      // Truong hop gui ban tin loi
      Util.logger.error(
          "getContent5@userid="
              + msgObject.getUserid()
              + "@serviceid="
              + msgObject.getServiceid()
              + "@requestid="
              + msgObject.getRequestid().toString()
              + "@message is null - LOST MESSAGE");
      return null;
    }

    DBPool dbpool = new DBPool();

    Util.logger.info(
        "getContent5@userid="
            + msgObject.getUserid()
            + "@serviceid="
            + msgObject.getServiceid()
            + "@usertext="
            + msgObject.getUsertext()
            + "@messagetype="
            + msgObject.getMsgtype()
            + "@requestid="
            + msgObject.getRequestid().toString());
    try {
      connection = dbpool.getConnection("smscnt");
      if (connection == null) {
        Util.logger.crisis(
            "getContent5: Error connection == null"
                + msgObject.getUserid()
                + "@TO"
                + msgObject.getServiceid()
                + "@"
                + msgObject.getUsertext()
                + "@requestid="
                + msgObject.getRequestid().toString());
        return null;
      }

      // USER_ID, SERVICE_ID, MOBILE_OPERATOR, COMMAND_CODE, CONTENT_TYPE,
      // INFO, MESSAGE_TYPE, REQUEST_ID
      sqlString =
          "INSERT INTO mo_queue( USER_ID, SERVICE_ID, MOBILE_OPERATOR, COMMAND_CODE, INFO,   REQUEST_ID) VALUES (?, ?, ?, ?, ?, ?)";

      // USER_ID, SERVICE_ID, MOBILE_OPERATOR, COMMAND_CODE,
      // CONTENT_TYPE, INFO, MESSAGE_TYPE, REQUEST_ID
      statement = connection.prepareStatement(sqlString);
      statement.setString(1, msgObject.getUserid());
      statement.setString(2, msgObject.getServiceid());
      statement.setString(3, msgObject.getMobileoperator());
      statement.setString(4, msgObject.getKeyword());
      statement.setString(5, msgObject.getUsertext());
      statement.setBigDecimal(6, msgObject.getRequestid());

      if (statement.executeUpdate() != 1) {
        Util.logger.crisis(
            "getContent5: Error@userid="
                + msgObject.getUserid()
                + "@serviceid="
                + msgObject.getServiceid()
                + "@usertext="
                + msgObject.getUsertext()
                + "@messagetype="
                + msgObject.getMsgtype()
                + "@requestid="
                + msgObject.getRequestid().toString());
        return null;
      }
      return null;
    } catch (SQLException e) {
      Util.logger.crisis(
          "getContent5: Error:@userid="
              + msgObject.getUserid()
              + "@serviceid="
              + msgObject.getServiceid()
              + "@usertext="
              + msgObject.getUsertext()
              + "@messagetype="
              + msgObject.getMsgtype()
              + "@requestid="
              + msgObject.getRequestid().toString()
              + "@"
              + e.toString());
      return null;
    } catch (Exception e) {
      Util.logger.crisis(
          "getContent5: Error:@userid="
              + msgObject.getUserid()
              + "@serviceid="
              + msgObject.getServiceid()
              + "@usertext="
              + msgObject.getUsertext()
              + "@messagetype="
              + msgObject.getMsgtype()
              + "@requestid="
              + msgObject.getRequestid().toString()
              + "@"
              + e.toString());
      return null;
    } finally {
      dbpool.cleanup(statement);
      dbpool.cleanup(connection);
    }
  }