This is a simple Student Record System (SRS) implemented using Tkinter for the graphical user interface and MySQL for database management. The system allows users to add, update, delete, and view student records.
Before running the application, ensure that you have the required Python libraries installed:
- Tkinter
- pymysql
You can install them using the following commands:
pip install tk
pip install pymysql
- Clone the repository to your local machine:
git clone https://github.com/your-username/your-repo.git
- Navigate to the project directory:
cd your-repo
To run the Student Record System, execute the following command in your terminal or command prompt:
python your_file_name.py
- Add new student records.
- Update existing student records.
- Delete selected student records.
- View all student records in a tabular format.
- Launch the application.
- Enter the student details in the "Enter Details" section.
- Click the "Save" button to add a new record.
- To update a record, select the record from the table, modify the details, and click the "Update" button.
- To delete a record, select the record from the table and click the "Delete" button.
- The "Clear" button resets the entry fields.
- The table displays all student records with columns such as Student UID, Full Legal Name, Faculty, etc.
The application is configured to use a MySQL database. Ensure that you have a MySQL server running locally with a database named 'srs1'. You can adjust the database configuration in the code if needed.
conn = pymysql.connect(host='localhost', user='root', password='', database='srs1')
- This system assumes a local MySQL database without authentication (password='') for simplicity.
- Modify the code to include proper database credentials and security measures in a production environment.
This project is licensed under the MIT License - see the LICENSE file for details.