Scribd
Upload
56 views2 pages

Express API for User Management

This document defines an Express.js API for performing CRUD operations on a users table within a Microsoft SQL Server database. It connects to the database, defines GET, POST, PUT, and DELETE routes for the users resource, and includes sample SQL statements for retrieving, inserting, updating, and deleting user records. The API listens on port 3001 and returns results or errors from the database queries.

Uploaded by

Vikas Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
56 views2 pages

Express API for User Management

This document defines an Express.js API for performing CRUD operations on a users table within a Microsoft SQL Server database. It connects to the database, defines GET, POST, PUT, and DELETE routes for the users resource, and includes sample SQL statements for retrieving, inserting, updating, and deleting user records. The API listens on port 3001 and returns results or errors from the database queries.

Uploaded by

Vikas Gupta
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 2

const express=require("express");

const app=express();
const db=require('mssql');

var config = {
user: 'hari',
password: 'Giri@123',
server: '[Link]',
database: 'johnreeses'
};

[Link](config, function (err) {


if (err){
[Link](err);
}

});
[Link]([Link]());

[Link]("/users",(req,res)=>{
[Link]("select * from users;",(err,result)=>{
if(err){
[Link](err);
}else{
[Link](result);
}
});
});

[Link]('/users',(req,res) => {
customer = [Link]([Link]([Link]));
[Link](customer);
[Link](`INSERT INTO users (name,phonenumber) VALUES ('${[Link]}','$
{[Link]}')`,(err, result) => {
if (err) {
[Link](result);
} else {
[Link](result);
}})});

[Link]('/users',(req,res) => {
customer = [Link]([Link]([Link]));
[Link](customer);
[Link](`update users set name=('${[Link]}'),phonenumber=('$
{[Link]}') where id=('${[Link]}')`,(err, result) => {
if (err) {
[Link](result);
} else {
[Link](result);
};
});

})
[Link]('/users',(req,res) => {
customer = [Link]([Link]([Link]));
[Link](customer);
[Link](`delete users where id=('${[Link]}');`,(err, result) => {
if (err) {
[Link](result);
} else {
[Link](result);
};
});

})

[Link]("3001",()=>{
[Link]("server is running ")
});

CREATE TABLE users(


id int IDENTITY(1,1) PRIMARY KEY,
name varchar(255) NOT NULL,
phonenumber varchar(255),

);

You might also like