在ListView中从php服务器检索mysql数据到android

Question

I would like to know if there is any way to retrieve or load database from MySql to the Android app? So far most of them includes JSON etc. Is it a must to involve JSON? Is there any alternative way?

I am able to post data to the database. I would like to know if I can view the table of the database or any info from the database from the Android app directly.

My aim is to view all directory and files available in the web server. User can enter the directory or file while browsing. It would be good if it is listed in ListView etc?

Answer 1

I have seen forum posts of undocumented MySQL JDBC drivers created for test and academic purposes. Just a quick search on google for "Android JDBC MySQL" will get you to some of these. However, you would not typically want to connect directly to a database over the web on your mobile device, bad idea (for a host of reasons). Instead you might look at creating an interface for whatever data it is you want to access and exposing it as a service (SOAP, REST, anything else). Then you can use a variety of plain Java APIs to get/ put/update/delete/whatever your data. What you want is more like the Google Data APIs, for your own stuff, rather than trying to include all sorts of JDBC overhead on a phone (keep all of that on the server, and use it like you normally would).