CN103678363A - Novel database query system - Google Patents
Novel database query system Download PDFInfo
- Publication number
- CN103678363A CN103678363A CN201210338690.2A CN201210338690A CN103678363A CN 103678363 A CN103678363 A CN 103678363A CN 201210338690 A CN201210338690 A CN 201210338690A CN 103678363 A CN103678363 A CN 103678363A
- Authority
- CN
- China
- Prior art keywords
- database
- gsm module
- query system
- novel
- way connection
- 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/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/23—Updating
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/245—Query processing
- G06F16/2455—Query execution
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computational Linguistics (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a novel database query system. The novel database query system is composed of a campus network (1), a database (2), an upper computer (3), a serial communicator (4), a GSM module (5), an LED panel (6) and a user mobile phone (7). The novel database query system is characterized in that the campus network (1) is connected with the database (2), the upper computer (3) is connected with the database (2) and in two-way connection with the serial communicator (4), the serial communicator (4) is in two-way connection with the GSM module (5), the GSM module (5) and the LED panel (6) are mutually connected, and the GSM module (5) is in two-way connection with the user mobile phone (7). According to the novel database query system, real-time update is achieved, data which can be queried in the database are all latest information, and users can conveniently and quickly query the existing latest information in the database at any time and any place according to their own requirements.
Description
Technical field
The present invention relates to a kind of Database Systems, relate in particular to a kind of Novel database query system.
Background technology
Along with making rapid progress of network technology, the inquiry of campus information and issue also realize by campus network, no matter are teacher or student, can utilize computer to be connected to work nternet, then log in campus network, then search voluntarily needed information.But inquiry mode can not meet teachers and students' demand like this, carry out needed condition more, limitation is more intense, can not accomplish to inquire about anywhere or anytime campus information.For some, need immediate inquiring campus information and the teachers and students of the inquiry of being inconvenient to surf the Net, inquiry is a very thing easily not.
Summary of the invention
In order to solve the problems of the technologies described above, the invention provides a kind of Novel database query system of energy real-time query, this database query system not only can be inquired about student's achievement, school timetable etc., the information having in every database all can conveniently be inquired about, by campus network (1), database (2), host computer (3), serial communication (4), gsm module (5), LED display (6), user mobile phone (7) forms, it is characterized in that campus network is connected with database, described database is connected with host computer, host computer is connected with above-mentioned serial communication is two-way, described serial communication is connected with gsm module is two-way, said GSM module and LED display are connected to each other, said GSM module is connected with described user mobile phone is two-way.
Beneficial effect of the present invention is: system energy real-time update, the data that can inquire about in database are all up-to-date information, and user can be at any time, according to oneself, need to conveniently inquire the up-to-date information having had in database Anywhere.
Accompanying drawing explanation
Fig. 1 is structural drawing of the present invention.
Embodiment
Shown in Fig. 1, campus network (1) is connected with database (2), described database (2) is connected with host computer (3), host computer (3) and two-way connection of above-mentioned serial communication (4), described serial communication (4) and two-way connection of gsm module (5), said GSM module (5) is connected to each other with LED display (6), said GSM module (5) and two-way connection of described user mobile phone (7).
The present invention is a kind of information query system, gsm module (5) is the main hardware module of this system, selected type is that TC35 is the common a kind of model in market, its main task is to read SM card, receive user's request signal, and by module with microcontroller serial port communicate by letter with host computer (3), received information is uploaded to host computer (3).Host computer (3) is after receiving Query Result, from database (2), transfer and need the result of inquiry and feed back to gsm module (5), database (2) can interconnection network, reach the effect of the information of real-time update database (2), host computer (3) is exactly mainly the inquiry of being responsible for data, identify the distant and out of sight inquiry content transmitting from the single-chip microcomputer of gsm module (5) simultaneously, according to content, inquire about accordingly or issue operation, in issue operation, also play the effect to encode Chinese characters for computer.After the Query Result that receives host computer (3), by its content, the power same form by note sends to inquiry to gsm module (5), simultaneously in the information content that shows screen display issue, by the content roll display that will issue, here gsm module (5) is mobile phone with user's communication media, using and only needing message editor to be sent to inquiry system, can receive the short message of Query Result.Display screen is LED screen, can convey a message timely and conveniently.
Claims (1)
1. a Novel database query system, by campus network (1), database (2), host computer (3), serial communication (4), gsm module (5), LED display (6), user mobile phone (7) forms, it is characterized in that campus network (1) is connected with database (2), described database (2) is connected with host computer (3), host computer (3) and two-way connection of above-mentioned serial communication (4), described serial communication (4) and two-way connection of gsm module (5), said GSM module (5) is connected to each other with LED display (6), said GSM module (5) and two-way connection of described user mobile phone (7).
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210338690.2A CN103678363A (en) | 2012-09-14 | 2012-09-14 | Novel database query system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201210338690.2A CN103678363A (en) | 2012-09-14 | 2012-09-14 | Novel database query system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103678363A true CN103678363A (en) | 2014-03-26 |
Family
ID=50315954
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201210338690.2A Pending CN103678363A (en) | 2012-09-14 | 2012-09-14 | Novel database query system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103678363A (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110223627A (en) * | 2019-05-17 | 2019-09-10 | 海纳巨彩(深圳)实业科技有限公司 | A kind of LED outdoor energy-saving screen control system based on big data |
-
2012
- 2012-09-14 CN CN201210338690.2A patent/CN103678363A/en active Pending
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110223627A (en) * | 2019-05-17 | 2019-09-10 | 海纳巨彩(深圳)实业科技有限公司 | A kind of LED outdoor energy-saving screen control system based on big data |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| Ketkar et al. | GSM mobile phone based led scrolling message display system | |
| CN202549126U (en) | Digital teaching platform for Internet of things | |
| CN104853023A (en) | Distribution method and system for electronic business card | |
| CN204596216U (en) | A kind of network multi-broadcast to clone | |
| CN103678363A (en) | Novel database query system | |
| CN202758351U (en) | Novel database inquiring system | |
| CN204010621U (en) | A kind of sight spot explains orally equipment | |
| CN102595311A (en) | Geographical position information layering-based network knowledge output method and system | |
| CN206058583U (en) | A kind of Remote Education System Based On Internet | |
| CN202025319U (en) | Information inquiry system | |
| CN102542033A (en) | Novel database query system | |
| CN103824512A (en) | Electronic information guide identity | |
| CN105989755A (en) | Classroom teaching process data collector | |
| CN202736044U (en) | Resource real-time query system of college study room | |
| CN206451239U (en) | A kind of Digital Campus information system | |
| CN205540685U (en) | School timetable display system based on wireless LAN | |
| CN202617165U (en) | Intelligent interaction satellite positioning system | |
| CN204576582U (en) | A kind of interactive educational management system | |
| CN201114593Y (en) | Wireless sensing network experimental system | |
| CN204102195U (en) | Calling device | |
| CN207335728U (en) | Books in libraries route alignment system | |
| CN204808395U (en) | Teaching and administrative staff management system that electronizes | |
| CN106251718B (en) | A kind of teaching application system | |
| CN202488442U (en) | Pluggable wireless transceiver card with proprietary definition | |
| CN203149879U (en) | Computer teaching control system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |
Application publication date: 20140326 |