Implementation of takeout information management system in Python

This paper shares the specific code of taking out information management system in Python for your reference. The specific contents are as follows

1、 Demand analysis

The requirements analysis includes the following:

1. Problem description

Log in to the system as the administrator of the takeout information system to realize the conditional query of store information, dispatcher information, customer service personnel information, order information and distribution information, as well as the entry, modification and deletion of information.

2. System function description

(1) Information entry: use wxPython to design the typesetting and writing window interface, give the interface for entering information, and realize the connection with the database through Python statements, so as to insert corresponding data into the database.

(2) Information modification: use wxPython to design the typesetting and write the window interface, give the interface to modify the information, and realize the connection with the database through Python statements, so as to modify the corresponding data in the database.

(3) Information query: in the window interface, it is triggered by the response button to realize the connection query with the database and obtain all online store information.

(4) Data statistics: write corresponding stored procedures in the database, and enter the store name to select the dispatchers and customer service personnel it manages.

3. System function module diagram

2、 Conceptual structure design

E-R model of the whole system:

3、 Logical structure design

Table structure used in the system and its connection:

1. Basic store information foodshop table

Primary key: shop_ name

2. Customer service basic information table

Primary key: Server_ id

Foreign key: shopname_ shop_ name

Reference table: shopname reference attribute: shop_ name

3. Courier table of dispatcher basic information

Primary key: Courier_ id

Foreign key: shopname_ shop_ name

Reference table: shopname reference attribute: shop_ name

4. Student basic information table

Primary key: Student_ phone

5. Order basic information book table

Primary key: (student_phone, server_id)

Foreign key: Student_ Phone, reference table student, reference attribute student_ phone

Foreign key: Server_ ID, reference table server, reference attribute server_ id

6. Delivery table of basic distribution information

Primary key: (student_phone, courier_id)

Foreign key: Student_ Phone, reference table student, reference attribute student_ phone

Foreign keys: Courier_ ID, reference table, reference attribute_ id

4、 Concrete implementation

login interface:

Attach source code:

Program demonstration:

(1) Store information

(2) Store shelves

(3) Store off shelf

(4) Dispatcher information

(5) Order information

(6) Buyer ordering

(7) Modify order

@H_ 419_ 201@

View the order information and confirm that it has been modified

So far, python has demonstrated the functions of adding, deleting, modifying and querying MySQL database with the help of pymysql. The remaining functions are not screenshots one by one, and the principle is similar.

5、 Summary

Through this course design, I have a deeper understanding and learning of the "database" and python content learned this semester. The understanding of database no longer only stays on the theoretical knowledge of textbooks, but can more clearly understand its background operation process. The application of Python is no longer limited to writing simple small programs, but to connect with the database. The corresponding SQL statements are passed into the database through the wxPython foreground window, so as to realize the operations of database insertion, modification, addition and deletion, and realize the foreground clarity of SQL statements. When designing E-R diagram, Navicat for MySQL, a visual tool for MySQL, was used to clearly present the relationship between tables. This course design benefited me a lot. While consolidating and expanding my knowledge, I also learned to use many tools, which provided valuable experience and cornerstone for future development.

For more learning materials, please pay attention to the special topic "management system development".