use ODATA insteasd of PHP.
Il giorno sabato 10 marzo 2012 12:34:03 UTC+1, ramalakshmi ha scritto:
>
> Hi!
> I want to develop an application which connects ms sql to android
> mobile.In this the table values of sql server should be shown in android
> mobile.
> For this I connected the sql server though php.the php content is
> <?php
> header('refresh: 10; url=sample1.php');
> $con = mssql_connect('admin', 'sa', '10$million');
> if(!$con)
> {
> die('Reloding te page ,please wait' .mssql_error());
> header("Location: sample1.php");
> }
> mssql_select_db('SPI',$con)
> or die("Could not select database");
> $arr = array();
> $rs = mssql_query("SELECT Symbol, Bid, Ask FROM Data WHERE Slno<16 AND
> Slno>8 order by Slno");
> while($obj = mssql_fetch_object($rs)) {
> $arr[] = $obj;
> }
> echo '{"Data":'.json_encode($arr).'}';
> ?>
> the output is
>
> {"Data":[{"Symbol":"GOLD","Bid":"1712.9","Ask":"1713.1"},{"Symbol":"SILVER","Bid":"34.27","Ask":"34.302"},{"Symbol":"PLATINUM","Bid":"1678.3","Ask":"1688.3"},{"Symbol":"CRUDE","Bid":"107.33","Ask":"107.45"},{"Symbol":"DOLLAR","Bid":"49.85","Ask":"49.86"},{"Symbol":"EURO","Bid":"1.3121","Ask":"1.3124"},{"Symbol":"YEN","Bid":"82.42","Ask":"82.47"}]}
>
> I have wrote two files in eclipse ide.the first one is
> JSONfunctions.java
>
> public class JSONfunctions {
>
> public static JSONObject getJSONfromURL(String url){
> InputStream is = null;
> String result = "";
> JSONObject jArray = null;
>
> //http post
> try{
> HttpClient httpclient = new DefaultHttpClient();
> HttpPost httppost = new HttpPost(url);
> HttpResponse response = httpclient.execute(httppost);
> HttpEntity entity = response.getEntity();
> is = entity.getContent();
>
> }catch(Exception e){
> Log.e("log_tag", "Error in http connection "+e.toString());
> }
>
> //convert response to string
> try{
> BufferedReader reader = new BufferedReader(new
> InputStreamReader(is,"iso-8859-1"),8);
> StringBuilder sb = new StringBuilder();
> String line = null;
> while ((line = reader.readLine()) != null) {
> sb.append(line + "\n");
> }
> is.close();
> result=sb.toString();
> }catch(Exception e){
> Log.e("log_tag", "Error converting result "+e.toString());
> }
>
> try{
>
> jArray = new JSONObject(result);
> }catch(JSONException e){
> Log.e("log_tag", "Error parsing data "+e.toString());
> }
>
> return jArray;
> }
> }
>
> the other one is
> main.java
>
> public class Main extends ListActivity {
> /** Called when the activity is first created. */
> @Override
> public void onCreate(Bundle savedInstanceState) {
> super.onCreate(savedInstanceState);
> setContentView(R.layout.listplaceholder);
> ArrayList<HashMap<String, String>> mylist = new
> ArrayList<HashMap<String, String>>();
> JSONObject json = JSONfunctions.getJSONfromURL("
> http://192.168.100.9:8000/sample1.php";);
> try{
> JSONArray Data = json.getJSONArray("Data");
> for(int i=0;i<Data.length();i++){
>
> HashMap<String, String> map = new HashMap<String,
> String>();
> JSONObject e = Data.getJSONObject(i);
> map.put("Symbol",""+e.getString("Symbol"));
> map.put("Bid", "" + e.getString("Bid"));
> map.put("Ask", "" + e.getString("Ask"));
> mylist.add(map);
> }
> }catch(JSONException e) {
> Log.e("log_tag", "Error parsing data "+e.toString());
> }
> ListAdapter adapter = new SimpleAdapter(this, mylist,
> R.layout.main,
> new String[] { "Symbol", "Bid", "Ask" },
> new int[] { R.id.item_title, R.id.item_title1,
> R.id.item_title2});
> setListAdapter(adapter);
> final ListView lv = getListView();
> lv.setTextFilterEnabled(true);
>
> });
> }
> }
> I got the output like this
>
> now I want to chage the values as it work in ajax.
> that is real time streaming values of the table I want.
> can anybody help.please excuse if there are any gramatical mistakes.
> R u understand my need ?
> --
> ramalakshmi
>
>
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
