Android Open Source - android-roadkill My Sql Handler

• Back to Development/data  ↑

From Project

Back to project page android-roadkill.

License

The source code is released under:

GNU General Public License

Java Source Code

package edu.ucdavis.cros.roadkill;
//  w w w  . j av  a2s .  c  o  m
import java.io.BufferedReader;
import java.io.FileOutputStream;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.util.ArrayList;
import java.util.List;

import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.NameValuePair;
import org.apache.http.client.CookieStore;
import org.apache.http.client.entity.UrlEncodedFormEntity;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.cookie.Cookie;
import org.apache.http.impl.client.BasicCookieStore;
import org.apache.http.impl.client.DefaultHttpClient;
import org.apache.http.message.BasicNameValuePair;
import org.apache.http.protocol.BasicHttpContext;
import org.apache.http.protocol.HttpContext;
import org.apache.http.util.ByteArrayBuffer;

import android.util.Log;

public class MySqlHandler {
  String result = "";
  private ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
  private ArrayList<NameValuePair> userData = new ArrayList<NameValuePair>();

  private DefaultHttpClient client = new DefaultHttpClient();
  private HttpPost post;
  private HttpGet request;
  private HttpEntity entity;
  private HttpResponse response;
  private BufferedReader reader;
  FileOutputStream fos;
  ByteArrayBuffer baf;
  List<Cookie> cookies;
  private InputStream is;

  CookieStore cookieStore = new BasicCookieStore();
  HttpContext httpContext = new BasicHttpContext();

  MySqlHandler() {

  }

  boolean login(String username, String password) {
    boolean findLogin = false;
    try {
      // Log in
      post = new HttpPost("http://www.wildlifecrossing.net/california/");
      userData.add(new BasicNameValuePair("form_id", "user_login_block"));
      userData.add(new BasicNameValuePair("name", username));
      userData.add(new BasicNameValuePair("pass", password));
      post.setEntity(new UrlEncodedFormEntity(userData));
      response = client.execute(post);
      entity = response.getEntity();
      is = entity.getContent();

      // Log in confirmation
      request = new HttpGet("http://www.wildlifecrossing.net/california/");
      response = client.execute(request);
      entity = response.getEntity();
      is = entity.getContent();
      BufferedReader reader = new BufferedReader(new InputStreamReader(
          is, "iso-8859-1"), 8);
      String line = null;
      while ((line = reader.readLine()) != null) {
        if (line.indexOf("login") > 0)
          findLogin = true;
      }
    } catch (Exception e) {
    }
    if (findLogin)
      return false;
    else
      return true;
  }

  boolean sendRecord(String species, String rating, String street,
      String latitude, String longitude, String date, String time,
      String duration, String observer) {

    String confidence = "Best Guess";

    if (rating == "1")
      confidence = "Best Guess";
    if (rating == "2")
      confidence = "Somewhat Confident";
    if (rating == "3")
      confidence = "100% Certain";

    try {

      // form page
      request = new HttpGet(
          "http://www.wildlifecrossing.net/california/node/add/roadkill");
      response = client.execute(request);
      entity = response.getEntity();
      is = entity.getContent();
      reader = new BufferedReader(
          new InputStreamReader(is, "iso-8859-1"), 8);

      StringBuilder sb = new StringBuilder();
      String line = null;
      while ((line = reader.readLine()) != null) {
        sb.append(line + "\n");
      }
      is.close();
      result = sb.toString();

      Integer index = result.indexOf("form-token");
      String formToken = result.substring(index + 19, index + 51);
      Log.d("MySqlHandler", "formToken: " + formToken);

      // form data
      nameValuePairs.add(new BasicNameValuePair("form_id",
          "roadkill_node_form"));
      nameValuePairs.add(new BasicNameValuePair("form_token", formToken));
      nameValuePairs.add(new BasicNameValuePair("taxonomy[1]", "4"));
      nameValuePairs.add(new BasicNameValuePair(
          "field_taxon_freetext[0][value]", species));
      nameValuePairs.add(new BasicNameValuePair(
          "field_id_confidence[value]", confidence));
      nameValuePairs.add(new BasicNameValuePair(
          "field_geography[0][street]", street));
      nameValuePairs.add(new BasicNameValuePair(
          "field_geography[0][locpick][user_longitude]", longitude));
      nameValuePairs.add(new BasicNameValuePair(
          "field_geography[0][locpick][user_latitude]", latitude));
      nameValuePairs.add(new BasicNameValuePair(
          "field_date_observation[0][value][date]", date));
      nameValuePairs.add(new BasicNameValuePair(
          "field_date_observation[0][value][time]", time));
      nameValuePairs.add(new BasicNameValuePair(
          "field_decay_duration[value]", duration));
      nameValuePairs.add(new BasicNameValuePair(
          "field_observer[0][value]", observer));
      nameValuePairs.add(new BasicNameValuePair("op", "Save"));

      // post form data
      post = new HttpPost(
          "http://www.wildlifecrossing.net/california/node/add/roadkill");
      post.setEntity(new UrlEncodedFormEntity(nameValuePairs));
      response = client.execute(post);
      entity = response.getEntity();
      is = entity.getContent();
      reader = new BufferedReader(
          new InputStreamReader(is, "iso-8859-1"), 8);

      baf = new ByteArrayBuffer(50);
      int current = 0;
      while ((current = reader.read()) != -1) {
        baf.append((byte) current);
      }
      fos = new FileOutputStream(
          "/data/data/edu.ucdavis.cros.roadkill/afterform.txt");
      fos.write(baf.toByteArray());
      fos.close();

    } catch (Exception e) {
    }
    return true;
  }

  void reset() {
    // reset cookies
    client = new DefaultHttpClient();
  }
  
}

Java Source Code List

• Back to Development/data  ↑