I'm having an error while trying to connect between my App and the MySQL database.
I'm creating a direct connection with my bank, I know the best way would be to use a webService, but I'm making this connection in localhost
and I do not have much knowledge in webService.
I'm using my mobile to run the application. Here is the code below.
Registration Class:
package com.example.junior.fireflyapp;
import android.content.DialogInterface;
import android.os.Bundle;
import android.support.v7.app.AppCompatActivity;
import android.text.InputType;
import android.view.View;
import android.widget.Button;
import android.widget.CheckBox;
import android.widget.EditText;
import android.widget.RadioButton;
import android.widget.RadioGroup;
import android.widget.Toast;
import com.wdullaer.materialdatetimepicker.date.DatePickerDialog;
import com.wdullaer.materialdatetimepicker.time.RadialPickerLayout;
import com.wdullaer.materialdatetimepicker.time.TimePickerDialog;
import java.util.Calendar;
public class ActCadastro extends AppCompatActivity implements DatePickerDialog.OnDateSetListener, TimePickerDialog.OnTimeSetListener, DialogInterface.OnCancelListener{
private Usuario usuario;
//EditText
private EditText txtNome;
private EditText txtSobrenome;
private EditText txtDtNasc;
private EditText txtEmail;
private EditText txtSenha;
private String sexo;
//RadioButton
private RadioGroup rdgSexo;
private RadioButton rbtMasculino;
private RadioButton rbtFeminino;
//Button
private Button btnCadastrar;
//CheckBox
private CheckBox cbxTermosUso;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.act_cadastrar);
this.usuario = new Usuario();
this.txtNome = (EditText)findViewById(R.id.txtNome);
this.txtSobrenome = (EditText)findViewById(R.id.txtSobrenome);
this.txtDtNasc = (EditText)findViewById(R.id.txtDtNasc);
this.txtDtNasc.setInputType(InputType.TYPE_NULL);
this.txtEmail = (EditText)findViewById(R.id.txtEmail);
this.txtSenha = (EditText)findViewById(R.id.txtSenha);
this.rdgSexo = (RadioGroup)findViewById(R.id.rdgSexo);
this.rbtMasculino = (RadioButton)findViewById(R.id.rbtMasculino);
this.rbtFeminino = (RadioButton)findViewById(R.id.rbtFeminino);
this.btnCadastrar = (Button)findViewById(R.id.btnCadastrar);
this.cbxTermosUso = (CheckBox)findViewById(R.id.cbxTermosUso);
txtDtNasc.setOnClickListener(new View.OnClickListener(){
@Override
public void onClick(View v) {
scheduleTestDrive(v);
}
});
}
private int day, month, year;
private void scheduleTestDrive(View v) {
InitDateTimeData();
Calendar cDefault = Calendar.getInstance();
cDefault.set(year, month,day);
DatePickerDialog datePickerDialog = DatePickerDialog.newInstance(
this,
cDefault.get(Calendar.YEAR),
cDefault.get(Calendar.MONTH),
cDefault.get(Calendar.DAY_OF_MONTH)
);
datePickerDialog.setOnCancelListener(this);
datePickerDialog.show(getFragmentManager(),"DatePickerDialog");
}
private void InitDateTimeData(){
if (year == 0){
Calendar c = Calendar.getInstance();
year = c.get(Calendar.YEAR);
month = c.get(Calendar.MONTH);
day = c.get(Calendar.DAY_OF_MONTH);
}
}
public void onClickCadastrar(View view){
boolean selectSexo;
if (rbtMasculino.isChecked()){
selectSexo = R.id.rbtMasculino == rdgSexo.getCheckedRadioButtonId();
sexo = "M";
}else {
selectSexo = R.id.rbtFeminino == rdgSexo.getCheckedRadioButtonId();
sexo = "F";
}
if(txtNome.getText().toString().isEmpty() ||
txtSobrenome.getText().toString().isEmpty() ||
txtDtNasc.getText().toString().isEmpty() ||
txtEmail.getText().toString().isEmpty() ||
txtSenha.getText().toString().isEmpty() ||
!selectSexo)
{
Toast.makeText(getApplicationContext(),"Todos os campos são obrigatórios", Toast.LENGTH_SHORT).show();
}else if(!cbxTermosUso.isChecked())
{
Toast.makeText(getApplicationContext(),"Para prosseguir você precisa aceitar os termos de uso", Toast.LENGTH_SHORT).show();
}else if(txtSenha.length() < 6 || txtSenha.length() > 12)
{
Toast.makeText(getApplicationContext(),"Sua senha deve ter entre 6 e 12 caracteres.", Toast.LENGTH_SHORT).show();
}else
{
this.usuario.setNome(this.txtNome.getText().toString());
this.usuario.setSobrenome(this.txtSobrenome.getText().toString());
this.usuario.setDataNascimento(this.txtDtNasc.getText().toString());
this.usuario.setEmail(this.txtEmail.getText().toString());
this.usuario.setSenha(this.txtSenha.getText().toString());
this.usuario.setSexo(sexo);
this.usuario.setDataNascimento(this.txtDtNasc.getText().toString());
this.usuario.cadastrar();
Toast.makeText(this, this.usuario.get_mensagem(), Toast.LENGTH_LONG).show();
if(usuario.is_status())
finish();
}
}
@Override
public void onCancel(DialogInterface dialog) {
year = month = year = 0;
txtDtNasc.setText("");
}
@Override
public void onDateSet(DatePickerDialog view, int y, int m, int d) {
year = y;
month = m;
day = d;
txtDtNasc.setText((day < 10 ? "0" + day : day) + "/" + (month+1 < 10 ? "0" + (month + 1) : (month+1)) + "/" + year);
}
@Override
public void onTimeSet(RadialPickerLayout view, int hourOfDay, int minute) {
}
}
Connection class:
package com.example.junior.fireflyapp;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
public class DB extends _Default implements Runnable {
private Connection conn;
private String host = "127.0.0.1";
private String db = "dbAppFireFly";
private int port = 3306;
private String user = "root";
private String pass = "junior3xtreme92";
private String url = "jdbc:mysql://%s:%d/%s";
public DB() {
super();
this.url = String.format(this.url, this.host, this.port, this.db);
this.conectar();
this.desconectar();
}
@Override
public void run() {
try{
Class.forName("com.mysql.jdbc.Driver");
this.conn = DriverManager.getConnection(this.url, this.user, this.pass);
}catch(Exception e){
this._mensagem = e.getMessage();
this._status = false;
}
}
private void conectar(){
Thread tread = new Thread(this);
tread.start();
try{
tread.join();//Aplicação espera a conclusão do metodo run
}catch (Exception e){
this._mensagem = e.getMessage();
this._status = false;
}
}
private void desconectar(){
if(this.conn != null){
try{
this.conn.close();
}catch(Exception e){
}finally {
this.conn = null;
}
}
}
public ResultSet select(String query){
this.conectar();
ResultSet resultSet = null;
try {
resultSet = new ExecuteDB(this.conn, query).execute().get();
}catch (Exception e){
this._status = false;
this._mensagem = e.getMessage();
}
return resultSet;
}
public ResultSet executar(String query) {
this.conectar();
ResultSet resultSet = null;
try {
resultSet = new ExecuteDB(this.conn, query).execute().get();
} catch (Exception e) {
this._status = false;
this._mensagem = e.getMessage();
}
return resultSet;
}
}
Here's my gradle: app
apply plugin: 'com.android.application'
android {
compileSdkVersion 23
buildToolsVersion "23.0.2"
defaultConfig {
applicationId "com.example.junior.fireflyapp"
minSdkVersion 16
targetSdkVersion 23
versionCode 1
versionName "1.0"
multiDexEnabled true
}
buildTypes {
release {
minifyEnabled false
proguardFiles getDefaultProguardFile('proguard-android.txt'), 'proguard-rules.pro'
}
}
productFlavors {
}
}
dependencies {
compile fileTree(include: ['*.jar'], dir: 'libs')
compile 'com.android.support:appcompat-v7:23.1.1'
compile 'com.android.support:design:23.1.1'
compile 'mysql:mysql-connector-mxj:5.0.12'
compile 'com.wdullaer:materialdatetimepicker:1.4.1'
//compile 'mysql:mysql-connector-java:5.1.37'
}
The error is being displayed in the run
method of the connection class in the following line.
this.conn = DriverManager.getConnection(this.url, this.user, this.pass);
After this line, the App gives a exception
with the following message:
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent to the server was 0 milliseconds ago. The driver has not received any packets from the server.