public void MySQL() {
    createBank = new CreateBank(this);
    connecting = createBank.getReadableDatabase();
    String[] colunas = new String[]{CHASSIII, NAVIOI, DESTINOI, PATIO, TRANSP, CHECK, HORAII, DATAII};
    Cursor c = connecting.query(TABELAMYSQL, colunas, null, null, null, null, null);

    String chassi, navio, destino, patio, transportadora, hora, data, check;
    int chassiCOluna = c.getColumnIndex(CHASSIII);
    int navioColuna = c.getColumnIndex(NAVIOI);
    int destinoColuna = c.getColumnIndex(DESTINOI);
    int patioColuna = c.getColumnIndex(PATIO);
    int transpColuna = c.getColumnIndex(TRANSP);
    int checkColuna = c.getColumnIndex(CHECK);
    int horaColuna = c.getColumnIndex(HORAII);
    int dataColuna = c.getColumnIndex(DATAII);

    if (c.getCount() > 0) {
        for (c.moveToFirst(); !c.isAfterLast(); c.moveToNext()) {
            chassi = c.getString(chassiCOluna);
            navio = c.getString(navioColuna);
            destino = c.getString(destinoColuna);
            patio = c.getString(patioColuna);
            transportadora = c.getString(transpColuna);
            check = c.getString(checkColuna);
            hora = c.getString(horaColuna);
            data = c.getString(dataColuna);
            Sender s = new Sender(workspaceConferente.this, urlAdress, chassi, navio, destino, patio, transportadora, data, hora, check);
            s.execute();
        }
    }else{Toast.makeText(getApplicationContext(), "O sistema já está sincronizado!", Toast.LENGTH_SHORT).show();}
    connecting.close();
}

package com.example.leandroramos.qualidade.MySQL;

String Echassi,Enavio,Edestino, Epatio, Etransportadora, Ehora, Edata, Echeck;

ProgressDialog pd;

public Sender(Context c, String urlAddress,String chassi, String navio, String destino, String patio, String transportadora, String data, String hora, String check) {
    this.c = c;
    this.urlAddress = urlAddress;

    this.txtChassi=chassi;
    this.txtNavio=navio;
    this.txtDestino=destino;
    this.txtPatio=patio;
    this.txtTransportadora=transportadora;
    this.txtHora=hora;
    this.txtData=data;
    this.txtCheck=check;

    Echassi=chassi;
    Enavio=navio;
    Edestino=destino;
    Epatio=patio;
    Etransportadora=transportadora;
    Ehora=hora;
    Edata=data;
    Echeck=check;

}

@Override
protected void onPreExecute() {
    super.onPreExecute();

    pd=new ProgressDialog(c);
    pd.setTitle("Enviando");
    pd.setMessage("Por favor aguarde...");
    pd.show();
}

@Override
protected String doInBackground(Void... params) {
    return this.send();
}

@Override
protected void onPostExecute(String response) {
    super.onPostExecute(response);

    createBank = new CreateBank(c);
    connecting = createBank.getWritableDatabase();

    pd.dismiss();

    if(response == "Lista recebida")
    {
        //Toast.makeText(c,response,Toast.LENGTH_SHORT).show();
        connecting.execSQL("DELETE FROM "+TABELAMYSQL);

    }else
    {
        Toast.makeText(c,"Falha na conexão."+response,Toast.LENGTH_LONG).show();
    }
}

private String send()
{
    HttpURLConnection con=HttpConnection.connect(urlAddress);

    if(con==null)
    {
        return null;
    }

    try
    {
        OutputStream os=con.getOutputStream();

        BufferedWriter bw=new BufferedWriter(new OutputStreamWriter(os,"UTF-8"));
        bw.write(new DataPackager(Echassi,Enavio,Edestino, Epatio, Etransportadora, Edata, Ehora, Echeck).packData());

        bw.flush();

        bw.close();
        os.close();

        int responseCode=con.getResponseCode();

        if(responseCode==con.HTTP_OK)
        {
            BufferedReader br=new BufferedReader(new InputStreamReader(con.getInputStream()));
            StringBuffer response=new StringBuffer();

            String line;

            while ((line=br.readLine()) != null)
            {
                response.append(line);
            }

            br.close();

            return response.toString();

        }else
        {

        }

    } catch (IOException e) {
        e.printStackTrace();
    }

    return null;
}

package com.example.leandroramos.qualidade.MySQL;

String Echassi,Enavio,Edestino, Epatio, Etransportadora, Ehora, EdataReal, Echeck;

public DataPackager(String chassi, String navio, String destino, String patio, String transportadora, String data, String hora, String check) {
    this.Echassi = chassi;
    this.Enavio = navio;
    this.Edestino = destino;
    this.Epatio = patio;
    this.Etransportadora = transportadora;
    this.Ehora = hora;
    this.EdataReal = data;
    this.Echeck = check;
}

public String packData()
{
    JSONObject jo=new JSONObject();
    StringBuffer packedData=new StringBuffer();

    try
    {
        jo.put("chassi",Echassi);
        jo.put("navio",Enavio);
        jo.put("destino",Edestino);
        jo.put("patio",Epatio);
        jo.put("transportadora",Etransportadora);
        jo.put("hora",Ehora);
        jo.put("data",EdataReal);
        jo.put("check",Echeck);

        Boolean firstValue=true;

        Iterator it=jo.keys();

        do {
            String key=it.next().toString();
            String value=jo.get(key).toString();

            if(firstValue)
            {
                firstValue=false;
            }else
            {
                packedData.append("&");
            }

            packedData.append(URLEncoder.encode(key,"UTF-8"));
            packedData.append("=");
            packedData.append(URLEncoder.encode(value,"UTF-8"));

        }while (it.hasNext());

        return packedData.toString();

    } catch (JSONException e) {
        e.printStackTrace();
    } catch (UnsupportedEncodingException e) {
        e.printStackTrace();
    }

    return null;
}

package com.example.leandroramos.qualidade.MySQL;

public static HttpURLConnection connect(String urlAddress) {

    try
    {
        URL url=new URL(urlAddress);
        HttpURLConnection con= (HttpURLConnection) url.openConnection();

        con.setRequestMethod("POST");
        con.setConnectTimeout(3000);
        con.setReadTimeout(3000);
        con.setDoInput(true);
        con.setDoOutput(true);

        return con;
    } catch (MalformedURLException e) {
        e.printStackTrace();
    } catch (IOException e) {
        e.printStackTrace();
    } catch (Exception e){
        e.printStackTrace();
    }

    return null;
}