CN105260967A - WEB-based educational institution management system and data operation method thereof - Google Patents
WEB-based educational institution management system and data operation method thereof Download PDFInfo
- Publication number
- CN105260967A CN105260967A CN201510852680.4A CN201510852680A CN105260967A CN 105260967 A CN105260967 A CN 105260967A CN 201510852680 A CN201510852680 A CN 201510852680A CN 105260967 A CN105260967 A CN 105260967A
- Authority
- CN
- China
- Prior art keywords
- information
- module
- student
- page
- employment
- 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
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a WEB-based educational institution management system, which comprises a front-end demonstration module and a background management module, wherein the front-end demonstration module generates a detail page by using a FreeMarker template and demonstrates data in the form of an HTML page; the background management module comprises a school management module, a student management module, an employment management module and a course management module; the school management module comprises a campus news module, a certificate management module, a qualified teacher management, a leaflet page management module and a question and answer management module; the student management module comprises a student information module and a student work module; the employment management module comprises an employed student module, an employment information module and a famous enterprise recommendation module; and the course management module comprises a course opening information module, a course module and a popular technology information module. The WEB-based educational institution management system is low in development cost, is convenient for a manager to manage website data dynamically, and can demonstrate information of the educational institution in all aspects to the viewers in a comprehensive and beautiful manner.
Description
Technical field
the present invention relates to a kind of educational institution management system, relate to a kind of cost of development is cheap, be easy to maintenance the educational institution's management system based on WEB and data manipulation method thereof particularly.
Background technology
along with the universal of computing machine and the fast development of internet, people can in the various relevant information oneself needed of locate line.Meanwhile, Ge Suo educational institution in order to allow numerous people can on network more detailed understanding mechanism, set up the organization web of oneself one after another thus reach the most direct propaganda objective.
but some school informations or Teachers Information often can only simply be shown in some current educational institution websites.The information of education can not be shown comprehensively, the people in area can not be allowed comparatively comprehensively to understand mechanism, and the synchronism on front page layout and backstage is poor.
Summary of the invention
for above-mentioned technical matters, the present invention seeks to: a kind of educational institution's management system based on WEB is provided, cost of development is cheap, not only can facilitate keeper's dynamic management website data, more comparatively comprehensive, attractive in appearance for educational institution's each side information can be showed viewer.
technical scheme of the present invention is:
based on educational institution's management system of WEB, it is characterized in that, comprise front end display module and Back Administration Module, described Back Administration Module comprises school control's module, course management module, student management module and employment management module;
described school control module comprises school district news template, certificate management module, teacher's management module and promotional pamphlet page management module; For managing the school district news information in the news template of school district, comprising increase, deleting and amendment school district news information; For managing the certificate information in certificate management module, comprising increase, deleting and amendment certificate information; For managing the teacher's information in teacher's management module, comprising increase, deleting and amendment teacher's information; For managing the page information in promotional pamphlet page management module, comprising increase, deleting and amendment page information;
described course management module comprises out a class information module, curriculum module and hot technology information module; Manage for the class's of the opening information in the class's of splitting information module, comprise increase, deletion and amendment and open a class information, screen according to affiliated course and state of classes; For managing the curriculum information in curriculum module, comprising increase, deleting and amendment curriculum information; For managing hot technology information in hot technology information module, comprising increase, deleting and amendment hot technology information, screening according to affiliated course;
described student management module comprises information of trainee module and student's works module, for managing the information of trainee in information of trainee module, comprising increase, deleting and amendment information of trainee; For managing the student's works information in student's works module, comprising increase, deleting and amendment student works information;
described employment management module comprises employment student module, employment information module and famous enterprise's recommending module, for managing the employment information of trainee in employment student module, comprising increase, deleting and amendment employment information of trainee; For managing the employment information in employment information module, comprising increase, deleting and amendment employment information; For managing the company information in famous enterprise's recommending module, comprising increase, deleting and amendment company information;
described front end display module, uses FreeMarker template generation details page with html page form display data, comprises broadcasting special efficacy, and in details page and list page, catalogue module floats display.
preferably, described school control module also comprises question and answer administration module, for managing the question and answer information of the visitor in question and answer administration module, comprising increase, deleting and amendment question and answer information, screen according to question and answer type.
preferably, described promotional pamphlet page management module can also arrange single page to the picture of page information and show or carousel displaying, and whether foundation is that carousel picture or single page picture screen.
preferably, described Back Administration Module also comprises system management module, for management system keeper and Information issued person's role-security, described Information issued person is used for editor and the issue of information, described system manager is used for managing system user information, comprise increase, delete, revise and search user profile, check Log daily record.
preferably, the role that described system comprises for the Role Information of storage system user shows, for the user message table of storing subscriber information, for the menu of memory function information, for storing the role-security table of role-security information, for storing the log sheet of Operation Log, for storing the news table of school district news information, for the certificate information table of Store Credentials information, for storing the promotional pamphlet page information table of promotional pamphlet page information, for storing teacher's table of teacher's information, for storing the question and answer information table of question and answer information, for storing the employment information table of employment information, for storing the employment information of trainee table of employment information of trainee, for storing the company information table of company information, for storing student's action message table of student's action message, for storing student's works information table of student's works information, for storing out the class's of opening information table of class information, for storing the curriculum information table of curriculum information, for storing the hot technology information table of hot technology information.
the invention also discloses a kind of data manipulation method based on the described educational institution's management system based on WEB, it is characterized in that, comprise the following steps:
s01: use MyBatis framework technology configuration data library information;
s02: for java entity class set up by table in database, create the interface to entity class data manipulation, and in xml configuration file, mapping relations are set up to entity class attribute and Database field, and be interface method splicing SQL statement;
s03: encapsulate further the interface layer of entity class data manipulation, creates each business logical operation method;
s04: encapsulation business logical operation method further, configures the redirect of the page and the data transmission of AM/BAM in struts configuration file.
compared with prior art, advantage of the present invention is:
1, the page uses JSP technology to carry out writing and obtaining back-end data, then JSP is converted to the html page of display with FreeMarker mould plate technique, realizes all special efficacys on the page with JS, JQuery technology.Backstage adopts J2EE technology, uses SSM framework greatly improve development efficiency and complete required function.
2, this system comparatively comprehensively introduces the various aspects of educational institution to people, has front page layout comparatively reasonable, attractive in appearance, can attract viewer.All data are classified, concluded typesetting, sums up school's module, student's module, employment module, curriculum module four modules.The design of background management system simplifies the operation of keeper, avoids keeper's direct control database, but with the form of the visualized graphs page, the data of modules in database are added, revise, the operation such as deletion.Cost of development is cheap, is easy to safeguard.
Accompanying drawing explanation
below in conjunction with drawings and Examples, the invention will be further described:
fig. 1 is the functional block diagram of the Back Administration Module of the educational institution's management system that the present invention is based on WEB;
fig. 2 is the data manipulation method process flow diagram of the educational institution's management system that the present invention is based on WEB.
Embodiment
for making the object, technical solutions and advantages of the present invention clearly understand, below in conjunction with embodiment also with reference to accompanying drawing, the present invention is described in more detail.Should be appreciated that, these describe just exemplary, and do not really want to limit the scope of the invention.In addition, in the following description, the description to known features and technology is eliminated, to avoid unnecessarily obscuring concept of the present invention.
embodiment:
as shown in Figure 1, a kind of educational institution's management system based on WEB, comprise front end display module and Back Administration Module, described front end display module, use FreeMarker template generation details page with html page form display data, comprise broadcasting special efficacy, in details page and list page, catalogue module floats display; Described Back Administration Module comprises school control's module, course management module, student management module and employment management module.
back Administration Module by logining administration module, user login interface input account number cipher login back-stage management interface; User can revise oneself password; Different authorities is given according to user role, wherein Information issued person can operate campus administration, course management, student management, all data of these modules of employment management, and system manager not only has these authorities, can also manage system, create user and distribute role and check User operation log.
school control's module comprises school district news template, certificate management module, teacher's management module, question and answer administration module and promotional pamphlet page management module; For managing the school district news information in the news template of school district, comprising increase, deleting and amendment school district news information, according to whether top set carries out the operations such as screening; For managing the certificate information in certificate management module, comprising increase, deleting and amendment certificate information; For managing the teacher's information in teacher's management module, comprising increase, deleting and amendment teacher's information; For managing the page information in promotional pamphlet page management module, comprising increase, deleting and amendment page information, can also arrange single page to the picture of page information and show or carousel displaying, whether foundation is that carousel picture or single page picture screen; For managing the question and answer information of the visitor in question and answer administration module, comprising increase, deleting and amendment question and answer information, screening according to question and answer type.
course management module comprises out a class information module, curriculum module and hot technology information module; Manage for the class's of the opening information in the class's of splitting information module, comprise increase, deletion and amendment and open a class information, screen according to affiliated course and state of classes; For managing the curriculum information in curriculum module, comprising increase, deleting and amendment curriculum information; For managing hot technology information in hot technology information module, comprising increase, deleting and amendment hot technology information, screening according to affiliated course;
student management module comprises information of trainee module and student's works module, for managing the information of trainee in information of trainee module, comprising increase, deleting and amendment information of trainee; For managing the student's works information in student's works module, comprising increase, deleting and amendment student works information;
employment management module comprises employment student module, employment information module and famous enterprise's recommending module, for managing the employment information of trainee in employment student module, comprising increase, deleting and amendment employment information of trainee; For managing the employment information in employment information module, comprising increase, deleting and amendment employment information; For managing the company information in famous enterprise's recommending module, comprising increase, deleting and amendment company information, according to whether top set carries out the operations such as screening;
back Administration Module also comprises system management module, for management system keeper and Information issued person's role-security, described Information issued person is used for editor and the issue of information, described system manager is used for managing system user information, comprise increase, delete, revise and search user profile, check Log daily record.
the page uses JSP technology to carry out writing and obtaining back-end data, with FreeMarker mould plate technique, JSP is being converted to the html page of display, is realizing all special efficacys on the page with JS, JQuery technology.Backstage adopts J2EE technology, uses SSM framework greatly improve development efficiency and complete required function.
the role that system comprises for the Role Information of storage system user shows, for the user message table of storing subscriber information, for the menu of memory function information, for storing the role-security table of role-security information, for storing the log sheet of Operation Log, for storing the news table of school district news information, for the certificate information table of Store Credentials information, for storing the promotional pamphlet page information table of promotional pamphlet page information, for storing teacher's table of teacher's information, for storing the question and answer information table of question and answer information, for storing the employment information table of employment information, for storing the employment information of trainee table of employment information of trainee, for storing the company information table of company information, for storing student's action message table of student's action message, for storing student's works information table of student's works information, for storing out the class's of opening information table of class information, for storing the curriculum information table of curriculum information, for storing the hot technology information table of hot technology information.The corresponding entity class of each tables of data.Each database table format is as follows:
a) role's table, roles shows: the different role of storage system user, and whether the field wherein comprised has role to number, role's title, creation-time, founder, last modification time, enable, and wherein role's numbering is major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| ID | Role numbers | Be | Number | 6 | Not null | Unique identification |
| roleName | Role's title | No | Varchar2 | 100 | ||
| creationTime | Creation-time | No | Date | Not null | ||
| createdBy | Founder | No | Varchar2 | 50 | ||
| lastUpdateTime | Last modification time | No | Date | |||
| isStrat | Whether enable | No | Number | 1 | 1 for enabling, and 0 for not enable |
b) user message table, users shows: the table of poke system user information, and whether the field wherein comprised has Customs Assigned Number, role's numbering, user alias, user name, password, creation-time, finally logins time, founder, last modification time, enables.Wherein Customs Assigned Number is major key, and role's numbering is external key, shows id field with reference to roles.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| id | Customs Assigned Number | Be | Number | 6 | Not null | Unique identification |
| rol_id | Role numbers | No | Number | 6 | Not null | External key, association roles table |
| userCode | User alias | No | Varchar2 | 50 | ||
| userName | User name | No | Varchar2 | 100 | Not null | |
| userPasswork | Password | No | Varchar2 | 50 | Not null | |
| creationTime | Creation-time | No | Date | Not null | ||
| lastLoginTime | Finally login the time | No | Date | Not null | ||
| createdBy | Founder | No | Varchar2 | 50 | ||
| lastUpdateTime | Last modification time | No | Date | |||
| isStart | Whether enable | No | Number | 1 | 1 for enabling, and 0 for not enable, and default value is 1 |
c) menu, functions shows: for storing all functions information.Whether the field wherein comprised has function numbering, function code name, function title, creation-time, founder, last modification time, function chained address, enables, parent numbering etc.Wherein function is numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| id | Function is numbered | Be | Number | 6 | Not null | Unique identification |
| functionCode | Function code name | No | Varchar2 | 50 | ||
| functionName | Function title | No | Varchar2 | 50 | Not null | |
| creationTime | Creation-time | No | Date | Not null | ||
| lastUpdateTime | Last modification time | No | Date | |||
| createdBy | Founder | No | Varchar2 | 50 | ||
| funcURL | Function links | No | Varchar2 | 255 | ||
| isStart | Whether enable | No | Number | 1 | 1 for enabling, and 0 for not enable, and default value is 1 | |
| ParentID | Parent is numbered | No | Number | 1 | Default value is 0 |
d) role-security table, role_permission shows: for storing role-security information.Whether the field wherein comprised has permission numbering, role's numbering, function numbering, creation-time, founder, last modification time, enables.Wherein authority is numbered major key, and role's numbering and function numbering are external keys, shows id field and functions table id field respectively with reference to roles.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| id | Authority is numbered | Be | Number | 6 | Not null | Unique identification |
| rol_id | Role numbers | No | Number | 6 | External key, association roles table | |
| fun_id | Function is numbered | No | Number | 6 | External key, association functions table | |
| creationTime | Creation-time | No | Date | Not null | ||
| createdBy | Founder | No | Varchar2 | 50 | ||
| lastUpdateTime | Last modification time | No | Date | |||
| isStart | Whether enable | No | Number | 1 | 1 for enabling, and 0 for not enable, and default value is 1 |
e) log sheet, logs shows: be used for Operation Log for storing, the field wherein comprised has daily record numbering, Customs Assigned Number, operation, running time etc.Wherein daily record is numbered major key, and Customs Assigned Number is external key, shows id field with reference to users.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| Id | Daily record is numbered | Be | Number | 16 | Not null | Unique identification |
| use_id | Customs Assigned Number | No | Number | 6 | External key, association users table | |
| operateInfo | Operation | No | Varchar2 | 255 | Not null | |
| operateDateTime | Running time | No | Date | Not null |
f) news table, news shows: user stores school district news information, and the field wherein comprised has news numbering, title, brief introduction, publisher, number of clicks, news details, information source, date issued, amendment date, whether top set etc.Wherein news is numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| id | News is numbered | Be | Number | Not null | Unique identification | |
| title | Headline | No | Varchar2 | 200 | Not null | |
| intro | News brief introduction | No | Varchar2 | 1000 | Not null | |
| author | Publisher | No | Varchar2 | 30 | Not null | |
| View_count | Number of clicks | No | Number | Not null | ||
| Content | News details | No | Clob | Not null | ||
| Src_from | Information source | No | Varcher2 | 200 | ||
| Cre_date | Date issued | No | Date | Not null | ||
| Upd_date | The amendment date | No | Date | Not null | ||
| isTop | Whether top set | No | Char | 1 | Not null | 1 is top set, and 0 is not top set |
g) certificate information table, yc_certificate shows: for Store Credentials information, the field wherein comprised has certificate number, certificate name, certificate picture, date issued, amendment date etc.Wherein certificate number is major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| id | Certificate number | Be | Number | 8 | Not null | Unique identification |
| Name | Certificate name | No | Varchar2 | 50 | Not null | |
| Picture | Certificate picture | No | Varchar2 | 500 | Not null | |
| Cre_date | Date issued | No | Date | Not null |
continued 3-7
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| Upd_date | The amendment date | No | Date | Not null |
h) promotional pamphlet page information table, yc_propagenda shows: for storing promotional pamphlet page information, whether the field wherein comprised has page number, title, publisher, number of clicks, brief introduction, issuing time, modification time, information source, content details, single page picture, is carousel picture etc.Wherein page number is major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| id | Page number | Be | Number | 8 | Not null | Unique identification |
| Title | Title | No | Varchar2 | 100 | Not null | |
| Author | Publisher | No | Varchar2 | 20 | Not null | |
| P_count | Number of clicks | No | Number | Not null | ||
| Intro | Brief introduction | No | Varchar2 | 800 | Not null | |
| Cre_date | Date issued | No | Date | Not null | ||
| Upd_date | The amendment date | No | Date | Not null | ||
| Src_from | Information source | No | Varchar2 | 20 | ||
| Content | Content details | No | Clob | Not null | ||
| Picture | Single page picture | No | Varchar2 | 500 | Not null | |
| Ishead | Whether be carousel picture | No | Char | 1 | Not null | 1 is common single page, and 0 is carousel picture |
i) teacher's table, yc_teacher shows: for storing teacher's information, the field wherein comprised has teacher to number, teacher's name, position, photo, be good at technology, technology, project experiences, admonition etc.Wherein teacher is numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| T_id | Teacher numbers | Be | Number | 8 | Not null | Unique identification |
| T_name | Teacher's name | No | Varchar2 | 20 | Not null | |
| Position | Position | No | Varchar2 | 20 | Not null | |
| Picture | Photo | No | Varchar2 | 500 | Not null | |
| Echnology_s | Be good at technology | No | Varchar2 | 500 | Not null | |
| Echnology | Technology | No | Varchar2 | 500 | Not null | |
| Experience | Project experiences | No | Varchar2 | 500 | Not null | |
| Proverbs | Admonition | No | Varchar2 | 500 | Not null |
j) question and answer information table, interlocution shows: for storing question and answer information, the field wherein comprised has question and answer numbering, question and answer title, information modification time, information issuing time, information source, question and answer content, number of clicks, question and answer type number, publisher etc.Wherein question and answer are numbered gradually.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| Qanum | Question and answer are numbered | Be | Number | Not null | Unique identification | |
| Qatitle | Question and answer title | No | Varchar2 | 1024 | Not null | |
| QaUpdateTime | Modification time | No | Date | Not null | ||
| QaInsertTime | Issuing time | No | Date | Not null | ||
| qaResource | Information source | No | Varchar2 | 1024 | Not null | |
| qaContent | Question and answer content | No | Clob | Not null | ||
| QaTypeId | Type number | No | Number | Not null | ||
| qaAuthor | Publisher | No | Varchar2 | 20 | Not null |
k) employment information table, yc_empinfo shows: for storing employment information, the field wherein comprised has information numbering, information title, issuing time, modification time, information source, information content, publisher, number of clicks, brief introduction etc.Wherein information is numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| Id | Information is numbered | Be | Number | 8 | Not null | Unique identification |
| Title | Information title | No | Varchar2 | 100 | Not null | |
| Cre_date | Issuing time | No | Date | Not null | ||
| Upd_date | Modification time | No | Date | Not null | ||
| Src_from | Information source | No | Varchar2 | 20 | ||
| Content | Information content | No | Clob | Not null | ||
| Author | Publisher | No | Varchar2 | 20 | Not null | |
| P_count | Number of clicks | No | Number | Not null | ||
| Intro | Brief introduction | No | Varchar2 | 800 | Not null |
l) employment information of trainee table, yc_graduate shows: user stores employment information of trainee, the field wherein comprised has student to number, student's name, employment unit, publisher, number of clicks, title, brief introduction, position, salary, date issued, amendment date, information source, content, photo etc.Wherein student is numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| Id | Student numbers | Be | Number | 8 | Not null | Unique identification |
| Name | Student's title | No | Varchar2 | 50 | Not null | |
| Company | Employment unit | No | Varchar2 | 50 | Not null | |
| Author | Publisher | No | Varchar2 | 20 | Not null | |
| P_count | Number of clicks | No | Number | Not null | ||
| Title | Title | No | Varchar2 | 50 | Not null | |
| Intro | Brief introduction | No | Varchar2 | 800 | Not null | |
| Job | Position | No | Varchar2 | 20 | Not null | |
| Sal | Salary | No | Varchar2 | 20 | Not null | |
| Cre_date | Issuing time | No | Date | Not null | ||
| Upd_date | Modification time | No | Date | Not null | ||
| Src_from | Information source | No | Varchar2 | 20 | ||
| Content | Content | No | Clob | Not null | ||
| Photo | Photo | No | Varchar2 | 500 | Not null |
m) company information table, yc_company shows: for storing company information, and the field wherein comprised has enterprise's numbering, enterprise name, publisher, number of clicks, brief introduction, issuing time, modification time, information source, enterprise's details, whether top set etc.Wherein enterprise is numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| Id | Enterprise numbers | Be | Number | 8 | Not null | Unique identification |
| Name | Enterprise name | No | Varchar2 | 50 | Not null | |
| Author | Publisher | No | Varchar2 | 20 | Not null | |
| P_count | Number of clicks | No | Number | Not null | ||
| Intro | Brief introduction | No | Varchar2 | 800 | Not null | |
| Cre_date | Issuing time | No | Date | Not null | ||
| Upd_date | Modification time | No | Date | Not null | ||
| Src_from | Information source | No | Varchar2 | 20 | ||
| Content | Enterprise's details | No | Clob | Not null | ||
| isTop | Whether top set | No | Char | 1 | Not null | 1 is top set, and 0 is not top set |
n) student's action message table, yc_activity shows: for storing student's action message, the field wherein comprised has numbering, title, publisher, number of clicks, brief introduction, issuing time, modification time, information source, content details, picture etc.Wherein be numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| Id | Numbering | Be | Number | 8 | Not null | Unique identification |
| Title | Title | No | Varchar2 | 100 | Not null | |
| Author | Publisher | No | Varchar2 | 20 | Not null | |
| P_count | Number of clicks | No | Number | Not null | ||
| Intro | Brief introduction | No | Varchar2 | 800 | Not null | |
| Cre_date | Issuing time | No | Date | Not null | ||
| Upd_date | Modification time | No | Date | Not null | ||
| Src_from | Information source | No | Varchar2 | 20 | ||
| Content | Content | No | Clob | Not null | ||
| Picture | Picture | No | Varchar2 | 500 |
o) student's works information table, studentWorks shows: for storing student's works information, the field wherein comprised is production number, work title, issuing time, modification time, information source, number of clicks, works content, publisher, exhibiting pictures etc.Wherein production number is major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| WorksID | Production number | Be | Number | 8 | Not null | Unique identification |
| WorksTilte | Work title | No | Varchar2 | 1024 | Not null | |
| WorksInTime | Issuing time | No | Date | Not null | ||
| WorksUpTime | Modification time | No | Date | Not null | ||
| WorksResource | Information source | No | Varchar2 | 1024 | ||
| WorksClickCount | Number of clicks | No | Number | Not null | ||
| WorksContent | Works details | No | Clob | Not null | ||
| WorksAuthor | Publisher | No | Varchar2 | 20 | Not null | |
| WorksShowPic | Exhibiting pictures | No | Varchar2 | 1024 | Not null |
p) class's of opening information table, beginClassInfo shows: for storing the class's of opening information, the field wherein comprised has class's numbering, the class's of opening time, closing date for entries, student's quantity, state of classes, course name, class name, publisher etc.Wherein class is numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| ClassCode | Class numbers | Be | Number | Not null | Unique identification | |
| Title | Class name | No | Varchar2 | 20 | Not null |
continued 3-16
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| ClassTime | The class's of opening time | No | Varchar2 | 1024 | Not null | |
| ClassDeadline | Closing date for entries | No | Varchar2 | 1024 | Not null | |
| ClassMatesNum | Student's quantity | No | Number | Not null | ||
| ClassStatus | State of classes | No | Varchar2 | 20 | Not null | |
| CourseTitle | Course name | No | Varchar2 | 20 | Not null | |
| Author | Publisher | No | Varchar2 | 20 | Not null |
q) curriculum information table, courseInfo shows: for storing curriculum information, the field wherein comprised has course numbering, course name, course content, issuing time, modification time, information source, course description, publisher etc.Wherein course is numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| CourseId | Course is numbered | Be | Number | Not null | Unique identification | |
| CourseName | Course name | No | Varchar2 | 1024 | Not null | |
| CourseCon | Course content | No | Clob | Not null | ||
| CourseInTime | Issuing time | No | Date | Not null | ||
| CourseUpTime | Modification time | No | Date | Not null | ||
| CourseResource | Information source | No | Varchar2 | 1024 | ||
| CourseIntro | Brief introduction | No | Varchar2 | 500 | Not null | |
| CourseAuthor | Publisher | No | Varchar2 | 20 | Not null |
r) hot technology information table, hotTechInfo shows: for storing hot technology information, the field wherein comprised has technology numbering, technical name, issuing time, modification time, information source, technology details, publisher, technology brief introduction, course name etc.Wherein technology is numbered major key.Tables of data is as shown in the table:
| Field name | Field description | Whether major key | Data type | Length | Whether be empty | Explanation |
| TechCode | Technology is numbered | Be | Number | Not null | Unique identification | |
| TechTitle | Technical name | No | Varchar2 | 1024 | Not null | |
| TechInTime | Issuing time | No | Date | Not null | ||
| TechUpTime | Modification time | No | Date | Not null | ||
| TechResource | Information source | No | Varchar2 | 1024 | ||
| TechContent | Technology details | No | Clob | Not null | ||
| TechAuthor | Publisher | No | Varchar2 | 20 | Not null | |
| TechIntro | Technology brief introduction | No | Varchar2 | 1024 | Not null | |
| TechCourseTitle | Course name | No | Varchar2 | 20 | Not null |
as shown in Figure 2, based on the data manipulation method of educational institution's management system of WEB to the business operation of the operation of database and each module data, should comprise the following steps:
s01: use MyBatis framework technology configuration data library information, realize the operation to database;
s02: for java entity class set up by table in database, create the interface to entity class data manipulation, and in xml configuration file, mapping relations are set up to entity class attribute and Database field, and be interface method splicing SQL statement;
s03: encapsulate further the interface layer of entity class data manipulation, creates each business logical operation method;
s04: encapsulation business logical operation method further, configures the redirect of the page and the data transmission of AM/BAM in struts configuration file.
be embodied as example below with the school district news template of school control's module, in the present invention the realization of modules and the implementation method of school district news template similar, repeat no more here.
school district news template
a) realized all modules shown when mouse moves to school control's module under school control's module by the show () method of jQuery and hide () method, and hide other module.Click " New Management " field, linking to functionName value in functions table is corresponding address in the funURL of " New Management ".
b) " inquiry " button is clicked, will label input frame and whether in top set drop-down list data import backstage into, call the showNewsList () method of NewsAction.java file in cn.ycbdqn.action bag, by title entry field and whether the splicing of top set option data to SQL statement fuzzy query, find out the news list of corresponding requirements and carry out Pagination Display with every page of ten records.
c) click " increasing newly " button, hiding newly-increased module will be ejected respectively, click input corresponding data in each input frame after and determine, then carry out form validation.It can not be empty for wherein identifying expression with asterisk before each input frame, for then providing corresponding prompting during sky.Can only numeral be inputted in " number of clicks " input frame, if input nonnumeric character, then provide miscue.Form validation imports backstage by being encapsulated by form data afterwards into into news object, performs addNews () the method operating database of NewsAction.java file in cn.ycbdqn.action bag.Success is pointed out to figure after preserving.Hide newly-increased module afterwards, again perform unconditional paging query display data.
d) click " increasing newly " button of the data colleague needing amendment, hiding newly-increased module will be ejected respectively, quote struts-tags tag library in the page and the data chosen are imported in js method, then import in modified module.
complete amendment click to determine, first carry out form validation, after meeting the requirements, form data is encapsulated and import backstage into into news object, perform editNews () the method operating database of NewsAction.java file in cn.ycbdqn.action bag, successfully provide prompting after amendment.Hide modified module afterwards, again perform unconditional paging query display data.
e) choose clickstream data with " preview " button of a line, open the details page of these data in front page layout.
f) data needing to delete are chosen, click same a line " deletion " button, news numbering is encapsulated and imports backstage into into news object, perform the delNews () method of NewsAction.java file in cn.ycbdqn.action bag, from database, delete data.
g) Pagination Display data in the list page of foreground.
system management module
a) in role_permission table, store role-security information, wherein the Information issued person role authority that do not have system manage, therefore when Information issued person's accessing system selective system manages, point out lack of competence.
b) system manager has the authority of system management, and mouse moves to system and manages out display system and manage each function.The operations such as system manager can carry out increasing newly in user management, revise, delete, inquiry, perform editUser (), delUser (), userList () in UserAction.java file in cn.ycbdqn.action bag respectively, the user management page, newly-increased module, modified module.
c) choose a user profile, click " the LOG daily record " of same a line, all operations daily record of display active user.
d) Operation Log under operation module, shows all operations record of all users.
in system architecture, employing be then B/S Design Mode.User sends request by browser to the many servers be distributed on network, the request of server to browser processes, user's information needed is turned back to browser, thus enormously simplify the work of client computer, then client computer just will configure a small amount of client software.
should be understood that, above-mentioned embodiment of the present invention only for exemplary illustration or explain principle of the present invention, and is not construed as limiting the invention.Therefore, any amendment made when without departing from the spirit and scope of the present invention, equivalent replacement, improvement etc., all should be included within protection scope of the present invention.In addition, claims of the present invention be intended to contain fall into claims scope and border or this scope and border equivalents in whole change and modification.
Claims (6)
1. based on educational institution's management system of WEB, it is characterized in that, comprise front end display module and Back Administration Module, described Back Administration Module comprises school control's module, course management module, student management module and employment management module;
Described school control module comprises school district news template, certificate management module, teacher's management module and promotional pamphlet page management module; For managing the school district news information in the news template of school district, comprising increase, deleting and amendment school district news information; For managing the certificate information in certificate management module, comprising increase, deleting and amendment certificate information; For managing the teacher's information in teacher's management module, comprising increase, deleting and amendment teacher's information; For managing the page information in promotional pamphlet page management module, comprising increase, deleting and amendment page information;
Described course management module comprises out a class information module, curriculum module and hot technology information module; Manage for the class's of the opening information in the class's of splitting information module, comprise increase, deletion and amendment and open a class information, screen according to affiliated course and state of classes; For managing the curriculum information in curriculum module, comprising increase, deleting and amendment curriculum information; For managing hot technology information in hot technology information module, comprising increase, deleting and amendment hot technology information, screening according to affiliated course;
Described student management module comprises information of trainee module and student's works module, for managing the information of trainee in information of trainee module, comprising increase, deleting and amendment information of trainee; For managing the student's works information in student's works module, comprising increase, deleting and amendment student works information;
Described employment management module comprises employment student module, employment information module and famous enterprise's recommending module, for managing the employment information of trainee in employment student module, comprising increase, deleting and amendment employment information of trainee; For managing the employment information in employment information module, comprising increase, deleting and amendment employment information; For managing the company information in famous enterprise's recommending module, comprising increase, deleting and amendment company information;
Described front end display module, uses FreeMarker template generation details page with html page form display data, comprises broadcasting special efficacy, and in details page and list page, catalogue module floats display.
2. the educational institution's management system based on WEB according to claim 1, it is characterized in that, described school control module also comprises question and answer administration module, for managing the question and answer information of the visitor in question and answer administration module, comprise increase, delete and amendment question and answer information, screen according to question and answer type.
3. the educational institution's management system based on WEB according to claim 1, it is characterized in that, described promotional pamphlet page management module can also arrange single page to the picture of page information and show or carousel displaying, and whether foundation is that carousel picture or single page picture screen.
4. the educational institution's management system based on WEB according to claim 1, it is characterized in that, described Back Administration Module also comprises system management module, for management system keeper and Information issued person's role-security, described Information issued person is used for editor and the issue of information, described system manager is used for, to system user information management, comprising increase, delete, revise and searching user profile, check Log daily record.
5. the educational institution's management system based on WEB according to claim 2, is characterized in that, the role that described system comprises for the Role Information of storage system user shows, for the user message table of storing subscriber information, for the menu of memory function information, for storing the role-security table of role-security information, for storing the log sheet of Operation Log, for storing the news table of school district news information, for the certificate information table of Store Credentials information, for storing the promotional pamphlet page information table of promotional pamphlet page information, for storing teacher's table of teacher's information, for storing the question and answer information table of question and answer information, for storing the employment information table of employment information, for storing the employment information of trainee table of employment information of trainee, for storing the company information table of company information, for storing student's action message table of student's action message, for storing student's works information table of student's works information, for storing out the class's of opening information table of class information, for storing the curriculum information table of curriculum information, for storing the hot technology information table of hot technology information.
6., based on a data manipulation method for the educational institution's management system based on WEB according to claim 1, it is characterized in that, comprise the following steps:
S01: use MyBatis framework technology configuration data library information;
S02: for java entity class set up by table in database, create the interface to entity class data manipulation, and in xml configuration file, mapping relations are set up to entity class attribute and Database field, and be interface method splicing SQL statement;
S03: encapsulate further the interface layer of entity class data manipulation, creates each business logical operation method;
S04: encapsulation business logical operation method further, configures the redirect of the page and the data transmission of AM/BAM in struts configuration file.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510852680.4A CN105260967A (en) | 2015-11-30 | 2015-11-30 | WEB-based educational institution management system and data operation method thereof |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510852680.4A CN105260967A (en) | 2015-11-30 | 2015-11-30 | WEB-based educational institution management system and data operation method thereof |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105260967A true CN105260967A (en) | 2016-01-20 |
Family
ID=55100642
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510852680.4A Pending CN105260967A (en) | 2015-11-30 | 2015-11-30 | WEB-based educational institution management system and data operation method thereof |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105260967A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106097202A (en) * | 2016-06-21 | 2016-11-09 | 广州伟度计算机科技有限公司 | A kind of intelligent terminal APP for family-school interaction realizes system and implementation method |
| CN106599139A (en) * | 2016-12-05 | 2017-04-26 | 金蝶软件（中国）有限公司 | MyBatis framework-based structured query language (SQL) processing method and apparatus |
| CN109472154A (en) * | 2018-09-30 | 2019-03-15 | 武汉达梦数据库有限公司 | The multi-layer mechanism of zero configuration, user maintenance method |
Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN104299096A (en) * | 2014-10-21 | 2015-01-21 | 沈阳化工大学 | Enterprise portal website management information system |
| CN104318383A (en) * | 2014-10-22 | 2015-01-28 | 沈阳化工大学 | College teaching management system |
| US20150187219A1 (en) * | 2013-12-27 | 2015-07-02 | Cloud Ta Llc | Systems and methods for computer-assisted grading of printed tests |
-
2015
- 2015-11-30 CN CN201510852680.4A patent/CN105260967A/en active Pending
Patent Citations (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20150187219A1 (en) * | 2013-12-27 | 2015-07-02 | Cloud Ta Llc | Systems and methods for computer-assisted grading of printed tests |
| CN104299096A (en) * | 2014-10-21 | 2015-01-21 | 沈阳化工大学 | Enterprise portal website management information system |
| CN104318383A (en) * | 2014-10-22 | 2015-01-28 | 沈阳化工大学 | College teaching management system |
Non-Patent Citations (3)
| Title |
|---|
| 曹强: "数字化校园系统的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
| 杨种学 等: "《Java EE项目 实训教材——MVC框架技术应用》", 31 December 2012, 南京大学出版社 * |
| 王瑞矫: "基于JavaEE的实训平台的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106097202A (en) * | 2016-06-21 | 2016-11-09 | 广州伟度计算机科技有限公司 | A kind of intelligent terminal APP for family-school interaction realizes system and implementation method |
| CN106599139A (en) * | 2016-12-05 | 2017-04-26 | 金蝶软件（中国）有限公司 | MyBatis framework-based structured query language (SQL) processing method and apparatus |
| CN106599139B (en) * | 2016-12-05 | 2021-02-26 | 金蝶软件（中国）有限公司 | SQL processing method and device based on MyBatis framework |
| CN109472154A (en) * | 2018-09-30 | 2019-03-15 | 武汉达梦数据库有限公司 | The multi-layer mechanism of zero configuration, user maintenance method |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20200293342A1 (en) | Generating content objects using an integrated development environment | |
| US8826169B1 (en) | Hiding content of a digital content item | |
| US20080313260A1 (en) | Automated website generation | |
| CN110325961A (en) | Software application exploitation based on electrical form | |
| CN103238150A (en) | Realtime synchronized document editing by multiple users for blogging | |
| CN105373382A (en) | Android-based student schedule system design method | |
| CN113836218A (en) | Distributed heterogeneous processing system based on workflow | |
| CN111788600A (en) | Software framework for progress tracking in a classroom environment | |
| Gerval et al. | Fusion of multimedia and mobile technology in audioguides for museums and exhibitions | |
| CN105260967A (en) | WEB-based educational institution management system and data operation method thereof | |
| CN101902492A (en) | Web Service server, website constructing method and information exchange method | |
| JP4976083B2 (en) | Information linkage program for information sharing system | |
| Chao | Cloud database development and management | |
| CN103297527A (en) | RFT (radio, film and television) intelligent community system and implementation method thereof | |
| Herrera | From static files to collaborative workspace with SharePoint | |
| Drisgill et al. | Sharepoint 2013 branding and user interface design | |
| Alabduljabbar et al. | Design of web content management system for dental laboratories | |
| Buck | Slacktivism, supervision, and# selfies: Illuminating social media composition through reception theory | |
| Quan | Research on Competitive Strategies of Traditional Media and Network Media | |
| Barber | Digital Archiving and" The New Screen" | |
| Al Kilani et al. | ERP Systems in Arab Education Sector: Towards Improved Implementation and Utilization | |
| Yuan et al. | Design Research of Electronic Journal System Based on ASP. NET | |
| Sherzad et al. | Transforming a paper-based library system to digital | |
| Rodrigues | Deliverable 6.1 | |
| Theresa et al. | COMPUTERISED COLLOCATE PARTICULARS AND DATA OF THE DEPARTMENT |
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: 20160120 |
|
| RJ01 | Rejection of invention patent application after publication |