How to use Mysql on Android

Question

After some searches, I saw that the only database that Android can use is Sqlite, It is correct this information?

Because I have an application that connects to an online database (Mysql) and would like to create an application on Android using the same database, it is possible?

If yes, how can I connect to a base mysql?

Answer 1

How is it answered here, it is possible to use an online database, in your case Mysql, as long as you have a:

• Webservice
• Client

Webservice You must make the request in the bank and return a response to be processed, usually a JSON, which can be sent, for example, with php, as follows:

<?php
   echo json_encode($minha_info);
?>

This will return a JSON for the customer.

Client It is possible to use the package JSON from Java itself, as in this example and retrieve the information on the client. The following example will use the reading of a twitter feed:

@Override
public void onCreate(Bundle savedInstanceState) {
  super.onCreate(savedInstanceState);
  setContentView(R.layout.main);
  String readTwitterFeed = readTwitterFeed();
  try {
    JSONArray jsonArray = new JSONArray(readTwitterFeed);
    Log.i(ParseJSON.class.getName(), "Number of entries " + jsonArray.length());
    for (int i = 0; i < jsonArray.length(); i++) {
      JSONObject jsonObject = jsonArray.getJSONObject(i);
      Log.i(ParseJSON.class.getName(), jsonObject.getString("text"));
    }
  } catch (Exception e) {
    e.printStackTrace();
  }
}

public String readTwitterFeed() {
  StringBuilder builder = new StringBuilder();
  HttpClient client = new DefaultHttpClient();
  HttpGet httpGet = new HttpGet("http://twitter.com/statuses/user_timeline/vogella.json"); //Aqui ele pega o json do tutorial, nessa linha que o seu cliente vai declarar o webservice que enviará o json
  try {
    HttpResponse response = client.execute(httpGet);
    StatusLine statusLine = response.getStatusLine();
    int statusCode = statusLine.getStatusCode();
    if (statusCode == 200) {
      HttpEntity entity = response.getEntity();
      InputStream content = entity.getContent();
      BufferedReader reader = new BufferedReader(new InputStreamReader(content));
      String line;
      while ((line = reader.readLine()) != null) {
        builder.append(line);
      }
    } else {
      Log.e(ParseJSON.class.toString(), "Failed to download file");
    }
  } catch (ClientProtocolException e) {
    e.printStackTrace();
  } catch (IOException e) {
    e.printStackTrace();
  }
  return builder.toString();
}

Answer 2

Felipe, it actually works! I myself am developing a system for bars and restaurants with an app and I am using direct connection from Mysql to Android, and, contrary to what most say, does not slow down.

The only caveat is that the android API does not allow you to exchange data over the network (either by Wi-Fi or 3G/4G) using the main thread (Uithread). For this there are the auxiliary classes as a Asynctask, present in API, that assists in the execution of processes in the background. All communication process between the app and the bank should be done through a secondary thread, ie a process in the background (including the connection itself).

I forgot to post an example of how to implement the connection of android with Mysql.

Looking on the net I found this tutorial very interesting and very similar to the way I use the connection.

Android connection to Mysql using the Asynctask class

I hope I helped! Hugs

Answer 3

You will have to build an API (Usually uses json/Rest) so that you can communicate with the server, and it can process the data for you.