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
| public class DoLogin extends AsyncTask<String,String,String> {
String z="";
Boolean isSucces = false;
Statement state;
ResultSet result;
@Override
protected void onPreExecute(){
//mProgressBar.setVisibility(View.VISIBLE);
}
@Override
protected void onPostExecute(String r){
if(isSucces) {
try {
nSuspect.setText(result.getString("Lname"));
pSuspect.setText(result.getString("Fname"));
//numSuspect.setText(result.getString("NumeroCarte"));
// numSuspect.setText("good");
seSuspect.setText(result.getString("sexe"));
affSuspect.setText(result.getString("AffaireName"));
//partie de l'image
String z = result.getString("imagePath");//recuperation du patrh de limage
img.setImageBitmap(BitmapFactory.decodeFile(z));
}
catch (MalformedURLException e) {
e.printStackTrace();
} catch (IOException e) {
e.printStackTrace();
}
catch (Exception ex)
{
// numSuspect.setText(ex.getMessage());
}
}
else {
}
}
@Override
protected String doInBackground(String...params){
String querry = " SELECT P.Lname,P.Fname,P.NumeroCarte,P.sexe,P.imagePath,P.AffaireId,A.ID,A.AffaireName,U.usernames,U.centerId FROM AndroidUsers U,P_Impliquer P INNER JOIN NAffaires A ON A.ID=P.AffaireId WHERE P.ID='" + value + "' and U.usernames= '"+name+"' ";
try {
Connection con = connectionClass.CONN();
if (con == null) {
// z = "Erreur de connection";
} else {
state = con.createStatement();
result = state.executeQuery(querry);
if (result.next()) {
z="Login Succes";
isSucces=true;
} else {
z="Login failed";
isSucces=false;
}
}
} catch (Exception ex) {
}
return z;
}
} |
Partager