Guest User

Untitled

a guest
Mar 25th, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.67 KB | None | 0 0
  1. public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
  2. try{
  3. Class.forName("com.mysql.jdbc.Driver");
  4. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Welcome_to_hyd", "root", "test");
  5. statement = con.createStatement();
  6. }catch(Exception e) {
  7. e.printStackTrace();
  8. }
  9.  
  10. switch (position) {
  11.  
  12.  
  13. case 0:
  14. try{
  15. String Fort = "Select Description from testHyd where TouristPlace='Golconda'";
  16. result = statement.executeQuery(Fort);
  17.  
  18. while (result.next()) {
  19. Desc = result.getString(1);
  20. System.out.println("result is " + Desc);
  21. }
  22. Desc=result.getString(1);
  23.  
  24. } catch (Exception e) {
  25. e.printStackTrace();
  26. }
  27. System.out.println("Printed output is " + Desc);
  28. Intent i = new Intent(getActivity(), ListNavigation.class);
  29. i.putExtra("DatabaseOutput", Desc);
  30. startActivity(i);
  31. }
  32. }
  33.  
  34. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
  35. 03-25 09:48:43.302 7137-7137/com.cityzers.welcometohyderabad W/System.err: at java.lang.reflect.Constructor.newInstance0(Native Method)
  36. 03-25 09:48:43.303 7137-7137/com.cityzers.welcometohyderabad W/System.err: at java.lang.reflect.Constructor.newInstance(Constructor.java:334)
  37. 03-25 09:48:43.308 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  38. 03-25 09:48:43.308 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.Util.getInstance(Util.java:386)
  39. 03-25 09:48:43.308 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1014)
  40. 03-25 09:48:43.309 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)
  41. 03-25 09:48:43.309 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)
  42. 03-25 09:48:43.310 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)
  43. 03-25 09:48:43.310 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2472)
  44. 03-25 09:48:43.310 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2215)
  45. 03-25 09:48:43.310 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:813)
  46. 03-25 09:48:43.310 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
  47. 03-25 09:48:43.311 7137-7137/com.cityzers.welcometohyderabad W/System.err: at java.lang.reflect.Constructor.newInstance0(Native Method)
  48. 03-25 09:48:43.311 7137-7137/com.cityzers.welcometohyderabad W/System.err: at java.lang.reflect.Constructor.newInstance(Constructor.java:334)
  49. 03-25 09:48:43.314 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
  50. 03-25 09:48:43.314 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:399)
  51. 03-25 09:48:43.314 7137-7137/com.cityzers.welcometohyderabad W/System.err: at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:334)
  52. 03-25 09:48:43.314 7137-7137/com.cityzers.welcometohyderabad W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:569)
Add Comment
Please, Sign In to add comment