Extract Name and last name from Database with JavaScript code

To extract data from an MSSQL database using JavaScript, you can utilize the mssql package, which allows you to connect and query SQL Server databases. Below is a simple example demonstrating how to retrieve the first name and last name based on an account number.

First, ensure you have the mssql package installed:

npm install mssql

Then, you can use the following code snippet:

const sql = require('mssql');

async function getUserDetails(accountNumber) {
    try {
        const config = {
            user: 'your_username',
            password: 'your_password',
            server: 'your_server', 
            database: 'your_database',
            options: {
                encrypt: true // Use this if you're on Azure
            }
        };

        // Connect to the database
        await sql.connect(config);

        // Query the database
        const result = await sql.query`SELECT firstName, lastName FROM dbo.ei_employee WHERE accountNumber = ${accountNumber}`;

        if (result.recordset.length > 0) {
            const { firstName, lastName } = result.recordset[0];
            console.log(`Name: ${firstName} ${lastName}`);
        } else {
            console.log('No user found with the provided account number.');
        }
    } catch (err) {
        console.error('SQL error', err);
    } finally {
        await sql.close();
    }
}

// Example usage
getUserDetails('12345');

Replace your_username, your_password, your_server, and your_database with your actual database credentials. The function getUserDetails takes an account number as an argument and retrieves the corresponding first and last names from the ei_employee table.