Weekend Gift Pack
The file storage format is as follows:
ID, name, age, phone, job1, Alex, 13651054608, IT2, Egon, 13304320533, Tearcher3, Nezha, 1333235322, IT
This employee information file is now required to be added and censored
I. Basic must-do:
- Can query, support three kinds of syntax:
- Select Column Name 1, column Name 2, ... where column name condition
- Support: greater than or equal, also support fuzzy Lookup.
- Example:
- Select name, age where age>22
- SELECT * Where Job=it
- SELECT * Where phone like 133
Two. Advanced Selection:
- New employee records can be created, and IDs are incremented in order C. You can delete the specified employee record and enter the employee ID directly
- Modify Employee information
- Syntax: Set column name = "New value" where condition
- #先用where查找对应人的信息, then use set to modify the column name corresponding to the value "new value"
- Note: To operate the Employee Information table, you must first login, login certification needs to complete with the adorner
- Other requirements as far as possible with function implementation
Three. Job Requirements:
- Today's assignment is packed together.
- Put in the Jobs folder
- Mind mapping for functions related to finishing
- Organize the function knowledge points of the blog link
- Large jobs are placed in folders
- The folder needs to include:
- Code
- Flowchart (Please submit a PNG image.) If you do not have the appropriate drawing software, you can use ProcessOn painting)
- Readme file (please hand in a TXT file, a few simple instructions on the job, including the overall idea of the operation, how to run, the realization of what functions, what problems encountered and so on. )
Python-based employee information sheet jobs