本文整理匯總了TypeScript中mssql.Connection.close方法的典型用法代碼示例。如果您正苦於以下問題：TypeScript Connection.close方法的具體用法？TypeScript Connection.close怎麽用？TypeScript Connection.close使用的例子？那麽, 這裏精選的方法代碼示例或許可以為您提供幫助。您也可以進一步了解該方法所在類mssql.Connection的用法示例。
在下文中一共展示了Connection.close方法的4個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的TypeScript代碼示例。
示例1: function
var connection = new mssql.Connection (config, function (err)
{
var request = new mssql.Request(connection);
var command: string = sql_manipulate.delete_command_gen (id_in);
request.query (command, function(err, rows)
{
if (err) throw err;
console.log ("*** 終了 ***");
});
connection.close ();
});示例2: function
request.query (command, function (err, rows)
{
for (var key in dict_aa)
{
console.log (key);
var sql_str: string = "insert into cities ";
sql_str += "(id,name,population,date_mod) values (";
var str_data: string = "'" + key + "','" + dict_aa[key].name;
str_data += "'," + dict_aa[key].population;
str_data += ",'" + dict_aa[key].date_mod + "')";
sql_str += str_data;
request.query (sql_str);
}
connection.close ();
console.log ("*** 終了 ***");
});示例3: function
var connection = new mssql.Connection (config, function (err)
{
var request = new mssql.Request(connection);
var str_sql: string = "select * from cities";
request.query (str_sql, function(err, rows)
{
for (var it in rows)
{
var str_out: string = rows[it].id + "\t";
str_out += rows[it].name + "\t";
str_out += rows[it].population + "\t";
str_out += rows[it].date_mod;
console.log (str_out);
}
console.log ("*** 終了 ***");
});
connection.close ();
});示例4:
/** Samples from https://github.com/patriksimek/node-mssql#connection */
import * as sql from "mssql";
/**
* connect https://github.com/patriksimek/node-mssql#connect-callback
*/
const connection = new sql.Connection({
user: '...',
password: '...',
server: 'localhost',
database: '...'
});
connection.connect(function(err) {
// ...
});
/**
* close https://github.com/patriksimek/node-mssql#close
*/
connection.close();