Technology Stack
- Node.js - JavaScript runtime environment
- Express.js - Web application framework
- MySQL - Relational database management system
- EJS - Embedded JavaScript templating
- mysql2 - MySQL client for Node.js with promise support
Features
- ✅ RESTful API routes
- ✅ MySQL database connection with connection pooling
- ✅ User management (CRUD operations)
- ✅ Product management (CRUD operations)
- ✅ Modern, responsive UI
- ✅ Error handling and validation
Project Structure
testNode/
├── app.js # Main application file
├── config/
│ └── database.js # Database configuration
├── routes/
│ ├── home.js # Home routes
│ ├── users.js # User routes
│ └── products.js # Product routes
├── views/
│ ├── layouts/ # Layout templates
│ └── *.ejs # View templates
├── public/
│ └── css/ # Static CSS files
└── package.json # Dependencies