1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140
|
package com.example.dylan.myapplication;
import android.os.Bundle;
import android.support.v7.app.ActionBarActivity;
import android.util.Log;
import android.view.Menu;
import android.view.MenuItem;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.widget.Toast;
import android.view.View.OnClickListener;
import java.sql.SQLException;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class MainActivity extends ActionBarActivity {
Connection connexion=null;
Statement statement=null;
Thread premium= null;
String url= "jdbc:mysql://172.22.18.8:3306/mabase";
String utilisateur= "MaBase";
String motDePasse= "Mocopoc0*";
String Message= new String();
Button connection = null;
EditText identifiant = null;
EditText password = null;
@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Log.i(Message, "Driver JDBC chargé");
}
catch(ClassNotFoundException e)
{
Log.i(Message, "erreur de chargement du driver JDBC"+e.getMessage());
}
catch(IllegalAccessException e)
{
Log.i(Message, "erreur de chargement 2"+e.getMessage());
}
catch(InstantiationException e)
{
Log.i(Message, "erreur de chargement 3"+e.getMessage());
}
// pour la connexion
premium= new Thread(runConnect);
if(premium!=null)
{
premium.start();
Log.i(Message, "thread premium est crée"+premium.isAlive());
}
else
{
Log.i(Message, "probleme de création de thread premium");
}
setContentView(R.layout.activity_main);
}
private Runnable runConnect =new Runnable()
{
public void run()
{
//handler.sendEmptyMessage(-1);
Log.i(Message, "Thread start");
if(connexion==null)
{
try
{
connexion= DriverManager.getConnection(url, utilisateur, motDePasse);
Log.i(Message, "connexion OK");
//handler.sendEmptyMessage(-2);
statement= connexion.createStatement();
}
catch (java.sql.SQLException e)
{
Log.i(Message, "Erreur de connexion"+e.getMessage());
//handler.sendEmptyMessage(-3);
}
}
else
{
Log.i(Message, "Deja connécté");
//handler.sendEmptyMessage(-4);
}
}
};
@Override
public boolean onCreateOptionsMenu(Menu menu) {
// Inflate the menu; this adds items to the action bar if it is present.
getMenuInflater().inflate(R.menu.menu_main, menu);
return true;
}
@Override
public boolean onOptionsItemSelected(MenuItem item) {
// Handle action bar item clicks here. The action bar will
// automatically handle clicks on the Home/Up button, so long
// as you specify a parent activity in AndroidManifest.xml.
int id = item.getItemId();
//noinspection SimplifiableIfStatement
if (id == R.id.action_settings) {
return true;
}
return super.onOptionsItemSelected(item);
}
} |
Partager