Guest User

Untitled

a guest
Jun 11th, 2018
120
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 7.24 KB | None | 0 0
  1. java.lang.RuntimeException: An error occured while executing doInBackground()
  2. at android.os.AsyncTask$3.done(AsyncTask.java:278)
  3. at java.util.concurrent.FutureTask$Sync.innerSetException(FutureTask.java:273)
  4. at java.util.concurrent.FutureTask.setException(FutureTask.java:124)
  5. at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:307)
  6. at java.util.concurrent.FutureTask.run(FutureTask.java:137)
  7. at android.os.AsyncTask$SerialExecutor$1.run(AsyncTask.java:208)
  8. at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1076)
  9. at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:569)
  10. at java.lang.Thread.run(Thread.java:856)
  11. Caused by: java.lang.VerifyError: net/sourceforge/jtds/jdbc/TdsCore
  12. at net.sourceforge.jtds.jdbc.JtdsConnection.<init>(JtdsConnection.java:359)
  13. at net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:184)
  14. at java.sql.DriverManager.getConnection(DriverManager.java:175)
  15. at java.sql.DriverManager.getConnection(DriverManager.java:140)
  16. at com.example.kamran.login.MainActivity.connectionclass(MainActivity.java:158)
  17. at com.example.kamran.login.MainActivity$CheckLogin.doInBackground(MainActivity.java:106)
  18. at com.example.kamran.login.MainActivity$CheckLogin.doInBackground(MainActivity.java:73)
  19. at android.os.AsyncTask$2.call(AsyncTask.java:264)
  20.  
  21. public class MainActivity extends AppCompatActivity
  22. {
  23. // Declaring layout button, edit texts
  24. Button login;
  25. EditText username,password,lable;
  26. ProgressBar progressBar;
  27. // End Declaring layout button, edit texts
  28.  
  29. // Declaring connection variables
  30. Connection con;
  31. String un,pass,db,ip;
  32. String usernam,passwordd;
  33. //End Declaring connection variables
  34.  
  35. @Override
  36. protected void onCreate(Bundle savedInstanceState)
  37. {
  38. super.onCreate(savedInstanceState);
  39. setContentView(R.layout.activity_main);
  40.  
  41. // Getting values from button, texts and progress bar
  42. login = (Button) findViewById(R.id.button);
  43. username = (EditText) findViewById(R.id.editText);
  44. password = (EditText) findViewById(R.id.editText2);
  45. lable = (EditText) findViewById(R.id.editText3);
  46. progressBar = (ProgressBar) findViewById(R.id.progressBar);
  47. progressBar.setVisibility(View.GONE);
  48. // End Getting values from button, texts and progress bar
  49.  
  50. // Declaring Server ip, username, database name and password
  51. ip = "SQL7002";
  52. db = "????????";
  53. un = "????????";
  54. pass = "??????";
  55. // Declaring Server ip, username, database name and password
  56.  
  57.  
  58. // Setting up the function when button login is clicked
  59. login.setOnClickListener(new View.OnClickListener()
  60. {
  61. @Override
  62. public void onClick(View v)
  63. {
  64. usernam = username.getText().toString();
  65. passwordd = password.getText().toString();
  66. CheckLogin checkLogin = new CheckLogin();// this is the
  67. Asynctask, which is used to process in background to reduce load on app
  68. process
  69. checkLogin.execute("");
  70. }
  71. });
  72. //End Setting up the function when button login is clicked
  73. }
  74.  
  75. public class CheckLogin extends AsyncTask<String,String,String>
  76. {
  77. String z = "";
  78. Boolean isSuccess = false;
  79.  
  80. @Override
  81. protected void onPreExecute()
  82.  
  83. {
  84. progressBar.setVisibility(View.VISIBLE);
  85. }
  86.  
  87. @Override
  88. protected void onPostExecute(String r)
  89. {
  90. progressBar.setVisibility(View.GONE);
  91. Toast.makeText(MainActivity.this, r, Toast.LENGTH_SHORT).show();
  92. if(isSuccess)
  93. {
  94. Toast.makeText(MainActivity.this , "Login Successfull" , Toast.LENGTH_LONG).show();
  95. //finish();
  96. }
  97. }
  98. @Override
  99. protected String doInBackground(String... params)
  100. {
  101.  
  102. if(usernam.trim().equals("")|| passwordd.trim().equals(""))
  103. z = "Please enter Username and Password";
  104. else
  105. {
  106. try
  107. {
  108. con = connectionclass(un, pass, db, ip); // Connect to database
  109. if (con == null)
  110. {
  111. z = "Check Your Internet Access!";
  112. }
  113. else
  114. {
  115. final String query = "select Spec from Password where Num= '" + usernam.toString() + "' and Pass = '"+ passwordd.toString() +"' ";
  116. Statement stmt = con.createStatement();
  117. ResultSet rs = stmt.executeQuery(query);
  118. runOnUiThread(new Runnable() {
  119. @Override
  120. public void run() {
  121. lable.setText(query);
  122. }
  123. });
  124. if(rs.next())
  125. {
  126.  
  127. z = "Login successful";
  128. isSuccess=true;
  129. con.close();
  130. }
  131. else
  132. {
  133. z = "Invalid Credentials!";
  134. isSuccess = false;
  135. }
  136. }
  137. }
  138. catch (Exception ex)
  139. {
  140. isSuccess = false;
  141. z = ex.getMessage();
  142. }
  143. }
  144. return z;
  145. }
  146. }
  147.  
  148.  
  149. @SuppressLint("NewApi")
  150. public Connection connectionclass(String un, String pass, String db, String ip)
  151. {
  152. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
  153. StrictMode.setThreadPolicy(policy);
  154. java.sql.Connection connection = null;
  155. String ConnectionURL = null;
  156. try
  157. {
  158. Class.forName("net.sourceforge.jtds.jdbc.Driver");
  159. ConnectionURL = "jdbc:jtds:sqlserver://SQL7002.site4now.net;database=?????????;user=?????????;password=???????????";
  160. connection = DriverManager.getConnection(ConnectionURL);
  161. }
  162. catch (SQLException se)
  163. {
  164. Log.e("error here 1 : ", se.getMessage());
  165. }
  166. catch (ClassNotFoundException e)
  167. {
  168. Log.e("error here 2 : ", e.getMessage());
  169. }
  170. catch (Exception e)
  171. {
  172. Log.e("error here 3 : ", e.getMessage());
  173. }
  174. return connection;
  175. }
  176. }
Add Comment
Please, Sign In to add comment