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; }
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); }
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; }