Monthly Archives: 11 月 2021

[nodejs][ftp-srv]登入按照帳號設定目錄

自己看不解釋

ftpServer.on('login',async (data, resolve, reject) => {
        var resultL;

        strSQL = "SELECT * FROM xxxxxxxxx WHERE aaaaaa='" + data.username + "' AND bbbbbbb='" + data.password + "'";
        resultL = await querySQL(strSQL);

        if (resultL.rowsAffected > 0) {
            return resolve({ root: resultL.recordset[0].StartupPath });
        } else {
            reject({});
        }

新增查詢方式

const querySQL = () => {
    return new Promise((resolve, reject) => {
        sqlA.Query(strSQL, (error, results) => {
            if (error) {
                return reject(error);
            }
            return resolve(results);
        });
    });
};

[nodejs]讓SQL乖乖的照順序執行

自己看自己抄，不解釋了，因為我也不會

var sql = require("./Class/mssql.js")


let sqlA = new sql();




//result=Query(strSQL);

//result = queryDb(strSQL).then((data) => { return data });


function funcB(int) {
    return new Promise(function (resolve, reject) {
        console.log(int);
    });
}




const queryPromise1 = () => {
    return new Promise((resolve, reject) => {
        sqlA.Query("SELECT TOP 1 * FROM FTP_UserAccount", (error, results) => {
            if (error) {
                return reject(error);
            }
            return resolve(results);
        });
    });
};

const queryPromise2 = () => {
    return new Promise((resolve, reject) => {
        sqlA.Query("SELECT TOP 1 * FROM FTP_Error_Log", (error, results) => {
            if (error) {
                return reject(error);
            }
            return resolve(results);
        });
    });
};

const queryPromise3 = () => {
    return new Promise((resolve, reject) => {
        sqlA.Query("SELECT TOP 1 * FROM code_d", (error, results) => {
            if (error) {
                return reject(error);
            }
            return resolve(results);
        });
    });
};


async function sequentialQueries() {
    funcB(1);
    try {
        const resultA = await queryPromise1();
        const resultB = await queryPromise2();
        const resultC = await queryPromise3();

        // here you can do something with the three results

        console.log(resultA);
        console.log(resultB);
        console.log(resultC);
    } catch (error) {
        console.log(error)
    }
    funcB(2);
}



sequentialQueries();

參考來源