I have recently come into contact with mobile app server-side development. I am in the initial stage, so I will make some records.
1. How to communicate with the server database under the Android platform
With the Android platform, how to communicate with the server database PostgreSQL, Oracle, Sybase, Microsoft SQLServer and other database management systems DBMS (database management system), there are two main methods: Method
1: direct connection Introduce the
JDBC driver into the Android project and connect directly. Method
2: Indirect connectionUse
PHP+DBMSon the server to do the server side, PHP will use DBMSdata in json or xml for encapsulation. Then send the encapsulated data back to the Android platform. php is a language of webserver. You can also use javascript or perl or asp. No matter which language, their common feature is that they receive androidAfter the client requests, according to the content of the request, extracts the data requested by the client from the database and returns it to the client.
The main problem with the bJDBC method is that the security is not high, and once the amount of data to be accessed is too much, it is easy to have problems. In addition, the Android system itself has direct parsing of json or xmlapi, so it is recommended to use the second method, which has improved practicality and security. Reference:http://blog.163.com/wang_1980_ww/blog/static/111141052013282163933/
2.
For reference on the architecture of the second methodFor details, please see:http: //www.cnblogs.com/YamatAmain/archive/2013/06/09/3129452.html
3.
AboutPHPPHP is not only suitable for web development, but also suitable for mobile phones
app Server-side development. For details, please see: http://www.thinkphp.cn/topic/5023.html
4.
Selection of development toolsThe main reasons for making the choice: It can fully meet the needs, and FREE
WAMP:
windows+apache+mysql+phpLAMP:
linux+apache+mysql+php5.
Database Designhttp:/ /www.csdn.net/article/2012-04-11/2804419
Serial: http://blog.csdn.net/liu7537/article/details/657230
http://www.cnblogs.com/know/p/3197952.html
The above has introduced the initial stage of mobile app server-side development---tool selection, including aspects of it. I hope it will be helpful to friends who are interested in PHP tutorials.