forked from hussien89aa/AndroidTutorialForBeginners
-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathNodeSqlServer.js
More file actions
62 lines (50 loc) · 1.59 KB
/
NodeSqlServer.js
File metadata and controls
62 lines (50 loc) · 1.59 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
var Connection=require('tedious').Connection;
var Config={
userName:"DB_9E3E00_testing_admin",
password:'123456789',
server:'SQL5019.Smarterasp.net'
};
var myconnection=new Connection(Config);
myconnection.on('connect', function(err){
console.log("we connected suffecuflly");
getdatae();
});
var Request = require('tedious').Request;
var TYPES = require('tedious').TYPES;
function getdatae() {
request = new Request("SELECT * FROM [DB_9E3E00_testing].[dbo].[user]", function(err) {
if (err) {
console.log(err);}
});
var result = "";
request.on('row', function(columns) {
columns.forEach(function(column) {
if (column.value === null) {
console.log('NULL');
} else {
result+= column.value + " ";
}
});
console.log(result);
result ="";
});
myconnection.execSql(request);
}
function insertdata() {
request = new Request("INSERT into [DB_9E3E00_testing].[dbo].[user] (firstname,lastname)VALUES (@firstname,@lastname);", function(err) {
if (err) {
console.log(err);}
});
request.addParameter('firstname', TYPES.NVarChar,'hussein');
request.addParameter('lastname', TYPES.NVarChar , 'alrubaye');
request.on('row', function(columns) {
columns.forEach(function(column) {
if (column.value === null) {
console.log('NULL');
} else {
console.log("item of inserted item is " + column.value);
}
});
});
myconnection.execSql(request);
}