Guest User

Untitled

a guest
Oct 26th, 2018
122
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.77 KB | None | 0 0
  1. public class CheckLogin extends AsyncTask<String,String,String>
  2. {
  3. String z = "";
  4. Boolean isSuccess = false;
  5.  
  6. @Override
  7. protected void onPreExecute()
  8. {
  9. // progressBar.setVisibility(View.VISIBLE);
  10. }
  11.  
  12. @Override
  13. protected void onPostExecute(String r)
  14. {
  15. // progressBar.setVisibility(View.GONE);
  16. Toast.makeText(LoginActivity.this, r, Toast.LENGTH_SHORT).show();
  17. if(isSuccess)
  18. {
  19. Toast.makeText(LoginActivity.this , "Login Successfull" , Toast.LENGTH_LONG).show();
  20. //finish();
  21. }
  22. }
  23.  
  24. @Override
  25. protected String doInBackground(String... params)
  26. {
  27. java.sql.Connection con;
  28. String usernam = params[0];
  29. String passwordd = params[1];
  30. if(usernam.trim().equals("")|| passwordd.trim().equals(""))
  31. z = "Please enter Username and Password";
  32. else
  33. {
  34. try
  35. {
  36. con = connectionclass();
  37.  
  38. if (con == null)
  39. {
  40. z = "Check Your Internet Access!";
  41. }
  42. else
  43. {
  44. // Change below query according to your own database.
  45. String query = "select * from owner where mail = '" + usernam.toString() + "' and password = '"+ passwordd.toString() +"' ";
  46. Statement stmt = con.createStatement();
  47. ResultSet rs = stmt.executeQuery(query);
  48. if(rs.next())
  49. {
  50. z = "Login successful";
  51. isSuccess=true;
  52. con.close();
  53. }
  54. else
  55. {
  56. z = "Invalid Credentials!";
  57. isSuccess = false;
  58. }
  59. }
  60. }
  61. catch (Exception ex)
  62. {
  63. isSuccess = false;
  64. z = ex.getMessage();
  65. }
  66. }
  67. return z;
  68. }
  69. }
  70.  
  71.  
  72. @SuppressLint("NewApi")
  73. public java.sql.Connection connectionclass()
  74. {
  75. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
  76. StrictMode.setThreadPolicy(policy);
  77. java.sql.Connection connection = null;
  78. String ConnectionURL = null;
  79. try
  80. {
  81. Class.forName("com.mysql.jdbc.Driver");
  82.  
  83. connection = DriverManager.getConnection(url, un, pas);
  84.  
  85. }
  86. catch (SQLException se)
  87. {
  88. Log.e("error here 1 : ", se.getMessage());
  89. }
  90. catch (ClassNotFoundException e)
  91. {
  92. Log.e("error here 2 : ", e.getMessage());
  93. }
  94. catch (Exception e)
  95. {
  96. Log.e("error here 3 : ", e.getMessage());
  97. }
  98. return connection;
  99. }
  100.  
  101. jdbc:mysql://185.176.43.41:3306/DB_name
Add Comment
Please, Sign In to add comment