Esempio n. 1
0
  protected void onPostExecute(String result) {
    if (TabName.equals("Review_Tab1")) {
      rvComment.setText("");
    } else if (TabName.equals("Review_Tab2")) {
      ReviewAdapter reviewAdapter = new ReviewAdapter(Review_Tab2_Context, reviewArr);
      Review_Tab2_ListView.setAdapter(reviewAdapter);
    } else if (TabName.equals("MapActivity")) {

      // Log.i("mytag", "markReview");

      ReviewAdapter reviewAdapter = new ReviewAdapter(MapActivity_Context, reviewArr);
      MapActivity_ListView.setAdapter(reviewAdapter);
      // MapActivity_ListView2.setAdapter(reviewAdapter);

      // MapActivity ma = new MapActivity();
      // ma.markReviews(reviewArr);
    } else if (TabName.equals("ReviewViewDelete")) {
      ((ReviewView) ReviewView.ReviewView_Context).finish();

      Review_Tab2 rvTab2 = new Review_Tab2();
      rvTab2.refreshReview();
    } else if (TabName.equals("Join")) {
      if (isDuplicated == false) {
        Message msg;
        msg = joinPopup_MessageHandler.obtainMessage();
        msg.arg1 = 1;
        joinPopup_MessageHandler.sendMessage(msg);
      } else if (isDuplicated == true) {
        Message msg;
        msg = joinPopup_MessageHandler.obtainMessage();
        msg.arg1 = 2;
        joinPopup_MessageHandler.sendMessage(msg);
      }
    } else if (TabName.equals("Cluster")) {

      Cluster cc = new Cluster();
      cc.setMarkArray();
      Log.i("mytag", "ReviewAsyncTask");
      // MapActivity map = new MapActivity();
      // map.setMarkClustered();
      Message msg;
      msg = MapActivity_MessageHandler.obtainMessage();
      msg.arg1 = 2;
      MapActivity_MessageHandler.sendMessage(msg);
    }
  }
Esempio n. 2
0
  protected String doInBackground(String... params) {

    // policeArr = new ArrayList<Emergency>();
    reviewArr = new ArrayList<Review>();

    if (this.isCancelled()) {
      this.cancel(true);
    }
    try {
      while (conn == null) {
        if (conn != null) break;
        else {
          Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
          Log.i("Connection", "**MSSQL driver load");
          conn =
              DriverManager.getConnection(
                  "jdbc:jtds:sqlserver://192.168.43.154:1433/SAFEMAP;encrypt=fasle;instance=SQLEXPRESS;",
                  "sa",
                  "74128526");
          Log.i("Connection", "**MSSQL open");

          stmt = conn.createStatement();
        }
      }

    } catch (Exception e) {
      Log.w("***Error connection", "" + e.getMessage());
    }

    if (TabName.equals("Review_Tab1")) {
      try {
        Review_Tab1 rvTab1 = new Review_Tab1();
        currentDateTime = getDateTime();
        stmt.executeUpdate(
            "insert into review (nickname, date, location, comment, icon, lat, lng) "
                + "values (\'"
                + rvTab1.getName()
                + "\',\'"
                + currentDateTime
                + "\',\'"
                + rvTab1.getLocation()
                + "\',\'"
                + rvTab1.getComment()
                + "\',"
                + rvTab1.getIcon()
                + ","
                + rvTab1.getLat()
                + ","
                + rvTab1.getLng()
                + ")");

      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }

      Message msg;
      msg = Review_Tab1_MessageHandler.obtainMessage();
      msg.arg1 = 1;
      Review_Tab1_MessageHandler.sendMessage(msg);

    } else if (TabName.equals("Review_Tab2")) {
      try {
        ResultSet reset =
            stmt.executeQuery(
                "select * from review where nickname = \'"
                    + UserNickName
                    + "\' order by reviewID desc");

        while (reset.next()) {
          int icon = R.drawable.ic_launcher;
          if (reset.getInt(6) == 0) {
            icon = R.drawable.yellow;
          } else if (reset.getInt(6) == 1) {
            icon = R.drawable.orange;
          } else if (reset.getInt(6) == 2) {
            icon = R.drawable.red;
          }
          reviewArr.add(
              new Review(
                  reset.getInt(1),
                  icon,
                  reset.getString(2),
                  reset.getString(4),
                  reset.getString(5),
                  reset.getString(3),
                  reset.getDouble(7),
                  reset.getDouble(8)));
        }
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }

      Message msg;
      msg = Review_Tab2_MessageHandler.obtainMessage();
      msg.arg1 = 1;
      Review_Tab2_MessageHandler.sendMessage(msg);

    } else if (TabName.equals("MapActivity")) {
      try {

        ResultSet reset = stmt.executeQuery("select * from review order by reviewID desc");

        while (reset.next()) {
          int icon = R.drawable.ic_launcher;
          if (reset.getInt(6) == 0) {
            icon = R.drawable.yellow;
          } else if (reset.getInt(6) == 1) {
            icon = R.drawable.orange;
          } else if (reset.getInt(6) == 2) {
            icon = R.drawable.red;
          }
          reviewArr.add(
              new Review(
                  reset.getInt(1),
                  icon,
                  reset.getString(2),
                  reset.getString(4),
                  reset.getString(5),
                  reset.getString(3),
                  reset.getDouble(7),
                  reset.getDouble(8)));
        }

        ResultSet reset2 = stmt.executeQuery("select * from police");

        while (reset2.next()) {

          policeArr.add(
              new Emergency(
                  reset2.getString(1),
                  reset2.getString(2),
                  reset2.getDouble(3),
                  reset2.getDouble(4)));
          // Log.i("mytag", "police");
        }

      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }

      Message msg;
      msg = MapActivity_MessageHandler.obtainMessage();
      msg.arg1 = 1;
      MapActivity_MessageHandler.sendMessage(msg);

    } else if (TabName.equals("ReviewViewDelete")) {
      try {
        stmt.executeUpdate("delete from review where reviewID=" + ReviewID);
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }
    } else if (TabName.equals("loading")) {
      Message msg;
      msg = loading_MessageHandler.obtainMessage();
      msg.arg1 = 1;
      loading_MessageHandler.sendMessage(msg);
    } else if (TabName.equals("Join")) {
      try {

        ResultSet reset = stmt.executeQuery("select * from [user]");

        while (reset.next()) {
          if (reset.getString(2).equals(strNickName)) {
            isDuplicated = true;
          }
        }

        if (isDuplicated == false) {

          stmt.executeUpdate(
              "insert into [user] (email, nickname) "
                  + "values (\'"
                  + strEmail
                  + "\',\'"
                  + strNickName
                  + "\')");
        }
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }

    } else if (TabName.equals("Cluster")) {
      Log.i("mytag", "cluster!!!");
      try {
        ResultSet reset = stmt.executeQuery("select * from review order by reviewID desc");

        while (reset.next()) {
          int icon = R.drawable.ic_launcher;
          if (reset.getInt(6) == 0) {
            icon = R.drawable.yellow;
          } else if (reset.getInt(6) == 1) {
            icon = R.drawable.orange;
          } else if (reset.getInt(6) == 2) {
            icon = R.drawable.red;
          }
          reviewArr.add(
              new Review(
                  reset.getInt(1),
                  icon,
                  reset.getString(2),
                  reset.getString(4),
                  reset.getString(5),
                  reset.getString(3),
                  reset.getDouble(7),
                  reset.getDouble(8)));
        }
        Log.i("mytag", String.valueOf(reviewArr.size()));
      } catch (SQLException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
      }
    }

    return null;
  }