Datenbank Abfragen

1private void goHttp() throws JSONException
2 {
3 String result = "";
4 //the year data to send
5
6 ******************************************
7
8 //http post
9 try
10 {
11
12 final HttpClient httpclient = new DefaultHttpClient();
13 final HttpPost httppost = new HttpPost("http://192.168.2.32/StundenPlanAppDatenbankAbfrage.php");
14
15 httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
16 final HttpResponse response = httpclient.execute(httppost);
17 final HttpEntity entity = response.getEntity();
18 final InputStream inputStream = entity.getContent();
19
20
21
22 //convert response to string
23 final BufferedReader reader = new BufferedReader(new InputStreamReader(inputStream, "ISO-8859-1"), 8);
24 final StringBuilder stringBuilder = new StringBuilder();

1package AndroidStundenPlan.App;
2
3
4import android.app.Activity;
5import android.os.Bundle;
6import android.util.Log;
7import android.view.View;
8import android.widget.AdapterView;
9import android.widget.AdapterView.OnItemSelectedListener;
10import android.widget.ArrayAdapter;
11import android.widget.Button;
12import android.widget.Spinner;
13import android.widget.TextView;
14import android.widget.Toast;
15
16import org.apache.http.HttpEntity;
17import org.apache.http.HttpResponse;
18import org.apache.http.NameValuePair;
19import org.apache.http.client.HttpClient;
20import org.apache.http.client.entity.UrlEncodedFormEntity;
21import org.apache.http.client.methods.HttpPost;
22import org.apache.http.impl.client.DefaultHttpClient;
23import org.apache.http.message.BasicNameValuePair;
24import org.json.JSONArray;
25import org.json.JSONException;
26import org.json.JSONObject;
27
28import java.io.BufferedReader;
29import java.io.InputStream;
30import java.io.InputStreamReader;
31import java.util.ArrayList;
32
33/**
34 * import java.sql.Connection;
35 * import java.sql.DriverManager;
36 * import java.sql.ResultSet;
37 * import java.sql.SQLException;
38 * import java.sql.Statement;
39 */
40
41public class androidStundenPlanApp extends Activity
42{
43 /**
44 * Called when the activity is first created.
45 */
46 @Override
47 public void onCreate(Bundle savedInstanceState)
48 {
49 super.onCreate(savedInstanceState);
50 setContentView(R.layout.main);
51
52 /** Erster Spinner zur Auswahl der Klasse! */
53
54 Spinner s = (Spinner) findViewById(R.id.spinner);
55 ArrayAdapter adapter = ArrayAdapter.createFromResource(
56 this, R.array.Klassen, android.R.layout.simple_spinner_item);
57 adapter.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
58 s.setAdapter(adapter);
59 s.setOnItemSelectedListener(new MyOnItemSelectedListener());
60
61 /** Zweiter Spinner Wochenauswahl */
62
63 Spinner d = (Spinner) findViewById(R.id.spinner2);
64 ArrayAdapter adapter2 = ArrayAdapter.createFromResource(
65 this, R.array.wochen, android.R.layout.simple_spinner_item);
66 adapter2.setDropDownViewResource(android.R.layout.simple_spinner_dropdown_item);
67 d.setAdapter(adapter2);
68 d.setOnItemSelectedListener(new MyOnItemSelectedListener2());
69
70 /** Abschicken Button */
71 /**final Button button = (Button) findViewById(R.id.abschickenbutton);
72 button.setOnClickListener(new View.OnClickListener()
73 {
74 public void onClick(View v)
75 {
76 setContentView(R.layout.abschickenbutton);
77 }
78 });
79 final Button button2 = (Button) findViewById(R.id.zurueckbutton);
80 button.setOnClickListener(new View.OnClickListener()
81 {
82 public void onClick(View v)
83 {
84 setContentView(R.layout.main);
85 }
86 }); */
87
88
89 }
90
91 /**
92 * Auswertung des Ersten Spinners (Klassenauswahl)
93 */
94 public class MyOnItemSelectedListener implements OnItemSelectedListener
95 {
96
97 public void onItemSelected(AdapterView<?> parent,
98 View view, int pos, long id)
99 {
100 /** Kurzer Popup der auswahl! */
101 Toast.makeText(parent.getContext(), "Die Klasse ist " +
102 parent.getItemAtPosition(pos).toString(), Toast.LENGTH_LONG).show();
103
104 /** Dauerhafte ausgab der AUswahl! */
105 /**TextView test = (TextView) findViewById(R.id.barname);
106 test.setText("Select * FROM STUNDENPLANDB WHERE Klasse2 = " + parent.getItemAtPosition(pos).toString()); */
107
108
109 }
110
111
112 public void onNothingSelected(AdapterView<?> parent)
113 {
114 // Do nothing.
115 }
116 }
117
118 /**
119 * Auswertung des zweiten Spinners (Wochenauswahl)
120 */
121 public class MyOnItemSelectedListener2 implements OnItemSelectedListener
122 {
123 public void onItemSelected(AdapterView<?> parent,
124 View view, int pos, long id)
125 {
126 /**Toast.makeText(parent.getContext(), "Die Woche ist " +
127 parent.getItemAtPosition(pos).toString(), Toast.LENGTH_LONG).show(); */
128
129 try
130 {
131 goHttp();
132
133 }
134 catch (JSONException e)
135 {
136 Log.i( "log_tag" , "onItemSelected() - " + e.getMessage());
137 }
138 }
139
140 public void onNothingSelected(AdapterView<?> parent)
141 {
142 // Do nothing.
143 }
144
145 private void goHttp() throws JSONException
146 {
147 String result = "";
148 //the year data to send
149
150
151
152 //http post
153 try
154 {
155
156 final HttpClient httpclient = new DefaultHttpClient();
157 final HttpPost httppost = new HttpPost("http://192.168.2.32/StundenPlanAppDatenbankAbfrage.php");
158
159
160 httppost.setEntity(new UrlEncodedFormEntity(nameValuePairs));
161 final HttpResponse response = httpclient.execute(httppost);
162 final HttpEntity entity = response.getEntity();
163 final InputStream inputStream = entity.getContent();
164
165
166
167 //convert response to string
168 final BufferedReader reader = new BufferedReader(new InputStreamReader(inputStream, "ISO-8859-1"), 8);
169 final StringBuilder stringBuilder = new StringBuilder();
170
171 String line = null;
172 while (null != (line = reader.readLine()))
173 {
174 stringBuilder.append(line).append("\n");
175
176 }
177 inputStream.close();
178
179 result = stringBuilder.toString();
180
181 }
182
183 catch (Exception e)
184 {
185
186 Log.e("log_tag", "Error converting result " + e.toString());
187 }
188
189 //parse json data
190 try
191 {
192 final JSONArray jArray = new JSONArray(result);
193 for (int i = 0; i < jArray.length(); i++)
194 {
195 final JSONObject json_data = jArray.getJSONObject(i);
196 Toast.makeText(getBaseContext(),"" + jArray.getJSONObject(i), Toast.LENGTH_LONG).show();
197 Log.i("log_tag",
198 "," + json_data.getString("AgenturNr") +
199 "," + json_data.getInt("Vorwahl") +
200 "," + json_data.getString("Name")
201 );
202 }
203
204 }
205 catch (JSONException e)
206 {
207 Log.e("log_tag", "Error parsing data " + e.toString());
208 }
209 }
210 }
211
212
213
214}

1nameValuePairs.add(new BasicNameValuePair("AgenturNr", ""+"Was der user gewählt hatte"));

1<TableLayout xmlns:android="http://schemas.android.com/apk/res/android"
2 android:layout_width="fill_parent"
3 android:layout_height="fill_parent"
4 android:stretchColumns="1">
5 <TableRow>
6 <TextView
7 android:padding="3dip" />
8 <TextView
9 android:gravity="right"
10 android:padding="3dip" />
11 </TableRow>
12
13 <TableRow>
14 <TextView
15 android:padding="3dip" />
16 <TextView
17 android:gravity="right"
18 android:padding="3dip" />
19 </TableRow>
20</TableLayout>