Esempio n. 1
0
  /**
   * Tai function cho Dababase
   *
   * @param _app
   * @param _queryser
   */
  public void queryToFunctions(AppCommon _app, QueryServer _queryser) {
    Date date;
    DateFormat dateFormat;

    // Bat buoc
    this.set_fileurl(_app.get_scriptUrl() + this.get_fileurl()); // Lay duong dan he thong cau hinh
    this.readScript(); // doc file
    this.set_define(_app.get_define());
    this.setquery(); // Set lai cau script lay

    dateFormat = new SimpleDateFormat("yyyyMMdd_HHmmss");
    date = new Date();
    this.set_startDate(dateFormat.format(date));
    CommandQuery.commandFunctions(_queryser.get_conn(), this.get_exquery());
    date = new Date();
    this.set_endDate(dateFormat.format(date));

    logger.info(
        "S["
            + this.get_startDate()
            + "], E["
            + this.get_endDate()
            + "]. Execute script successful with name: "
            + this.get_querynm());
  }