PCLUB secy task no 5

I had zero idea about backend development ,I only knew little bit about MySQL(from school) so in the past 3 days I have learnt some parts of nodejs and how to develop a backend.
First I installed MySQL for database and Xampp Control Panel and thunder client extension in VS Code.
Added json package to my project folder using powershell window

Installed packages

Installed mysql,express,body-parser and nodemon packages using terminal

started local server

app.js file code

Require all the packages at top of the file and set the listening port to be 5000

Started Xampp control panel to start MySql and then opened phpMyAdmin

created database using phpMyAdmin ss_pclub and table student_data with following structure

Connected Node.js with MySQL

Entered some records data through phpMyAdmin

Code for displaying whole data

Filtering Data

I could not find way to filter using multiple parameters so I have used only single parameters for filtering

#Deleting a record I have written query just to delete a record on the basis of RollNo

Adding a Record

Using Post method

Updating a Record

I have kept only branch and name to be updatable