I am new to android programming and i am trying to make an ap开发者_StackOverflowp that will interface with a website i have. It is a movie website with all of its information stored in SQL database. I know how to write the requests and queries in .asp but dont know how to get information from the database in my app. I want the user to be able to enter a movie title, and through a couple of stored procedures that are in my SQL database, return the info on that movie(actor, budget, genre....). I would like to have little info stored on the device, have all of the queries being sent to my SQL server and just have the info being returned.
So my question boils down to, how do i link my existing SQL database with an android app.
Any help would be great.
Thanks Basketball4567
You would have to expose an interface for your existing database that an application on the device could access.. Now how you do that is up to you, there are a ton of possibilities. The main thing to keep in mind is that you are not likely going to do any direct database connections to a public database through the device and expect to query natively. You can alternatively look on http://groups.google.com/group/android-developers for JDBC or the like if you really would like to remotely connect to the db directly, although this is generally not recommended and most of what you will find is more hacked together works than full solutions.
精彩评论