Code Generation For Android Terminals Accessing To Database Based On Object Relation Mapping

With the rapid development of internet of things and intelligent terminal, the operating system has become the focus of competition among the intelligent terminal products. The rapid development of industrial handheld terminal products require intelligent terminal and the remote database have better data transfer and interaction, and development tools which the Android terminals access to a remote database have a higher demand. Currently visualization tools have produced, and these tools are used to develop Android terminals application, such as Mobiforms software and DoirdDB software which are visualization tools and can develop Android applications. Developers also have an urgent need to visualize tool which can develop the Android terminals access remote database. But at present, very little visualization software can access to a remote database.In order to solve the visual development problem which is Android terminals access to remote database automatically generated code, this paper combines with the Object Relation Mapping theory, creates an Object-Weight(Object-Weight) model, defines the mapping between data objects and weights objects, and achieves access to the remote database code automatically generated process. Reference Object Relation Mapping (ORM) theory, this paper will regard terminal weights, terminal weights ID, data tables and data fields as object elements. And according to certain object relation mapping rules, we can implement code generation method that Android terminals access to remote database. These codes include three aspects, namely, automatic generation creation Android terminal database table SQL statements, automatic generation a subclass (MySQLiteOpenHelper) of SQLiteOpenHelper class in Android terminal database, and automatic generation the queries and updates SQL statement which Android terminals access to a remote database.Through research and analysis the interfaces and methods that Android terminals access to the remote database, this paper uses technology of Java, WebService and XML to develop the visualization software that Android terminals access to remote database. Through choice and fill in the necessary parameters, developers can develop SQL statement that Android terminals access to a remote database, and combine with Android terminal development tools to achieve the whole development process.