Guest User

Untitled

a guest
Mar 23rd, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 6.55 KB | None | 0 0
  1. package com.cityzers.welcometohyderabad;
  2.  
  3. import android.content.Intent;
  4. import android.os.Bundle;
  5. import android.support.v4.app.Fragment;
  6. import android.view.LayoutInflater;
  7. import android.view.MenuInflater;
  8. import android.view.View;
  9. import android.view.ViewGroup;
  10. import android.widget.AdapterView;
  11. import android.widget.ArrayAdapter;
  12. import android.widget.ListView;
  13. import android.widget.TextView;
  14.  
  15. import java.sql.Connection;
  16. import java.sql.DriverManager;
  17. import java.sql.ResultSet;
  18. import java.sql.SQLException;
  19. import java.sql.Statement;
  20.  
  21. /**
  22. * Created by DELL on 04-03-2018.
  23. */
  24.  
  25.  
  26. public class TouristPlace extends Fragment implements AdapterView.OnItemClickListener {
  27. public ListView list;
  28. public ArrayAdapter<String> arrayAdapter;
  29. public ResultSet result;
  30. public Statement statement;
  31. public String Desc;
  32. public String output;
  33. public TouristPlace touristPlace;
  34.  
  35. public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
  36. View rootView = inflater.inflate(R.layout.tourists, container, false);
  37. list = (ListView)rootView.findViewById(R.id.places);
  38. touristPlace=new TouristPlace();
  39. try {
  40. Class.forName("com.mysql.jdbc.Driver");
  41. Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Welcome_to_hyd", "root", "test");
  42. statement = con.createStatement();
  43. } catch (Exception e) {
  44. System.out.println(e.getMessage());
  45. }
  46. final String[] placelist = getResources().getStringArray(R.array.menu);
  47. arrayAdapter = new ArrayAdapter<String>(getActivity(), android.R.layout.simple_list_item_1, placelist);
  48. list.setAdapter(arrayAdapter);
  49. list.setOnItemClickListener(this);
  50. return rootView;
  51. }
  52.  
  53. @Override
  54. public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
  55. switch(position) {
  56. case 0:
  57. output=touristPlace.result("Golconda");
  58. Intent i = new Intent(getActivity(), ListNavigation.class);
  59. i.putExtra("DatabaseOutput", output);
  60. startActivity(i);
  61. }
  62. }
  63.  
  64. public String result(String city){
  65. String Fort = "Select Description from testHyd where TouristPlace="+city;
  66. try {
  67. result = statement.executeQuery(Fort);
  68. while (result.next()) {
  69. Desc=result.getString(1);
  70. System.out.println(Desc);
  71. }
  72. }catch (Exception e){
  73. e.printStackTrace();;
  74. }
  75. return Desc;
  76. }
  77. }
  78.  
  79. package com.cityzers.welcometohyderabad;
  80.  
  81. import android.app.Activity;
  82. import android.content.Intent;
  83. import android.os.Bundle;
  84. import android.support.v7.app.AppCompatActivity;
  85. import android.widget.TextView;
  86.  
  87. import java.sql.Connection;
  88. import java.sql.DriverManager;
  89. import java.sql.Statement;
  90.  
  91. /**
  92. * Created by DELL on 10-03-2018.
  93. */
  94.  
  95. public class ListNavigation extends Activity {
  96.  
  97. public void onCreate(Bundle savedInstanceState){
  98. super.onCreate(savedInstanceState);
  99. setContentView(R.layout.placesoutput);
  100. TextView tv=findViewById(R.id.hydtext1);
  101. tv.setText(getIntent().getStringExtra("DatabaseOutput"));
  102. }
  103. }
  104.  
  105. Process: com.cityzers.welcometohyderabad, PID: 2973
  106. java.lang.RuntimeException: Unable to start activity ComponentInfo{com.cityzers.welcometohyderabad/com.cityzers.welcometohyderabad.ListNavigation}: java.lang.NullPointerException: Attempt to invoke virtual method 'void android.widget.TextView.setText(java.lang.CharSequence)' on a null object reference
  107. at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2665)
  108. at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2726)
  109. at android.app.ActivityThread.-wrap12(ActivityThread.java)
  110. at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1477)
  111. at android.os.Handler.dispatchMessage(Handler.java:102)
  112. at android.os.Looper.loop(Looper.java:154)
  113. at android.app.ActivityThread.main(ActivityThread.java:6119)
  114. at java.lang.reflect.Method.invoke(Native Method)
  115. at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)
  116. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)
  117. Caused by: java.lang.NullPointerException: Attempt to invoke virtual method 'void android.widget.TextView.setText(java.lang.CharSequence)' on a null object reference
  118. at com.cityzers.welcometohyderabad.ListNavigation.onCreate(ListNavigation.java:23)
  119. at android.app.Activity.performCreate(Activity.java:6679)
  120. at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1118)
  121. at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2618)
  122. at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2726) 
  123. at android.app.ActivityThread.-wrap12(ActivityThread.java) 
  124. at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1477) 
  125. at android.os.Handler.dispatchMessage(Handler.java:102) 
  126. at android.os.Looper.loop(Looper.java:154) 
  127. at android.app.ActivityThread.main(ActivityThread.java:6119) 
  128. at java.lang.reflect.Method.invoke(Native Method) 
  129. at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886) 
  130. at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776) 
Add Comment
Please, Sign In to add comment