Advertisement
Guest User

Untitled

a guest
Mar 12th, 2018
94
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.93 KB | None | 0 0
  1. //npm install express body-parser ejs mysql
  2. var express = require('express');
  3. var mysql = require('mysql');
  4. var bodyParser = require('body-parser')
  5. var ejs = require('ejs')
  6.  
  7. var app =express();
  8.  
  9. app.use(bodyParse.urlencoded({extended : false}));
  10. app.use(bodyParser.json());
  11. app.set('view engine', 'ejs');
  12. app,set('views', path.join(__dirname, 'views'));
  13.  
  14. var con = mysql.createConnection({
  15. host: "10.10.182.251", //name of mysql server
  16. port: "33066",
  17. user: "training",
  18. password: "nodejs",
  19. database: "classicmodels"
  20. });
  21.  
  22. con.connect( (err) => {
  23. if (err) throw err;
  24. console.log("Connected!");
  25.  
  26. var sql = "select firstName, lastName, jobTitle from employees"
  27. con.query(sql, function (err, rows) {
  28. if (err) throw err;
  29. console.log("#ROW:" + rows.length);
  30. var i = 1;
  31. rows.forEach(em => {
  32. console.log(i++ + '.' + em.firstName)
  33. })
  34. });
  35. con.end();
  36. });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement