Exemple #1
0
  // TODO
  public int insertCert(ApkBean apk) {
    int ret = -1;
    for (CertBean cert : apk.certs) {
      try {
        PreparedStatement pstmt = null;
        String marketUpdateQuery =
            "INSERT INTO cert " + "(issuer,certhash,certBrief)" + " VALUES(?, ?,?) ";
        pstmt = (PreparedStatement) conn.prepareStatement(marketUpdateQuery);
        pstmt.setString(
            1, ((X509Certificate) cert.certificate).getIssuerX500Principal().toString());
        pstmt.setString(2, cert.certificateHash);
        pstmt.setString(3, apk.certInfo());

        pstmt.executeUpdate();
        ret = 0;
      } catch (SQLException e) {
        if (e.getErrorCode() == 1062) {
          return 0;
        }
        e.printStackTrace();
        ret = -2;
      }
    }

    return ret;
  }
Exemple #2
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()]);
  }