Ejemplo n.º 1
0
  public static Cache insertCache(
      String url,
      String r_location,
      String r_lang,
      int r_date,
      String tid,
      String fid,
      Date cache_date,
      JsonObject response) {

    try {

      DataBaseConect.cargarDriver();
      DataBaseConect.conectarAlServidor("postgres", "postgres", "localhost", "alcine-dev");
      DataBaseConect.exeUpdate(
          "INSERT INTO \"CACHE\"(url, r_location, r_lang, r_date, tid, fid, cache_date, response) VALUES ('"
              + url
              + "', '"
              + r_location
              + "', '"
              + r_lang
              + "', "
              + r_date
              + ", '"
              + tid
              + "', '"
              + fid
              + "', '"
              + new java.sql.Timestamp((cache_date).getTime())
              + "', '"
              + response.toString()
              + "');");
      DataBaseConect.cerrarConexion();

    } catch (SQLException e) {
      e.printStackTrace();
    }

    return new Cache(url, r_location, r_lang, r_date, tid, fid, cache_date, response);
  }
Ejemplo n.º 2
0
  public static Cache updateCache(
      String url,
      String r_location,
      String r_lang,
      int r_date,
      String tid,
      String fid,
      Date cache_date,
      JsonObject response) {

    try {

      DataBaseConect.cargarDriver();
      DataBaseConect.conectarAlServidor("postgres", "postgres", "localhost", "alcine-dev");
      DataBaseConect.exeUpdate(
          "UPDATE \"CACHE\" SET  tid='"
              + tid
              + "', fid='"
              + fid
              + "', cache_date='"
              + new java.sql.Timestamp((cache_date).getTime())
              + "', response='"
              + response.toString()
              + "' WHERE url='"
              + url
              + "' AND r_location='"
              + r_location
              + "' AND r_lang='"
              + r_lang
              + "' AND r_date="
              + r_date
              + ";");
      DataBaseConect.cerrarConexion();

    } catch (SQLException e) {
      e.printStackTrace();
    }

    return new Cache(url, r_location, r_lang, r_date, tid, fid, cache_date, response);
  }