CN103530425A - Android terminal remote data base access code generation system and method based on object dependence mapping - Google Patents
Android terminal remote data base access code generation system and method based on object dependence mapping Download PDFInfo
- Publication number
- CN103530425A CN103530425A CN201310533899.9A CN201310533899A CN103530425A CN 103530425 A CN103530425 A CN 103530425A CN 201310533899 A CN201310533899 A CN 201310533899A CN 103530425 A CN103530425 A CN 103530425A
- Authority
- CN
- China
- Prior art keywords
- mobile terminal
- data base
- remote data
- control
- interface
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/90—Details of database functions independent of the retrieved data types
- G06F16/95—Retrieval from the web
- G06F16/953—Querying, e.g. by the use of web search engines
- G06F16/9537—Spatial or temporal dependent retrieval, e.g. spatiotemporal queries
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L67/00—Network arrangements or protocols for supporting network services or applications
- H04L67/2866—Architectures; Arrangements
- H04L67/30—Profiles
- H04L67/303—Terminal profiles
Abstract
The invention relates to an Android terminal remote data base access code generation system and method based on object dependence mapping and aims at solving the problem that an android program on the existing mobile terminal operation system interacts with a remote data base, and the existing developing tools do not have the functions of visible generation of a mobile terminal remote access data base program framework structure and do not provide a basic Android program framework. The Android terminal remote data base access code generation system based on the object dependence mapping comprises 14 modules. The Android terminal remote data base access code generation method based on the object dependence mapping comprises 8 steps. The Android terminal remote data base access code generation system and method based on the object dependence mapping is applied to the field of development of mobile terminals by using embedded technology.
Description
Technical field
The present invention relates to a kind of Android terminal access remote data base code generating system and method, relate in particular to a kind of Android terminal access remote data base code generating system and method based on object association mapping.
Background technology
Current mobile network is developed rapidly, and particularly the user's request reform of new is being bred in the rise of intelligent terminal and application.The rise of panel computer, smart mobile phone has brought the epoch of mobile terminal, and intelligent terminal has replaced the effect of traditional computer in some cases, is more welcomed by users.Along with the widespread use of mobile terminal product, the quantity of application program for mobile terminal has also obtained fast development, and development prospect is also very optimistic.In mobile terminal, the mode that application program is obtained data is divided into two kinds substantially: this locality obtains with remote data base and obtains.For this locality, obtain data, by mobile terminal accessing itself, carry database.For the data acquisition of remote data base, most mobile terminals that adopt are connected with Database by the transfer of server, obtain required data.Therefore need the server of exploitation database far away separately, appointment data packet protocol etc., though increase relatively flexibly development and maintenance cost.
When mobile terminal remote accessing database, mobile terminal not only needs to provide some key messages for remote access data storehouse, also will consider the processing form returning results.Different access modes, the form that needs mobile terminal result is different, its result has reduced the portability of development efficiency and program.
How to develop fast and efficiently and there is high reliability application software, become the important topic of mobile Internet epoch exploitation.Software visualization is the important channel addressing this problem, software visualization in Future Software engineering in occupation of important position.At present, there is successively the visualization tool of software development, the Mobiforms software providing as the interface tool DroidDraw of Android, Opera company, DoirdDB software etc.
Along with the development of mobile terminal, higher to the function of database access and performance requirement.The mode of Android terminal operation remote data base is roughly divided into two kinds at present: a kind of is to obtain data method based on SAOP agreement: by WebService mode, carry out remote access data storehouse, WebService is a kind of far call standard based on SAOP agreement, can be by different operating system platform by WebService, different language, different technologies is integrated together; In Android mobile terminal, obtain server end WebService and call, need to use third party's class libraries (KSOAP2).Another mode is to obtain data method based on Http agreement: adopt HttpClient to server end action request msg, use JSON format analysis processing data.Such as: struts2+hibernate+spring+json.Json can be used in data aspect, also can use xml.These two kinds of modes all need to carry out writing of client and remote data base end code, and code process is complicated, program design requires technology more, needs developer to have certain development Experience and ability, improve the requirement to Android developer, strengthened development difficulty.So it is very meaningful to develop a kind of visualization tool of the Android of support terminal access remote data base.This mode provides overall unified view and the consistent access interface of database resource for user, and developer can realize Android terminal remote accessing database fast.After accessing database, data turn back to terminal with unified form, make Android terminal can conveniently carry out data processing, carry out succinctly, efficiently data interaction.
Summary of the invention
The Android program and the remote data base that the object of the invention is in order to solve on current mobile terminal operating system are mutual, current developing instrument does not have the function of Visual Production mobile terminal remote accessing database program frame structure and the problem of basic Android program frame is not provided, and therefore Android terminal access remote data base code generating system and the method based on object association mapping be provided.Program frame and the code generating system of the Android terminal access remote data base based on object association mapping, it comprises:
Remote data base device, mobile terminal data storehouse essential information device, mobile terminal data storehouse meter apparatus, the device that mobile terminal and remote data base are mutual, the center control massaging device that mobile terminal and remote data base are mutual, mobile terminal and teledata library inquiry interactive device, mobile terminal and remote data base upgrade data message device, the device of query sentence of database essential information, the unique identification of interface of mobile terminal control and the corresponding device of visit data library information, the essential information device of database update statement, the device of mobile terminal accessing remote data base, mobile terminal obtains the device of access remote data base SQL statement, the API that the data message device of the mobile terminal accessing remote data base of XML form and mobile terminal utilization provide processes the data message device of the remote data base receiving,
Described mobile terminal data storehouse essential information device server end connects remote data base device, described mobile terminal data storehouse essential information device client connects mobile terminal data storehouse meter apparatus, the mutual device of described mobile terminal and remote data base respectively with mobile terminal data storehouse meter apparatus, the center control massaging device that mobile terminal and remote data base are mutual, mobile terminal and teledata library inquiry interactive device, mobile terminal upgrades data message device with remote data base and is connected with the device of mobile terminal accessing remote data base, the center control of the center control massaging device that described mobile terminal is mutual with remote data base obtains unique identification and the corresponding device of visit data library information that end connects interface of mobile terminal control, the query statement of described mobile terminal and teledata library inquiry interactive device forms the device of end connection data library inquiry statement essential information, the renewal statement that described mobile terminal and remote data base upgrade data message device forms the essential information device that statement is upgraded in end connection data storehouse, the device of described mobile terminal accessing remote data base is connected with the device that mobile terminal obtains access remote data base SQL statement, the visit data return terminal of the device of described mobile terminal acquisition access remote data base SQL statement connects the data message device of the mobile terminal accessing remote data base of XML form, the API that the data storage end of the data message device of the mobile terminal accessing remote data base of described XML form connects mobile terminal utilization to be provided processes the data message device of the remote data base receiving.
Program frame and the code generating method of the Android terminal access remote data base based on object association mapping, it comprises the steps:
Access remote data base essential information, connect remote data base step, comprise setting steps for information such as clear and definite mobile terminal list structure, interface of mobile terminal assembly and teledata database table structure fields, for the type of remote data base being set and connecting the step of the information such as remote data base;
Mobile terminal data storehouse essential information is set, and database-name, version number's step, comprise step for clear and definite mobile terminal desired data library structure and list structure, for the step of clear and definite mobile terminal list structure and interface of mobile terminal module information;
SQL statement deposit position step is set;
Create mobile terminal data storehouse table, the relationship step of mobile terminal table and remote data base table is set, comprises step for mobile terminal data storehouse table and list structure are set, for obtaining step that interface of mobile terminal control assembly uniquely identified obtains, for by the field attribute of mobile terminal table and the corresponding step of unique ID attribute of interface of mobile terminal control object are set;
Create the structure of mobile terminal table, the step of field attribute, comprises that mobile terminal table name is set to be claimed step and mobile terminal table field attribute step is set;
Generate the SQL statement step that creates mobile terminal table, comprise that tissue generates the SQL statement of establishment mobile terminal table and obtains the deposit position step that generates SQL statement; Generate the content of SQL statement with for the step at program frame CodeWindow display routine skeleton code;
Create the mutual step of mobile terminal and remote data base, comprise for program frame code and the file that access remote data base end generates are shone upon, and in program frame code relevant position generate the step of event handling code, for the incidence relation of program frame code and control object is shone upon, in the relevant position of program frame code, generate the step of event handling code and for program frame code and incidence relation are shone upon, in the relevant position of program frame code, generate the step of event handling code;
Obtain the mutual center control information step of mobile terminal and remote data base, comprise obtaining the mutual center control device in trigger data storehouse in interface of mobile terminal control and for obtaining interface of mobile terminal control uniquely identified acquisition device;
Inquiry, the lastest imformation step of mobile terminal and remote data base interactive operation are set, comprise when obtaining mobile terminal enquiry remote data base, the literary name section needing, the acquisition step of condition, also comprise for obtaining the step of mobile terminal to update remote data base data message, also comprise for obtaining the unique ID of interface of mobile terminal control and the data message that corresponding control shows, complete the step of mobile terminal to update remote data base;
Generate mobile terminal accessing remote data base SQL statement step, comprise and generate SQL statement, the generation mobile terminal enquiry and the step of upgrading the SQL statement of remote data base that creates mobile terminal table;
Return to the data message step of the mobile terminal accessing remote data base of XML form, the step of the step of the return data information while comprising for the treatment of mobile terminal enquiry remote data base and return data information consolidation form when generating mobile terminal enquiry remote data base;
API that mobile terminal utilization provides processes the data message step of the remote data base receiving, and comprises the step of step, the assignment of business datum of carrying for the treatment of the control object in interface of mobile terminal file and the data message relation of conversion and remote data base end that return data information while also comprising for the treatment of mobile terminal enquiry remote data base and interface of mobile terminal assembly match, for safeguarding the step of the object association mapping relations that the data of mobile terminal and remote data base end match.
Inventive principle:
According to the setting of remote data base device with check that setting, the mobile terminal data storehouse meter apparatus that can complete mobile terminal data storehouse essential information device can arrange those; When mobile terminal accessing remote data base, the content that the mutual device of mobile terminal and remote data base completes, need to carry out the associated of mobile terminal and remote data base by the mobile terminal center control massaging device mutual with remote data base, wherein the unique identification of mobile terminal UI control is the tie of this relationship maps relation with the corresponding device of visit data library information, has completed mobile terminal and teledata library inquiry interactive device and mobile terminal and remote data base and has upgraded data message device; The device that comprises the device of query sentence of database essential information, the essential information device of database update statement and mobile terminal accessing remote data base when carrying out mobile terminal and remote data base interactive operation; The data message device that will use mobile terminal to obtain the device of access remote data base SQL statement after setting completes mobile terminal and the mutual content of remote data base and return to the mobile terminal accessing remote data base of XML form returns after the database data needing, and the data message device that the API that mobile terminal utilization provides processes the remote data base receiving completes the operation of mobile terminal accessing remote data base.
Beneficial effect of the present invention is: 1, between interface and Code Design, set up annexation, strengthened the readability of interface and code; 2, the skeleton code structure of Android application program is provided, for general developer's exploitation, compared with the Android application program access remote data base of standard, provides template; 3, object association is shone upon to thought and introduce visualization applications design and code generation field, widened the basic ideological realms that visualization applications design and code generate.The present invention can greatly reduce the workload of exploitation.The present invention can realize the Development of Module such as interface of mobile terminal, mobile terminal data storehouse, remote data base.Use this systems design and development Android terminal access remote data base, the overall unified view and consistent access interface of database resource can be provided for user, developer can realize Android terminal remote accessing database fast, facilitates Android terminal succinctly, efficiently to carry out data processing.
Accompanying drawing explanation
Fig. 1 is the Android terminal access remote data base code generating system integral module picture frame based on object association mapping in embodiment one;
Fig. 2 is program frame and the code generating method process flow diagram of the Android terminal access remote data base based on object association mapping in embodiment four;
Fig. 3 sets up the schematic diagram of mobile terminal data database table structure in embodiment five;
Fig. 4 be embodiment seven with embodiment eight in step inquiry and the schematic diagram of new technological process more.
Embodiment
Embodiment one: as shown in Figure 1, program frame and the code generating system of the Android terminal access remote data base based on object association mapping, it comprises,
Remote data base device 1, mobile terminal data storehouse essential information device 2, mobile terminal data storehouse meter apparatus 3, the device 4 that mobile terminal and remote data base are mutual, the center control massaging device 5 that mobile terminal and remote data base are mutual, mobile terminal and teledata library inquiry interactive device 6, mobile terminal and remote data base upgrade data message device 7, the device 8 of query sentence of database essential information, the unique identification of interface of mobile terminal control device 9 corresponding with visit data library information, the essential information device 10 of database update statement, the device 11 of mobile terminal accessing remote data base, mobile terminal obtains the device 12 of access remote data base SQL statement, the API that data message device 13 and the mobile terminal utilization of the mobile terminal accessing remote data base of XML form provides processes the data message device 14 of the remote data base receiving,
Described mobile terminal data storehouse essential information device 2 server ends are connected with remote data base device 1, described mobile terminal data storehouse essential information device 2 clients are connected with mobile terminal data storehouse meter apparatus 3, the mutual device 4 of described mobile terminal and remote data base respectively with mobile terminal data storehouse meter apparatus 3, the center control massaging device 5 that mobile terminal and remote data base are mutual, mobile terminal and teledata library inquiry interactive device 6, mobile terminal upgrades data message device 7 with remote data base and is connected with the device 11 of mobile terminal accessing remote data base, the center control of the center control massaging device 5 that described mobile terminal is mutual with remote data base obtains unique identification and the corresponding device 9 of visit data library information that end connects interface of mobile terminal control, the query statement of described mobile terminal and teledata library inquiry interactive device 6 forms the device 8 of end connection data library inquiry statement essential information, the renewal statement that described mobile terminal and remote data base upgrade data message device 7 forms the essential information device 10 that statement is upgraded in end connection data storehouse, the device 11 of described mobile terminal accessing remote data base is connected with the device 12 that mobile terminal obtains access remote data base SQL statement, the visit data return terminal of the device 12 of described mobile terminal acquisition access remote data base SQL statement connects the data message device 13 of the mobile terminal accessing remote data base of XML form, the API that the data storage end of the data message device 13 of the mobile terminal accessing remote data base of described XML form connects mobile terminal utilization to be provided processes the data message device 14 of the remote data base receiving.
Embodiment two: present embodiment is different from embodiment one: described remote data base device 1, comprise tree-shaped device for showing remote data base client database list structure, for access remote data base and teledata database table structure information device, for select remote data base type and database user and password configuration information device with for being connected the device of the connection string of dissimilar remote data base;
Described mobile terminal data storehouse essential information device 2, comprise the condition device that creates mobile terminal data storehouse for arranging, for generate the device of mobile terminal data storehouse table with for generating the device of mobile terminal data database table structure;
Described mobile terminal data storehouse meter apparatus 3, comprise for arrange mobile terminal table name claim the device that waits with for the device of the field attribute of mobile terminal table is set;
The device 4 that described mobile terminal and remote data base are mutual, comprise for the condition of mobile terminal accessing remote data base and the device of interface of mobile terminal activex relation are set, for program frame code and the file that access remote data base end generates are shone upon, and relevant position generates the device of event handling code in program frame code, for the incidence relation of program frame code and control object is shone upon, at the device of the relevant position of program frame code generation event handling code and for program frame code and incidence relation are shone upon, in the relevant position of program frame code, generate the device of event handling code,
The center control massaging device 5 that described mobile terminal and remote data base are mutual, comprise for obtain the mutual center control device in interface of mobile terminal control trigger data storehouse with for obtaining interface of mobile terminal control uniquely identified acquisition device;
Described mobile terminal and teledata library inquiry interactive device 6, the device of return data information while comprising for the treatment of mobile terminal enquiry remote data base, the unique identification of interface of mobile terminal control and the corresponding device of visit data library information, for by the field attribute of mobile terminal table and the unique identification Attribute Relative of interface of mobile terminal the control device of answering and the device that generates mobile terminal enquiry remote data base statement are set;
Described mobile terminal and remote data base upgrade data message device 7, comprise device for obtaining mobile terminal to update remote data base data message, for obtaining unique identification and the corresponding assembly device that shows information and the device that generates mobile terminal to update remote data base statement of interface of mobile terminal assembly;
The device 8 of described query sentence of database essential information, comprise when obtaining mobile terminal enquiry remote data base the acquisition device of the literary name section needing, for obtaining the device and the data and the device that implied terms value is set that obtain from interface of mobile terminal control of mobile terminal enquiry remote data base end conditional information;
The unique identification of described interface of mobile terminal control device 9 corresponding with visit data library information, comprises the device of field, the unique ID attribute of interface of mobile terminal control and remote data base literary name section three's the one-to-one relationship of judgement mobile terminal table;
The essential information device 10 of described database update statement, comprises the device that upgrades remote data base end list structure for arranging, for obtaining the conditional information device and the device obtaining from data and the implied terms value of interface of mobile terminal control of mobile terminal to update remote data base;
The device 11 of described mobile terminal accessing remote data base, comprises for the device at program frame CodeWindow display routine skeleton code and for obtaining application program for mobile terminal essential information device;
Described mobile terminal obtains the device 12 of access remote data base SQL statement, comprises for generating the device and the device generating for generating mobile terminal accessing teledata bank code of SQL statement;
The data message device 13 of the mobile terminal accessing remote data base of described XML form, the device that comprise the device of the return data information consolidation form when generating mobile terminal accessing remote data base, the return data information during for the treatment of mobile terminal enquiry remote data base and interface of mobile terminal assembly matches;
API that described mobile terminal utilization provides processes the data message device 14 of the remote data base receiving, and comprises the device of the assignment of the business datum of carrying for the treatment of the control object in interface of mobile terminal file and the data message relation of conversion and remote data base end and for safeguarding the device of the object association mapping relations that the data of mobile terminal and remote data base end match.Other step and parameter are identical with embodiment one.
Embodiment three: present embodiment and embodiment one or two are not both: described for the condition of mobile terminal accessing remote data base being set and the device of interface of mobile terminal activex relation comprises TextView control, EditText control, CheckBox control, RadioButon control, ListView control, Spinner control, AutoCompleteTextView control, MultiAutoCompleteTextView control, DatePicker control, TimePicker control, AnalogClock control and DigitalClock control, described remote data base type comprises Oracle Server, Oracle Lite, Microsoft SQL Server, Microsoft Access, Sybase SQL Anywhere Server, IBM DB2Server and SQLite and Sun MySQL, in interface of mobile terminal control, the mutual center control in trigger data storehouse is the control that Button control is initiated service logic action.Other step and parameter are identical with embodiment one or two.
Embodiment four: as shown in Figure 2, program frame and the code generating method of the Android terminal access remote data base based on object association mapping, it comprises the steps:
Access remote data base essential information, connect remote data base step, comprise setting steps for information such as clear and definite mobile terminal list structure, interface of mobile terminal assembly and teledata database table structure fields, for the type of remote data base being set and connecting the step of the information such as remote data base;
Mobile terminal data storehouse essential information is set, and database-name, version number's step, comprise step for clear and definite mobile terminal desired data library structure and list structure, for the step of clear and definite mobile terminal list structure and interface of mobile terminal module information;
SQL statement deposit position step is set;
Create mobile terminal data storehouse table, the relationship step of mobile terminal table and remote data base table is set, comprises step for mobile terminal data storehouse table and list structure are set, for obtaining step that interface of mobile terminal control assembly uniquely identified obtains, for by the field attribute of mobile terminal table and the corresponding step of unique ID attribute of interface of mobile terminal control object are set;
Create the structure of mobile terminal table, the step of field attribute, comprises that mobile terminal table name is set to be claimed step and mobile terminal table field attribute step is set;
Generate the SQL statement step that creates mobile terminal table, comprise that tissue generates the SQL statement of establishment mobile terminal table and obtains the deposit position step that generates SQL statement; Generate the content of SQL statement with for the step at program frame CodeWindow display routine skeleton code;
Create the mutual step of mobile terminal and remote data base, comprise for program frame code and the file that access remote data base end generates are shone upon, and in program frame code relevant position generate the step of event handling code, for the incidence relation of program frame code and control object is shone upon, in the relevant position of program frame code, generate the step of event handling code and for program frame code and incidence relation are shone upon, in the relevant position of program frame code, generate the step of event handling code;
Obtain the mutual center control information step of mobile terminal and remote data base, comprise obtaining the mutual center control device in trigger data storehouse in interface of mobile terminal control and for obtaining interface of mobile terminal control uniquely identified acquisition device;
Inquiry, the lastest imformation step of mobile terminal and remote data base interactive operation are set, comprise when obtaining mobile terminal enquiry remote data base, the literary name section needing, the acquisition step of condition, also comprise for obtaining the step of mobile terminal to update remote data base data message, also comprise for obtaining the unique ID of interface of mobile terminal control and the data message that corresponding control shows, complete the step of mobile terminal to update remote data base;
Generate mobile terminal accessing remote data base SQL statement step, comprise and generate SQL statement, the generation mobile terminal enquiry and the step of upgrading the SQL statement of remote data base that creates mobile terminal table;
Return to the data message step of the mobile terminal accessing remote data base of XML form, the step of the step of the return data information while comprising for the treatment of mobile terminal enquiry remote data base and return data information consolidation form when generating mobile terminal enquiry remote data base;
API that mobile terminal utilization provides processes the data message step of the remote data base receiving, and comprises the step of step, the assignment of business datum of carrying for the treatment of the control object in interface of mobile terminal file and the data message relation of conversion and remote data base end that return data information while also comprising for the treatment of mobile terminal enquiry remote data base and interface of mobile terminal assembly match, for safeguarding the step of the object association mapping relations that the data of mobile terminal and remote data base end match.
Embodiment five: present embodiment is different from embodiment four: the program frame of the Android terminal access remote data base based on object association mapping and the restriction of code generating system are further illustrated, for creating the format analysis processing of mobile terminal data storehouse table essential information, it also comprises
The field mappings relation of specified data storehouse pattern.Usually, terminal database (database) can comprise one or more tables (table), comprises one or more fields (column) in table.When creating the table of terminal database, both can complete multiplexing remote data base literary name section, can be also the subset of remote data base literary name section.
Mapping relations information between mobile terminal data storehouse pattern and remote data base pattern, specifically refers in remote data base the mapping relations between some fields in some fields and terminal database;
Mapping relations information between mobile terminal control and remote data base field is the mapping relations between the some fields in interface of mobile terminal control ID and remote data base.
The set of the set-inclusion mobile terminal table of showing in remote data base, and the Related fields remote data base respective table field of mobile terminal table, and be associated one to one, do not exist mobile terminal literary name section not belong to literary name section situation in remote data base.By checking that mobile terminal data library structure can know in remote data base certain structure existing.
As shown in Figure 3, described establishment mobile terminal data storehouse table step, it comprises,
Step1: in the set of remote data base table, set up the table relation between mobile terminal data storehouse and remote data base according to the table set-inclusion of regular mobile terminal; The table set Tables of judgement mobile terminal be empty, and the table set Tables by mobile terminal and remote data base table set DBTables are related to Relations comparison, and the table that meets mobile terminal is contained in remote data base table, existence
and table1 ∈ Tables, sets up table table1; The table name that Tables deletion simultaneously has been set up claims table1; When Tables is sky, the establishment of terminal list finishes, and generates the code that creates list structure;
Step2: the set of fields that is contained in remote data base table according to the set of fields of the table of regular mobile terminal, create the field of mobile terminal table table1, the set of fields Columns of judgement mobile terminal table1 table is not empty, set up so first field column of table1, obtain the set of fields DBColumns in remote data base table, when meeting
column ∈ Columns, sets up required respective field, and deletes the field column in Columns set; According to step2, set up other fields of table.When Columns is judged as sky, represent that this literary name section foundation finishes, and turns back to step1.
Other step and parameter are identical with embodiment four.
Embodiment six: present embodiment is different from embodiment four or five: the described program frame of Android terminal access remote data base shining upon based on object association and the inquiry of code generating system and renewal further illustrate and limit, and comprising:
Request based on server lookup database is converted to the inquiry request based on True Data base resource, and utilizes the method that the uniform interface of accessing database is provided, and adopt Attribute Equivalence mode to realize corresponding function in conjunction with XML Schema technology.
(1) when carrying out data base querying, upgrading operation, the consistance that need to keep field information in the id information of mobile terminal control and remote data base table, particularly will carry out teledata database data while storing local data base into, must determine that control id information is consistent with field in remote data base table, also needs local data base to have consistent field information.
(2) mobile terminal is by calling corresponding production code, and access remote data base, returns to result according to unified XML form, and provides and meet the corresponding interface of XML form, and result is processed accordingly.
(3) server that mobile terminal provides by this program frame and corresponding process software, can obtain the return data of XML consolidation form, and the api routine consistent with this process software is provided, provide mobile terminal that returning results accordingly of acquisition processed.
(4) in field, unanimously time, need to carry out corresponding conversion operations, this part needs resource user to note when mobile terminal design.Other step and parameter are identical with embodiment four or five.
Embodiment seven: as shown in Figure 4, present embodiment is different from one of embodiment four to six: described for mobile terminal and the mutual mobile terminal enquiry teledata of teledata library inquiry library information, it comprises the steps:
Step1: obtaining the mutual center control in trigger data storehouse in interface of mobile terminal control is the unique identification of inquire button, here be id value, by the unique identification set of traversal interface of mobile terminal control, be Ids set, the unique identification id value that obtains the center control of trigger data library inquiry in interface of mobile terminal control is querybutton button;
Step2: check the table set DBTables of remote data base, judging whether to exist needs question blank table1; If there is no, inquire about unsuccessfully;
Step3: check the set of fields DBColumn of remote data base table table1, obtain inquiry field; If there is no, return to step2, reselect question blank, until all tables do not meet; Otherwise carry out step4;
Step4: obtain condition: according to the unique ID attribute of the field of regular mobile terminal table, interface of mobile terminal control and remote data base literary name section three's one-to-one relationship, terminal control id is identical with field relation and unique, so can infer corresponding control id value in interface of mobile terminal program; Conditional value is transmitted by Android terminal, and according to the requirement of Android application programming, general condition value is interface of mobile terminal data XXX.getText (); If do not exist accordingly in Ids set, inquire about unsuccessfully; Reset terminal program code;
Step5: select Query Result DISPLAY ORDER: traversal DBColumn set, select required field; If there is no, return to step2;
Step6: generated query code has been set;
Step7: the part of mobile terminal using the code generating in step6 as program, inquire about remote data base, return to the result of consolidation form;
By above step, the data that mobile terminal needs turn back to interface end with XML form, only need interface end to call corresponding result treatment interface, can complete design.Other step and parameter are identical with one of embodiment four to six.
Embodiment eight: as shown in Figure 4, present embodiment is different from one of embodiment four to seven: describedly for mobile terminal and remote data base, upgrade data message for mobile terminal to update teledata library information, renewal comprises insertion, revises and deletes, and it comprises the steps:
Step1: the center control of obtaining is the id value of renewing button, by traversal, Ids gathers, and searches id value for gengxbutton button;
Step2: check DBTables, whether exist and need question blank table1; If there is no, upgrade unsuccessfully;
Step3: check the DBColumn of remote data base table table1, obtain more newer field; If there is no, return to step2, reselect question blank, until all tables do not meet; Otherwise carry out step4; If when deleting data, step3 skips;
Step4: obtain condition: according to the unique ID attribute of the field of regular mobile terminal table, interface of mobile terminal control and remote data base literary name section three's one-to-one relationship, terminal control id is identical with field relation and unique, so can infer corresponding control id value in interface of mobile terminal program; Conditional value is transmitted by Android terminal, and according to the requirement of Android application programming, general condition value is interface of mobile terminal data XXX.getText (); If do not exist accordingly in Ids set, inquire about unsuccessfully; Reset terminal program code;
Step5: generated query code has been set;
Step6: the part of mobile terminal using the code generating in step5 as program, upgrade remote data base.
Other step and parameter are identical with one of embodiment four to seven.
Embodiment nine: in present embodiment, the further restriction of the described Android interface based on object association and the generation system of program frame is mainly to carry out the explanation of implementation method by stricter definition rule form, it also comprises,
Mapping relations set (MappingRelationship) is the subset of mapping ruler (MappingRule) set, article one, mapping ruler comprises (TableRelation) subset of relation between table and field mappings (ColumnMapping) subset, terminal control id and field relation (IdColumnRelation) subset, and all elements of field mappings subset must be for same database table (DBTable).Can be expressed as follows:
Rule 1: in object association mapping ruler, establishing MappingRelationship, MappingRules is two nonempty sets, and MappingRelationship is comprised of all elements with MappingRules subset.The set that MappingRules is comprised of three affiliated partner elements, is respectively TRs, CM, and, between three, there is terminal field, database side field, the constraint of interface I D corresponding relationship in CR.TCRelations is the subordinate relation between table and field, and field is an element in table.Formalization representation:
MappingRelationship={mr|mr∈MappingRules}；
MappingRules={<TRs,CM,ICRs>|
icr4,cm1∈CMs,cm2∈CMs,icr3∈ICRs,icr4∈ICRs→cm1.DBColumn.DBTable=cm2.DBColumn.DBTable,icr3.id=cm1.DBColumn,icr4.id=cm2.column}；
TCRelations={field|field∈table}；
Rule 2: in the object association mapping between table, establish the element that variable table1 is mobile terminal Tables, table2 is the element of database side DBTables, has relation relation between table1 and table2.Formalization representation:
TableRelations={<(table1,table2),relation>|table1∈Tables,table2∈DBTables,
DBTables，relation∈Relations}；
Relations={“=”,“<”,“>”,“<>”,“>=”,“<=”}
Rule 3: in the object association mapping of interfield, establish variable column and DBColumn, column is the element of mobile terminal Columns, and DBColumn is the element of database side DBColumns, and wherein Columns is contained in DBColumns.Formalization representation:
ColumnMappings={<column,DBColumn>|column∈Columns,DBColumn∈DBColumns,Columns
DBColumns}；
Rule 4: in the object association mapping of field and control, establishing id is the ID of terminal control, and column is the field of terminal database, and dbcolumn is the field in remote data base, and the mapping relations between three are as follows.
IdColumnRelations={<(id,column,dbcolumn),realtion>|id∈Ids,column∈Columns,dbcolumn∈DBColumns}；
Relations={“=”,“<”,“>”,“<>”,“>=”,“<=”}
Wherein, MappingRule is the set of mapping ruler, ColumnMapping is the set of field mappings, TableRelation is the set of relation between table, IdColumnRelations is the set of relationship of mobile terminal control and database table field, Columns is the set of field in local data base, DBColumns is the set of remote data base field, DBTables is the set of showing in remote data base, Tables is the set of mobile terminal table, Ids is the set of mobile terminal control id, and in terminal control id value and interface of mobile terminal program design, the variable of some necessary control must be of the same name, this point is conducive to terminal interface information and database information intercommunication operation.Relations is the set of logical relation.
In present embodiment, the generation of the code of mobile terminal accessing remote data base is by using for reference object association mapping (Object Relational Mapping is called for short ORM) technology.Mainly realize program object to the mapping of relation data database data.Based on object association mapping research mobile terminal remote accessing database, adopt the unidirectional relationship maps one to one of class pattern, realize mobile terminal data storehouse corresponding with remote data base, during mobile terminal accessing remote data base, interface control data are corresponding with teledata database data.The event handling code that generates can be reinvented, and as mobile terminal accessing remote data base code file is rewritten, the event handling code generating in program frame can be revised thereupon and be corresponding with it.Code skeleton can be revised for developer, and the modification that developer carries out can comprise increase, delete code, and what these codes completed is mainly business function.The code file content generating, in event handling code, is the control module of the Android application program mode in business flow processing process and order during the operation phase.The associated corresponding table of control object is the storage organization of incidence relation between control, is that incidence relation is to the reference unit of code mapping.
The technology that realizes that present embodiment adopts is under Windows operating system, uses java Swing technology, and mobile terminal accessing teledata library is imitated, and realizes the exploitation of mobile terminal accessing remote data base in visualization process.Utilize the technology such as WebService to call remote server, in conjunction with application program for mobile terminal, design according to certain calling sequentially and mode, determine code and the program of mobile terminal code success combination of mobile terminal accessing teledata library, propose the method for visual direct development scheme access teledata database data under Windows.
Above-mentioned mentioned program frame and to mapping after can program compiler refer in the assembled process of writing of Android application program, the program of different phase forms, do not carrying out application program for mobile terminal code and access remote data base end data corresponding code while combining, the content of target program is exactly basic program frame structure, otherwise, be the Android application code structure that can compile.This API that wherein most important application program for mobile terminal is applied flexibly the method and provided carries out the assembled part of code of program.Because Android program is to use java language as its development language, each .java file will carry out according to the structure of java programming so.If the internal characteristic space that Android is divided into and external characteristics space, the API that the method provides so just belongs to external characteristics, so the successful combination of the external characteristic of realization and bulk properties is to being also even more important with application the method.
Claims (7)
1. the Android terminal access remote data base code generating system shining upon based on object association, is characterized in that it comprises:
Remote data base device (1), mobile terminal data storehouse essential information device (2), mobile terminal data storehouse meter apparatus (3), the device (4) that mobile terminal and remote data base are mutual, the center control massaging device (5) that mobile terminal and remote data base are mutual, mobile terminal and teledata library inquiry interactive device (6), mobile terminal and remote data base upgrade data message device (7), the device of query sentence of database essential information (8), the unique identification of interface of mobile terminal control and the corresponding device of visit data library information (9), the essential information device (10) of database update statement, the device of mobile terminal accessing remote data base (11), mobile terminal obtains the device (12) of access remote data base SQL statement, the API that the data message device (13) of the mobile terminal accessing remote data base of XML form and mobile terminal utilization provide processes the data message device (14) of the remote data base receiving,
Described mobile terminal data storehouse essential information device (2) server end connects remote data base device (1), described mobile terminal data storehouse essential information device (2) client connects mobile terminal data storehouse meter apparatus (3), the mutual device (4) of described mobile terminal and remote data base respectively with mobile terminal data storehouse meter apparatus (3), the center control massaging device (5) that mobile terminal and remote data base are mutual, mobile terminal and teledata library inquiry interactive device (6), mobile terminal upgrades data message device (7) with remote data base and is connected with the device (11) of mobile terminal accessing remote data base, the described mobile terminal center control massaging device (5) mutual with remote data base connects unique identification and the corresponding device of visit data library information (9) of interface of mobile terminal control, the query statement of described mobile terminal and teledata library inquiry interactive device (6) forms the device (8) of end connection data library inquiry statement essential information, the renewal statement that described mobile terminal and remote data base upgrade data message device (7) forms the essential information device (10) that statement is upgraded in end connection data storehouse, the device of described mobile terminal accessing remote data base (11) is connected with the device (12) that mobile terminal obtains access remote data base SQL statement, the visit data return terminal of the device (12) of described mobile terminal acquisition access remote data base SQL statement connects the data message device (13) of the mobile terminal accessing remote data base of XML form, the API that the data storage end of the data message device (13) of the mobile terminal accessing remote data base of described XML form connects mobile terminal utilization to be provided processes the data message device (14) of the remote data base receiving.
2. the Android terminal access remote data base code generating system based on object association mapping according to claim 1, is characterized in that
Described remote data base device (1), comprise tree-shaped device for showing remote data base client database list structure, for access remote data base and teledata database table structure information device, for select remote data base type and database user and password configuration information device with for being connected the device of the connection string of dissimilar remote data base;
Described mobile terminal data storehouse essential information device (2), comprise the condition device that creates mobile terminal data storehouse for arranging, for generate mobile terminal data storehouse meter apparatus with for generating the device of mobile terminal data database table structure;
Described mobile terminal data storehouse meter apparatus (3), comprise for arrange mobile terminal table name claim the device that waits with for the device of the field attribute of mobile terminal table is set;
The device (4) that described mobile terminal and remote data base are mutual, comprise for the condition of mobile terminal accessing remote data base and the device of interface of mobile terminal activex relation are set, for program frame code and the file that access remote data base end generates are shone upon, and relevant position generates the device of event handling code in program frame code, for the incidence relation of program frame code and control object is shone upon, at the device of the relevant position of program frame code generation event handling code and for program frame code and incidence relation are shone upon, in the relevant position of program frame code, generate the device of event handling code,
The center control massaging device (5) that described mobile terminal and remote data base are mutual, comprise for obtain the mutual center control device in interface of mobile terminal control trigger data storehouse with for obtaining interface of mobile terminal control uniquely identified acquisition device;
Described mobile terminal and teledata library inquiry interactive device (6), the device of return data information while comprising for the treatment of mobile terminal enquiry remote data base, the unique identification of interface of mobile terminal control and the corresponding device of visit data library information, for by the field attribute of mobile terminal table and the unique identification Attribute Relative of interface of mobile terminal the control device of answering and the device that generates mobile terminal enquiry remote data base statement are set;
Described mobile terminal and remote data base upgrade data message device (7), comprise device for obtaining mobile terminal to update remote data base data message, for obtaining unique identification and the corresponding assembly device that shows information and the device that generates mobile terminal to update remote data base statement of interface of mobile terminal assembly;
The device of described query sentence of database essential information (8), comprise when obtaining mobile terminal enquiry remote data base the acquisition device of the literary name section needing, for obtaining the device and the data and the device that implied terms value is set that obtain from interface of mobile terminal control of mobile terminal enquiry remote data base end conditional information;
The unique identification of described interface of mobile terminal control and the corresponding device of visit data library information (9), comprise the device of field, the unique ID attribute of interface of mobile terminal control and remote data base literary name section three's the one-to-one relationship of judgement mobile terminal table;
The essential information device (10) of described database update statement, comprises the device that upgrades remote data base end list structure for arranging, for obtaining the conditional information device and the device obtaining from data and the implied terms value of interface of mobile terminal control of mobile terminal to update remote data base;
The device of described mobile terminal accessing remote data base (11), comprises for the device at program frame CodeWindow display routine skeleton code and for obtaining application program for mobile terminal essential information device;
Described mobile terminal obtains the device (12) of access remote data base SQL statement, comprises for generating the device and the device generating for generating mobile terminal accessing teledata bank code of SQL statement;
The data message device (13) of the mobile terminal accessing remote data base of described XML form, the device that comprise the device of the return data information consolidation form when generating mobile terminal accessing remote data base, the return data information during for the treatment of mobile terminal enquiry remote data base and interface of mobile terminal assembly matches;
API that described mobile terminal utilization provides processes the data message device (14) of the remote data base receiving, and comprises the device of the assignment of the business datum of carrying for the treatment of the control object in interface of mobile terminal file and the data message relation of conversion and remote data base end and for safeguarding the device of the object association mapping relations that the data of mobile terminal and remote data base end match.
3. the Android terminal access remote data base code generating system based on object association mapping according to claim 2, is characterized in that described for the condition of mobile terminal accessing remote data base being set and the device of interface of mobile terminal activex relation comprises TextView control, EditText control, CheckBox control, RadioButon control, ListView control, Spinner control, AutoCompleteTextView control, MultiAutoCompleteTextView control, DatePicker control, TimePicker control, AnalogClock control and DigitalClock control, described remote data base type comprises Oracle Server, Oracle Lite, Microsoft SQL Server, Microsoft Access, Sybase SQL Anywhere Server, IBM DB2Server and SQLite and Sun MySQL, in interface of mobile terminal control, the mutual center control in trigger data storehouse is the control that Button control is initiated service logic action.
4. the Android terminal access remote data base code generating method based on object association mapping as claimed in claim 1, is characterized in that, it comprises the steps:
Access remote data base essential information, connect remote data base step, comprise setting steps for information such as clear and definite mobile terminal list structure, interface of mobile terminal assembly and teledata database table structure fields, for the type of remote data base being set and connecting the step of the information such as remote data base;
Mobile terminal data storehouse essential information is set, and database-name, version number's step, comprise step for clear and definite mobile terminal desired data library structure and list structure, for the step of clear and definite mobile terminal list structure and interface of mobile terminal module information;
SQL statement deposit position step is set;
Create mobile terminal data storehouse table, the relationship step of mobile terminal table and remote data base table is set, comprises step for mobile terminal data storehouse table and list structure are set, for obtaining step that interface of mobile terminal control assembly uniquely identified obtains, for by the field attribute of mobile terminal table and the corresponding step of unique ID attribute of interface of mobile terminal control object are set;
Create the structure of mobile terminal table, the step of field attribute, comprises that mobile terminal table name is set to be claimed step and mobile terminal table field attribute step is set;
Generate the SQL statement step that creates mobile terminal table, comprise that tissue generates the SQL statement of establishment mobile terminal table and obtains the deposit position step that generates SQL statement; Generate the content of SQL statement with for the step at program frame CodeWindow display routine skeleton code;
Create the mutual step of mobile terminal and remote data base, comprise for program frame code and the file that access remote data base end generates are shone upon, and in program frame code relevant position generate the step of event handling code, for the incidence relation of program frame code and control object is shone upon, in the relevant position of program frame code, generate the step of event handling code and for program frame code and incidence relation are shone upon, in the relevant position of program frame code, generate the step of event handling code;
Obtain the mutual center control information step of mobile terminal and remote data base, comprise obtaining the mutual center control device in trigger data storehouse in interface of mobile terminal control and for obtaining interface of mobile terminal control uniquely identified acquisition device;
Inquiry, the lastest imformation step of mobile terminal and remote data base interactive operation are set, comprise when obtaining mobile terminal enquiry remote data base, the literary name section needing, the acquisition step of condition, also comprise for obtaining the step of mobile terminal to update remote data base data message, also comprise for obtaining the unique ID of interface of mobile terminal control and the data message that corresponding control shows, complete the step of mobile terminal to update remote data base;
Generate mobile terminal accessing remote data base SQL statement step, comprise and generate SQL statement, the generation mobile terminal enquiry and the step of upgrading the SQL statement of remote data base that creates mobile terminal table;
Return to the data message step of the mobile terminal accessing remote data base of XML form, the step of the step of the return data information while comprising for the treatment of mobile terminal enquiry remote data base and return data information consolidation form when generating mobile terminal enquiry remote data base;
API that mobile terminal utilization provides processes the data message step of the remote data base receiving, and comprises the step of step, the assignment of business datum of carrying for the treatment of the control object in interface of mobile terminal file and the data message relation of conversion and remote data base end that return data information while also comprising for the treatment of mobile terminal enquiry remote data base and interface of mobile terminal assembly match, for safeguarding the step of the object association mapping relations that the data of mobile terminal and remote data base end match.
5. the Android terminal access remote data base code generating method based on object association mapping according to claim 4, is characterized in that, described establishment mobile terminal data storehouse table step, and it comprises,
Step1: in the set of remote data base table, set up the table relation between mobile terminal data storehouse and remote data base according to the table set-inclusion of regular mobile terminal; The table set Tables of judgement mobile terminal be empty, and the table set Tables by mobile terminal and remote data base table set DBTables are related to Relations comparison, and the table that meets mobile terminal is contained in remote data base table, existence
and table1 ∈ Tables, sets up table table1; The table name that Tables deletion simultaneously has been set up claims table1; When Tables is sky, the establishment of terminal list finishes, and generates the code that creates list structure;
Step2: the set of fields that is contained in remote data base table according to the set of fields of the table of regular mobile terminal, create the field of mobile terminal table table1, the set of fields Columns of judgement mobile terminal table1 table is not empty, set up so first field column of table1, obtain the set of fields DBColumns in remote data base table, when meeting Columns
dBColumns, column ∈ Columns, sets up required respective field, and deletes the field column in Columns set; According to step2, set up other fields of table.When Columns is judged as sky, represent that this literary name section foundation finishes, and turns back to step1.
6. the Android terminal access remote data base code generating method based on object association mapping according to claim 5, is characterized in that, described mutual for mobile terminal and teledata library inquiry, it comprises the steps:
Step1: obtaining the mutual center control in trigger data storehouse in interface of mobile terminal control is the unique identification of inquire button, here be id value, by the unique identification set of traversal interface of mobile terminal control, be Ids set, the unique identification id value that obtains the center control of trigger data library inquiry in interface of mobile terminal control is querybutton button;
Step2: check the table set DBTables of remote data base, judging whether to exist needs question blank table1; If there is no, inquire about unsuccessfully;
Step3: check the set of fields DBColumn of remote data base table table1, obtain inquiry field; If there is no, return to step2, reselect question blank, until all tables do not meet; Otherwise carry out step4;
Step4: obtain condition: according to the unique ID attribute of the field of regular mobile terminal table, interface of mobile terminal control and remote data base literary name section three's one-to-one relationship, terminal control id is identical with field relation and unique, so can infer corresponding control id value in interface of mobile terminal program; Conditional value is transmitted by Android terminal, and according to the requirement of Android application programming, general condition value is interface of mobile terminal data XXX.getText (); If do not exist accordingly in Ids set, inquire about unsuccessfully; Reset terminal program code;
Step5: select Query Result DISPLAY ORDER: traversal DBColumn set, select required field; If there is no, return to step2;
Step6: generated query code has been set;
Step7: the part of mobile terminal using the code generating in step6 as program, inquire about remote data base, return to the result of consolidation form;
By above step, the data that mobile terminal needs turn back to interface end with XML form, only need interface end to call corresponding result treatment interface, can complete design.
7. the Android terminal access remote data base code generating method based on object association mapping according to claim 6, described mobile terminal upgrades data message with remote data base, upgrades and comprises insertions, modification and deletion, and it comprises the steps:
Step1: the center control of obtaining is the id value of renewing button, by traversal, Ids gathers, and searches id value for gengxbutton button;
Step2: check DBTables, whether exist and need question blank table1; If there is no, upgrade unsuccessfully;
Step3: check the DBColumn of remote data base table table1, obtain more newer field; If there is no, return to step2, reselect question blank, until all tables do not meet; Otherwise carry out step4; If when deleting data, step3 skips;
Step4: obtain condition: according to the unique ID attribute of the field of regular mobile terminal table, interface of mobile terminal control and remote data base literary name section three's one-to-one relationship, terminal control id is identical with field relation and unique, so can infer corresponding control id value in interface of mobile terminal program; Conditional value is transmitted by Android terminal, and according to the requirement of Android application programming, general condition value is interface of mobile terminal data XXX.getText (); If do not exist accordingly in Ids set, inquire about unsuccessfully; Reset terminal program code;
Step5: generated query code has been set;
Step6: the part of mobile terminal using the code generating in step5 as program, upgrade remote data base.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310533899.9A CN103530425A (en) | 2013-11-01 | 2013-11-01 | Android terminal remote data base access code generation system and method based on object dependence mapping |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310533899.9A CN103530425A (en) | 2013-11-01 | 2013-11-01 | Android terminal remote data base access code generation system and method based on object dependence mapping |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103530425A true CN103530425A (en) | 2014-01-22 |
Family
ID=49932434
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310533899.9A Pending CN103530425A (en) | 2013-11-01 | 2013-11-01 | Android terminal remote data base access code generation system and method based on object dependence mapping |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103530425A (en) |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104102489A (en) * | 2014-07-24 | 2014-10-15 | 深圳市神州通在线科技有限公司 | Third-party database APP (Application) construction system and construction method |
| CN104506606A (en) * | 2014-12-19 | 2015-04-08 | 苏州卫生职业技术学院 | Method for embedded device to access remote database |
| CN105278945A (en) * | 2014-06-05 | 2016-01-27 | 株式会社日立制作所 | Program visualization device, program visualization method, and program visualization program |
| CN105302695A (en) * | 2015-11-10 | 2016-02-03 | 浪潮(北京)电子信息产业有限公司 | Linux system managing and monitoring system and method based on object model |
| CN106649457A (en) * | 2016-09-26 | 2017-05-10 | 天津海量信息技术股份有限公司 | Data processing frame based on object relation mapping technology |
| CN106682799A (en) * | 2015-11-07 | 2017-05-17 | 上海海典软件股份有限公司 | Method for achieving drugstore shop ranking through mobile phone App |
| CN106682798A (en) * | 2015-11-07 | 2017-05-17 | 上海海典软件股份有限公司 | Method for realizing trade assistant ranking through mobile phone APP |
| CN108595162A (en) * | 2018-03-20 | 2018-09-28 | 北京车音网科技有限公司 | A kind of code generating method and device |
| CN105205123B (en) * | 2015-09-11 | 2018-12-04 | 北京恒华伟业科技股份有限公司 | Data interactive method and device between a kind of database |
| CN109726026A (en) * | 2018-12-29 | 2019-05-07 | 北京字节跳动网络技术有限公司 | A kind of interaction data processing method, device, equipment and storage medium |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012034395A1 (en) * | 2010-09-15 | 2012-03-22 | 青岛海信移动通信技术股份有限公司 | Method and device for code debugging |
| CN102902531A (en) * | 2012-09-11 | 2013-01-30 | Tcl集团股份有限公司 | Customization and generation method and device of Android application program |
| CN103034486A (en) * | 2012-11-28 | 2013-04-10 | 清华大学 | Automatic optimization method based on full-system expansion call graph for mobile terminal operation system |
-
2013
- 2013-11-01 CN CN201310533899.9A patent/CN103530425A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| WO2012034395A1 (en) * | 2010-09-15 | 2012-03-22 | 青岛海信移动通信技术股份有限公司 | Method and device for code debugging |
| CN102902531A (en) * | 2012-09-11 | 2013-01-30 | Tcl集团股份有限公司 | Customization and generation method and device of Android application program |
| CN103034486A (en) * | 2012-11-28 | 2013-04-10 | 清华大学 | Automatic optimization method based on full-system expansion call graph for mobile terminal operation system |
Non-Patent Citations (1)
| Title |
|---|
| WEN HU,YANLI ZHAO: "Code Generation for Mobile Terminals Remote Accessing to the Database Based on Obejct Relational Mapping", 《INTERNATIONAL JOURNAL OF DATABASE THEORY AND APPLICATION》 * |
Cited By (15)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105278945B (en) * | 2014-06-05 | 2018-07-13 | 株式会社日立制作所 | Program visualization device and program visualization method |
| CN105278945A (en) * | 2014-06-05 | 2016-01-27 | 株式会社日立制作所 | Program visualization device, program visualization method, and program visualization program |
| CN104102489A (en) * | 2014-07-24 | 2014-10-15 | 深圳市神州通在线科技有限公司 | Third-party database APP (Application) construction system and construction method |
| CN104506606A (en) * | 2014-12-19 | 2015-04-08 | 苏州卫生职业技术学院 | Method for embedded device to access remote database |
| CN105205123B (en) * | 2015-09-11 | 2018-12-04 | 北京恒华伟业科技股份有限公司 | Data interactive method and device between a kind of database |
| CN106682799A (en) * | 2015-11-07 | 2017-05-17 | 上海海典软件股份有限公司 | Method for achieving drugstore shop ranking through mobile phone App |
| CN106682798A (en) * | 2015-11-07 | 2017-05-17 | 上海海典软件股份有限公司 | Method for realizing trade assistant ranking through mobile phone APP |
| CN105302695A (en) * | 2015-11-10 | 2016-02-03 | 浪潮(北京)电子信息产业有限公司 | Linux system managing and monitoring system and method based on object model |
| CN105302695B (en) * | 2015-11-10 | 2018-06-29 | 浪潮(北京)电子信息产业有限公司 | A kind of linux system management monitoring system and method based on object model |
| CN106649457A (en) * | 2016-09-26 | 2017-05-10 | 天津海量信息技术股份有限公司 | Data processing frame based on object relation mapping technology |
| CN106649457B (en) * | 2016-09-26 | 2020-10-30 | 天津海量信息技术股份有限公司 | Data processing system based on object relation mapping technology |
| CN108595162A (en) * | 2018-03-20 | 2018-09-28 | 北京车音网科技有限公司 | A kind of code generating method and device |
| CN108595162B (en) * | 2018-03-20 | 2022-04-05 | 北京车音网科技有限公司 | Code generation method and device |
| CN109726026A (en) * | 2018-12-29 | 2019-05-07 | 北京字节跳动网络技术有限公司 | A kind of interaction data processing method, device, equipment and storage medium |
| CN109726026B (en) * | 2018-12-29 | 2021-03-19 | 北京字节跳动网络技术有限公司 | Interactive data processing method, device, equipment and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN103530425A (en) | Android terminal remote data base access code generation system and method based on object dependence mapping | |
| CN110019350B (en) | Data query method and device based on configuration information | |
| CN106951694B (en) | Adaptive modeling method for online monitoring system of secondary equipment of power system | |
| US20200057865A1 (en) | Management of co-ownership database system | |
| US10120915B2 (en) | Integrated framework for secured data provisioning and management | |
| CN103455540A (en) | System and method of generating in-memory models from data warehouse models | |
| CN102255914B (en) | Android network application program information verification method | |
| US10958420B2 (en) | Method and system for blockchain-implemented project management | |
| CN110704476A (en) | Data processing method, device, equipment and storage medium | |
| CN108228762B (en) | Method and system for configuring master database universal templates | |
| CN108471433B (en) | Configurated synchronous message verification receiving method, system and storage medium | |
| CN112949269A (en) | Method, system, equipment and storage medium for generating visual data analysis report | |
| US20220076182A1 (en) | Database system and method for carbon footprint optimization | |
| CN113434175A (en) | Data processing method, device, storage medium and equipment | |
| CN103838781A (en) | Database access method and system | |
| CN109976736A (en) | Reduce the unified platform application framework of system business model complexity | |
| CN113868252A (en) | Database mode matching method and device and SQL query statement generation method | |
| CN115017182A (en) | Visual data analysis method and equipment | |
| CN101237449B (en) | Method and system for access to IMS database | |
| US20180262589A1 (en) | Control system with persistent and transient data stores for registration, production and status data for networked devices | |
| CN110109893A (en) | The method and apparatus of data modeling and operation | |
| US9946781B2 (en) | System and method of implementing table aliases | |
| CN108959309B (en) | Method and device for data analysis | |
| CN102479218A (en) | Method and server for express query based on API (Application Program Interface) | |
| CN104506606A (en) | Method for embedded device to access remote database |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140122 |
|
| WD01 | Invention patent application deemed withdrawn after publication |