Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- package com.cityzers.welcometohyderabad;
- import android.content.Intent;
- import android.os.Bundle;
- import android.support.v4.app.Fragment;
- import android.view.LayoutInflater;
- import android.view.MenuInflater;
- import android.view.View;
- import android.view.ViewGroup;
- import android.widget.AdapterView;
- import android.widget.ArrayAdapter;
- import android.widget.ListView;
- import android.widget.TextView;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.ResultSet;
- import java.sql.SQLException;
- import java.sql.Statement;
- /**
- * Created by DELL on 04-03-2018.
- */
- public class TouristPlace extends Fragment implements AdapterView.OnItemClickListener {
- public ListView list;
- public ArrayAdapter<String> arrayAdapter;
- public ResultSet result;
- public Statement statement;
- public String Desc;
- public String output;
- public TouristPlace touristPlace;
- public View onCreateView(LayoutInflater inflater, ViewGroup container, Bundle savedInstanceState) {
- View rootView = inflater.inflate(R.layout.tourists, container, false);
- list = (ListView)rootView.findViewById(R.id.places);
- touristPlace=new TouristPlace();
- try {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/Welcome_to_hyd", "root", "test");
- statement = con.createStatement();
- } catch (Exception e) {
- System.out.println(e.getMessage());
- }
- final String[] placelist = getResources().getStringArray(R.array.menu);
- arrayAdapter = new ArrayAdapter<String>(getActivity(), android.R.layout.simple_list_item_1, placelist);
- list.setAdapter(arrayAdapter);
- list.setOnItemClickListener(this);
- return rootView;
- }
- @Override
- public void onItemClick(AdapterView<?> parent, View view, int position, long id) {
- switch(position) {
- case 0:
- output=touristPlace.result("Golconda");
- Intent i = new Intent(getActivity(), ListNavigation.class);
- i.putExtra("DatabaseOutput", output);
- startActivity(i);
- }
- }
- public String result(String city){
- String Fort = "Select Description from testHyd where TouristPlace="+city;
- try {
- result = statement.executeQuery(Fort);
- while (result.next()) {
- Desc=result.getString(1);
- System.out.println(Desc);
- }
- }catch (Exception e){
- e.printStackTrace();;
- }
- return Desc;
- }
- }
- package com.cityzers.welcometohyderabad;
- import android.app.Activity;
- import android.content.Intent;
- import android.os.Bundle;
- import android.support.v7.app.AppCompatActivity;
- import android.widget.TextView;
- import java.sql.Connection;
- import java.sql.DriverManager;
- import java.sql.Statement;
- /**
- * Created by DELL on 10-03-2018.
- */
- public class ListNavigation extends Activity {
- public void onCreate(Bundle savedInstanceState){
- super.onCreate(savedInstanceState);
- setContentView(R.layout.placesoutput);
- TextView tv=findViewById(R.id.hydtext1);
- tv.setText(getIntent().getStringExtra("DatabaseOutput"));
- }
- }
- Process: com.cityzers.welcometohyderabad, PID: 2973
- 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
- at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2665)
- at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2726)
- at android.app.ActivityThread.-wrap12(ActivityThread.java)
- at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1477)
- at android.os.Handler.dispatchMessage(Handler.java:102)
- at android.os.Looper.loop(Looper.java:154)
- at android.app.ActivityThread.main(ActivityThread.java:6119)
- at java.lang.reflect.Method.invoke(Native Method)
- at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)
- at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)
- Caused by: java.lang.NullPointerException: Attempt to invoke virtual method 'void android.widget.TextView.setText(java.lang.CharSequence)' on a null object reference
- at com.cityzers.welcometohyderabad.ListNavigation.onCreate(ListNavigation.java:23)
- at android.app.Activity.performCreate(Activity.java:6679)
- at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1118)
- at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2618)
- at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2726)
- at android.app.ActivityThread.-wrap12(ActivityThread.java)
- at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1477)
- at android.os.Handler.dispatchMessage(Handler.java:102)
- at android.os.Looper.loop(Looper.java:154)
- at android.app.ActivityThread.main(ActivityThread.java:6119)
- at java.lang.reflect.Method.invoke(Native Method)
- at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:886)
- at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:776)
Add Comment
Please, Sign In to add comment