Пример #1
0
  public int get_pmi_size(int prev) throws SQLException {
    String time = SimpleTime.getPrevDay(prev);
    ResultSet rs = db.Query("select count(*) from pmi_keyword where date=" + time);
    if (!rs.next()) return 0;

    return rs.getInt(1);
  }
Пример #2
0
  public String[] get_pmi(int prev) throws SQLException {

    String time = SimpleTime.getPrevDay(prev);
    ResultSet rs = db.Query("select count(*) from pmi_keyword where date=" + time);
    rs.next();
    String[] ret = new String[rs.getInt(1)];

    rs = db.Query("select * from pmi_keyword where date=" + time + " order by pmi desc");
    int i = 0;
    while (rs.next()) {
      ret[i] = rs.getString("word");
      i++;
    }
    return ret;
  }
Пример #3
0
  public String[] get_pmi_relate(int prev, String word) throws SQLException {
    String time = SimpleTime.getPrevDay(prev);

    ResultSet rs =
        db.Query("select * from pmi_keyword where date=" + time + " and word='" + word + "'");
    if (!rs.next()) return new String[0];

    int id = rs.getInt("id");

    rs = db.Query("select count(*) from pmi_relate where pmi_id=" + id);
    if (!rs.next()) return new String[0];

    String[] ret = new String[rs.getInt(1)];

    rs = db.Query("select * from pmi_relate where pmi_id=" + id + " order by pmi desc");
    int i = 0;
    while (rs.next()) {
      ret[i] = rs.getString("word");
      i++;
    }

    return ret;
  }