本文整理汇总了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();