SQL Server Calling stored procedure from node js

uurv41yg 于 2023-03-11 发布在其他

关注(0)|答案(2)|浏览(107)

I am using express and I am trying to call LoginMember stored procedure from Azure portal. This is my form from, taken from ejs:

<form method="post" action="/available-copies">
      <input type="text" placeholder="SSN" name="userssn">
      <input type="password" placeholder="Password" name="userpassword">
      <input type="submit" value="Login">
</form>

This is my post request

router.post('/available-copies', function (req, res) {
    var ssn = req.body.userssn;
    var password = req.body.userpassword;

    sql.connect(sqlConfig, function (err) {
        if (err) console.log(err);
        // create Request object
        var request = new sql.Request();
        // query to the database and execute procedure
        request.query("exec LoginMember @SSN='"+ssn+"', @PASSWORD='"+password+"';", function (err, recordset) {
            if (err) console.log(err);

            res.send(recordset);
        });
    });
    sql.close()
});

SqlConfig comes from another file and this part is fine. Just in case, this is my stored procedure creation code:

CREATE PROCEDURE LoginMember @SSN varchar(11), @PASSWORD char(64)
AS
BEGIN
   Select * from Member
   WHERE Member.ssn = @SSN AND Member.password = @PASSWORD
END

What happens- When I submit my form, page keeps loading for 3-5mins, after that I get

This page isn’t working
localhost didn’t send any data.

Console doesn't return any additional errors. I know this might be not the best solution I can be using, but this is my approach and I want to make it work.

sql-server

来源：https://stackoverflow.com/questions/50697134/calling-stored-procedure-from-node-js

2条答案

按热度按时间

am46iovg1#

Make sure you are closing sql connection after query execution or failure.What i found in your code is that you are closing sql connection outside sql.connect which is incorrect because node js is asynchronous in nature which is killing your connection before completion.Please find the update code below:

router.post('/available-copies', function (req, res) {
var ssn = req.body.userssn;
var password = req.body.userpassword;

sql.connect(sqlConfig, function (err) {
    if (err) console.log(err);
    // create Request object
    var request = new sql.Request();
    // query to the database and execute procedure 
    let query = "exec LoginMember @SSN='" + ssn + "', @PASSWORD='" + password + "';";
    console.log(query)
    request.query(query, function (err, recordset) {
        if (err) {
            console.log(err);
            sql.close();
        }
        sql.close();
        res.send(recordset);

    });
  });
});

I hope it helps.

赞(0）回复(0）举报 2023-03-11

n6lpvg4x2#

let id = "C00008";

//calling stored procedure   
sql.connect(config).then(() => {
    const request = new sql.Request();

    request.input("c_id", sql.VarChar, id);

    request.execute("GetLedgerBalance").then((result) => { 
        const ledgerBalance = result.recordset[0].ledger_balance;
        console.log(`Ledger Balance is: ₹ ${ledgerBalance}/-`);
    }).catch((err) => {
        console.log(`Error executing sp ${err}`);
    });
}).catch((err) => {
    console.log(err);
});

赞(0）回复(0）举报 2023-03-11

我来回答

SQL Server Calling stored procedure from node js

2条答案

相关问题

热门标签

最新问答