This Student Enquiry Database Management System is an web application integrated with Oracle sql plus and currently working on ejs for the frontend and node for the backend.
The connection string to connect the app to Sql database is configured in the app.js file.
The username and password used in the Passport.js for the login system is stored in the app.js with its functions in passport.js file which is imported in app.js.
Login Page:
Welcome Page:
Data Representation:
Add new student:
Edit existing student data:
Edit Page:
Filters:
Dependecies in the app.js :
- "body-parser": "^1.19.0",
- "connect-flash": "^0.1.1",
- "ejs": "^3.0.1",
- "express": "^4.17.1",
- "express-flash": "0.0.2",
- "express-session": "^1.17.1",
- "express-validator": "^6.4.0",
- "method-override": "^3.0.0",
- "oracledb": "^4.2.0",
- "passport": "^0.4.1",
- "passport-local": "^1.0.0"
- "nodemon": "^2.0.3"