Exemple #1
0
  public ApkBean[] getDiffApks() {
    ArrayList<ApkBean> diffApk = new ArrayList<ApkBean>();
    String[] marketNames = getMarketNames();

    for (String marketName : marketNames) {
      String query = String.format(DIFF_APK_QUERY, marketName, marketName);
      PreparedStatement pstmt;
      try {
        pstmt = (PreparedStatement) conn.prepareStatement(query);
        ResultSet rs = pstmt.executeQuery();
        while (rs.next()) {
          ApkBean apk = new ApkBean();
          apk.packageName = String.valueOf(rs.getString("package_name"));
          apk.marketBean.marketName = "Gfan";
          diffApk.add(apk);
        }
      } catch (SQLException e) {
        e.printStackTrace();
      }
    }
    return diffApk.toArray(new ApkBean[diffApk.size()]);
  }