Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //npm install express body-parser ejs mysql
- var express = require('express');
- var mysql = require('mysql');
- var bodyParser = require('body-parser')
- var ejs = require('ejs')
- var app =express();
- app.use(bodyParse.urlencoded({extended : false}));
- app.use(bodyParser.json());
- app.set('view engine', 'ejs');
- app,set('views', path.join(__dirname, 'views'));
- var con = mysql.createConnection({
- host: "10.10.182.251", //name of mysql server
- port: "33066",
- user: "training",
- password: "nodejs",
- database: "classicmodels"
- });
- con.connect( (err) => {
- if (err) throw err;
- console.log("Connected!");
- var sql = "select firstName, lastName, jobTitle from employees"
- con.query(sql, function (err, rows) {
- if (err) throw err;
- console.log("#ROW:" + rows.length);
- var i = 1;
- rows.forEach(em => {
- console.log(i++ + '.' + em.firstName)
- })
- });
- con.end();
- });
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement