Node js  Application

In this project, you will create a Node js  Application that interacts with a MySQL database. You’ll practice executing various types of queries, such as INSERT, SELECT, UPDATE, and DELETE, to manage employee records in the database.

Check tips on how to do your Online Assignment Help.

Instructions:

Setup:

Make sure you have Node.js and MySQL installed on your system. Create a new folder for your project and navigate to it using the command line.

Database Setup:

Create a new MySQL database named “employee_db” or a name of your choice. Create a table named “employees” with columns “id” (INT), “name” (VARCHAR), and “job_title” (VARCHAR).

Node.js Application:

Inside your project folder create a new file named “app.js”.,

Connect to the Database:

Require the mysql npm package and create a connection to the MySQL database using your database credentials.,

INSERT Statement:

Write a function to insert a new employee record into the “employees” table. Use the connection.query() method to execute an INSERT query.,

SELECT Statement:

Write a function to retrieve the names of all employees from the “employees” table. Use the connection.query() method to execute a SELECT query.,

UPDATE Statement:

Write a function to update the job title of an employee. Use the connection.query() method to execute an UPDATE query.,

DELETE Statement:

Write a function to delete an employee record from the “employees” table. Use the connection.query() method to execute a DELETE query.,

Execution:

Run your Node.js application using the command node app.js. Check the console output for the results of each query.

Node js  Application

Example Code Snippets:

Here’s an example of how your “app.js” file could be structured:

const mysql = require(‘mysql’);

const connection = mysql.createConnection({
host: “localhost”,
user: “yourusername”,
password: “yourpassword”,
database: “employee_db”
});

connection.connect(function(err) {
if (err) throw err;
console.log(“Connected to MySQL server!”);

// Write your INSERT, SELECT, UPDATE, and DELETE functions here

// Close the connection
connection.end(function(err) {
if (err) throw err;
console.log(“Connection closed”);
});
});

Note: Replace ‘yourusername’ and ‘yourpassword’ with your actual MySQL credentials.

Submission Instructions

1. Place all of your files for this project in a folder labeled “Lesson 10.” In the file names, be sure to replace MEID with your actual MEID.

CIS276DA_XXXXX_JAM2334209.sql