CN105184472A - Medical management system based on SSH - Google Patents
Medical management system based on SSH Download PDFInfo
- Publication number
- CN105184472A CN105184472A CN201510537430.1A CN201510537430A CN105184472A CN 105184472 A CN105184472 A CN 105184472A CN 201510537430 A CN201510537430 A CN 201510537430A CN 105184472 A CN105184472 A CN 105184472A
- Authority
- CN
- China
- Prior art keywords
- medicine
- information
- module
- employee
- management system
- 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
- Medical Treatment And Welfare Office Work (AREA)
Abstract
The invention discloses a medical management system based on SSH. The system comprises a database access module, a staff log-in module, a medicine information management module, a staff register module, and a user information management module. The database access module is used to realize data interaction between application program and a database. The staff log-in module is used for log-in to access a staff management page. The medicine information management module is used for adding, checking, deleting, and modifying medicine information. The staff register module is used to register log-in accounts. The user information management module is used for system administrators to check registered user account information, and add, modify, and delete assigned staff information or administrator information. The system provides convenience for medical staff to update medicine information in time, and saves a large amount of time for checking information of medicine in stock, and the system assists a medicine purchasing system to make purchase plans, and effectively coordinates operation of each department in a hospital.
Description
Technical field
The present invention relates to disease medicine administrative skill field, relate to a kind of Medicine Management System based on SSH particularly.
Background technology
Along with fast development and the application of internet, infotech and database, new challenge is proposed to medical management work.Traditional labor management mode inefficiency, the easily outstanding problem such as to make mistakes are day by day remarkable, for adapting to current medical management status, urgent need better the medical management work of information technology application to hospital, thus improves medical management work level, improves medical management mode, improves medical management work efficiency.Therefore, in order to Neng Shi hospital is better community service, the Medicine Management System of exploitation complete set is imperative.
Summary of the invention
For above-mentioned technical matters, the present invention seeks to: a kind of Medicine Management System based on SSH is provided, system utilizes modern infotech, medical worker is facilitated to upgrade in time medicine information, save the time of a large amount of count of stock medicine information, the procurement plan of medication purchasing system formulates can also be assisted, the effective operation coordinating the work of hospital internal all departments simultaneously.
Technical scheme of the present invention is:
Based on a Medicine Management System of SSH, it is characterized in that, comprise database access module, employee's login module, drug information management module, employee's Registering modules and subscriber information management module; Described database access module is for realizing the data interaction between application program and database, described employee's login module is used for login and enters the staff's benefits page, described drug information management module is used for medicine information and adds, checks, deletes and retouching operation, described employee's Registering modules is for registering login account, described subscriber information management module is used for system manager and checks registered user account information, adds the employee information of specifying or Administrator Info, revise and deletes.
Preferably, described medicine information comprises: medicine ID, medicine coding, nomenclature of drug, manufacturer, medicine description, price, Quantity of drugs, drug demand quantity, medicine picture path, medicine classification.
Preferably, described medicine classification comprises: category IDs, item name, classification describe, creation-time.
Preferably, also comprise statistical analysis module, for adding up the inventory record situation of corresponding time period and generating statistical graph.
Preferably, also comprise statement management module, for generating the form that can derive according to medicine information.
Preferably, described database comprises employee information database, medicine information database, system administrator information database, medicine classification information database.
Preferably, described system uses Hibernate framework connection data storehouse and application program.
Preferably, the method for operating of application program to database entity class is packaged with in described database access module.
Preferably, the execution flow process of described medicine information look facility comprises the following steps:
A. employee's Successful login system enters the staff's benefits page, clicks medicine information and checks that operating function links;
B. employee enters medicine information and checks window, clicks and browses medicine information;
What c. system responses employee submitted to checks request, and backstage performs query manipulation and obtains Query Result;
D. front page layout obtains Query Result, exports medicine information with the circulation of the form of result set.
Preferably, the amendment of described medicine information, by entering Drugstore management function window, browses current Drug Storage information, according to selecting the medicine information of designated recorder and after clicking this record, this full detail recorded being passed in a tabular form the medicine amendment page.
Compared with prior art, advantage of the present invention is:
1. the Medicine Management System based on SSH mainly realizes the functions such as medicine information inquiry, employee information inquiry, Drugstore management, statistical study, Report Server Management and system management.System utilizes modern infotech, medical worker is facilitated to upgrade in time medicine information, save the time of a large amount of count of stock medicine information, the procurement plan of medication purchasing system formulates can also be assisted simultaneously, the effective operation coordinating the work of hospital internal all departments.
2., based on the SSH framework technology in the Medicine Management System employing J2EE of SSH, front page layout adopts JSP technology, and partial page attribute adopts CSS to realize the consistent of page properties.System adopts Struts2 framework to realize being separated of front page layout and background business logic, and Hibernate framework generates entity class and mapped file according to database table, and Spring realizes the unified management of whole system, significantly reduces the degree of coupling of system.In native system, the XML configuration file of core realizes the data transmission between front page layout and background business logic, improves traditional data transfer mode.Use PostgreSQL database MySQL to manage back-end data, the GUI graphic user interface of MySQL is very easy to the operation of database and table.
Accompanying drawing explanation
Below in conjunction with drawings and Examples, the invention will be further described:
Fig. 1 is the structured flowchart of the background function module of the Medicine Management System that the present invention is based on SSH;
Fig. 2 is the employee information sterogram of the Medicine Management System that the present invention is based on SSH;
Fig. 3 is the medicine information entity of the Medicine Management System that the present invention is based on SSH;
Fig. 4 is the system administrator information entity of the Medicine Management System that the present invention is based on SSH;
Fig. 5 is the medicine classification information entity of the Medicine Management System that the present invention is based on SSH;
Fig. 6 is the entity relationship diagram of the Medicine Management System that the present invention is based on SSH;
Fig. 7 is the schematic diagram of the Hibernate data persistence of the Medicine Management System that the present invention is based on SSH;
Fig. 8 is that the medicine information look facility of the Medicine Management System that the present invention is based on SSH holds sequential chart;
Fig. 9 is the medicine information amendment sequential chart of the Medicine Management System that the present invention is based on SSH;
Figure 10 is that the medicine information of the Medicine Management System that the present invention is based on SSH deletes sequential chart.
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:
This Medicine Management System comprises front page layout and background function module, and front page layout is mainly the window link of employee and system manager's the corresponding function module, and backstage functional module is used for realizing each functional module.
The front page layout of Medicine Management System is mainly to the homepage content of employee and system manager's display systems, notifications, medical information, hospital scenario brief introduction and contact method.Employee is provided to link with the login window of system manager.
Background function module is mainly using the role of employee and system manager two type as operation driver, and employee and system manager enter administration module respective in system by username and password, as shown in Figure 1, mainly comprise following functions module:
A. login module is registered
A. employee's login module: employee is by the username and password login user administration module of oneself;
B. new employee's Registering modules: new employee clicks and enters log-in window, fills in enrollment form and completes registration;
C. system manager's login module: system manager is logged in by the account number cipher that keeper specifies and enters system management module.
B. staff's benefits module
Enter staff's benefits module after employee logins successfully, staff's benefits module comprises drug information management module, statement management module and statistical analysis module.Drug information management module comprises:
A. medicine is browsed: show current all medicine informations;
B. medicine adds: add and newly enter medicine, upgrade in time Drug Storage information;
C. Drugstore management: check current Drug Storage record, can revise or delete and specify drug stock information;
Report Server Management: click and generate status reporting information;
Statistical study: add up the inventory record situation of corresponding time period and generate statistical graph.
C. system management module
Keeper enters system management module, selects to perform following function:
A. employee information is browsed: show current employee information situation;
B. Administrator Info browses: check current Administrator Info, can revise or delete the Administrator Info specified;
C. keeper adds: can increase new Administrator Info;
D. password amendment: keeper relies on user name and initial password to revise original code;
E. log off: keeper operates end, can log off from main separation.
Data item involved by Medicine Management System and data structure are:
A. employee information, the concrete data item comprised has: employee ID, user name, password, creation-time.
B. Administrator Info, the concrete data item comprised has: keeper ID, username and password.
C. medicine information, the concrete data item comprised has: medicine ID, medicine coding, nomenclature of drug, manufacturer, medicine description, price, Quantity of drugs, drug demand quantity, medicine picture path, medicine classification.
D. medicine classification information, the concrete data item comprised has: category IDs, item name, classification describe, creation-time.
According to above-mentioned data item and data structure, the sterogram comprised has: employee information entity, medicine information entity, system administrator information entity, medicine classification information entity.The structure of four sterograms as shown in Figure 2-5.The entity relationship diagram that Medicine Management System relates generally to as shown in Figure 6.
According to entity analysis, need establishment four database tables in the database of Medicine Management System: employee information table, structure is as following table:
| Field | Data type | Length | Whether be major key | Whether can be sky |
| id | Integer | Be | No | |
| username | Varchar | 50 | No | No |
| password | Varchar | 50 | No | No |
| createTime | Datetime |
The structure of medicine information table is as following table:
| Field | Data type | Length | Whether be major key | Whether can be sky |
| id | Integer | Be | No | |
| medNo | Varchar | 100 | No | No |
| name | Varchar | 200 | No | No |
| factoryAdd | Varchar | 200 | No | Be |
| description | Varchar | 200 | No | Be |
| price | Double | No | Be |
| medCount | Integer | No | Be | |
| reqCount | Integer | No | Be | |
| photoPath | Varchar | 255 | No | Be |
| categoryId | Integer | No | Be |
The structure of system administrator information table is as following table:
| Field | Data type | Length | Whether be major key | Whether can be sky |
| id | Integer | Be | No | |
| username | Varchar | 45 | No | No |
| password | Varchar | 45 | No | No |
The structure of medicine category information table is as following table:
| Field | Data type | Length | Whether be major key | Whether can be sky |
| id | Integer | Be | No | |
| name | Varchar | 100 | No | Be |
| description | Varchar | 200 | No | Be |
| createTime | Datetime | No | Be |
This Medicine Management System adopts SSH framework technology, uses the JDBC DataBase combining mode that Hibernate framework substitution is traditional, constructs the bridge between database and application program.The schematic diagram of Hibernate data persistence as shown in Figure 7.
Data interaction between application program and database is realized by DAO module DAO, encapsulates the method for operating of application program to database entity class in DAO, and by instantiation DAO object, call operation method visits database.To the operation of database table be substantially all based on information in his-and-hers watches increase, delete, check and revise these four kinds operations.
Employee's login module, the employee clicking system homepage for registered employee logs in link, directly jumps to employee's login window, according to the username and password of oneself.After submitting log-on message to, whether system verification employee information is correct, and jumps to corresponding results page according to the result correctness.The employee logined successfully enters the staff's benefits page, and the employee of login failure jumps to the wrong page, selects to return to the homepage.
Drug information management module is under the precondition of employee's Successful login system, and the feature operation link selected by employee, different operation selections can jump to and link window accordingly.Drug information management is specifically divided into medicine information to add, checks, deletes and retouching operation.Wherein, after the amendment of medicine information and deletion action need employee to click to browse current medicine information, just can select operation.The sequential chart that medicine information look facility performs as shown in Figure 8.
The execution flow process of medicine information look facility forms primarily of following steps:
A. employee's Successful login system enters the staff's benefits page, clicks medicine information and checks that operating function links;
B. employee enters medicine information and checks window, clicks and browses medicine information;
What c. system responses employee submitted to checks request, and backstage performs query manipulation and obtains Query Result;
D. front page layout obtains Query Result, exports medicine information with the circulation of the form of result set.
Medicine information modify feature is: employee to the staff's benefits page by user name and password Successful login, is clicked and enters Drugstore management function window.Current Drug Storage information is browsed in click.Select the medicine information of designated recorder as required and click this record after " amendment " link, jump to medicine amendment the page while, by this record full detail be passed in a tabular form medicine revise the page.Except ID attribute can not be revised, the information shown by other all can be modified.Click on submission button, medicine is revised the Parameter transfer of the page to MedicineModifyAction class by struts.xml configuration file, MedicineModifyAction class performs execute () method, IUserDao interface is called by applicationContext.xml, UserDao realizes the medModify () method in IUserDao interface, the medicine passed over from MedicineModifyAction class is revised information by the UPDATE statement in HQL, realizes upgrading according to the id information of former medicine.Be updated successfully and jump to the medicine information page, click " browsing medicine information " and medicine amendment information can be inquired.Medicine information amendment sequential chart illustrates as shown in Figure 9.
Medicine information delete function is: employee to the staff's benefits page by user name and password Successful login, is clicked and enters Drugstore management function window.Current medicine information is browsed in click, selects the medicine record of nominated bank, clicks record " deletion " option of operation below.Because the ID of every bar medicine information is unique, so front page layout only needs the MedicineDeleteAction class of will the ID of medicine record be specified to pass to backstage by struts.xml configuration file, perform execute () method, call IUserDao interface, UserDao realizes the deleteMedicineById () method in IUserDao interface, by the medicine id information that passes over from MedicineModifyAction class by the Delete statement in HQL, realize upgrading according to medicine ID.Medicine deletes time chart analysis as shown in Figure 10.
Employee's Registering modules, needs initiatively on system homepage, to select the link of " new employee's registration " function for new employee, completes the registration of employee's account.Consider the security of employee's account, native system operates in the internal network of hospital.Employee needs to use the computing machine of having authorized to complete the registration of respective account.System manager has permission and checks and operate the account information of all employees.
Subscriber information management module, system manager can check current chartered employee's accounts information, modifies and delete the employee information of specifying.Employee does not have authority deletion oneself and the account of other employee, does not have authority to check other employee's accounts information yet.System manager can also add new keeper's accounts information.
System manager deletes and specifies the operating process of employee information to be made up of following steps:
A. system administration page is entered after system manager's Successful login system;
B. click " employee information " and enter the employee information page, browse employee information;
C. the employee information record deletion link below of selecting to specify is clicked;
D. system acceptance operation requests, background business logic process also makes deletion response;
E. the employee information after employee information page furbishing display deletion.
Password Management module is for realizing the amendment to original code.The operating process of employee's Modify password is divided into following step:
A., after employee's Successful login system, the staff's benefits page is entered;
B. click " password amendment " action link, enter the password amendment page;
C. fill in Page user name and new password information and submit to.
D. systems process user request and return operating result response employee.
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 (10)
1. based on a Medicine Management System of SSH, it is characterized in that, comprise database access module, employee's login module, drug information management module, employee's Registering modules and subscriber information management module; Described database access module is for realizing the data interaction between application program and database, described employee's login module is used for login and enters the staff's benefits page, described drug information management module is used for medicine information and adds, checks, deletes and retouching operation, described employee's Registering modules is for registering login account, described subscriber information management module is used for system manager and checks registered user account information, adds the employee information of specifying or Administrator Info, revise and deletes.
2. the Medicine Management System based on SSH according to claim 1, it is characterized in that, described medicine information comprises: medicine ID, medicine coding, nomenclature of drug, manufacturer, medicine description, price, Quantity of drugs, drug demand quantity, medicine picture path, medicine classification.
3. the Medicine Management System based on SSH according to claim 3, is characterized in that, described medicine classification comprises: category IDs, item name, classification describe, creation-time.
4. the Medicine Management System based on SSH according to claim 3, is characterized in that, also comprise statistical analysis module, for adding up the inventory record situation of corresponding time period and generating statistical graph.
5. the Medicine Management System based on SSH according to claim 3, is characterized in that, also comprise statement management module, for generating the form that can derive according to medicine information.
6. the Medicine Management System based on SSH according to claim 1, is characterized in that, described database comprises employee information database, medicine information database, system administrator information database, medicine classification information database.
7. the Medicine Management System based on SSH according to claim 1, is characterized in that, described system uses Hibernate framework connection data storehouse and application program.
8. the Medicine Management System based on SSH according to claim 1, is characterized in that, is packaged with the method for operating of application program to database entity class in described database access module.
9. the Medicine Management System based on SSH according to claim 1, is characterized in that, the execution flow process of described medicine information look facility comprises the following steps:
A. employee's Successful login system enters the staff's benefits page, clicks medicine information and checks that operating function links;
B. employee enters medicine information and checks window, clicks and browses medicine information;
What c. system responses employee submitted to checks request, and backstage performs query manipulation and obtains Query Result;
D. front page layout obtains Query Result, exports medicine information with the circulation of the form of result set.
10. the Medicine Management System based on SSH according to claim 1, it is characterized in that, described medicine information amendment is by entering Drugstore management function window, browse current Drug Storage information, according to select designated recorder medicine information and click this record after, by this record full detail be passed in a tabular form medicine amendment the page.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510537430.1A CN105184472A (en) | 2015-08-27 | 2015-08-27 | Medical management system based on SSH |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510537430.1A CN105184472A (en) | 2015-08-27 | 2015-08-27 | Medical management system based on SSH |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN105184472A true CN105184472A (en) | 2015-12-23 |
Family
ID=54906535
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510537430.1A Pending CN105184472A (en) | 2015-08-27 | 2015-08-27 | Medical management system based on SSH |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105184472A (en) |
Cited By (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106326645A (en) * | 2016-08-18 | 2017-01-11 | 上海知了数据系统有限公司 | Treatment scheme information supporting management system |
| CN106845943A (en) * | 2017-02-06 | 2017-06-13 | 徐艳艳 | Medicine（Including medicine equipment）Registration management system |
| CN107193998A (en) * | 2017-06-13 | 2017-09-22 | 杭州药视康信息技术有限公司 | A kind of Medicine Management System |
| CN107609660A (en) * | 2017-10-13 | 2018-01-19 | 广东电网有限责任公司江门供电局 | A kind of Work tool information management and control automated system |
| CN107944834A (en) * | 2017-12-13 | 2018-04-20 | 哈尔滨渤飞网络科技有限公司 | A kind of body-building SAAS big data systematic management systems |
| CN108831543A (en) * | 2018-06-26 | 2018-11-16 | 白宣 | A kind of Hospital Drugs total management system and its management method |
| CN110957047A (en) * | 2019-12-25 | 2020-04-03 | 马宇洁 | Sudden cardiac arrest patient data management system |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103854244A (en) * | 2014-04-02 | 2014-06-11 | 沈阳常山新电子有限公司 | Hospital drug management system |
| CN104361426A (en) * | 2014-10-21 | 2015-02-18 | 沈阳化工大学 | Hospital pharmacy management system |
-
2015
- 2015-08-27 CN CN201510537430.1A patent/CN105184472A/en active Pending
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103854244A (en) * | 2014-04-02 | 2014-06-11 | 沈阳常山新电子有限公司 | Hospital drug management system |
| CN104361426A (en) * | 2014-10-21 | 2015-02-18 | 沈阳化工大学 | Hospital pharmacy management system |
Non-Patent Citations (1)
| Title |
|---|
| 张红军: "某药店管理系统的设计与实现", 《中国优秀硕士学位论文全文数据库 信息科技辑》 * |
Cited By (9)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106326645A (en) * | 2016-08-18 | 2017-01-11 | 上海知了数据系统有限公司 | Treatment scheme information supporting management system |
| CN106326645B (en) * | 2016-08-18 | 2018-09-14 | 上海知了数据系统有限公司 | Therapeutic scheme Informational support manages system |
| CN106845943A (en) * | 2017-02-06 | 2017-06-13 | 徐艳艳 | Medicine（Including medicine equipment）Registration management system |
| CN107193998A (en) * | 2017-06-13 | 2017-09-22 | 杭州药视康信息技术有限公司 | A kind of Medicine Management System |
| CN107609660A (en) * | 2017-10-13 | 2018-01-19 | 广东电网有限责任公司江门供电局 | A kind of Work tool information management and control automated system |
| CN107944834A (en) * | 2017-12-13 | 2018-04-20 | 哈尔滨渤飞网络科技有限公司 | A kind of body-building SAAS big data systematic management systems |
| CN108831543A (en) * | 2018-06-26 | 2018-11-16 | 白宣 | A kind of Hospital Drugs total management system and its management method |
| CN108831543B (en) * | 2018-06-26 | 2022-01-28 | 白宣 | Hospital medicine comprehensive management system and management method thereof |
| CN110957047A (en) * | 2019-12-25 | 2020-04-03 | 马宇洁 | Sudden cardiac arrest patient data management system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105184472A (en) | Medical management system based on SSH | |
| US9449329B2 (en) | Enterprise architecture system and method | |
| US11409904B2 (en) | User interface for building a data privacy pipeline and contractual agreement to share data | |
| US11356456B2 (en) | Multi-participant and cross-environment pipelines | |
| US20090282045A1 (en) | Apparatus and method for accessing data in a multi-tenant database according to a trust hierarchy | |
| US11496584B2 (en) | Extraction and distribution of content packages in a digital services framework | |
| JP2020053051A (en) | Integrated entity view across distributed systems | |
| US9971803B2 (en) | Method and system for embedding third party data into a SaaS business platform | |
| US9275112B2 (en) | Filtering views with predefined query | |
| US10909109B1 (en) | Quality control test transactions for shared databases of a collaboration tool | |
| US9330140B1 (en) | Transient virtual single tenant queries in a multi-tenant shared database system | |
| US11334601B2 (en) | Unified data model | |
| US20200104398A1 (en) | Unified management of targeting attributes in a/b tests | |
| US20200334244A1 (en) | Bidirectional mapping of hierarchical data to database object types | |
| US11580479B2 (en) | Master network techniques for a digital duplicate | |
| US11113664B2 (en) | Data provisioning system and method | |
| US20140278790A1 (en) | System and method for data acquisition, data warehousing, and providing business intelligence in a retail ecosystem | |
| US20210011902A1 (en) | Methods, apparatuses, and systems for ingesting and consuming data utilizing a trading partner manager | |
| CN110019456B (en) | Data import method, device and system | |
| US11669547B2 (en) | Parallel data synchronization of hierarchical data | |
| US20230281339A1 (en) | Centralized data transformation in a multi-tenant computing environment | |
| CN107608690B (en) | Configuration management method and device | |
| CN110335016A (en) | A kind of distribution cell lean intelligence manufacture management system | |
| JP6338909B2 (en) | Content control system | |
| US20240296434A1 (en) | Universal payment gateway connector for a multi-tenant computing environment |
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: 20151223 |
|
| RJ01 | Rejection of invention patent application after publication |