CN103425792A - Interaction method, device and system for teaching affair administration - Google Patents
Interaction method, device and system for teaching affair administration Download PDFInfo
- Publication number
- CN103425792A CN103425792A CN2013103824013A CN201310382401A CN103425792A CN 103425792 A CN103425792 A CN 103425792A CN 2013103824013 A CN2013103824013 A CN 2013103824013A CN 201310382401 A CN201310382401 A CN 201310382401A CN 103425792 A CN103425792 A CN 103425792A
- Authority
- CN
- China
- Prior art keywords
- user
- teaching management
- logon information
- module
- information
- 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 an interaction method, a device and a system for teaching affair administration, belonging to the technical field of computers. The method comprises the following steps: starting a teaching affair administration module, and displaying a user login interface for a user to input login information; after the user inputs the login information, matching the login information input by the user with login information in a created user login table; if matching is successful, entering a teaching affair administration operation page, and displaying a corresponding running process of the operation for the user via the teaching affair administration operation page according to basic operation triggered by the user; adding a data inquiry view and displaying via the teaching affair administration page for the user to directly call the view for inquiring. The device comprises a starting module, a verification module, an operating module and a view inquiry module. The system comprises a plurality of interaction devices. According to the method, the device and the system, a teaching affair administration platform is established, so that guidance on a back ground operating process provided by foreground operation can be seen visually.
Description
Technical field
The present invention relates to field of computer technology, particularly a kind of exchange method of teaching management, Apparatus and system.
Background technology
SQL Server (StructuredQueryLanguage, the structuralized query voice) be a kind of syntax that data in relational database are defined and operate, the industrial standard of supporting for most of relational database management systems, it is one of current Large-scale Relational Database, application also very extensively, along with being widely used of SQL Server.
At present, to the teaching management of SQL Server, be generally to take independently to use that to take the ABC of database be carrier, adopt again programming, this makes the management of SQL Server educational administration relatively independent, be unfavorable for student's understanding when database is combined with the programming teaching management, also make the user can't understand the relation in SQL Server and real work.
Summary of the invention
For the management that solves SQL Server educational administration relatively independent, when being combined with the programming teaching management, database is unfavorable for student's understanding, also make the user can't understand the problem of the relation in SQL Server and real work, the embodiment of the present invention provides a kind of exchange method, Apparatus and system of teaching management.Described technical scheme is as follows:
First aspect, provide a kind of exchange method of teaching management, and described method comprises:
Start the teaching management module, and show user's log-in interface, for the user, input logon information;
After the user inputs logon information, whether the logon information of described user input is mated with the logon information that the user who has created logs in table;
After the match is successful, enter the teaching management operation pages, the basic operation triggered according to the user, show the corresponding operational process of described operation by described teaching management operation pages to described user, and described basic operation comprises: increase operation, deletion action, retouching operation and search operation; Described operational process refers to by triggering described basic operation the change procedure of the corresponding SQL statement runnable interface of described basic operation and back-end data is shown by the described teaching management page;
Add the data query view, and shown by the described teaching management page, for the user, directly call view and inquired about.
Preferably, described startup teaching management module, and show user's log-in interface, input logon information for the user and also comprise before:
Teaching management module and background data base connected and be configured, show the layoutprocedure that is connected of described teaching management module and background data base, setting up user's logon information, user's logon information is carried out to typing, completing user logs in the establishment of table.
Preferably, described after the user inputs logon information, whether the logon information of described user input is mated with the logon information that the user who has created logs in table, specifically comprise:
After the logon information of user's input, judge user name in the logon information of described user input according to the logon information in the user's log form created and log in password and whether mate, when described user name with log in password when coupling, operate accordingly, otherwise demonstration logs in failure information.
Preferably, described interpolation data query view, and shown by the described teaching management page, for the user, directly call view and inquired about, also comprise:
Create index, at described teaching management page input index statement, obtain indexed results, and shown by described teaching management operation pages.
Preferably, described method also comprises:
Automatically upgrade statement and set up respectively that corresponding trigger creates information reminding and account is upgraded automatically by storage information reminding and account, and show by the teaching management page process that described information reminding and account are upgraded automatically.
Second aspect, provide a kind of interactive device of teaching management, and described device comprises:
Start module, for starting the teaching management module, and show user's log-in interface, for the user, input logon information;
Whether authentication module, after as the user, inputting logon information, mated the logon information of described user input with the logon information that the user who has created logs in table;
Operational module, for after the match is successful, enter the teaching management operation pages, the basic operation triggered according to the user, show the corresponding operational process of described operation by described teaching management operation pages to described user, described basic operation comprises: increase operation, deletion action, retouching operation and search operation; Described operational process refers to by triggering described basic operation the change procedure of the corresponding SQL statement runnable interface of described basic operation and back-end data is shown by the described teaching management page;
The view query module, for adding the data query view, and shown by the described teaching management page, for the user, directly calls view and inquired about.
Preferably, described device also comprises:
Creation module, for teaching management module and background data base are connected and are configured, show the layoutprocedure that is connected of described teaching management module and background data base, set up user's logon information, user's logon information is carried out to typing, and completing user logs in the establishment of table.
Preferably, described authentication module specifically for the logon information when user input after, judge user name in the logon information of described user input according to the logon information in the user's log form created and log in password and whether mate, when described user name with log in password when coupling, operate accordingly, otherwise demonstration logs in failure information.
Preferably, described view query module, also for creating index, at described teaching management page input index statement, obtains indexed results, and is shown by described teaching management operation pages.
Preferably, described device comprises prompting module, for automatically upgrading statement by storage information reminding and account and setting up respectively that corresponding trigger creates information reminding and account is upgraded automatically, and show by the teaching management page process that described information reminding and account are upgraded automatically.
The third aspect, the invention provides a kind of interactive system of teaching management, comprises arbitrary interactive device that several are described above.
The beneficial effect that the technical scheme that the embodiment of the present invention provides is brought is:
By take all knowledge points that SQL Server database comprised, it is carrier, the interface operation that foreground is completed is arranged to the EXE executable file, double-click this file, the learner can see good human-computer interaction interface, what next need the learner to complete is, complete step by step exploitation and the operation of database, and see operating effect intuitively by the interface on foreground, can allow the learner realize the globality of project, know after completing each step operation simultaneously, can see intuitively that each operation is for the effect of a complete system and the effect reached, after having created database, after having created table, even the learner is without any software programming knowledge, also can be totally independent of other subject, independent learning database system.
The accompanying drawing explanation
In order to be illustrated more clearly in the technical scheme in the embodiment of the present invention, in below describing embodiment, the accompanying drawing of required use is briefly described, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, under the prerequisite of not paying creative work, can also obtain according to these accompanying drawings other accompanying drawing.
The exchange method process flow diagram of a kind of teaching management that Fig. 1 provides for the embodiment of the present invention one;
Fig. 2 is that the user logs in unsuccessfully examples of interfaces figure;
Fig. 3 is the examples of interfaces figure that adds operation;
Fig. 4 is the examples of interfaces figure of inquiry view;
Fig. 5 is the examples of interfaces figure that creates user's log form;
The interactive device structural drawing of a kind of teaching management that Fig. 6 provides for the embodiment of the present invention two;
The interactive device structural drawing of the another kind of teaching management that Fig. 7 provides for the embodiment of the present invention two;
The interactive device structural drawing of another teaching management that Fig. 8 provides for the embodiment of the present invention two.
Embodiment
For making the purpose, technical solutions and advantages of the present invention clearer, below in conjunction with accompanying drawing, embodiment of the present invention is described further in detail.
Embodiment mono-
The embodiment of the present invention one provides a kind of exchange method of teaching management, and as shown in Figure 1, described method comprises:
Step 101: start the teaching management module, and show user's log-in interface, for the user, input logon information.
Step 102: after the user inputs logon information, whether the logon information of described user input is mated with the logon information that the user who has created logs in table.
Particularly, described step 102 specifically comprises:
After the logon information of user's input, judge user name in the logon information of described user input according to the logon information in the user's log form created and log in password and whether mate, when described user name with log in password when coupling, operate accordingly, otherwise demonstration logs in failure information;
When the user logs in table and do not create, login system can be pointed out error message, and for example, prompting logs in failure information as shown in Figure 2.
Step 103: after the match is successful, enter the teaching management operation pages, the basic operation triggered according to the user, show the corresponding operational process of described operation by described teaching management operation pages to described user.
Wherein, described basic operation comprises: increase operation, deletion action, retouching operation and search operation; Described operational process refers to by triggering described basic operation the change procedure of the corresponding SQL statement runnable interface of described basic operation and back-end data is shown by the described teaching management page;
For example, by the surface chart that described basic operation is operated, the interpolation user of take is example, as shown in Figure 3, interpolation user function in selecting function menu, can show on the top on right side the SQL statement that current interpolation operates, and shows the variation of data in the table of lower right side.
Step 104: add the data query view, and shown by the described teaching management page, for the user, directly call view and inquired about.
Wherein, described data query view refers on the basis of query statement sets up view, and directly calls view and inquired about;
For example, look for example with statistical information, while carrying out the statistical information inquiry, when running into the income type statistics, corresponding code is as follows: select project name=b.shouzhilx, number of times=count (a.lxbianhao), total=sum (JiaoyiJE) from ShouzhiMX as a inner join leixing as b on a.LXBianhao=b.LXBianhao where JiaoyiSJ Between'2010-1-1'and'2010-1216'and b.shouzhi=' income ' Group By b.shouzhilx; As shown in Figure 4,
From above-mentioned query statement, can find out, statement itself is long.If need to often check such information, will repeat to input this inquiry, this is obviously cumbersome.If plan to reuse in some way, except used statement being saved in to the disk file China and foreign countries in query analyzer, can also on the basis of query statement, set up view, thereby simplify query manipulation.By the teaching management platform, complete establishment and the associative operation of view, directly call view and inquired about, for the function of user's intuitivism apprehension view.
In conjunction with above-mentioned embodiment, before described step 101, also comprise:
Teaching management module and background data base connected and be configured, show the layoutprocedure that is connected of described teaching management module and background data base, setting up user's logon information, user's logon information is carried out to typing, completing user logs in the establishment of table.
Wherein, can create user's log form according to the method for knowledge, as shown in Figure 5, the user logs in table and comprises: the information such as user name, sequence number, user cipher and authority.
In conjunction with above-mentioned embodiment, described step 104 also comprises:
Create index, at described teaching management page input index statement, obtain indexed results, and shown by described teaching management operation pages.
Particularly, for example, at product, show, data more than 1,000 ten thousand are arranged, and the field of the inside has pid, pname (ProductName), pcontent (product is introduced in detail), pimage (product picture), userid (user of issue), we inquire the product sum of certain user's issue in the product table by SQL statement now.Open teaching platform, the following statement operation of input in SQL statement:
select?count(*)from?product?where?userid=10000
By system timer, at 63.678908 seconds, shown operation result.
Use another method, first in platform, create index:
CREATE?INDEX?index_product?ON?product([userid])
And then move following SQL statement:
select?count(*)from?product?where?userid=10000
By system timer, at 0.934947 second, moved, show result working time.
In conjunction with above-mentioned all modes, described method also comprises:
Automatically upgrade statement and set up respectively that corresponding trigger creates information reminding and account is upgraded automatically by storage information reminding and account, and show by the teaching management page process that described information reminding and account are upgraded automatically.
The embodiment of the present invention is carrier by take all knowledge points that the SQLServer database comprised, the interface operation that foreground is completed is arranged to the EXE executable file, double-click this file, the learner can see good human-computer interaction interface, what next need the learner to complete is, complete step by step exploitation and the operation of database, and see operating effect intuitively by the interface on foreground, can allow the learner realize the globality of project, know after completing each step operation simultaneously, can see intuitively that each operation Du is for the effect of a complete system and the effect reached, after having created database, after having created table, even the learner is without any software programming knowledge, also can be totally independent of other subject, independent learning database system.
Embodiment bis-
The embodiment of the present invention two provides a kind of interactive device of teaching management, and as shown in Figure 6, described device comprises:
Whether authentication module 602, after as the user, inputting logon information, mated the logon information of described user input with the logon information that the user who has created logs in table;
Wherein, described authentication module 602 specifically for the logon information when user input after, judge user name in the logon information of described user input according to the logon information in the user's log form created and log in password and whether mate, when described user name with log in password when coupling, operate accordingly, otherwise demonstration logs in failure information.
Described basic operation comprises: increase operation, deletion action, retouching operation and search operation; Described operational process refers to by triggering described basic operation the change procedure of the corresponding SQL statement runnable interface of described basic operation and back-end data is shown by the described teaching management page;
Particularly, described view query module 604, also for creating index, at described teaching management page input index statement, obtains indexed results, and is shown by described teaching management operation pages.
In conjunction with said apparatus, as shown in Figure 7, described device also comprises:
In conjunction with said apparatus, as described in Figure 8, described device also comprises:
Prompting module 801, for automatically upgrading statement by storage information reminding and account and setting up respectively that corresponding trigger creates information reminding and account is upgraded automatically, and show by the teaching management page process that described information reminding and account are upgraded automatically.
The embodiment of the present invention is carrier by take all knowledge points that the SQLServer database comprised, the interface operation that foreground is completed is arranged to the EXE executable file, double-click this file, the learner can see good human-computer interaction interface, what next need the learner to complete is, complete step by step exploitation and the operation of database, and see operating effect intuitively by the interface on foreground, can allow the learner realize the globality of project, know after completing each step operation simultaneously, can see intuitively that each operation Du is for the effect of a complete system and the effect reached, after having created database, after having created table, even the learner is without any software programming knowledge, also can be totally independent of other subject, independent learning database system.
The invention described above embodiment sequence number, just to describing, does not represent the quality of embodiment.
One of ordinary skill in the art will appreciate that all or part of step that realizes above-described embodiment can complete by hardware, also can come the hardware that instruction is relevant to complete by program, described program can be stored in a kind of computer-readable recording medium, the above-mentioned storage medium of mentioning can be ROM (read-only memory), disk or CD etc.
The foregoing is only preferred embodiment of the present invention, in order to limit the present invention, within the spirit and principles in the present invention not all, any modification of doing, be equal to replacement, improvement etc., within all should being included in protection scope of the present invention.
Claims (11)
1. the exchange method of a teaching management, is characterized in that, described method comprises:
Start the teaching management module, and show user's log-in interface, for the user, input logon information;
After the user inputs logon information, whether the logon information of described user input is mated with the logon information that the user who has created logs in table;
After the match is successful, enter the teaching management operation pages, the basic operation triggered according to the user, show the corresponding operational process of described operation by described teaching management operation pages to described user, and described basic operation comprises: increase operation, deletion action, retouching operation and search operation; Described operational process refers to by triggering described basic operation the change procedure of the corresponding SQL statement runnable interface of described basic operation and back-end data is shown by the described teaching management page;
Add the data query view, and shown by the described teaching management page, for the user, directly call view and inquired about.
2. method according to claim 1, is characterized in that, described startup teaching management module, and show user's log-in interface, input logon information for the user and also comprise before:
Teaching management module and background data base connected and be configured, show the layoutprocedure that is connected of described teaching management module and background data base, setting up user's logon information, user's logon information is carried out to typing, completing user logs in the establishment of table.
3. method according to claim 1, is characterized in that, described after the user inputs logon information, and whether the logon information of described user input is mated with the logon information that the user who has created logs in table, specifically comprises:
After the logon information of user's input, judge user name in the logon information of described user input according to the logon information in the user's log form created and log in password and whether mate, when described user name with log in password when coupling, operate accordingly, otherwise demonstration logs in failure information.
4. method according to claim 1, is characterized in that, described interpolation data query view, and shown by the described teaching management page, for the user, directly call view and inquired about, also comprise:
Create index, at described teaching management page input index statement, obtain indexed results, and shown by described teaching management operation pages.
5. according to the described method of claim 1-4, it is characterized in that, described method also comprises:
Automatically upgrade statement and set up respectively that corresponding trigger creates information reminding and account is upgraded automatically by storage information reminding and account, and show by the teaching management page process that described information reminding and account are upgraded automatically.
6. the interactive device of a teaching management, is characterized in that, described device comprises:
Start module, for starting the teaching management module, and show user's log-in interface, for the user, input logon information;
Whether authentication module, after as the user, inputting logon information, mated the logon information of described user input with the logon information that the user who has created logs in table;
Operational module, for after the match is successful, enter the teaching management operation pages, the basic operation triggered according to the user, show the corresponding operational process of described operation by described teaching management operation pages to described user, described basic operation comprises: increase operation, deletion action, retouching operation and search operation; Described operational process refers to by triggering described basic operation the change procedure of the corresponding SQL statement runnable interface of described basic operation and back-end data is shown by the described teaching management page;
The view query module, for adding the data query view, and shown by the described teaching management page, for the user, directly calls view and inquired about.
7. device according to claim 6, is characterized in that, described device also comprises:
Creation module, for teaching management module and background data base are connected and are configured, the layoutprocedure that is connected that shows described teaching management module and background data base, teaching management module and background data base are connected and be configured, the layoutprocedure that is connected that shows described teaching management module and background data base, set up user's logon information, user's logon information is carried out to typing, completing user logs in the establishment of table.
8. device according to claim 6, it is characterized in that, described authentication module specifically for the logon information when user input after, judge user name in the logon information of described user input according to the logon information in the user's log form created and log in password and whether mate, when described user name with log in password when coupling, operate accordingly, otherwise demonstration logs in failure information.
9. device according to claim 6, is characterized in that, described view query module, also for creating index, at described teaching management page input index statement, obtains indexed results, and shown by described teaching management operation pages.
10. according to the described device of claim 6-9, it is characterized in that, described device comprises prompting module, for automatically upgrading statement by storage information reminding and account and setting up respectively that corresponding trigger creates information reminding and account is upgraded automatically, and show by the teaching management page process that described information reminding and account are upgraded automatically.
11. the interactive system of a teaching management, is characterized in that, comprises the described arbitrary interactive device of several the claims 6-10.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013103824013A CN103425792A (en) | 2013-08-28 | 2013-08-28 | Interaction method, device and system for teaching affair administration |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN2013103824013A CN103425792A (en) | 2013-08-28 | 2013-08-28 | Interaction method, device and system for teaching affair administration |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103425792A true CN103425792A (en) | 2013-12-04 |
Family
ID=49650529
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN2013103824013A Pending CN103425792A (en) | 2013-08-28 | 2013-08-28 | Interaction method, device and system for teaching affair administration |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103425792A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105511870A (en) * | 2015-12-01 | 2016-04-20 | 国网北京市电力公司 | Interface prompting method and device |
| CN110941650A (en) * | 2019-11-22 | 2020-03-31 | 北京雅丁信息技术有限公司 | Medical data statistical query system and method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1619558A (en) * | 2003-11-19 | 2005-05-25 | 英业达股份有限公司 | Network education system of combining teaching and educational administration and its method |
| US20070282869A1 (en) * | 2006-06-05 | 2007-12-06 | Microsoft Corporation | Automatically generating web forms from database schema |
| CN101968786A (en) * | 2009-07-28 | 2011-02-09 | 英业达股份有限公司 | System for inquiring vocabulary example sentence and method thereof |
-
2013
- 2013-08-28 CN CN2013103824013A patent/CN103425792A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1619558A (en) * | 2003-11-19 | 2005-05-25 | 英业达股份有限公司 | Network education system of combining teaching and educational administration and its method |
| US20070282869A1 (en) * | 2006-06-05 | 2007-12-06 | Microsoft Corporation | Automatically generating web forms from database schema |
| CN101460950A (en) * | 2006-06-05 | 2009-06-17 | 微软公司 | Automatically generating WEB forms from database schema |
| CN101968786A (en) * | 2009-07-28 | 2011-02-09 | 英业达股份有限公司 | System for inquiring vocabulary example sentence and method thereof |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105511870A (en) * | 2015-12-01 | 2016-04-20 | 国网北京市电力公司 | Interface prompting method and device |
| CN110941650A (en) * | 2019-11-22 | 2020-03-31 | 北京雅丁信息技术有限公司 | Medical data statistical query system and method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US11347779B2 (en) | User interface for regular expression generation | |
| CN108829378A (en) | A kind of development approach of application software, device and electronic equipment | |
| CN105827438A (en) | Method for setting APN automatically | |
| CN105184552A (en) | Enterprise management process optimization method based on voice command control | |
| US10095608B2 (en) | Application test automation transmitting data via phone/voice calls | |
| US20220276882A1 (en) | Artificial intelligence based systems and methods for autonomously generating customer service help guides with integrated graphical components and for autonomously error-checking knowledge base support resources | |
| Yu | Matlab programming environment based on web | |
| CN105955746B (en) | A kind of method and device of version management | |
| CN103425792A (en) | Interaction method, device and system for teaching affair administration | |
| US10135684B2 (en) | Differential staging of devices in bulk enrollment | |
| CN107944288B (en) | Data access control method and device | |
| CN112988165A (en) | Kubernetes-based interactive modeling method and device, electronic equipment and storage medium | |
| CN109597824A (en) | The efficient write method of SQL statement | |
| CN109754805A (en) | A kind of the voice input method and platform of production operation process | |
| CN108964990A (en) | Implementor name display methods and device in a kind of multiple equipment management system | |
| CN116232910A (en) | Open cloud platform, construction method thereof and storage medium | |
| CN104735072A (en) | Method and device for logging in user account | |
| CN114297057A (en) | Design and use method of automatic test case | |
| EP2075691B1 (en) | A Framework for building an executable scheme | |
| CN112667200A (en) | Artificial intelligence application service software development terminal | |
| CN109257233A (en) | A kind of configuration method of node node equipment in communication system | |
| CN115858049B (en) | RPA flow componentization arrangement method, device, equipment and medium | |
| CN115952376B (en) | Webpage access method and device, electronic equipment and storage medium | |
| CN117504297A (en) | Object editing method and device | |
| Naik | Learning Linux Shell Scripting: Leverage the power of shell scripts to solve real-world problems |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20131204 |
|
| RJ01 | Rejection of invention patent application after publication |