Node JS DATABASE CONNECT

 var express = require('express');

var app = express();

app.get('/', function (req, res) {

   

    var sql = require("mssql");

    // config for your database

    var config = {

        user: 'USER',

        password: 'USER',

        server: 'SERVER IP', 

port:1333,

options:{encrypt:false},

        database: 'BONDHON' 

    };

    // connect to your database

    sql.connect(config, function (err) {

    

        if (err) console.log(err);

        // create Request object

        var request = new sql.Request();

           

        // query to the database and get the records

        request.query('select * from fn_items() where arno=\'8010240\'', function (err, recordset) {

            

            if (err) console.log(err)

            // send records as a response

            res.send(recordset);

            

        });

    });

});

var server = app.listen(5000, function () {

    console.log('Server is running..');

});