CN101835118A - Universal-type information query method based on mobilephone short messages - Google Patents
Universal-type information query method based on mobilephone short messages Download PDFInfo
- Publication number
- CN101835118A CN101835118A CN 201010159789 CN201010159789A CN101835118A CN 101835118 A CN101835118 A CN 101835118A CN 201010159789 CN201010159789 CN 201010159789 CN 201010159789 A CN201010159789 A CN 201010159789A CN 101835118 A CN101835118 A CN 101835118A
- Authority
- CN
- China
- Prior art keywords
- query
- data
- tables
- information
- server end
- 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
Abstract
The invention discloses a universal-type information query method based on mobilephone short messages, comprising the following steps of: (1) acquiring a data table corresponding to information query at a server end and extracting field names from a data table structure; (2) setting a short message query command format, wherein each short query command at least comprises one query condition which is related to the field names; (3) editing and transmitting a short message according with the short message query command format by a user through a mobilephone and and receiving the short message by the server end through a wireless communication network; (4) carrying out matching analysis on the received short message according to the set short message query command format and obtaining a query command; and (5) executing a data query operation and returning an query result to a query mobilephone so as to realize information query based on the mobilephone short message. The invention is used for querying information in an MIS (Management Information System) by taking the mobilephone as a terminal device by means of the wireless communication network and has unconstrained queried target system, dynamically-defined query command format and universality.
Description
Technical field
The present invention relates to a kind of method of information inquiry, be specifically related to a kind of information query method based on SMS.
Background technology
Information inquiry is an important application in most management information systems (MIS).Whether the inquiry means are abundant, various and convenient, are importances weighing the mis system quality.
Along with popularizing of GSM networks development and mobile phone, short message is as the simplest in the gsm system and the cheap data communication mode of expense, and its business and application obtain swift and violent development.The topmost application of SMS is: mobile phone is to the point-to-point communication of mobile phone, and mobile phone or computer are to designated mobile phone group's information issue.But the case that in recent years SMS is used for the inquiry application of mis system is appeared in the newspapers.For example publication number is that the Chinese invention patent application of CN101052180A discloses a kind of method of utilizing the mobile phone short message enquiry chemical information, the user is with chemical name of an article input handset note, send to the Mobile Directory Number of appointment, this note is received by short message transceiver by cordless communication network, resolve short message content by query software again, and from the chemicals database, retrieve relevant information by the chemical name of an article in the note, by short message transceiver Query Result is sent on the user mobile phone with note or multimedia message mode at last.
Yet in the said method, SMS can only be used for the information inquiry of specific mis system, causes this class to be used and is not easy to promote.Therefore, study a kind ofly, have positive effect for promoting the application of SMS in MIS based on the general mis system information inquiry of note and the method for issue.
Summary of the invention
The object of the invention provides a kind of information query method based on SMS, makes the system of this method of application possess versatility, is not subjected to the restriction of goal systems.
For achieving the above object, the technical solution used in the present invention is: a kind of universal-type information query method based on SMS comprises the following steps:
(1) obtains the tables of data of information inquiry correspondence at server end, from data list structure, extract field name;
(2) at server end the message search command format is set, comprises a querying condition relevant at least in each described message search order with field name;
(3) user also sends the note that meets the message search command format with the mobile phone editor, and this note is received by server end through cordless communication network;
(4) server end mates parsing according to set message search command format to the note that receives, and obtains querying command;
(5) server end is carried out the data query operation, and Query Result is returned to the inquiry mobile phone with note, realizes the information inquiry based on SMS thus.
Can work out corresponding query software and realize said method, during use, query software is connected with goal systems, the tables of data information that the input goal systems is used, query software can duplicate this tables of data, extracts field name and be presented at the message search command format to be provided with on the interface; The user is provided with the form of one or more message search order as required, usually, the message search order comprises a querying condition at least, also multinomial querying condition can be arranged, perhaps represent logical relation between each querying condition with some symbols, for example with or, relation such as non-, realize complex query; Through after above-mentioned the setting, the goal systems of using this query software can be informed the command format of short message enquiry to its user, the user is editing short message and transmission in view of the above, after query software receives note, resolve, draw querying command by the form of above-mentioned setting, in tables of data, inquire about, the Query Result that returns is handled as required, forms the output result, is sent to inquiring user with note.Cordless communication network wherein can adopt the mobile communications network of any support SMS, comprises existing GSM, Personal Handyphone System, 3G network etc.
Further technical scheme, in the step (1) tables of data of information inquiry correspondence obtain the employing deriving method, corresponding tables of data exports to the tables of data of setting form in the information query system of this method with using, as the tables of data of information inquiry correspondence.Promptly, what the goal systems of interface tube did not adopt is any database structure, adopt the query software of this method all it to be carried out the data derivation, the tables of data that forms unified structure is as the corresponding tables of data of inquiry, avoid the different problem of querying command of different system thus, be convenient to carry out the setting of message search command format, make it to have stronger versatility.
Optimized technical scheme, the tables of data of described setting form are the EXCEL table.
Further technical scheme includes username and password in each described message search order.For example, form is: user name-password-command name (condition 1-condition 2-condition 3-condition 4), wherein ,-can substitute with the space, expression option in () is not imported other symbolic representation logical relation between condition.Then this moment, inquiry system can carry out the checking of username and password, and determines user's search access right etc. in view of the above, realizes that thus more complicated query is used.
The present invention is by cordless communication network, inquires about information in the mis system with mobile phone as terminal equipment, compares with existing method, has versatility, shows:
(1) the present invention forms the pairing tables of data of inquiry by obtaining or derive the tables of data in the goal systems, and in conjunction with the predefine of ordering, makes that the goal systems that can inquire about is unrestricted;
(2) but the form Dynamic Definition of querying command.Different goal systems, data name difference, inquiry compound mode difference; Different users should have different search access rights; Effectively query time can be set as required, and all these can realize dynamic setting when adopting this method.
Description of drawings
Fig. 1 is the functional block diagram of the universal messaging breath service platform of the embodiment of the invention one.
Embodiment
Below in conjunction with drawings and Examples the present invention is further described:
Embodiment one: a kind of universal-type information query method based on SMS comprises the following steps:
(1) obtain the tables of data of information inquiry correspondence at server end, the method that adopts data to derive exports as the EXCEL table with this tables of data, as the tables of data that information inquiry is used, extracts field name from the EXCEL structure of data table;
(2) at server end the message search command format is set, comprises user name, password, at least one the querying condition relevant in each described message search order with field name;
(3) user also sends the note that meets the message search command format with the mobile phone editor, and this note is received by server end through cordless communication network;
(4) server end mates parsing according to set message search command format to the note that receives, and obtains querying command;
(5) server end is carried out the data query operation, and Query Result is returned to the inquiry mobile phone with note, realizes the information inquiry based on SMS thus.
Shown in accompanying drawing 1, cease the functional block diagram of service platform for the universal messaging of realizing the present embodiment querying method.Platform feature comprises system's setting, system user, inquiry design management, inquiry log, SMS and help function.Wherein, system is provided with function and is used for importing, configuration, management database; The system user function is used for leading subscriber, encrypted message, authority information etc.; Inquiry design management function is used for being provided with, inquires about, revises the message search command format.
This universal messaging breath service platform can the different MIS management system of interface, realizes that generalization uses.
Embodiment two: based on the system and method for embodiment one, realize the student status information query system based on SMS.
With system and the student status management system interface of embodiment one, import the student status information database, when importing data, should select tables of data earlier, again the field of option table.Many querying commands can be set.
1) querying individual essential information command format:
XH?PASS?JBXX
It is as follows that form is returned in setting:
Dear classmate:
Below be your student status information:
Valuestring (Query Information that representative is returned)
According to the mentioned order form, certain user's first (student number: 00001; Password: 0000), send the querying command note:
00001?0000?JBXX
Inquire about, it is as follows that Query Result returns note:
Dear classmate:
Below be your student status information:
Name: first; Age: 22;
2) querying individual course achievement command format:
XH PASS KC course number
It is as follows that form is returned in setting:
Dear classmate:
Below be the course achievement that you inquire about:
Valuestring (Query Information that representative is returned)
According to the mentioned order form, certain user's first (student number: 00001; Password: 0000, the inquiry course number is 02001), send the querying command note:
00001?0000?KC?02001
Inquire about, it is as follows that Query Result returns note:
Dear classmate:
Below be the course achievement of your inquiry:
Name: first; The achievement of course operating system (02001) is.。。
Embodiment three: based on the system and method for embodiment one, realize the book information inquiry system based on SMS.
With system and the school library's database interface of embodiment one, import the information data table that checks out, querying command is set again.As inquiry be at the command format of borrowing books:
XH?PASS?Bor
It is as follows that form is returned in setting:
Dear classmate:
Below be the book information that you are borrowing:
Valuestring (Query Information that representative is returned)
According to the mentioned order form, certain user's first (student number: 00001; Password: 0000; Borrowed " microeconomics ", " macroeconomics " two books) the transmission note
00001?0000?Bor
Inquire about, it is as follows that Query Result returns note:
Dear classmate:
Below be the book information that you are borrowing:
" microeconomics "; " macroeconomics "
Embodiment four: based on the system and method for embodiment one, realize the OA information query system based on SMS.
With system and the OA of the school database interface of embodiment one, import the announcement information tables of data, querying command is set again.As the notification command form of inquiring about issue one day is:
The XH PASS NOTICE date
It is as follows that form is returned in setting:
Hello.
Below be the XXXX XX announcement information of month XX day:
Valuestring (Query Information that representative is returned)
According to the mentioned order form, certain user's first (job number: 00001; Password: 0000; ) need the inquiry notice on December 1st, 09, send the querying command note:
00001?0000?notice?20090901
Inquire about, it is as follows that Query Result returns note:
Hello.
Below be on 09 01st, 2009 announcement information:
1) 2 pm, each institute holds the working conference that relevant interim quality of instruction is checked to be unit,
2)......。
Claims (4)
1. the universal-type information query method based on SMS is characterized in that comprising the following steps:
(1) obtains the tables of data of information inquiry correspondence at server end, from data list structure, extract field name;
(2) at server end the message search command format is set, comprises a querying condition relevant at least in each described message search order with field name;
(3) user also sends the note that meets the message search command format with the mobile phone editor, and this note is received by server end through cordless communication network;
(4) server end mates parsing according to set message search command format to the note that receives, and obtains querying command;
(5) server end is carried out the data query operation, and Query Result is returned to the inquiry mobile phone with note, realizes the information inquiry based on SMS thus.
2. the universal-type information query method based on SMS according to claim 1, it is characterized in that: the tables of data of information inquiry correspondence obtains the employing deriving method in the step (1), tables of data corresponding in the information query system of application this method is exported to the tables of data of setting form, as the tables of data of information inquiry correspondence.
3. the universal-type information query method based on SMS according to claim 2 is characterized in that: the tables of data of described setting form is the EXCEL table.
4. the universal-type information query method based on SMS according to claim 1 is characterized in that: include username and password in each described message search order.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010159789 CN101835118A (en) | 2010-04-29 | 2010-04-29 | Universal-type information query method based on mobilephone short messages |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 201010159789 CN101835118A (en) | 2010-04-29 | 2010-04-29 | Universal-type information query method based on mobilephone short messages |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN101835118A true CN101835118A (en) | 2010-09-15 |
Family
ID=42719008
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 201010159789 Pending CN101835118A (en) | 2010-04-29 | 2010-04-29 | Universal-type information query method based on mobilephone short messages |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN101835118A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103236901A (en) * | 2013-04-15 | 2013-08-07 | 天脉聚源(北京)传媒科技有限公司 | Method and device for transmitting commands |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1825845A (en) * | 2005-02-25 | 2006-08-30 | 北京中科富星信息技术有限公司 | Universal mobile inquiring method |
| CN1838126A (en) * | 2006-01-11 | 2006-09-27 | 张新波 | Freely-inputted wireless short message matching and search engine information processing method, and apparatus therefor |
| CN101165683A (en) * | 2006-10-19 | 2008-04-23 | 维豪信息技术有限公司 | Heterogeneous different source different platform data integration method and exchange method |
-
2010
- 2010-04-29 CN CN 201010159789 patent/CN101835118A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1825845A (en) * | 2005-02-25 | 2006-08-30 | 北京中科富星信息技术有限公司 | Universal mobile inquiring method |
| CN1838126A (en) * | 2006-01-11 | 2006-09-27 | 张新波 | Freely-inputted wireless short message matching and search engine information processing method, and apparatus therefor |
| CN101165683A (en) * | 2006-10-19 | 2008-04-23 | 维豪信息技术有限公司 | Heterogeneous different source different platform data integration method and exchange method |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103236901A (en) * | 2013-04-15 | 2013-08-07 | 天脉聚源(北京)传媒科技有限公司 | Method and device for transmitting commands |
| CN103236901B (en) * | 2013-04-15 | 2015-11-25 | 天脉聚源(北京)传媒科技有限公司 | A kind of method of transfer instruction and device |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN101159730B (en) | Information processing method, system and device of multimedia affiliation center | |
| CN103763443B (en) | The mobile customer service system of a kind of many communication modes polymerization and method | |
| CA2608581C (en) | Automatic initiation of communications | |
| CN102664871A (en) | Method for processing intelligent terminal address list | |
| CN104113466A (en) | Harassing phone call identification method, client, server and system | |
| CN104123313B (en) | Obtain the method and server of guide to visitors information | |
| EP3057004A1 (en) | Method and apparatus for sharing environment context | |
| CN101505457A (en) | Method for position enquiry by GPS mobile phone | |
| JP4889813B1 (en) | Data brokerage system | |
| CN102103606A (en) | Technology for realizing advanced search of commodities on mobile phone client | |
| KR100876958B1 (en) | A Middleware for Data Communication Between Various Terminals and Application Server and An Operating Method thereof | |
| TW201242392A (en) | System and method for sharing group | |
| KR20020051576A (en) | Method For Transmitting A Short Message Noted With Command Code | |
| CN101835118A (en) | Universal-type information query method based on mobilephone short messages | |
| KR102404144B1 (en) | Method for managing interactive communication and managing server thereof | |
| CN103841508A (en) | User information obtaining method and information aggregation platform | |
| Ding et al. | The case study on service encapsulation for web-based application system | |
| KR20110104448A (en) | Mobile browser phone call method and system using web | |
| KR101129535B1 (en) | Method for transmitting response message in mobile terminal and mobile terminal thereof | |
| KR101704337B1 (en) | Organization-based Social Networking Service System | |
| CN202979291U (en) | Word query system based on short message platform | |
| KR102055260B1 (en) | Apparatus for update profile, method thereof and computer recordable medium storing the method | |
| Zhu et al. | Research on the service encapsulation for web-based system | |
| CN102149053A (en) | Message generating method, setting method and mobile communication device | |
| US20150100641A1 (en) | Communications Method, Apparatus and System for Mobile Devices |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C12 | Rejection of a patent application after its publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20100915 |