Alexander R.
- Forum-Beiträge: 1.148
21.11.2010, 13:29:13 via Website
21.11.2010 13:29:13 via Website
Hallo Androiden,
ich versuche gerade eine MySQL verbindung aufzubauen und die Daten auszulesen.
Leider bekomme ich immer nur einnen weissen Bildschirm:
Als Layout habe ich eine einfache Webview:
Hoffe ihr könnt mir helfen
ich versuche gerade eine MySQL verbindung aufzubauen und die Daten auszulesen.
Leider bekomme ich immer nur einnen weissen Bildschirm:
1package de.Rocky.Test;
2
3import java.io.BufferedReader;
4import java.io.InputStream;
5import java.io.InputStreamReader;
6import java.util.ArrayList;
7
8import org.apache.http.HttpEntity;
9import org.apache.http.HttpResponse;
10import org.apache.http.NameValuePair;
11import org.apache.http.client.HttpClient;
12import org.apache.http.client.entity.UrlEncodedFormEntity;
13import org.apache.http.client.methods.HttpPost;
14import org.apache.http.impl.client.DefaultHttpClient;
15import org.apache.http.message.BasicNameValuePair;
16import org.json.JSONArray;
17import org.json.JSONException;
18import org.json.JSONObject;
19
20import android.app.Activity;
21import android.app.AlertDialog;
22import android.content.DialogInterface;
23import android.os.Bundle;
24import android.util.Log;
25import android.view.Menu;
26import android.view.MenuInflater;
27import android.view.MenuItem;
28
29public class Test extends Activity {
30 private InputStream is;
31 private static final int BEENDEN = 0;
32 /** Called when the activity is first created. */
33 @Override
34 public void onCreate(Bundle savedInstanceState) {
35 super.onCreate(savedInstanceState);
36 setContentView(R.layout.main);
37
38 String result = "";
39 //the year data to send
40 ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
41 nameValuePairs.add(new BasicNameValuePair("birthyear","1994"));
42 //http post
43 try{
44 HttpClient httpclient = new DefaultHttpClient();
45 HttpPost httppost = new HttpPost("http://rocky.bplaced.net/get.php");
46 httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
47 HttpResponse response = httpclient.execute(httppost);
48 HttpEntity entity = response.getEntity();
49 InputStream is = entity.getContent();
50 }catch(Exception e){
51 Log.e("log_tag", "Error in http connection "+e.toString());
52 }
53 //convert response to string
54 try{
55 BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
56 StringBuilder sb = new StringBuilder();
57 String line = null;
58 while ((line = reader.readLine()) != null) {
59 sb.append(line + "n");
60 }
61 is.close();
62 result=sb.toString();
63 }catch(Exception e){
64 Log.e("log_tag", "Error converting result "+e.toString());
65 }
66 //parse json data
67 try{
68 JSONArray jArray = new JSONArray(result);
69 for(int i=0;i<jArray.length();i++){
70 JSONObject json_data = jArray.getJSONObject(i);
71 Log.i("log_tag","id: "+json_data.getInt("id")+
72 ", name: "+json_data.getString("name")+
73 ", sex: "+json_data.getInt("sex")+
74 ", birthyear: "+json_data.getInt("birthyear")
75 );
76 }
77 }
78 catch(JSONException f){
79 Log.e("log_tag", "Error parsing data "+f.toString());
80 }
81 }
82
83 //Menü
84 @Override
85 public boolean onCreateOptionsMenu(Menu menu) {
86 super.onCreateOptionsMenu(menu);
87 menu.add(0, BEENDEN, 0, "Beenden").setIcon(android.R.drawable.ic_menu_close_clear_cancel);
88 return true;
89 }
90 //Menü
91
92
93 //Menü aktionen
94 @Override
95 public boolean onOptionsItemSelected(MenuItem item) {
96 switch (item.getItemId()) {
97 case BEENDEN:
98 AlertDialog.Builder builder = new AlertDialog.Builder(this);
99 builder.setTitle("Beenden");
100 builder.setMessage("Möchtest du die App beenden?")
101 .setCancelable(false)
102 .setPositiveButton("Ja", new DialogInterface.OnClickListener() {
103 public void onClick(DialogInterface dialog, int id) {
104 System.exit(0);
105 }
106 })
107 .setNegativeButton("Nein", new DialogInterface.OnClickListener() {
108 public void onClick(DialogInterface dialog, int id) {
109 dialog.cancel();
110 }
111 });
112 AlertDialog alert = builder.create();
113 alert.show();
114 break;
115 }
116 return false;
117 }
118 //Menü aktionen
119}
2
3import java.io.BufferedReader;
4import java.io.InputStream;
5import java.io.InputStreamReader;
6import java.util.ArrayList;
7
8import org.apache.http.HttpEntity;
9import org.apache.http.HttpResponse;
10import org.apache.http.NameValuePair;
11import org.apache.http.client.HttpClient;
12import org.apache.http.client.entity.UrlEncodedFormEntity;
13import org.apache.http.client.methods.HttpPost;
14import org.apache.http.impl.client.DefaultHttpClient;
15import org.apache.http.message.BasicNameValuePair;
16import org.json.JSONArray;
17import org.json.JSONException;
18import org.json.JSONObject;
19
20import android.app.Activity;
21import android.app.AlertDialog;
22import android.content.DialogInterface;
23import android.os.Bundle;
24import android.util.Log;
25import android.view.Menu;
26import android.view.MenuInflater;
27import android.view.MenuItem;
28
29public class Test extends Activity {
30 private InputStream is;
31 private static final int BEENDEN = 0;
32 /** Called when the activity is first created. */
33 @Override
34 public void onCreate(Bundle savedInstanceState) {
35 super.onCreate(savedInstanceState);
36 setContentView(R.layout.main);
37
38 String result = "";
39 //the year data to send
40 ArrayList<NameValuePair> nameValuePairs = new ArrayList<NameValuePair>();
41 nameValuePairs.add(new BasicNameValuePair("birthyear","1994"));
42 //http post
43 try{
44 HttpClient httpclient = new DefaultHttpClient();
45 HttpPost httppost = new HttpPost("http://rocky.bplaced.net/get.php");
46 httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
47 HttpResponse response = httpclient.execute(httppost);
48 HttpEntity entity = response.getEntity();
49 InputStream is = entity.getContent();
50 }catch(Exception e){
51 Log.e("log_tag", "Error in http connection "+e.toString());
52 }
53 //convert response to string
54 try{
55 BufferedReader reader = new BufferedReader(new InputStreamReader(is,"iso-8859-1"),8);
56 StringBuilder sb = new StringBuilder();
57 String line = null;
58 while ((line = reader.readLine()) != null) {
59 sb.append(line + "n");
60 }
61 is.close();
62 result=sb.toString();
63 }catch(Exception e){
64 Log.e("log_tag", "Error converting result "+e.toString());
65 }
66 //parse json data
67 try{
68 JSONArray jArray = new JSONArray(result);
69 for(int i=0;i<jArray.length();i++){
70 JSONObject json_data = jArray.getJSONObject(i);
71 Log.i("log_tag","id: "+json_data.getInt("id")+
72 ", name: "+json_data.getString("name")+
73 ", sex: "+json_data.getInt("sex")+
74 ", birthyear: "+json_data.getInt("birthyear")
75 );
76 }
77 }
78 catch(JSONException f){
79 Log.e("log_tag", "Error parsing data "+f.toString());
80 }
81 }
82
83 //Menü
84 @Override
85 public boolean onCreateOptionsMenu(Menu menu) {
86 super.onCreateOptionsMenu(menu);
87 menu.add(0, BEENDEN, 0, "Beenden").setIcon(android.R.drawable.ic_menu_close_clear_cancel);
88 return true;
89 }
90 //Menü
91
92
93 //Menü aktionen
94 @Override
95 public boolean onOptionsItemSelected(MenuItem item) {
96 switch (item.getItemId()) {
97 case BEENDEN:
98 AlertDialog.Builder builder = new AlertDialog.Builder(this);
99 builder.setTitle("Beenden");
100 builder.setMessage("Möchtest du die App beenden?")
101 .setCancelable(false)
102 .setPositiveButton("Ja", new DialogInterface.OnClickListener() {
103 public void onClick(DialogInterface dialog, int id) {
104 System.exit(0);
105 }
106 })
107 .setNegativeButton("Nein", new DialogInterface.OnClickListener() {
108 public void onClick(DialogInterface dialog, int id) {
109 dialog.cancel();
110 }
111 });
112 AlertDialog alert = builder.create();
113 alert.show();
114 break;
115 }
116 return false;
117 }
118 //Menü aktionen
119}
Als Layout habe ich eine einfache Webview:
1<?xml version="1.0" encoding="UTF-8" ?>
2<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
3 android:orientation="vertical"
4 android:layout_width="fill_parent"
5 android:layout_height="fill_parent">
6
7<WebView android:id="@+id/View"
8 android:layout_width="fill_parent"
9 android:layout_height="fill_parent" />
10</LinearLayout>
2<LinearLayout xmlns:android="http://schemas.android.com/apk/res/android"
3 android:orientation="vertical"
4 android:layout_width="fill_parent"
5 android:layout_height="fill_parent">
6
7<WebView android:id="@+id/View"
8 android:layout_width="fill_parent"
9 android:layout_height="fill_parent" />
10</LinearLayout>
Hoffe ihr könnt mir helfen
— geändert am 21.11.2010, 13:38:11
Gruß Alexander
Empfohlener redaktioneller Inhalt
Mit Deiner Zustimmung wird hier ein externer Inhalt geladen.
Mit Klick auf den oben stehenden Button erklärst Du Dich damit einverstanden, dass Dir externe Inhalte angezeigt werden dürfen. Dabei können personenbezogene Daten an Drittanbieter übermittelt werden. Mehr Infos dazu findest Du in unserer Datenschutzerklärung.